This post refers to an older version of this procedure. Please see HERE for the latest version. Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots. This new version adds more flexibility to the procedure, allowing you to specify the snapshot's suffix, add a timestamp and alter the path... Continue Reading →
Just a quick post this time , I was fumbling around the DMV's the other day looking for a specific Availability group DMV that I just couldn't remember the name of - I think we have all been there before with some of the DMV names! 🙂 Whilst I was combing through various combinations of... Continue Reading →
I quite often find myself scripting objects out via T-SQL rather than using the GUI, it's not that I have anything against using the GUI to script out a Stored procedure, it's just that sometimes this can be time-consuming especially when there are alot of stored procedures in the Programmability folder. I know that... Continue Reading →
One way i tend to query multiple servers in one go is to use Registered servers, but there are times when I might need to run something against a specific set of servers which i do not have a Registered servers group for, or maybe i need to select these servers dynamically. Maybe i do... 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 →
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 →
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 →
SQL Undercover 