We've been working really hard on SQL Source Control, and need your input. We're currently working on suggestions from our user forum and on an updated migrations feature that supports all source control systems and works across branches. We'd love it if you could spare 10 minutes to complete this survey. If you complete the survey by Friday June 14, you could win a $100 Amazon voucher. There are two up for grabs!
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
When a disaster occurs, the response from your organization isn't always pre-determined. There are times when you might not want to failover to secondary systems, especially if you don't expect the disaster to last long. How do you decide when to fail over?
Microsoft has introduced a new BI product that will help simplify the data discovery phase for Excel users. “Data Explorer” is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Data Explorer is a preview product so these features may appear differently in the final release.
This metric reports the number of connections that are currently blocked, divided by the total count of current connections.
Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.
Moving data around can be a challenge as the sizes of our databases grow. Steve Jones talks about some of the challenges and some creative ways you might consider moving data.
Once databases are placed in source control, it is possible to integrate them into the existing build automation process. This will ensure that the whole development project, including the database, can be integrated regularly and tested by an automated build system. This, in turn, leads to opportunities for more frequent, reliable deployments.
Do you let your fear drive you in how you work with technology? Steve Jones thinks you should be cautious, but not paralyzed.
Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.
This article details an Excel 2010 function to return the cell address of min and max functions.
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item 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