Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations transform raw information into actionable insights. For decades, leaders have relied on batch processing as...
2025-09-02 (first published: 2025-08-25)
9 reads
Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source...
2025-09-02 (first published: 2025-08-23)
21 reads
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...
2025-09-02 (first published: 2025-08-27)
81 reads
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no...
2025-09-02
29 reads
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other database performance tuning isn’t just about faster queries—it’s directly tied to your bottom line in...
2025-09-02 (first published: 2025-08-25)
7 reads
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital estate – a castle of data, with towers of insight and vaults of sensitive information....
2025-09-02
36 reads
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-02 (first published: 2025-08-27)
46 reads
SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and data movement. In recent years, Python has exploded in popularity as a data movement and...
2025-09-01 (first published: 2025-08-11)
315 reads
In a tech landscape dominated by distributed systems, serverless architectures, and real-time analytics, one might assume that SQL, a language born in the 1970s, would be fading into obscurity....
2025-09-01 (first published: 2025-08-11)
1,219 reads
Had an incredible time at DevUp in St. Louis this weekend! This conference gets better and better each year and draws in some incredible folks from all over the...
2025-08-29 (first published: 2025-08-08)
102 reads
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Sorry, but you do not have permission to view this content.
Comments posted to this topic are about the item Database File Growth Report Script
I maintain an application written years ago, where the database is on a Windows...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers