Posted inSQL Server

Database Corruption Week 2 Solution

Database Corruption Week 2 Solution Unfortunately I missed week 2 submissions, but here is my solution for week two. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-2-database-corruption-challenge/week-2-challenge-details/  …
Posted inSQL Server

Database Corruption Week 1 Solution

Database Corruption Week 1 Solution Here is my solution for week one. The original database and details for this can be found here: http://stevestedman.com/2015/04/introducing-the-database-corruption-challenge-dbcc-week-1-challenge/    
Posted inBlog

New Lab Environment 2015

I have recently been looking at solution for hardware for a new home lab. The primary need was a lower power solution, with plenty of ram and the ability to run…
Posted inSQL Server

SQL Index dm_db_index_xxx_stats

There are 3 dm_db_index_xxx_stats objects that can be used to check and investigate index information. sys.dm_db_index_usage_stats can be used to see how beneficial the index is, and its related maintenance…
Posted inBlog

Surface Pro 3

Surface Pro 3 My first impression of the Surface Pro 3 was that Microsoft had produced a tablet/laptop that was really tempting. The choice of which model to buy is…