A Script a Day

In February I will be starting a series of Blog Posts I'm calling a "A Script a Day".  Each day...

Actual Emails: Is "NOLOCK is the epitome of evil?"

Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,

Can you send me references to support my contention that NOLOCK...

Afterthoughts: IT Pro Camp Orlando 2012

This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...

Clicking on Links in Email

Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...

Determining Active Directory Group Membership

As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers.  There...

Generate test data using DBGen

Over the last couple of months I have on several occasions found myself in need of test data for demos,...

PASS Performance VC Reboot

The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant...

Read contents of a file to variable – SSIS

Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...

RECONFIGURE can flush the procedure cache

I ran across this KB article the other day, which lists a few ways in which performance is affected by...

Sitting Between Two Stools: Analysis Services 2012, Windows 8 and Market Niche Confusion at Microsoft

In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...