Today Steve Jones talks about development, and finding ways to make small changes that improve your code.

The Potential of Joins

by Ashutosh Pandey

SQLServerCentral.com

T-SQL

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins

Another Look at Tuning Big Data Queries

by Additional Articles

Database Journal

Big Data

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.

How do you develop and deploy your database?

by Press Release

Redgate

Deployment Process

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.

Small Leadership

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks leadership, and the value it can bring to your team if you display just a little of it.

The DRI Subject of References

by Additional Articles

SimpleTalk

A database must be able to maintain and enforce the business rules and relationships in data in order to maintain the data model. It does this through referential constraints. They aren't complex, but are powerful, especially with the means to attach DRI actions to them. Joe Celko explains all, and pines for the ANSI CREATE ASSERTION statement.

Making Plans

by Steve Jones

SQLServerCentral.com

Editorial

PASS President Tom Larock doesn't make long term plans. Steve Jones doesn't make long term plans. Do you?

Error handling with try-catch-finally in PowerShell for SQL Server

by Additional Articles

MSSQLTips.com

PowerShell

PowerShell V2 introduces the "try-catch-finally" statements, similar to those you already use when you write .NET code. "Try-catch-finally" encloses a block of script that is likely to produce errors under specific circumstances and therefore helps you to keep your code organized. This article is a short usage guide for this error handling construct.