PowerShell-Input-Validation Scripts

Input values are validated using various mechanisms.  let’s start by examining how you would validate input parameters in Windows PowerShell...

Resume Generating Event (RGE)

No, I haven't lost my job. This is just one of those topics that's good to get out there. There...

Sorkin On Writing

I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL...

The default autogrowth settings do NOT come from the Model database.

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed...

Video: Designing Stored Procedure Solutions

My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...

Why Can't I Reinitialize My Subscriber?

I recently had a colleague request help with a replication problem he was having with a client.  The client was...

PROBLEM - ERROR EXECUTING SSIS PACKAGE FROM SQL JOB. Error Message would be something like this - failed to load xml file...

SOLUTION...

SQL Agent Error During Windows Failover Cluster Setup

Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...

When issue is not exactly "issue"

In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...