Blog Post

May I help you?

With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games.  Those were the greatest winter...


817 reads

Blog Post


I have been pondering recently what helps me to sleep at night.  Or, conversely, what prevents me from sleeping at...


1,312 reads

Blog Post

In Vs. Inner Join

This is tightly related to another of my forays into tuning some slowly/poorly performing processes.  This process came across my...


866 reads

Blog Post

PayPeriod II

I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...


787 reads

Blog Post


This month Rob Farley is hosting TSQL-Tuesday #3.  The topic is Relationships and he has left it wide open for...


866 reads

Blog Post

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:

T-SQL Tuesday Participation Over the Years December 19, 2018

T-SQL Tuesday #104: Just Can't Cut That Cord...


1 reads


Using Data Masker on Chinese Surnames


A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft


looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing


I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs


Happy Memorial Day 2023

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Happy Memorial Day 2023

Install SQL Server using Powershell Desired State Configuration (DSC)

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Install SQL Server using Powershell...

The Secure Enclave

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Secure Enclave

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers