How many times have we heard that SQL Server is running slow from end-user, but can’t track down why? Or what happened? In this post
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
How to calculate Max Memory for SQL Server?
How do you calculate max memory setting for SQL Server; in affect how much memory to leave to OS, threads, etc.
SQL 2008 R2 SP1 CU10 Released!
Build: 10.50.2868 KB: 2783135 A few fixes have been made, however for some reason I think I have seem most of this in previous CUs.
SQL Server 2008 R2 SP2 CU4 Released!
Build: 10.50.4270, KB: 2777358 Many fixes are rolled up in this KB, some of the interesting ones for me (Since I primary focus on the
SQL Server 2012 RTM CU5 Released
SQL Server 2012 RTM CU5 released. Build #11.0.2395.0 Most of the SQL 2012 fixes are for SSRS, SS MDX Queries, etc. But another interesting fix
Performance Impact of SQL Server Profiler
The general best practice is only capture the events and columns you need when using SQL Server Profiler. But how much impact does it have?
SQL Canada (SQLCAN) 