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
128 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
272 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
135 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,367 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers