Building a SQL Server data dictionary
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
Additional Articles
How do you monitor your databases? Take the survey!
Calling data professionals! We want to know how you are monitoring your servers, instances and databases. By taking the 2021 State of Database Monitoring survey, you’ll help us better understand how the community monitor and manage their estates, and the challenges they face. You’ll get exclusive early access to the 2021 State of Database Monitoring report, plus, one lucky winner will receive a $500 Amazon gift card in our prize draw.
2021-04-29
Detecting Database Drift during Flyway Database Development
How to detect database drift prior to running a database migration, so that you can be certain that a database hasn't been subject to any 'uncontrolled' changes that could affect the migration or result in untested changes being deployed to production.
2021-04-28
Five Facts about the SQL Server Resource Database
In this article we cover interesting facts about the hidden resource database in SQL Server and how this is used by SQL Server.
2021-04-28
How to improve DevOps communication clarity
Communication is at the heart of DevOps, but it can be difficult to achieve. Mike Cuppett explains how to improve DevOps communication clarity.
2021-04-27
Creating Database Build Artifacts when Running Flyway Migrations
This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.
2021-04-26
Never, Ever, Ever Start T-SQL Comments with Two Dashes
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
2021-04-26
Learn basics of Data Wrangling in SQL Server to handle Invalid Values
In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.
2021-04-23
SQL Server Security – Fixed server and database roles
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
Batch Processing using Flyway
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
2021-04-21
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers