Windows 2000 Professional Certification Exam for Executives
Give this test to your boss...only if he has a sense of humor!
2001-08-27
2,825 reads
Articles
What's a DBA? - An Overview
Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.
2001-08-24
9,093 reads
The Self-Taught DBA
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
2001-08-24
4,429 reads
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,947 reads
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,339 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,040 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,322 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,205 reads
2001-08-20
3,471 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
Check sequential order of status of items
There is a table tblItems with below structure ( i cannot change the below...
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
SSMS V20 encryption vs SQL Server SSL Encryption
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers