Measuring Well Being
I need to write something more on this, but it struck me that this is something I wish previous employers had done, anonymously, and reported results back to others....
2020-07-10 (first published: 2020-06-29)
393 reads
Blog Posts
Thoughts As Pride Month 2020 Comes to a Close
I’ve begun working on developing a couple of small habits this month, thanks largely to Andy Mallon‘s helpful advocacy. Becoming more consistent in sharing my pronouns My pronouns are...
2020-07-10 (first published: 2020-06-30)
295 reads
BBQ Time in Texas
My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I...
2020-07-09
2 reads
Daily Coping 9 Jul 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...
2020-07-09
36 reads
New Free Course: The Dirty Secrets of NOLOCK
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK. A...
2020-07-09 (first published: 2020-06-29)
1,237 reads
SQL Server Backups on AWS RDS
One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...
2020-07-09 (first published: 2020-06-29)
316 reads
Backup On-Premise SQL Server to Azure BLOB Storage
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it’s not something that I’ve had all that...
2020-07-08 (first published: 2020-06-22)
507 reads
Daily Coping 8 Jul 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...
2020-07-08
10 reads
I created a table and SQL created a schema and a user.
Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick ... Continue reading
2020-07-08 (first published: 2020-06-22)
397 reads
Speaking at the Edmonton PASS user group on 16 July 2020
A short post this week, to let you know that I’ll be presenting a brand new session to the Edmonton PASS user group (EDMPASS) next Thursday. It will be...
2020-07-08
8 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers