SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Why does SELECT 1/2 return 0 in SQL Server and not 0.5? Beginners often think it is a bug. Here is the SELECT One by Two answer, explained simply.
SQL SERVER – Identifying Page Types
During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
What is ACID Property in Database? – Interview Question of the Week #066
What is the ACID Property in a database? A classic interview question, with Atomicity, Consistency, Isolation and Durability explained in plain words.
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.