Adding Extended Properties to Tables

Creating a New Sequence–#SQLNewBlogger

I wrote about sequences in an editorial recently and decided to start using them. Creating one turned out to be surprisingly easy. I had a table I’d been logging...

Daily Coping 19 Jun 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Evaluating Life at Work

It can be hard to evaluate your career and job situation, but Steve has some ideas today.

Social: Growing Up with the Dukes of Hazzard

I grew up in the South. The capital of the Confederacy was a short drive from my house. We studied the Civil War. I watched the Dukes on TV,...

CTE in Tempdb

Daily Coping 18 Jun 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Why Billing Will Be Part of Our Job

I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don't know that any department ever lost service, […]

Daily Coping 17 Jun 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Getting the Group Counts