Dates and Times in SQL Server: TIME

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where...

How I became a Data Platform MVP

As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...

Importance of Memory Setting in SQL Server

Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit,...

Management Studio Shortcut – Change Connection

Update: Now with Object Explorer shortcuts! One of the most common things I do within SSMS is to change connection for...

SQL Server Management Studio Dark theme

Enable dark-theme for SSMS   Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS).   Reading time   +/- 10 minutes   References www.sqlserver.info...

SQL Server Management Studio Dark theme

Enable dark-theme for SSMS   Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS).   Reading time   +/- 10 minutes   References www.sqlserver.info...

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4
It seems...

The SQL Privacy Summit

This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help...

Understanding DBCC FLUSHAUTHCACHE

This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...