Today Steve Jones looks at the potential downfalls of monitoring every change without lots of filtering.

Why Would I Ever Need to Partition My Big ‘Raw’ Data?

by Additional Articles

SimpleTalk

Big Data

Whether you are running an RDBMS, or a Big Data system, it is important to consider your data-partitioning strategy. As the volume of data grows, so it becomes increasingly important to match the way you partition your data to the way it is queried, to allow 'pruning' optimisation. When you have huge imports of data to consider, it can get complicated. Bartosz explains how to get things right; not perfect but wisely.

Service Broker Error Handling

by Paul Milligan

SQLServerCentral.com

Service Broker (SSSB)

How to handle errors raised during Service Broker Queue Processing.

What is Normal?

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor on the virtues of "over normalizing"

Wow. Just Wow

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks at the loss of a database backup on a public website.

Implementing a custom sort

by Additional Articles

SQLPerformance.com

order by

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.

Share the Interesting Work

by Andy Warren

SQLServerCentral.com

Editorial

Today we have a guest editorial from Andy Warren that looks at how we might divvy up our workload in a company.

How to Start Big Data with Apache Spark

by Additional Articles

SimpleTalk

Big Data

It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and volume of semi-structured data that would be awkward for a relational database. With an IDE such as Databricks you can very quickly get hands-on experience with an interesting technology.