SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases

Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script. 
You just need to run the...

Retiring of the MCM Certifications, Part II

Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...

Last Weeks Top “Reading” Links #47

It’s Tuesday, it’s time for weekly round-up #47.  As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...

Introduction to Integrity: Interpreting DBCC CHECKDB Results

I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most...

Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...

Skills I Used Last Week

Ever thought about what your average week looks like? What are the real core skills your environment uses every day...

Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...

SQLSaturday #250 in Pittsburgh

Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/

SQLSaturday is a full day FREE  training event for SQL Server professionals and those wanting to learn more about SQL...

When I run “Script as” it isn’t (or is) … How do I fix it?

When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...

SQLSat 235 Wrap-Up

Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for Curacao in my queue.  I had fully intended on...