Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.
If you want to speak at SQL Saturday #38 in Jacksonville, FL on May 8, 2010, there's still time to submit a session.
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.
We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?
For this Friday's poll, Steve Jones asks if there is a set of essential software that every DBA needs to have installed on their machine.
This article examines the various methods for retrieving data from an Audit table.
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
A guest editorial from Andy Warren today looks at choices in time management, as well as work accomplished.
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
Comments posted to this topic are about the item BIT_COUNT in SQL Server
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers