The Great Blog Move of 2013

For at least a year, I’ve been considering changing blog platforms.  I set up my blog on TimMitchell.net using BlogEngine.NET...

Vote for my SQL Bits sessions

“Rob? Tsk tsk tsk. That’s a naughty word. We never rob. We just sort of borrow a bit from those...

Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database

Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...

Free SQL Server Learning Resources - Jan'2013

 Database Normalization (some useful links)
http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples
SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm

SQL Server Database Administration
DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/
DBA Best Practices
http://www.bradmcgehee.com/presentations/
Free eBooks (to...

Querying and Optimizing DAX

Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit.  One of the presentations I...

Re-Awarded as a Microsoft MVP

Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....

sp_spaceused system-stored procedure

You can use the sp_spaceused system-stored procedure to return space usage information about a database or a table within a...

SQL Server Consulting–New for 2013

Today is the first full work day for me in 2013 and I though I’d use it to write a...

T-SQL Tuesday #38 – Standing Firm

Introduction Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community.  This is the party that happens on the second Tuesday of...

Looking Forward to the New Year - Professional Goals

Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....