PASS Board Update: May 2015

I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...

Speaking at ITPROceed 2015

This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT...

SQL Agent Job Wrapper Part 2 – Adding Error Generation to the Cmdlet

Last week I posted Creating a SQL Agent Job Wrapper with PowerShell and SMO. In that post I created a...

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutesI had a project once that was using change data capture (CDC)...
The post SQL F.A.D. – CSV List...

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...

Database Engine Tuning Advisor

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...

Default database

What?

The default database is one of the options when creating a login in SQL Server. This is the initial database...

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite
Once you have created your database you can now start to manage and configure it.
There are six...

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt...