Slide Decks
Hello everyone! Just a quick note. I’ve removed all my slide decks from SlideShare. I found they were inserting ads into the slides and I didn’t sign up for...
2025-08-02
44 reads
Blog Posts
Step-by-Step SQL Server Migration Using SSMS: Best Practices & Use Cases
Introduction Migrating databases can be a complex task, especially when dealing with large-scale systems or transitioning to cloud environments. The SQL Server Migration component in SQL Server Management Studio (SSMS) offers...
2025-08-01
144 reads
Build and Deploy Dockerize Python Application to Azure Container Instances (ACI) using Azure DevOps
As a software Engineer, I would like to deploy my Dockerized Python Application to Azure Container Instance (ACI) using Azure DevOps so that I can automate my workflow and...
2025-07-29
70 reads
Communications: Three Questions
The better skilled we are communications, the more likely we will be understood. Whether we're talking work colleagues or our families and friends, being understood is more important than...
2025-07-28
75 reads
Comparing Top AI Tools for Image and Code Generation
The post explores various AI assistants, highlighting their strengths and weaknesses in areas like coding and image generation. It emphasizes the usefulness of tools like CoPilot and Gemini for...
2025-07-28
79 reads
Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained
The report outlines the evolution in data management systems, transitioning from traditional siloed structures to modern integrated platforms. It compares Data Warehouses, Data Lakehouses, and Lakebases, highlighting their roles...
2025-07-28
276 reads
Zero Downtime SQL Server Upgrade: Best Practices for Seamless Migration
Upgrading SQL Server is a mission-critical task for DBAs, especially when the goal is zero disruption to application connectivity. Whether you’re modernizing for performance, compliance, or supportability, choosing the right...
2025-07-28
136 reads
SQL Saturday Baton Rouge 2025
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has some of the best food, presenters, and attendees in the country! Had some incredible questions...
2025-07-26
41 reads
Responsible AI: Why Leaders Need More Than Just Guardrails
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks, compliance protocols, and technical safeguards. These “guardrails” are necessary, but not sufficient. Because AI isn’t...
2025-07-25
35 reads
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
📘 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,374 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers