Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script

Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...

Tip: Jobs without a scheduled run

It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...

Using multiple CTEs in one query

This is a fairly simple thing to do, but I had to look it up the other day and thought...

Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!

The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...

Volunteers Needed For PASS SUMMIT

Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.

Not know what PASS is? head...

The “most_recent_sql_handle” column

While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...

PowerShell Remote Commands

This is something I've found useful here recently when I had a server acting up. It's a simple way to...

Easy Backup History Review Script

I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...

Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database.  As I pulled out the script from the...

Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...