by Brad M. McGehee – So what options does an intelligent individual, such as yourself, have if you want to become a DBA (or to become a master DBA, if you are already a newbie DBA)? If you can’t get the training you really need from classes, where do you turn? If you are like most DBAs I
Tag: sql server
By Cathan Cook – This article provides insight into the inner workings of SQL Server architecture. It covers database engine enhancements, providing usage tips and pointers to more information. Understanding depth information about the SQL Server engines can help a Database Administrator (Database S
View Chapter 6, XSD Schemas, of this SQL Server book online.
One of the downsides of SQL Mail is the fact that it is tied to a MAPI Profile. Here is a way to send email using the sp_OACreate procedure to call a third party SMTP component.
Discover the information you need to evaluate SQL Server based on its performance, scalability, reliability, market momentum, cost of ownership, and ease of use, from the industry's leading sources. You will also find a list of reference links that will provide quick access to statistics, benchm
By Tony Bain – It is surprising the number of application developers who over look the need for database object code source control. This article is intended to demonstrate how version control can be used for database objects.
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
By Michael Otey – I have an opinion about nearly everything, but I'm on the fence about Visual Basic (VB) 6.0 versus VB.NET. Microsoft and the VB.NET proponents claim that VB.NET is the next evolutionary step for VB—finally bringing to VB some of the advanced features that other languages have e
We are giving away $2490 worth of bug tracking software usage from Red Gate Software in our new competition 'raise a bug'. The competition is very simple to enter – all you need to do is to raise a test 'bug' or 'issue' in the Aardvark competition database. To mak
In several recent articles we explored the fundamental concepts of SQL, the process of creating databases and database tables and the art of retrieving data from a database using simple queries. This article expands on these topics and looks at using join techniques to retrieve data from multiple t