Cumulative Update #11 for SQL Server 2014 SP1

The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...

Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell

In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...

Monday Coffee 2017-03-13

Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for...

TSQL2sday – Daily database WTF

This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...

VS Code PowerShell Snippets

Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...

Next Stop, SQL Saturday Richmond

I can’t believe it’s almost time for SQL Saturday #610.  I’ll be there presenting What is Power BI?  If you...

Thinking about Chapters (aka Groups)

I think it was 2003 or 2004 when someone from PASS came to Orlando and helped start what became OPASS....

Run a Job on SQL Azure (Using SSIS Package)

Requirements: A valid azure account, Local Instance of SQL Server (>= 2012), SQL Server Data Tools, Excel 2007 or above

Scenario: Dump...

PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet

Abstract
A common task of any administrator is to manage and maintain the application availability by checking the various services status,...

Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2

I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...