Introduction to MDX Scripting in Microsoft SQL Server 2005
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.
Using Indexes to Bypass Locks
One of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
Custom Log Shipping
This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.
The T-SQL Quiz
Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.
Configure SQL Server Service Broker for Sending Stored Procedures
Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
SQL Server 2008’s Management Data Warehouse
This article looks at the new Management Data Warehouse (MDW) that is incorporated into SQL Server 2008. This warehouse is performance analysis and capacity planning tool for DBAs. This article will discuss the basic architecture of the MDW and how to set it up using a wizard.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers