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.
Using sys.dm_io_virtual_file_stats DMF to get IPOS and BPS
SQL Server keeps track of all the reads and writes it submits to the operating system (OS). It records this information in sys.dm_io_virtual_file_stats DMF. We
SQL Canada (SQLCAN) 