Finding Top Offenders with Extended Events

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...

Finding Top Offenders with Extended Events

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...

Azure SQL Database Managed Instance is now private preview

Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...

Packt $10 Sale

One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...

Table Internal Sync Rule–Substituting the Sync Column

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...

Book Review: SQL Server 2017 Machine Learning Services With R

Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...

Identify the owner and then change the owner of a SQL Agent Job

In this post and video you will learn how to identify the owner and then change the owner of a...

Classifying your data in Azure SQL DB for GDPR

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don’t...

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection

Watch this week's video on YouTube
Object-relational...