Single User Mode – Back to Basics

In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...

Power BI Data Security – Power BI Report Server

Power BI Report Server was released as a way to host reports on premises. It was one of the highest...

Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger

It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is...

Updated query to view data in the error log

This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...

SQL Saturday 769 Melbourne & 771 Sydney

For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne.  SQL Saturday 771 (Sat 07 Jul 2017)...

SQL Saturday 769 Melbourne & 771 Sydney

For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...

Birthday Musings and Deploy Using PoshSSDTBuildDeploy

Hello!

It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...

Lost that SQL Server Access?

Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...

Lost that SQL Server Access?

As a data professional can you recall the last time you needed to support a SQL Server instance for which...

The Importance of ORDER BY

Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...