Getting back to basics
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
606 reads
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
606 reads
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,376 reads
[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...
2014-05-23
14,763 reads
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,669 reads
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,150 reads
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,296 reads
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,472 reads
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...
2013-05-31 (first published: 2013-05-24)
4,681 reads
How many lines of TSQL codes and Window Functions you need to come up with this?
With R, it takes about...
2013-05-16
905 reads
This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.
I’ve got plenty of SQL Server books...
2013-05-10
914 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