Configuration Manager is Corrupt

So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...

Configuration Manager is Corrupt

So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...

Right-Click File Options in SSMS and SSDT

Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...

SQL Server Converts Numbers to Asterisks

Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;

PRINT('varchar...

SQL Server Converts Numbers to Asterisks

Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;

PRINT('varchar...

SQL Server Converts Numbers to Asterisks

Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...

SQL Undercover TV Christmas Special – David's Top 5 Azure Data Studio Features

In our Christmas Special, David picks his top 5 features of Azure Data Studio.

Unprepared for Travel

I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption...

Why Don’t People Use Columnstore Indexes?

I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why. Now, before I explain my answer, please, let me...

What happens if I disable the clustered index?

You are probably already aware that you can disable an index. This can be handy when you have a large ... Continue reading