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.

Pick a Database, any Database…

All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.

SQL Standard Confusion

The whole universe, the well-guarded people—may they all query databases together in a single language!

SQL Server Crib Sheet Compendium

As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.

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.

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.

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

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.