Advice I Like: Naps
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep...
2025-08-15
29 reads
SQL Server Management Studio uses the Visual Studio installer
Yes, SSMS 21 uses the Visual Studio installer. No, you don’t need to download it every time. No, you don’t need a Visual Studio license to use it.
The post...
2025-08-14
49 reads
Getting Started with Microsoft Fabric: Why It Matters and What You Gain
In today’s data-driven world, organizations are constantly seeking ways to simplify their analytics stack, unify fragmented tools, and unlock real-time insights. Enter Microsoft Fabric, a cloud-native, AI-powered data platform...
2025-08-14
211 reads
Managing Enterprise Storage with Pure Storage Fusion in PowerShell
When managing storage infrastructure at scale, one of the most powerful approaches is treating related storage resources as cohesive Workloads rather than individual components. This becomes especially important when...
2025-08-14
35 reads
Terraform Commands
I realized I never created a post to show how to deploy Terraform from VS Code. I haven’t done that in a while because I don’t do it at...
2025-08-13
89 reads
T-SQL Tuesday #189–AI and your Career
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
58 reads
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
25 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
138 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
31 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
19 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers