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

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

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?

by drsql@hotmail.com

SQLServerCentral

Database Weekly

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

by Additional Articles

SimpleTalk

Auditing

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

by Steve Jones

SQLServerCentral

software development

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

by mamta_d

SQLServerCentral

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

by Additional Articles

MSSQLTips.com

This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.

Analyzing Breached Data

by Steve Jones

SQLServerCentral

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.