Error : Property Size is not available for Database "[tempdb]"

Today when I clicked Properties of tempdb in SSMS, I got the error message below:

At first I thought the database...

Its the little things – Service Master Keys

In advance of the yearly licensing reconciliation with Microsoft at work, I have led the charge to ensure all of...

More on Password Managers

Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...

Rochester – Welcome to the PASS MN Family

It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...

Star Schema The Complete Reference – Review

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...

Transactions: Who, What and Where

Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...

Webcast Follow-Up: The Flavors of Non-Clustered Indexes

Earlier today, I presented a session for Pragmatic WorksTraining on the T’s titled The Flavors of Non-Clustered Indexes.  In the session,...

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

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

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