Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
505 reads
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
505 reads
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
1,983 reads
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,797 reads
To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL...
2013-12-18
952 reads
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
958 reads
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
542 reads
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
611 reads
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
710 reads
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
679 reads
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,261 reads
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