Microsoft SQL Server Browser service is critical component of SQL Server, that lets allows users to connect to an instance if the default port has
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
SQL Server 2008 SP3 CU8 Released
Multiple components of SQL Server were fixed in this. Fixes for SSRS, Replication, Locking Hints, Security issues, etc. Few interesting ones for me… Added support
SQL Server 2012 SP1 Released!
Not just fixes this time, but new functionality and enhancements too :). New DMV for getting stats information sys.dm_db_stats_properties. A new SSMS Complete (no more
Slow disk write performance when you use a back-end SAN on a computer that is running Windows Server 2008 R2
Interesting fix was released today, your WRITE performance might be poor due to incorrect priority in DPC in Windows 2008 R2. If you have write
Microsoft Support policy for SQL Server in Windows 8 and Windows 2012
Now that Windows 8 (which btw ROCKS!) and Windows 2012 is out, Microsoft has released a KB highlighting the support for SQL Server in respect
Calculating Datetime Based on NT Time
A colleague of mine gave me an interesting challenge today. I am by no means a T-SQL expert, however it was interesting dissecting the problem.
SQL Canada (SQLCAN) 