Cosmos DB – Monitoring performance
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
245 reads
Webinar: How to Harden SQL Server
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
189 reads
PASS Data Summit 2023 KeyNote 1
Morning from the PASS Data Summit! I will be live blogging the event today, so check back for announcements and releases throughout the keynote. Today, we have Shireesh Thota,...
2023-11-15
107 reads
Deploying Indexes with SQL Compare
I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...
2023-11-15
180 reads
SQL Server Recovery Models
When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have...
2023-11-15
22 reads
T-SQL Tuesday #168–Using Window Functions
I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year...
2023-11-14
61 reads
My data architecture book is now available for pre-order!
For those looking to be first in line when my book is available for a printed copy, I’m very excited to let you know that it is now available...
2023-11-14
33 reads
Get Certificate Details for SQL Encryption In-Transit Using PowerShell – UPDATED
In a previous blog post, I showed you how to use PowerShell to retrieve the details of the certificate being used for encryption-in-transit, aka TLS encryption. I have received...
2023-11-22 (first published: 2023-11-14)
1,596 reads
Testing Microsoft Fabric - Part 1
Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...
2023-11-14
6 reads
Query Store Reports Time Intervals
A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...
2023-11-24 (first published: 2023-11-13)
273 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name