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.
2020-05-04
Additional Articles
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.
2020-05-04
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.
2020-05-01
Free Training Week: How I Use the First Responder Kit – sp_Blitz
When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.
2020-04-30
798 reads
SQL Server 2019 New Performance Features
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
2020-04-29
Getting Started with CQRS – Part 3
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
2020-04-28
SQL Monitor Roadtrip: Preparation
Setting up SQL Monitor without a bit of preparation work is a bit like embarking on a road trip without first learning to drive. Phil Factor show the essential kit and route maps you need for the journey.
2020-04-27
Tracking Underlying Object Changes in Views
Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.
2020-04-27
Creating or Altering an Objects with a Single Statement
Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.
2020-04-24
What Percent Complete Is That Index Build?
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
2020-04-23
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