SQL Server Service Information

DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...

Tables can't be compared

"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...

Tables can't be compared

"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...

The Side Project

When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...

AlwaysON RECOVERY PENDING SQL Server Bugs Enhancement Requests T-SQL Tuesday

AdvertisementsThis month’s T-SQL Tuesday topic is “SQL Server Bugs & Enhancement Requests” and hosted by my favorite and inspirational Brent Ozar.
 

 
Here...

Connect suggestion to add included columns to sp_helpindex

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...

Increased Productivity with the Pomodoro Technique – TAPtips

Today's TAPtips is about Increased Productivity with the Pomodoro Technique.  Have you tried the Pomodoro Technique? If so, what were...

My first Microsoft MVP Award!

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...

My first Microsoft MVP Award!

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing...

My first Microsoft MVP Award!

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...