The Complexity of Managing a SAN
This article from Veritas does a good overview of the complexities involved in managing a SAN. SAN's are here to stay, even if you don't have one, you should be reading about them.
2003-06-26
550 reads
Articles
Managing Jobs - Part 4
Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.
2003-06-25
8,022 reads
Deleting Child Data Based Upon Criteria in the Parent Table
New Author! Thom's first article discusses the difficulties you encounter when your database doesn't support cascading deletes (or you've opted not to use it) and you need to delete data in a child table based upon a value in the parent table. Not exactly your run of the mill delete query. Take a look and please rate/comment the article!
2003-06-24
5,295 reads
SQL Server DTS Best Practices
This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.
2003-06-24
4,068 reads
Managing Max Degree of Parallelism
Herve has done some work experimenting with max degree of parallelism (DOP) on some large multi processor blocks and based on that, has some recommendations for you if you're using more than 8 processors. Good reading!
2003-06-23
31,277 reads
SQL and IIS on the same Box?
David takes us through why he believes trying to run SQL and IIS on the same box is a bad idea. It's a common notion that it IS a bad thing to do, but you have real justification? Read this and you will!
2003-06-20
14,616 reads
Free BCP GUI
Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.
2003-06-19
1,922 reads
UDF as Computed Column
UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.
2003-06-18
12,301 reads
myLittleAdmin for MS SQL and MSDE released !
myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.
2003-06-17
1,164 reads
In the Real World - Lost Data Chains
How do you deal with problems in the real world? What steps should you follow? A new series looking at actual experiences at work. This one looks at a weeklong adventure in troubleshooting SQL Server applications.
2003-06-16
4,965 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
Question of the Day
Backing Up a DMK
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