SQL Local Variables and Performance Issues
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
A New and Improved Data Warehouse: Data Engineering with Fabric
In this next installment, John performs the research you might do if your management asked you to examine Fabric.
Do You Have the Gifts to Be a DBA?
This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
Auditing SQL Server – Part 3 – SQL Server Configuration Audit
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
A Lack of Architecture and Planning
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
Data Prediction with SQL Server Machine Learning Services, Python, and Linear Regression
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.
Analyzing Breached Data
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
Recover a Database from Suspect Mode Step by Step
Learn how you can recover a database that is in suspect mode.
What Do You Drop?
Time is a valuable resource in your lives, and when you decide to tackle something, something else gets dropped.
Blogs
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers