Look At The SQLSaturday Orlando Home Page

One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...

Bad Ideas: Alert Storming

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...

The Phoenix Project: a DBA rises from the ashes

About a year ago, fellow blogger Thomas LaRock recommended the book The Phoenix Project, claiming that “every business leader and...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.

For example, instead of this:...

PowerShell, help me to publish my SSRS reports to SharePoint!

Every time when I heard the word 'PowerShell' it was just like a call to Terra Incognito, you know nothing...

Doing it with the EzAPI

In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...

5 Things a developer should know about databases

Database Normalization

Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th...

VMware Certification Changes

The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...

Auditing VMware vCenter Actions (on SQL Server)

When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....