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 inSQL Server

Check status of SQL Jobs

Finding out the status of SQL Jobs is a simple task which can be accomplished via the GUI or in code using EXEC msdb.dbo.sp_help_job. However one issue that is encountered…
Posted inBlog SQL Server

SQL Event for July 2014

Almost July 2014 and looking forward to what will no doubt be another great SQLBits. This time in Telford. SQLBits XII 17th - 19th July 2014 The International Centre, Telford http://sqlbits.com/ However…
Posted inSQL Server

Dangers of giving dbo in MSDB

I wanted to talk today about something that I have often seen in environments which is that dbo is granted to msdb without a second thought to the exact implications. So…
Posted inBlog SQL Server

SQL Saturday 269 Exeter

Not quite sure where the time is going this year, but coming very shortly is SQL Saturday 269 in Exeter and it is well worth attending. http://www.sqlsaturday.com/269/eventhome.aspx This event will…
Posted inSQL Server

SQL Server Login password hash

In this article we will look at how SQL Server stores passwords and how we can go about working them out. As a developer/administrator you are probably accessing SQL Server…