Daily Coping 24 Aug 2020
I 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-08-24
9 reads
Blog Posts
Don’t Forget Unique with FILESTREAM–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing FILSTREAM with SQL Clone the other...
2020-08-24
8 reads
Multi-Subnet AlwaysOn - Scripts & Downloads - Part 3
Let’s see how to get access to scripts for this tutorial series
2020-08-24
10 reads
2020-08-24
10 reads
2020-08-24
3 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
16 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! This course...
2020-08-24
6 reads
New Pluralsight Course – Configuring and Managing Kubernetes Security
My new course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to Pluralsight! ...
2020-08-24
1 reads
Persist Sample Percent in SQL Server IS NOT PERSISTED!
Update: Sept 14, 2021 Persist sample percent is fixed. The fix is now rolled into SQL 2016 SP2 CU17, SQL 2019 CU10, and the future SQL 2017 CU26. When a bug...
2020-08-24
10 reads
Unconscious Bias
This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:
Note to Self June...
2020-08-24 (first published: 2020-08-11)
432 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
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