Happy New Year! As we developers often do, I have recently looked at some code that had aged a bit – more like vinegar and less like wine – and thought, “Did I write that? What was I thinking?” Constantly becoming aware of and implementing best practices, avoiding bad practices, and recovering from failures are … Read more
…Code School has a new class for that! I’d like to say at this point that I don’t now, nor have I ever, had any financial ties to Code School. I say that because I know I’ve done a fair amount of free advertising here for them. It’s only because their online classes are the … Read more
This is closely related to my last post, where we were searching for text in the data itself, but now we’re just looking to see if the text exists in the statements that create views or stored procedures. This has been tested only on SQL Server 2008 R2. If you do not have permission on … Read more