This is one of them little options that I see which quite often gets little consideration, or gets set to a user database without consideration of what the consequences may be if that default database becomes unavailable. There are going to be situations where setting a default database other than the master database is essential.... Continue Reading →
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
Here is a relatively simple yet effective stored procedure to quickly view those failed login attempts (an alternative to viewing the SQL Server Error log manually and filtering). There are other ways of getting this information, but we liked the idea of having a stored procedure that we could run Ad hoc when we wanted. Its... Continue Reading →
SQL Undercover 