Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share...

The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting

Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...

Azure Data Catalog

Azure Data Catalog
Now available in public preview is the Azure Data Catalog.  The Data catalog provides an enterprise data repository...

Enterprise Strategies – A #TSQL2sDay post

This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...

Extended Events Objects

Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:

Correlate SQL...

Learning Extended Events in 60 Days

This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...

Learning Extended Events in 60 Days

Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...

Setting Up Alerts in Azure SQL Database

Setting Up Alerts in Azure SQL Database
SEPTEMBER 8, 2015

IntroductionIf I've learned one thing with my on premise versions of SQL Server, it is to automate as much as possible....

SQL Server – Using Window ranking function with UPDATE statement

Hi friends, I was working on a scenario in which I need to assign a unique values to a column....

SQL Server Data Tools is now a separate installer – Things to know!

Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...