Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was...
2021-10-20
50 reads
Daily Coping 20 Oct 2021
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...
2021-10-20
44 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here! If you want to learn about the course, check out the trailer...
2021-10-20
71 reads
Daily Coping 19 Oct 2021
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...
2021-10-19
20 reads
Commenting a branching IF-THEN-ELSE.
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE ... Continue reading
2021-10-19
71 reads
External Temp Tables Preventing Plan Reuse in Stored Procedures
Here’s an interesting issue that recently came up. We were seeing very high compilations and recompilations on a server to the point that it started causing us some very...
2021-10-29 (first published: 2021-10-19)
342 reads
Scaling your Azure SQL Managed Instance
No doubt there will be times where you need to scale up the actual instance in terms of vCores but also you may want to move across tiers (for...
2021-11-03 (first published: 2021-10-19)
218 reads
STRING_SPLIT Basics–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post on using STRING_SPLIT() with...
2021-10-27 (first published: 2021-10-18)
608 reads
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who...
2021-10-18
9 reads
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who...
2021-10-18
6 reads
Blogs
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers