(Latest Version 1.8 - 23 November 2020) I'm sure we've all been there, we need to restore a database to 11:34am, four days ago. What's the first step? To go off hunting down the relevant full and differential backups and then figure out what transaction logs we need to play in and in what order.... Continue Reading →
I know I know, Why not just use the GUI right? well that's ok but sometimes the GUI just takes too long for me...maybe I am a little impatient but sometimes I just need something to run that will give me the answers in just a couple of seconds with the touch of a button.... 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 →
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 →
SQL Undercover 