What skills do you need to be a DBA? Lots of different ones, but people often forget there are non-technical skills that matter. This article by David Poole examines some of the softer skills
that can help your career.
2001-08-28
7,967 reads
This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]
2001-08-27
3,167 reads
2001-08-26
1,448 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,175 reads
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
2001-08-24
4,429 reads
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,974 reads
Want to learn more about some of your favorite authors. Check out this interview with Robin Dewson.
2001-08-15
3,463 reads
This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,957 reads
The script will monitor the growth of the databases on your server. It is really meant to just get you started on a more detailed solution.
2001-08-08
5,391 reads
The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.
2001-07-27
5,407 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers