What’s New in SQL Monitor 10?

SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.

Relationally Divided over EAV

A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.

How to deploy a database plus static data using SQL Compare and SQL Data Compare

This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.

Why Object Databases will always be Tomorrow's Technology

For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?

Sweeping out SQL Server 2005

Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.

SQL Server Source Control Basics

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.

SQL Server Source Control Basics

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.

• Download free eBook
• Printed book:
  • US
  • UK
• Kindle book:
  • US
  • UK

Swallowing the Camel

There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]

Mongo Jumbo Backups

Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.