Reasons Why People Who Work With Computers Seem To Have A Lot Of Spare Time…

SQL Server – Msg 2555, Level 16, State 1, Line 1 – Error DBCC SHRINKFILE with EMPTYFILE option

When tried to empty one of the tempdb data file using the below T-SQL command: (My goal here is to...

Thanks everyone for a fantastic SQL Saturday Lincoln #165

Today I presented two sessions at SQL Saturday Lincoln (almost in my backyard!) – Virtualizing Business-Critical SQL Servers and Database Health...

Class and instance variables in Python 2.7

The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...

How to avoid windows REBOOT after any operation required restart ?

Issue :
Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different...

Active flag on the TCP/IP Properties page of SQL Server Configuration Manager

I’ve been unable to connect to a server via one of its aliases for about a week.  When I looked...

SQL Azure–Failed to Update because the database is read-only

An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...

2012 PASS Elections Letter Of Recommendation From Karen Lopez

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...

Finding and removing hidden characters in your data using dynamic T-SQL

It has been a long morning for me. It was supposed to be a standard run for our quarterly data...

Reblog: September 28 to October 4

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...