It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion leads to the pros versus cons of each. The need to apply updates and the balance with the business requirements. Pros and Cons of Windows and SQL Server updates on Production SQL Servers: PRO: Service …

Latest Service Packs – To Install or Not to Install? Read more »

Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers.  Since then I have used it but, but realized that what I really needed was a diff tool to compare two strings similar to the command line diff tool. First we take a look the SplitWithLineNumber from the previous article.  This …

VARCHAR diff function Read more »