Podcast: Big Data Solutions in the Cloud
In this podcast I talk with Carlos Chacon of SQL Data Partners on big data solutions in the cloud. Here is...
2018-04-16
543 reads
Execution Plan Shortcoming in Extended Events
I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...
2018-04-26 (first published: 2018-04-16)
1,717 reads
Free Session, Free Beer, Free Food - # Not the GDPR News
This is a final call for attendees. We are have the last few seats available in out #Not the GDPR news -...
2018-04-16
352 reads
Azure SQL Database vCore
vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...
2018-04-24 (first published: 2018-04-16)
2,376 reads
I’ve gotten a transaction log full error but when I look it’s not full??
Every now and again I’ll get an error telling me a transaction log is full. This can be for any...
2018-04-23 (first published: 2018-04-16)
2,295 reads
Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,305 reads
Find Missing Indexes For All SQL Server Databases
DMV (Database Management View) and DMO (Database Management Objects) were added in 2005. There have been huge improvements in each...
2018-04-16
26,251 reads
Best-practices, guiding principles of choosing procedure parameters
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,316 reads
Remove-DbaBackup with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-04-20 (first published: 2018-04-13)
2,427 reads
Custard Indexes
Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me...
2018-04-13
469 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers