SQL Index Fragmentation and sys.dm_db_index_physical_stats

Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...

Renewed as MVP for SQL Server

I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...

Renewed

I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized...

2011 – The dissection

 
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...

Roles and Responsibilty of SQL Server DBA

What is a role of a DBA in an organization?What are the daily activities of a DBA?What shall I check...

2012: SQL Server, Olympics, Football and Darts

Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this...

SQL Server DBA – Grow as a DBA

It’s the first day of 2012.  Setting New Year Resolutions is often a futile activity – and  resolutions I’ve set in...

Wishing you all a very Happy and Prosperous new year, may success comes to your doorstep
Image source : Top CNN...

Book review - SQL Server Secret Diary (Know the unknown secrets of SQL Server)

Like a lot of people within the SQL community, I can never read enough on the subject.  Books, whitepapers, academic...

Happy New Year

Image: ponsuwan / FreeDigitalPhotos.net
As 2011 draws to a close and as people look forward to evening of partying and celebrating I’d...