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 →
Here is a little quickie for a Friday afternoon , one for the back pocket maybe? Here is a scenario that you may have been faced with before, I am pretty sure we all have at some point but today I want to show a neat little way to get around this situation which does... Continue Reading →
When Microsoft announced STRING_SPLIT, cries of joy and jubilation could be heard all around the offices of SQL Undercover. For those of you who aren't aware of this miracle of the database world, we've finally got a way of converting a delimited string into a table. If you've ever written a proc or script where you... Continue Reading →
I like finding ways of making things easier , recently I started toying with Snippets within SQL Server Management Studio to find that I could reduce the amount of repetitive typing that i regularly do for things such as calling store procedures. I will show you what I did, there may be other ways and... Continue Reading →
The dreaded '3013 - RESTORE LOG is terminating abnormally' message! the bane of my life, until recently... So I find myself looking through our automated backup restore job history, and i see a bunch of the '3013' errors and I am wondering what on earth is going wrong here, this could be anything! The error... Continue Reading →
Unless you've been living under a rock for the last few years I'm sure that you've all heard of that mystical world that is Azure and some of us may even know people who have visited that land but how do we get there ourselves? Well don't worry my fair database folk, there's no need... Continue Reading →
Database mirroring has been deprecated since SQL Server version 2012 and now with the advent of SQL 2016 SP1 which happens to include two node Always On in Standard edition, surely there's no place in the World for it, right? Consider this scenario for a moment, you've got a 2TB database that lives on Server... Continue Reading →
SQL Undercover 