5 Great Articles on Data – Oct. 2015

The Unbearable Lightness of Data

Have you ever tried explaining your job to family or friends and seen their eyes glaze over? Will Thrash explains it better than we did. In the first 15 minutes or so of this video he talks about how he first got interested in data at a young age, and why it still holds his interest to this day. You can tell he gets why we do what we do, and why we all love it.

In the latter half he gives a good overview of different philosophies and technologies in the market today, including Kimball design, Hadoop, and more.

QuasarByte Blog

This blog is beautiful in its simplicity. Each post is simply a useful query for Netezza, like a query for user sessions, a query for primary keys, a query for database objects size, etc.

Seeding SQL RAND Method With NEWID for Per-Row Random Values

At some point you may have attempted to use the random function in a query expecting to get a different random number on each row, and discovered that it doesn’t exactly work that way. This post shows the ingenious technique of seeding the random function with the newid() function, creating a new random number for every row. I’ve used this trick to create sample data for several articles on this site!

Sending a DataTable to a Stored Procedure

A very useful trick that many don’t know about; you can send a whole data table to a stored procedure. The trick is to create a user-defined table type. This article shows how to wire it all up.

The Side Effect of NOLOCK

A great article on the danger of the infamous NOLOCK hint. Jason Strate makes a compelling point at the end that I’m personally familiar with: reports that give an incorrect result, but then a correct result when the user re-runs them. I don’t know how much time I’ve wasted looking for bugs in query logic when NOLOCK was the culprit all along.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s