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
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers