Where should SQL Server go in the future? Steve Jones continues to explore his wish list for future versions of SQL Server. This article looks at an area where much improvement is needed: the index tuning wizard.
2003-09-08
4,738 reads
Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!
2003-09-05
11,086 reads
Troubleshooting performance problems takes a lot of time and work. This article outlines the process the author uses - pretty interesting.
2003-09-04
7,461 reads
This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.
2003-09-03
11,076 reads
Where should SQL Server go in the future? What enhancements are needed? Steve Jones takes a break from his wishes to include some feedback from users who have some wishes of their own. Read about what real users of SQL Server would like to see included in future versions.
2003-09-02
3,681 reads
2003-09-01
5,853 reads
Stateless programming can be tricky... In case you ever need to return a specified subset of a query without first returning the entire recordset, here's a method.
2003-08-29
10,199 reads
The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.
2003-08-28
6,849 reads
Where should SQL Server go in the future? Steve Jones continues to explore his wish list for future versions of SQL Server. This one examines an enhancement that could speed up some of your queries by enhancing the index structures.
2003-08-25
4,245 reads
Joe Sack returns (is back?) with some scripts you can use to log information you may need when disaster strikes.
2003-08-22
1,438 reads
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 Managing Incidents and Fighting Fires
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
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