How to Add a Filter to an Existing SQL Change Automation Project
Kendra Little demonstrates how to create a SQL Compare filter file and save it to a SQL Change Automation project folder, so that it will be used automatically during development.
Technology Makes a Difference
As the world deals with the Covid-19 pandemic, technology is making some things better for those of us in isolation. We are also better equipped today to fight the disease. Researchers are using artificial intelligence to quickly develop vaccines and treatments.
Configuring Database Alerts for Azure SQL Database
This article will help us to understand how to monitor Azure SQL Database and set up Azure metric alerts. Even though the database in Azure SQL Database is fully managed by Microsoft, we are still responsible for proper database access and performance. Azure does make it easy for us and it can alert on critical […]
SQL Server Database Deployment: What Could Go Wrong?
Phil Factor tackles the questions you were too shy to ask about SQL Server database builds, migrations and deployments.
Storage 101: Data Center Storage Configurations
In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.
Representing uncertainty in difficult times
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
An Introduction to PowerShell for a DBA
An introduction to PowerShell that covers basics alone with some more advanced features. It will walk you through from the very beginning to the writing of a few useful scripts.
Are You Ready To Change Your Work Environment?
With many of us working from home, Steve wonders if you want to change anything.
Export SQL Server Tables to Excel
Sometimes there is a need to export data for a lot of different SQL Server tables into an Excel file. In this tip we look at how we can quickly export several tables into one Excel workbook where each table is stored in a different worksheet.
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
How do you approach engineering services consulting?
I’ve been thinking a lot about the role of consulting in engineering projects. Having...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers