Honored to be a Microsoft MVP Again
I was renewed this week as a Microsoft MVP. This is my 15th award in a row and each year this happens it is an honor to be recognized...
2022-07-06
26 reads
Blog Posts
Log in to Power BI Desktop as an External (B2B) User
I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs...
2022-07-06 (first published: 2022-06-22)
284 reads
Snowflake Data Cloud
Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of...
2022-07-06
181 reads
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
35 reads
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the...
2022-07-06 (first published: 2022-07-04)
104 reads
Thank You Kevin!
I don’t think I’m going too far out on a limb to call Kevin Kline a friend. I’m extremely humbled and honored that I can say that. Kevin is...
2022-07-06
20 reads
usp_SQLServerCarpenter_Tools_Get_Costliest_Queries
This procedure can get you the list of queries being executed frequently and for duration greater/less than a particular time. You may also find it very useful if you...
2022-07-06
52 reads
usp_SQLServerCarpenter_Tools_Get_Objects_Performing_Committed_Read
This procedure will get all the objects performing committed reads. It will fetch all the objects (Procedures, Functions, Triggers, View etc.) that doesn't uses the NOLOCK and SET ISOLATION...
2022-07-06
49 reads
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
This procedure will get all the stored procedures and triggers missing the use of SET NOCOUNT ON. It may be helpful in performance tuning assignments.
2022-07-06 (first published: 2022-07-04)
58 reads
What is causing my constraint to be untrusted?
The problem
In this scenario, you have discovered that one of your Check constraints or Foreign keys is not trusted.
Maybe you’ve detected it with a sp_Blitz, dbachecks or out of...
2022-07-06 (first published: 2022-06-24)
366 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers