This post is part of an impromptu series about PostgreSQL and things I am learning coming from a SQL Server background. A complete list of posts can be found on this post. While Triggers have gotten a bad rap in many circles and are often discouraged (great read by Joe Celko), they are still a … Read more
Over the last two years, as I’ve been working more closely on our application database (a database with nearly 20 years of history), one simple question keeps coming up as I work on old scripts and prepare new changes. Should we use a DROP/CREATE or CREATE/ALTER pattern for Stored Procedures, Functions, Views, and Triggers? Because … Read more
Who doesn’t love sp_WhoIsActive? Nearly every single DBA talk I have attended in the last two years mentions as a “must have!” I do the same during my DBA Newbie talk at SQL Saturdays. About 18 months ago I came across this post by Tara Kizer and started logging activity every 30 seconds on most … Read more
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s #tsql2sday event is being hosted by James Anderson (b|t) and this months topic is: Shipping Database Changes. This month’s #tsql2sday topic couldn’t have come at a better time. We’re once again faced with … Read more
Do you want to grow your blog by creating a Lead Magnet? Connect with new potential readers by offering something in exchange for their contact information, a name and email address. When my wife, Laura, was ready to offer her first lead magnet landing page I thought it would be an easy task. I thought, “Surely, … Read more