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,826 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,100 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,949 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,345 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,041 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,324 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,207 reads
2001-08-20
3,473 reads
Blogs
Data Masking with Azure Databricks
By Rayis Imayev
“Alice: Would you tell me, please, which way I ought to go from here?The...
Grinding Away: Mary Spender
By Steve Jones
A few years ago I stumbled on this video and loved it. That led...
PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year...
Forums
How do I fix the, "Unable to process the existing user settings" error message?
I'm sure I've asked this question in either this forum, or another one, in...
Cannot restore new DB
I have made an empty DB called "HJEM_BB" I try to fill it from...
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item How to Avoid Incorrect Results...
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers