(Ryan Adams) I learned a hard lesson when I first started as a DBA. Although to be honest, it’s not a lesson I should have had to learn (I’ll keep you in suspense). I work for a large Fortune 100 company and as with many companies our size, there are many processes in IT.

(Arthur Olcot) Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to their latitude/longitude locations so I could use that data within some Tableau dashboards that I’m working on. I had a look around to see what I could find and quickly found both sites

(Kenneth Fisher) For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how truly useful they can be. To that end here is all that I can remember about batch files (basically a text file that ends with .bat).

(Pradeep Adiga) Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediate