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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
Setting up iSCSI Target and Initiator
I am sure everyone has realized, when it comes to configure Servers I am the last person that should get near them. I am good
Online Index Operation – Doc Bug –
In SQL Server 2012, Index Online operation is supported for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX), and XML. However the ALTER INDEX states it is not supported. In
Index_Name Function for SQL Server
We have the database_name, object_name, object_schema_name but don’t have index_name. So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name
Login failed. The login is from an untrusted domain…
Troubleshooting Failed Login, login is from an untrusted domain and cannot be used with windows authentication.
A Microsoft SQL Server DMV/DMF Cheat-Sheet
I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views (DMV) or dynamic management functions (DMF) should I
SQL Canada (SQLCAN) 