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,097 reads
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,097 reads
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
954 reads
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,323 reads
2001-08-20
3,473 reads
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,856 reads
2001-08-13
4,063 reads
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,939 reads
2001-08-08
2,578 reads
This procedure will BCP out all data in a table. The format is designed to be used with the dbsp_bcp_in stored procedure to import the data back into a server.
2001-08-08
3,928 reads
This is a great administrative reference for anyone using SQL Server 2000.
2001-08-08
3,275 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...