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...

Slammer, Alive…Barely

By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm it caused came largely due to unpatched, unprotected SQL...

Insert multiple rows from one INSERT statement

One of the things that has been annoying for a long time in SQL Server is adding lots of data...

January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries

Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...

Monday Morning Mistakes: Remote Connectivity to SQL Server

Inspired by common emails and questions I  see, I figured I’d do a series of blog posts on common mistakes...

New Article: How to audit sysadmin members on multiple servers using PowerShell

My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...

Notes from the January 2012 oPASS Meeting

It’s been quite a while – where did the time go? – since I had done a presentation for oPASS, so when...

Revamping SUG 2nd Meeting

Friends,
Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang...

S3OLV February 2012

Do you recognize this person?

 
If you are from the Colorado Springs area, you probably do.  This is:
 
 
 

Troy Ketsdever (twitter)
Troy will...