An Interview with Louis Davidson
Want to learn more about some of your favorite authors. Check out this interview with Louis Davidson, author of Professional SQL Server 2000 Database Design.
2001-08-23
2,968 reads
Articles
Installation Problems in SQL Server 7.0
This article examines some of the common issues that may occur when installing SQL Server 7.0
2001-08-23
3,374 reads
Aggregating a Set of Hierachical Records
A great deal of data in any RDBMS is hierarchial. This article presents a technique for aggregating this data.
2001-08-22
3,085 reads
Review: Log Explorer 2.1
Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.
2001-08-22
6,352 reads
Strategies for Backing Up and Restoring Transactional Replication
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
2001-08-21
2,176 reads
Design Oversight - Preliminary Review
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
2001-08-20
8,231 reads
2001-08-20
3,501 reads
Recover Those Packages!
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,896 reads
An interview with Robin Dewson
Want to learn more about some of your favorite authors. Check out this interview with Robin Dewson.
2001-08-15
3,448 reads
Review: Loading Sample Data with DataTect 1.6
So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.
2001-08-15
3,933 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers