Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
Resource Bottlenecks in SQL Server: A Wait Stats Script That Groups Them
Resource bottlenecks hide in the wait statistics, under a pile of idle waits and totals since startup. This post builds a script that removes the idle waits, measures an interval and groups the rest by resource. It also explains how to read each group and the signal wait.
SQL SERVER – Case of Different Default Collation on Two Servers
My client saw a different default collation on two servers installed with SQL Server 2012. Here is what decides the default collation during setup.
SQL SERVER – Puzzle – Playing with Datetime with Customer Data
Playing with Datetime became a puzzle when one conversion worked for a customer but failed for me. The input was unchanged.
SQL SERVER – Edition Downgrade with Supported Migration Checks
To Downgrade SQL Server editions, I plan a supported migration or reinstall. I test the application on the destination edition first.
SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist
A developer found a columnstore index cannot be created on a large history table in SQL Server 2014. The surprise cause: computed columns in the table.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?