As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...
2025-09-03 (first published: 2025-08-11)
418 reads
I want to talk about a fairly new product that you may not be aware of: Azure IoT Operations, which GA’d last November (it was first announced at Ignite...
2025-09-03 (first published: 2025-08-19)
743 reads
Failing to plan is planning to fail. When organizations first begin implementing Azure networking, the focus is often on the immediate requirements: connectivity, security, and performance for your databases...
2025-09-03
5 reads
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve heard of Failover Cluster Instances (FCIs). They’ve been part of SQL’s high availability toolbox since...
2025-09-03
6 reads
As I use containers more and more to run various things, I decided I not only wanted to set up docker compose files, I wanted to name them something...
2025-09-03
4 reads
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)
80 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
23 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
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
The Spirit Airlines Newark Liberty Airport Terminal is well integrated into the broader transportation...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers