Reading the log on SQL for Linux

The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...

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

Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...

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

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

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...

Where To From Fundamentals?

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

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

Level Up Your SQL Server Cross Platform Skills With mssql-scripter

The ability to export a script of database objects has for a long time been a feature of SQL Server...