Don’t optimize for ad hoc workloads as a best practice
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held...
2022-02-02
56 reads
Blog Posts
SQL Homework – February 2022 – “Soft” skills.
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-02
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks related to the CIS Center for Internet Security requirements. I have yet to write a...
2022-02-02 (first published: 2022-01-21)
2,198 reads
Setup Kerberos Constrained Delegation for Group Managed Service Accounts
Kerberos delegation is not a new concept in Active Directory; however, setting it up for Group Managed Service Accounts (gMSA) can be a bit confusing. Unlike normal domain accounts,...
2022-02-01
684 reads
SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
2022-02-01
175 reads
T-SQL Tuesday #147 Invitation – Upgrade Strategies
It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...
2022-02-01
21 reads
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
35 reads
Daily Coping 31 Jan 2022
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...
2022-01-31
11 reads
DP-900 Preparation Guide
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-01-31
46 reads
Trusting the Fine Print or connecting Azure Data Factory with Salesforce
(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...
2022-01-31 (first published: 2022-01-20)
529 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers