Trace Flags That Are Now Defaulted Behaviors in SQL Server

If you have ever attended one of my performance tuning sessions, you know I tend to talk about  trace flags.  Trace Flags can help fix performance issues and some...

Using a PoSh variable in a string- #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or...

Viewing Azure SQL DB security with sp_AzSQLDBPermissions

A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure ... Continue reading

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...

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

Welcome back to my series on Power Platform quick tips! In this episode you will learn how to document your flow logic with comments.

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 Homework – December 2019 – The default trace and the system health session.

I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading

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,...