Bacon Blog Day 3: Salty Talk

by @WidowPage Before I show you the curing process, we need to talk about salt and how it turns pork belly into bacon.  Curing doesn’t happen without salt.  If you look back into the history of bacon, humans all over the world were packing pork belly into salt to preserve the meat.  The Chinese and Europeans started curing meat as early as 1500 BC.  According to the Pork Board of America, Hernando de Soto’s herd of 13 pigs sparked early conflicts with Native Americans who developed a fondness for the taste of pork.  His herd eventually grew to 700 hogs,…
Read More

Video: SQL Prompt Execution Warnings

A while back, I wrote about how SQL Prompt now includes execution warnings and how useful I think that feature is. It's saved my bacon several times now, including just last week! I'm now happy to announce that I've recorded a demo video of this feature for Redgate's series of #SuperSQLTips for SQL Prompt. Be sure to check out my video, as well as the rest of the series - there's some super-helpful stuff in there!  
Read More

Helpful Tech Tools for New Parents

Parenting is most definitely something that parents are constantly learning more about. Our son is 11 weeks old today, and while Michelle and I are by no means experts, we've learned a bunch in that time. We've also found some techie tools that have proved incredibly helpful these past few months, and I wanted to take a brief break from database speak to share them. Here they are, in no particular order: Baby Tracker. This awesome app helps you keep track of your baby's eating, sleeping, and diaper-ing. It's incredibly simple to use, and never again will you have to wonder if…
Read More

SQL Prompt 7.2 – Now With Execution Warnings!

I've loved using Redgate's tools ever since I discovered what they were, and now that I'm a Friend of Redgate it's even more fun because I get to give feedback to their developers and hear all about what's coming out in new releases! Recently, Redgate announced SQL Prompt 7.2, with a bunch of new features and improvements. My personal favorite of all these is execution warnings. Databases (and computers in general) have this pesky habit of always doing exactly what we tell them to do, instead of doing what we really meant to tell them to do. Have you ever been burned…
Read More

Signed Integer Ranges: Why and How

Whether you are working in T-SQL, Oracle, MySQL, C#, or Java, the range of possible values for a signed (positive or negative) 32-bit integer is from $latex -2^{31}$ or (-2,147,483,648) to $latex (2^{31})-1$ or (2,147,483,647). The fact that it's so consistent across so many different platforms (and also against plenty of others I didn't list) means there has to be more to it than just the preference of some developers somewhere, right? Exactly right. Down to the bits Any data your computer deals with, be it numbers, text, music or videos, all end up in binary at one point or another. Binary means…
Read More