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

The Fastest Way to Combine DATE and TIME Data Types to a DATETIME

Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...

T-SQL Tuesday #70 - SQL Server In the Enterprise

PearlKnows WeB log, Stardate 2015.9.8: This week’s topic is strategies for
managing an enterprise, brought to us by one half of...

Unusual errors with Distributed Replay

I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...

Viewing Running XEvent Metadata

In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...

Dustin Ryan: Power Pivot 101: An Introduction

The PASS Excel Business Intelligence virtual chapter presents Dustin Ryan introducing everybody to Power Pivot in Excel. This chapter has...