SQL Server 2000 Black Book
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
Cell Phone Horror Stories
These are some stories that show the downside of everyone having cell phones.
Getting The Best From The Index Tuning Wizard
The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.
Using DTS Global Variables
Global variables are a little known solution in Data Transformation Services (DTS). Often packages become "stale", where you must develop a package for each client.
Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.
DTS Basics
In this article, we get you started with the core knowledge you'll need to transform your data using DTS.
Incorrect Reporting of Date and Time in Performance Log Files
If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.
Non_Continuous Replication
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
Blogs
Build Recovery into the Design
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
dataMinds Connect 2024 – Session Materials
The slides and scripts for my session “Tackling the Gaps & Islands Problem with...
Want to Supercharge Your Business? SQL is Your Secret Weapon.
Look, we all know data is king these days. But having mountains of data...
Forums
Log Backup failed on Secondary Replica
I have a scenario where log backup is getting failed in Secondary replica on...
Everything is Code
Comments posted to this topic are about the item Everything is Code
Question of the Day
Statistics Histograms
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers