Recording of PASS Security VC Webinar

If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...

Trying to Solve the Wrong Problem

Some time back, while pulling into a local coffee shop, I spotted a stranded motorist in the parking lot. Per...

SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2

Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...

Where To From Fundamentals?

The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...

Row-count Estimates when there are no Statistics

I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...

SQL Crossword : T-SQL Keywords : June 2017

I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...

The Three A’s: Auditing

Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...

Persisting data in docker containers – Part Two

Last week in Part One I went through how to mount directories from the host server into a docker container...

How to Put SQL Column Names Onto Multiple Lines in SSMS

SQL in 60 Seconds is a series where I share SQL tips and tricks that you can learn and start using in less than a minute.

Watch this week's video...

The Three A’s: Authorization

Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know...