SQL Tutorial - Free Templates - Free Cpanel Hosting


Use This SP to Generate a SQL Server Job Report Have you ever wanted to create a report listing all of the SQL Server jobs on your SQL Server 7.0 or 2000 servers? This is easy if you use the stored procedure I have created just for this purpose
http://www.sql-server-performance.com/sm_job_report.asp			Hits:120
All About Passwords Neil Boyle explains the mechanisms SQL Server uses to secure itself from unauthorized access, and discusses best practice for selecting and administering passwords
http://databasejournal.com/features/mssql/article.php/1582981			Hits:115
An Introduction to Triggers -- Part I 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..
http://www.sqlteam.com/item.asp?ItemID=3850			Hits:106

An Introduction to Triggers -- Part II 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 ..
http://www.sqlteam.com/item.asp?ItemID=6494			Hits:100
Creating DTS Packages With SQL Server 2000 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 INSERT INTO `sites` VALUES(Database Administrator..
http://www.devarticles.com/art/1/64/			Hits:97
Are SQL Server Temp Tables Really Necessary? 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
http://www.sql-server-performance.com/rd_temp_tables.asp			Hits:94
SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning First in a series of new articles on how to best upgrade SQL Server.
http://www.sql-server-performance.com/jk_sql_server_upgrade.asp			Hits:94

Auditing Your SQL Server Environment Part I 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
http://www.transactsql.com/Articles/NEPI.html			Hits:92
Comparing Tables 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
http://www.sqlteam.com/item.asp?ItemID=7269			Hits:87
Beware of Mixing Collation with SQL Server 2000 - Part 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
http://databasejournal.com/features/mssql/article.php/1587631			Hits:83
Page: 1 2 3 4 5 6 7