Jeremy Hillpot, November 22, 2019

The MONEY data type in SQL Server is shrouded in mystery. What is it for? When should you avoid it? What advantages does it bring? What is the difference between it and the DECIMAL data type? Read our in-depth guide on the SQL MONEY data type.

Doug Breaker, November 13, 2019

Introduction The volume, variety, and velocity of big data are all swelling dramatically. According to a survey by market intelligence firm IDC, the average company now manages a mind-boggling 163 terabytes (163,000 gigabytes) of information . How can businesses hope to manage and utilize these never ending streams of information ...

David T, September 5, 2019

Introduction Enterprise data management and analysis is growing more complex and difficult by the minute, as businesses struggle to make the most effective use of the vast arrays of information at their fingertips. According to a 2017 survey, 95 percent of Fortune 1000 companies have embarked on a big data ...

Jeremy Hillpot, August 23, 2019

*Much lonely... Nobody likes to feel lonely. Not even your SQL table data. Fortunately, a SQL GROUP BY clause can bring it all together—so your data never feels alone. GROUP BY clauses are a powerful way to organize your SQL data into useful statistics and business insights. This fun tutorial ...

David T, August 9, 2019

If you’ve been learning about data warehouses for your business, you might have run across the term “star schema.” What is a star schema exactly, and do you need a star schema for your enterprise data warehouse?

Jeremy Hillpot, June 14, 2019

During the last three months, I learned to code in SQL (for free). I went from an absolute newbie to intermediate status using free resources on the internet. In this guide, I'll show you how to do the same, in 30 days or less. Something you should know about learning ...

Erin Forst, June 4, 2019

The right attention at the right time could be the difference between your startup becoming the next Amazon or fading into oblivion. Having a great idea that solves a problem is an important part of the journey, but you also have to make sure people know about it. With the ...

Jeremy Hillpot, May 31, 2019

Sequel Pro claims to be "a fast, easy-to-use Mac database management application for working with MySQL databases." It also boasts a 5-star rating on MacUpdate with glowing user reviews. Sounds excellent, right? When you add the fact that Sequel Pro is free, opensource software , it's an attractive option for ...

Jeremy Hillpot, May 17, 2019

I'm a tech writer. Not a programmer. And until a short time ago, I had never written a single line of code in my life. But then something changed: SQLBot challenged me to review SQLZoo's Structured Query Language course… SQLZoo ...

Doug Breaker, April 12, 2019

Most businesses generate data. Tons of data. Oceans of data! One of the biggest challenges confronting business today is consuming that data. How can you examine and combine the data? How do you make sense of the data? Where to begin? Man, I wish I was surfing There are two ...