SQL 2017 Administration Inside Out - link dump

Hello all-

More than a year's work went into the newest Inside Out book by Microsoft Press, I was happy to...

SQL Server logins, users, SIDs, and orphaned users – a quick primer

Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some...

The best overlooked addition to SQL 2016

Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...

UNDERCOVER TOOLBOX: sp_WhatsMyAG

Here’s a quick one for you.  If you happen to be managing SQL Servers with a large number of databases...

Which Blogs Do I Recommend?

One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...

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...

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...

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...

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...

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...