Quick and Easy XE for Azure DB

This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...

Quick and Easy XE for Azure DB

The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....

Thread-safe PowerShell Logging with PSFramework

In my previous post, I mentioned that I wasn’t checking the status of my RSJobs because I had logging built into my function. I originally tried to log out...

Last Week Reading (2018-12-23)

The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...

Call for Speakers for Orlando Code Camp Closes Jan 18, 2019 & We Need SQL Speakers

Orlando Code Camp is March 30. 2019 in Lake Mary (same location as SQLSaturday Orlando) and we’re hoping to have...

Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)

More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...

Select-AzureRmProfile : The term ‘Select-AzureRmProfile’ is not recognized as the name of a cmdlet, function, script file, or operable program

I got a chance to work with PowerShell automation script to automate the login process. In the script, the profile...

SQL Server 2008 end of support

2018 is about to end. In the case you didn't know or haven't heard, the extended support for SQL Server 2008 (and R2) reaches to an end in 2019.

This...

Azure Portal Enhancements – Switching Accounts

More and more I am impressed on the Azure Portal.  Microsoft continues to make enhancements to the user interface (UI)...

What is the Max Degree of Parallelism setting for SQL Server?

Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server.  What exactly does...