sp_execute_external_script and SQL Injection

In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...

Current database vs database locks

I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading

Error: ‘misaligned log IOs which required falling back to synchronous IO’ And Slow AG Synchronisation

I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...

Find Things Pointing at Production

Step AWAY from the Production servers! Read on...

Importance of Testing

I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...

Is That Database in Use?

This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:

Finding Deprecated Uses in SQL Server November 7, 2016...

Kubernetes Pipelines

This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...

Last Week Reading (2019-07-21)

Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...

Moving Databases into Azure SQL Elastic Pools

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...

The Data platform has evolved – so too must the DBA.

This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...