SQL Server How to Check What Settings Are Set On Active Sessions

SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...

SQLSaturday Orlando 2018 Registration is Open

We’ve just opened up registration and the call for speakers for our 12th SQLSaturday here in Orlando. We did #1...

You know everything about GROUP BY. Do you?

SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...

Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler

  This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...

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

dbachecks – Save the results to a database for historical reporting

I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...

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

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

Single User Mode – Back to Basics

Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...

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