Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
581 reads
Database Administration
Using Azure Data Studio to Deploy a SQL Server VM on Azure
This article looks at deploying SQL Server on an Azure VM from Azure Data Studio.
2023-05-24
1,530 reads
How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
9,497 reads
Cheat Sheet for SQL Server DBA Daily Operations
This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
2023-05-05
2023-05-05
173 reads
2023-05-03
500 reads
2023-04-12
475 reads
2023-04-05
584 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,528 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
615 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers