A set of PowerShell automation script tasks for running database build and migrations tasks. This article describes the SQL code analysis task, which will check the syntax of the SQL code in your databases and your migration scripts for 'code smells'.
2021-04-30
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
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
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
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
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
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
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
2021-04-26
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
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Your AI is busy. But do you know what it's worth? Most companies can...
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers