MsSQL Subcategories |
Creating DTS Packages With SQL Server 2000 |
| MsSQL | Views: 0 | |
| Back in the days when Microsoft SQL Server 6.5 was still hot property, the bulk copy program was the only way to backup or export databases from SQL Server to other data sources, such as other database servers or text files. DBA's (Database Administrator.. |
Comparing Tables |
| MsSQL | Views: 2 | |
| We're in the process of rolling out a new version of a SQL Server-based software package at work. I already have numerous scripts that load tables and I was trying to find out which ones would break. I needed an easy way to compare tables |
Compare SQL Server Databases with sp_CompareDB |
| MsSQL | Views: 3 | |
| I bet almost every DBA has at times desperately wanted to be able to compare data and structure between database tables, or even whole databases for that matter. Wouldn’t it be nice to have a stored procedure that uses only two parameters -- the name of .. |
Building a Mail Queue System |
| MsSQL | Views: 0 | |
| This article demonstrates an email queue system using SQL Server and VB Script. This overcomes the limitations of the Sending SMTP Mail using a Stored Procedure method |
Beware of Mixing Collation with SQL Server 2000 - Part 1 |
| MsSQL | Views: 1 | |
| Gregory A Larsen explains a few things that need to be understood about mixing collations, now that it is possible to have multiple collating sequences on a single database server |
Auditing Your SQL Server Environment Part I |
| MsSQL | Views: 0 | |
| This article is the first of a series that I plan on writing and placing on my website to help other DBAs in auditing a new SQL Server environment. This article deals with determing which SQL Server logins have weak passwords, with the definition of weak |
Are SQL Server Temp Tables Really Necessary? |
| MsSQL | Views: 1 | |
| Learn the the pros and cons of using SQL Server temp tables. Also find out how to optimize temp tables, assuming you can't find a way to avoid using them |
An Introduction to Triggers -- Part II |
| MsSQL | Views: 0 | |
| A few months ago I wrote an article for SQLTeam called An Introduction to Triggers -- Part I. The article covered trigger fundamentals--the most important being the way the inserted and deleted virtual tables work. I also showed an example of how to use .. |
An Introduction to Triggers -- Part I |
| MsSQL | Views: 0 | |
| A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure." The main difference between a trigger and a stor.. |
All About Passwords |
| MsSQL | Views: 0 | |
| Neil Boyle explains the mechanisms SQL Server uses to secure itself from unauthorized access, and discusses best practice for selecting and administering passwords |
|
