Wednesday, April 24, 2019

How to count NULLS without using IS NULL in a WHERE clause

›
This came up the other day, someone wanted to know the percentage of NULL values in a column Then I said "I bet you I can run that ...
Sunday, April 14, 2019

How to check if an Extended Event session exists before dropping it

›
Are you still running profiler or have you transferred to using Extended Events? I use Extended Events almost exclusively now because it...
Saturday, April 13, 2019

How to improve your tech skills

›
Today we are going to look at how to improve your tech skills. This really is a continuation of the  Stay relevant and marketable  post fro...
Wednesday, March 20, 2019

Some numbers that you will know by heart if you have been working with SQL Server for a while

›
This is just a quick and fun post. I was troubleshooting a deadlock the other day and it got me thinking.... I know the number 1205 by h...
5 comments:
Monday, March 18, 2019

Stay relevant and marketable

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed...
Saturday, March 16, 2019

Use sys.configurations to find features that are enabled but perhaps not used

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed,...
Monday, February 18, 2019

Calculating Sexy Primes, Prime Triplets and Sexy Prime Triplets in SQL Server

›
The other day I was reading something on Hackernews and someone posted a link to a Sexy Primes wikipedia article.  I looked at that and th...
1 comment:
Thursday, February 14, 2019

Finding rows where the column starts or ends with a 'bad' character

›
A coworker came to me asking me for some help. He had some issues trying to convert some data from a staging table to numeric. I asked him t...