Introducing FabricTools (PowerShell module)
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps is still maturing. Unlike Azure Data Factory (ADF), which has been around long enough to...
2025-06-20
33 reads
Generating Random Strings with GenAI
One of the things I’ve been experimenting with in AI is taking things other people do and seeing how well the AI works. In this case, I took a...
2025-06-20
22 reads
Heading to SQL Bits 2025
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day of the conference. I wasn’t selected to speak, but since I’m in Cambridge next week...
2025-06-20
23 reads
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-07-04 (first published: 2025-06-19)
242 reads
Why India’s NEW Tax Regime is a GAME CHANGER for the Job Market
India’s 2025 tax reforms have introduced a bold shift in how income is taxed, and the ripple effects are already being felt across industries. With a focus on simplification,...
2025-06-19
14 reads
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very important for ensuring that there is a smooth deployment and maintainable code quality. Building a...
2025-06-19
71 reads
Better Trigger Design: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me...
2025-06-18
31 reads
SQL Server in the Cloud – Are DBAs Still Needed?
Things your cloud vendor may not tell you Here’s a common theme I hear from small IT teams: “Our SQL Server is in the cloud now. We don’t...
2025-06-18
38 reads
SQL Server error 18456
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
109 reads
ColumnStore Indexes: The Secret to Fast SQL Queries
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
1,047 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers