• submit to reddit
Erik Ejlskov Jensen04/08/14
0 replies

SQL Server Compact Toolbox 3.7.2: A Visual Guide of New Features

After more than 260.000 downloads, version 3.7.2 of the author's SQL Server Compact Toolbox extension for Visual Studio 2013, 2012 and 2010 is now available for download. This blog post is a visual guide to the new features included in this release.

Lukas Eder04/07/14
0 replies

CUME_DIST(): A Lesser-Known SQL Gem

When doing reporting or statistics with SQL, you better know your window functions. There are many of them, and few SQL developers know about them. CUME_DIST() is one such function.

Erich Styger04/07/14
0 replies

What Meetings feel like for Engineers

And here I share my newest fun story (a video this time): An engineer as an ‘expert’ in a business/requirement meeting. The task is simple: create seven red lines. But the twist is that these lines must be perpendicular…

Mpumelelo Msimanga04/07/14
0 replies

Visualizing SQL Statements

Having a visual representation of a SQL statement can be helpful in deciphering the statement. My visualization tool of choice for SQL is an Open Source application called Reverse Snowflake Joins (REVJ). As the name implies, this tool shines when it comes to showing you how your tables are related.

Mike Bushong04/07/14
0 replies

Timing technological change: creation vs. consumption

What is happening now is that we are at some risk of the luminaries creating an impassable distance between their vision and the on-the-ground reality in many IT shops today.

Eric Minick04/07/14
1 replies

Is Continuous Delivery just Continuous Integration done right?

If you want to understand why I think CI and CD done correctly are almost the same thing, follow me down the rabbit hole.

Mike Stonebraker04/07/14
0 replies

VoltDB: Creating an Openshift Cartridge, Part 1

This blog describes a new Openshift cartridge developed for the VoltDB database. I’ve been doing research on VoltDB and figured that others might benefit from having quick access to an Openshift hosted instance of the database. VoltDB is truly impressive in both performance and in capabilities.

Alec Noller04/06/14
0 replies

The Best of the Week (Mar. 28): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include performance tips for SELECT statements in SQL, a product that claims to implement "reactive programming" through a REST and JSON API, VoltDB's support for unconventional transactions, and more.

Alec Noller04/05/14
0 replies

SQL Zone Link Roundup (Apr. 5)

For a look at what's been happening outside of the SQL Zone, we've assembled a collection of links from around the web. Stories include a performance comparison of 4 databases, PostgreSQL pain points, bad things Linux might be doing to PostgreSQL, an Oculus VR SQL injection vulnerability, and more.

Lukas Eder04/05/14
0 replies

MySQL Bad Idea #666

MySQL… We’ve blogged about MySQL before. Many times. We’ve shown quite a few bad ideas implemented in MySQL. But this beats everything.

Johanna Rothman04/04/14
0 replies

Who Solves Which Problems?

When someone else tells you what a standard for your work has to be? How does that feel to you?

Konrad Garus04/04/14
0 replies

Be Careful With Native SQL in Hibernate

The author really likes Hibernate, but also doesn’t know a tool that is nearly as powerful and deceptive at the same time. I could write a book on surprises in production and cargo cult programming related to Hibernate alone. It’s more of an issue with the users than with the tool, but let’s not get too ranty.

Tom Howlett04/04/14
0 replies

A Creative System of Work

Let those people creating the software, create the system of creation too.

Greg Duncan04/03/14
0 replies

Six Videos To Help You Upgrade your Inner DBA to SQL Server 2014'ness

In this post, you'll find a collection of resources to help you get up to speed with SQL Server 2014, as well as some to provide an overview of new features and enhancements.

Mpumelelo Msimanga04/03/14
0 replies

How to Pivot Data in SQL

Most pivoting of data is done outside of relational databases. Relational databases are rigid, and the variable number of columns in a pivot table do not go hand in hand with the rigid structures defined in relational databases. However, pivoting in SQL can sometimes be very useful.