Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
577 reads
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...
2020-09-02
18 reads
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
398 reads
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case. After creating Azure SQL Databases...
2020-09-01 (first published: 2020-08-21)
551 reads
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-09-01
13 reads
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
407 reads
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
91 reads
Last week I wrote a blog post about Decoding Helm Secrets. The post goes through deploying a Helm Chart to Kubernetes and then running the following to decode the...
2020-08-31 (first published: 2020-08-18)
230 reads
If you are like me, you inherited variously configured SQL Servers when you took over as the DBA for your company. After almost two years, I have gotten all...
2020-08-31 (first published: 2020-08-18)
546 reads
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-31
10 reads
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Comments posted to this topic are about the item A Place where AI Technology...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers