Why I Travel So Much
I travel a lot. But occasionally I get asked “Why”. The answer to that is pretty simple and comes down to three simple things. 1. When I just out of high school (18 years old ish) I had no clue what I’d be doing for a living. My first real job out of high school…
The post Why I Travel So Much appeared first on SQL Server with Mr. Denny.
Azure Database for MySQL server has a slow query log now
I’m not sure when this feature got introduced, but I just saw it for the first time recently (and I asked for it when Azure Database for MySQL server was in private preview); but Azure Database for MySQL server can show you the slow queries that are running against the MySQL database. In fact, it’ll…
The post Azure Database for MySQL server has a slow query log now appeared first on SQL Server with Mr. Denny.
Free Performance Metrics from Traffic Manager
A couple of weeks ago DCAC moved our website from being hosted in a single data center to being a globally distributed web application with multiple Azure WebApps with one hosted in the US and one in Europe. As part of having traffic manager configured and enabled for our site, we get some free reporting…
The post Free Performance Metrics from Traffic Manager appeared first on SQL Server with Mr. Denny.
Cost Threshold for Paralellism
Cost Threshold for Parallelism is a setting in SQL Server that’s been around for as far back in the product that I can think of. It decides how expensive an operator needs to be because SQL Server will use multiple threads for that operator instead of a single thread. The Cost Threshold for Parallelism setting…
The post Cost Threshold for Paralellism appeared first on SQL Server with Mr. Denny.