📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,378 reads
Will adding generative AI to your data project improve the outcomes? It might, but it’s not guaranteed. It can be harmful and costly to add generative AI in the...
2025-07-23
1,080 reads
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
16 reads
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
18 reads
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure Fabric pipelines with multiple notebooks running slower than you’d like? Are you paying for more...
2025-07-23
191 reads
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
69 reads
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure and scale operations across borders, the challenge is no longer just about moving fast –...
2025-07-22
70 reads
I’m honored to be speaking at the PASS Data Community Summit in Seattle this fall. I’ll be delivering a Professional Development session (Blogging for the Tech Professional), which might...
2025-07-22
53 reads
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
341 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers