TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and community volunteer Taiob Ali – Taiob’s call is to blog on how AI, (the biggest...
2025-08-13
44 reads
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do...
2025-08-13
149 reads
DBCC CHECKDB: Just Because It’s Quiet Doesn’t Mean It’s Safe
Corruption isn’t a “maybe someday” problem – what you need to do now. Stop. Don’t panic. You just ran DBCC CHECKDB for the first time in a while (or...
2025-08-13
38 reads
SQL Server 2025 Backups - New ZSTD Compression
Compression was introduced in SQL Server version 2008. While it helped, the compression ratios were frequently too low to justify the...
2025-08-13
36 reads
PASS Data Community Summit LinkedIn Contest
If you're not having success in convincing your organization to send you to this year's PASS Data Community Summit, you could win a 3-day registration by submitting some basic...
2025-08-29 (first published: 2025-08-12)
155 reads
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
When deploying SQL Server in enterprise environments, choosing the right service account model is critical for security, manageability, and scalability. Traditionally, DBAs have relied on standard domain accounts with static passwords,...
2025-08-12
81 reads
Andreas Wolter on Evading Data Access Auditing
There are always bad actors who will seek to get access to and, likely, exfiltrate (exfil) the data. But they don't want to get caught; they don't want to...
2025-08-11
46 reads
Adding a Named Default Constraint to a Table: #SQLNewBlogger
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)
489 reads
Using Python Code in SSIS
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)
472 reads
Why SQL Still Reigns in the Age of Cloud-Native Databases
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,335 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers