My Favorite FREE Reports in SSMS
Microsoft has given us DBAs/Developers/etc. a wealth of free reports integrated into SQL Server Management Studio (SSMS) in order to...
2015-04-07
814 reads
Blog Posts
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
787 reads
SQL New Blogger Challenge: Week 1
WOW!
The response to the SQL New Blogger Challenge I issued a couple of weeks ago has been absolutely incredible. At...
2015-04-07
512 reads
SQL Server Quickie #23 – Plan Cache Pollution
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in...
2015-04-07
908 reads
SSMS regular expressions: format text into a block
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a...
2015-04-07
515 reads
SSRS report footer is NOT lost in Excel
With all the recent changes and updates within the Microsoft PowerBI universe, SSRS core technology gets less and less attention....
2015-04-07 (first published: 2015-03-31)
14,193 reads
Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at...
2015-04-06 (first published: 2015-03-30)
7,142 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 1
AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR in one! Even with AGs, still integral to your...
2015-04-06
19 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 1
AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR...
2015-04-06
971 reads
Does the New Cardinality Estimator Reduce Bad Parameter Sniffing
No. Next question.
Although, that answer can be slightly, ever so slightly, nuanced…
Parameter sniffing is a good thing. But, like a...
2015-04-06 (first published: 2015-03-30)
7,288 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers