Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
1,266 reads
Blog Posts
Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
126 reads
Different methods to write PowerShell output to a SQL table
PowerShell has become the ultimate choice for many database administrators because of its efficient way of handling and managing automation...
2017-12-26
1,349 reads
Execution Plan Metrics and Units of Measure
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,440 reads
Extended Events Permissions
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
132 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,230 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
154 reads
My Learning Goals for 2018
A couple of weeks ago, the SQL Server community had their last T-SQL Tuesday of the year – 97th since 2009...
2017-12-26
753 reads
PaaS and the ever changing role of the DBA
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...
2017-12-26 (first published: 2017-12-12)
1,659 reads
SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
427 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers