Edgardo Valdez

Useful Links

Access

128809 - ACC #Deleted Errors with Linked ODBC Tables

Bugs and Fixes

281345 - PRB Dialog Box Opens During Backup Process Prompting You To Insert Disk in Drive A
296386 - FIX AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance
319246 - FIX Error Dialog Box During SQL Server Database Backup

Certifications

Microsoft Certified Professionals Worldwide

Disaster Recovery

304692 - INF Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE

DTS

Execute a package from Active Server Pages (ASP)
Global Variables and Stored Procedure Parameters
How can I check if a file exists
How to overwrite SQL Server DTS package logs everytime the package executes-runs Narayana Vyas Kondreddi's home page
Multiple Paths in Workflow
Package Ownership Issues
Portable DTS Packages
Sample Code & Packages
Skip the execution of an individual Task
SWYNK.COM Multiphase Data Pump Overview
Transferring DTS Packages
Using DTS to Detect and Process a File

IIS

Internet Information Server IIS 5 on W2K Server stops responding

Media

Bloomberg
Capitol Records
CBS
CNBC Dow Jones Business Video
CNET Today - Technology News
CNN Videoselect
Disney
ESPN Sports
Fox News
Fox Sports
Hollywood Online
Internet Radio Guide
MSNBC
MUSICVIDEOS.COM
NBC VideoSeeker
TV Guide Entertainment Network
Universal Studios Online
Warner Bros. Hip Clips
What's On Now
Windows Media Showcase

MS How-To

137890 - HOWTO Create a User-Defined Service
290991 - HOW TO Manually Remove SQL Server 2000 Default, Named, or Virtual Instance
307487 - HOW TO Shrink the Tempdb Database in SQL Server
314546 - HOW TO Move Databases Between Computers That Are Running SQL Server
Adding Counter Names and Descriptions to the Registry

MS KB INF

187824 - INF How to Move Tempdb to a Different Device
224071 - INF Moving SQL Server Databases to a New Location with Detach-Attach

Programming

4GuysFromRolla.com - Creating Excel Spreadsheets with Office Web Components (OWC), Part 2
Codefixer
Juicy Studio Visual Basic, File Handling and The File System Object (FSO)
Microsoft Visual Basic Visual Basic 6.0 Code Advisor
Tek-Tips Forums for computer professionals
Visual Basic How create a new Excel worksheet from VB recordset
Win32 Scripting.... Everything you need to get up and running

Quest Software

Software License Agreement

SAN

304261 - INF Support for Network Database Files

VBScript

Functions
TechTV Windows Tip Use Netstat to Track IPs
Trojan Ports to Block

SQL

#2403 How do I send e-mail from SQL Server
246133 - INF How To Transfer Logins and Passwords Between SQL Servers
255596 - INF sp_lock2 Returns Additional Locking Details
263556 - INF How to Configure SQL Mail
272093 - INF Effects of Nonlogged and Minimally Logged Operations on Transaction Log Backup and Restore Process
274188 - PRB Troubleshooting Orphaned Users Topic in Books Online is Incomplete
281345 - PRB Dialog Box Opens During Backup Process Prompting You To Insert Disk in Drive A
283696 - INF Job to Monitor SQL Server 2000 Performance and Activity
307487 - HOW TO Shrink the Tempdb Database in SQL Server
317748 - FIX Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memo
ACID - a searchDatabase definition - see also atomicity, consistency, isolation, and durability
Configuring SQL Server with Stored Procedures
Detailed Locking View sp_lock2
Disk Space Alert Script
DTSBackup Utility (VB)
Estimating the Size of a Table
FAQ check file exists from SQL Server
Fuzzy Software Newsgroups microsoft.public.sqlserver.server
Get Notified When Accounts Are Changed - SQLServerCentral.com Script Library
How to Determine the Version and SP of SQL Server
How to move SQL Server from one computer to another Narayana Vyas Kondreddi's home page
How to troubleshoot orphan users in SQL Server databases Narayana Vyas Kondreddi's home page
How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)
How To
http--www.swynk.com-downloads-roles.SQL
Information Schema Views
InformIT.com Working with SQL Server 2000 Management Tools and Utilities
Managing the Enterprise - Best Practices and Tips for SQL Server
Microsoft SQL Server - Quoted Identifiers in SQL Server 2000 - SQLTeam.com
Microsoft SQL Server Linked Server - Error 7405 Heterogeneous queries
Microsoft SQL Server Locked Out of SQL Server
Microsoft Visual Basic Visual Basic 6.0 Code Advisor
MSSQLCity.Com tuning articles
Network Appliance - SAP R-3 4.6x SQL Server 7-Windows NT Integrating with a NetApp Filer
PostgreSQL (PostODBC) and MS SQL Server 7
Put DBCC into a table
Reader Challenge
Restore a backup over a current SQL Dbase
Sample Disaster Recovery Plans
Some Useful Undocumented SQL Server 2000 Trace Flags
Songhay System - The Funky Knowledgebase - SQL and Database Management Systems
SP_MSFOREACHDB - Databases List Via TSQL
sp_MSforeachtable
SQL How To's Part 1
SQL How To's Part 2
SQL Server 2000 Clustering Database Tips
SQL Server 2000 Recovery Models Give You Backup-and-Restore Flexibility
SQL Server 2000 Some Useful Trace Flags
SQL Server 7.0 Replication FAQ and common problems Narayana Vyas Kondreddi's home page
SQL Server 7.0 Replication FAQ and common problems, part 3 Narayana Vyas Kondreddi's home page
SQL Server Database Performance Tuning Tips
SQL Server Forums - How to update password for copied logins
SQL Server Script Library - Backup - Restore (for SQL Server 2000 and 7.x)
SQL Server Script Library - Miscellaneous (for SQL Server 2000 and 7.x)
SQL Server SP Versions
SQLDTS.com - Data Transformation Services on the web
sqlServer.co.nz - sp_MSForEachDB
SQLServerCentral.com Script Library Get Notified When Accounts Are Changed
SQLServerCentral.com Script Library
SWYNK.COM
System Stored Procedures
Tek-Tips Forums for computer professionals
The curse and blessings of dynamic SQL
The undocumented nature of sp_readerrorlog in SQL Server 2000 Narayana Vyas Kondreddi's homepage
Tips for Performance Tuning SQL Server Database Configuration Settings
Tips for Performance Tuning SQL Server Database Setting
Using Startup Options
Viewing Transaction Log
Ways to Determine the Version and SP of SQL Server
Welcome to the dkRanch!
What's best for DBAs GUI or T-SQL commands Narayana Vyas Kondreddi's home page

SQL & XML

PerfectXML.com - Importing XML into SQL Server 2000

SQL Performance Monitor

Microsoft SQL Server Database Performance Monitor CPU Counter Tips
Microsoft TechNet - Samples Available

SQL Research

#2403 How do I send e-mail from SQL Server
246133 - INF How To Transfer Logins and Passwords Between SQL Servers
255596 - INF sp_lock2 Returns Additional Locking Details
263556 - INF How to Configure SQL Mail
272093 - INF Effects of Nonlogged and Minimally Logged Operations on Transaction Log Backup and Restore Process
274188 - PRB Troubleshooting Orphaned Users Topic in Books Online is Incomplete
281345 - PRB Dialog Box Opens During Backup Process Prompting You To Insert Disk in Drive A
299921 - HOW TO Add Error Logging for Low Disk Space in System Monitor in Windows 2000
317748 - FIX Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memo
ACID - a searchDatabase definition - see also atomicity, consistency, isolation, and durability
Configuring SQL Server with Stored Procedures
Database Journal Microsoft Sql Server Administration News, Articles, Scripts, Tutorials, Forums, And Resources for the Sql Ser
DBAzine.com the online portal for database issues and solutions
Detailed Locking View sp_lock2
Estimating the Size of a Table with a Clustered Index
Estimating the Size of a Table Without a Clustered Index
Estimating the Size of a Table
Examples of SQL Collations
FAQ check file exists from SQL Server
How to Determine the Version and SP of SQL Server
How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)
http--seer.support.veritas.com-search_forms-SearchFrame.aspSearchTerm=how to set up sql agent&Path=seer.support.veritas.com-d
Microsoft SQL Server - Executing DTS Package from Stored procedure
Microsoft SQL Server - Quoted Identifiers in SQL Server 2000 - SQLTeam.com
Microsoft SQL Server Locked Out of SQL Server
Microsoft Visual Basic Visual Basic 6.0 Code Advisor
Network Appliance - SAP R-3 4.6x SQL Server 7-Windows NT Integrating with a NetApp Filer
p2p.wrox.com - Help populating sysperfinfo table...
PostgreSQL (PostODBC) and MS SQL Server 7
Put DBCC into a table
Selecting a SQL Collation
Some Useful Undocumented SQL Server 2000 Trace Flags
Songhay System - The Funky Knowledgebase - SQL and Database Management Systems
SP_MSFOREACHDB - Databases List Via TSQL
sp_MSforeachtable
SQL Server 2000 Clustering Database Tips
SQL Server 2000 Recovery Models Give You Backup-and-Restore Flexibility
SQL Server 2000 Some Useful Trace Flags
SQL Server Database Performance Tuning Tips
SQL Server SP Versions
SQLDTS.com - Data Transformation Services on the web
SQLServerCentral.com Script Library
System Stored Procedures
Tek-Tips Forums for computer professionals
The curse and blessings of dynamic SQL
The undocumented nature of sp_readerrorlog in SQL Server 2000 Narayana Vyas Kondreddi's homepage
Transform Data Task Properties (Options Tab)
Unify Data Access with Linked Servers
Using SQL Collations
Using Startup Options
What's best for DBAs GUI or T-SQL commands Narayana Vyas Kondreddi's home page

SQL Security

http--www.nextgenss.com-papers-more_advanced_sql_injection.pdf
More Advanced SQL Injection
SQLSecurity.com - Lockdown Script Project
SQLSecurity.com

SQL Tips

#2160 How do I know which version of SQL Server I'm running
#2446 Why is tempdb full, and how can I prevent this from happening
#2453 How do I count the number of business days between two dates
110139 - INF Causes of SQL Transaction Log Filling Up
139444 - INF How to Remove Duplicate Rows From a Table
180500 - PRB Missing Device Causes Database to Be Marked Suspect
187824 - INF How to Move Tempdb to a Different Device
193453 - PRB DB Marked Suspect; Operating System Error 5 (Access Denied)
196909 - HOW TO Increase the Number of SQL Server Error Logs
230590 - HOW TO Archive More Than Six SQL Server Error Logs
246133 - INF How To Transfer Logins and Passwords Between SQL Servers
256650 - INF How to Shrink the SQL Server 7.0 Transaction Log
272318 - INF Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
283696 - INF Job to Monitor SQL Server 2000 Performance and Activity
283886 - HOW TO View SQL Server 2000 Performance Data
288809 - PRB How to Recover SQL Server After a Tempdb Database is Marked Suspect
291332 - FIX SERVERPROPERTY Returns Incorrect Value for LICENSETYPE
294453 - INF How to Set Up SQL Server 2000 to Listen on Multiple Static TCP Ports
299921 - HOW TO Add Error Logging for Low Disk Space in System Monitor in Windows 2000
304261 - INF Support for Network Database Files
304692 - INF Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE
307775 - INF Disaster Recovery Articles for Microsoft SQL Server
310335 - Error Message The Installation-Removal of a Previous Program Was Not Completed
320125 - HOW TO Move a Database Diagram
321185 - HOW TO Identify Your SQL Server Service Pack Version and Edition
325003 - HOW TO Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility
814410 - FIX - Performance Degradation and Memory Leak in the SQL Server ODBC Driver
83065 - INFO Description of DBCC PAGE Command
ADO.NET and SQL Server Performance Tips
Create Your Own SQL Server Job Management System
DBAzine.com - Information Schema Views and Object Properties
Decrypt encrypted stored procedures
Execute a package from Visual Basic (VB)
formato_import
Full-Text Search Deployment
How do I remove duplicate rows from a table
How to Determine the Version and SP of SQL Server
Insufficient Virtual Memory on the Server
Microsoft SQL Server Administration FAQ for DBAs and solutions to common problems (7.0-2000) Narayana Vyas Kondreddi's home pa
Microsoft SQL Server max length varchar
Microsoft SQL Server Programming - Encrypting Stored Procedures AND the script file
Microsoft SQL Server SQL Server System Table Map
Microsoft TechNet - Lodctr
mssqlserver.com FAQ I can't see the SQL performance counters in PerfMon. What could be wrong
Multiple Paths in Workflow
Nightly Failed Jobs Report
Orphaned Sessions
Questions, Answers, and Tips About SQL Server
Sample Code & Packages
Script to Map SQL Maintenance Plans to SQL Server Jobs
Scripting Jobs
SERVERPROPERTY
Skip the execution of an individual Task
SQL - Server Memory Options
SQL Server Database Performance Tuning Tips
SQL Server Link Server Performance Tips
Sql Server. Script database objects from tsql using sql-dmo - Author Nigel Rivett
SQLDTS.com - Data Transformation Services on the web
Sqlserver setup FAQ--shrink tempdb
sqlServer.co.nz - sp_MSForEachDB
Stored Procedure Script Generation By Dependency By Robbe Morris
The curse and blessings of dynamic SQL
Tools for Capacity Planning
Transferring DTS Packages
UPDATED Procedure to script your data (it ge - SQL, database, informix, oracle, SQL Server
Useful Undocumented Extended Stored Procedure

SQLServerCentral

Microsoft SQL Server Linked Server - Error 7405 Heterogeneous queries
SQLServerCentral.com Script Library Alert When Not Enough Free Disk Space
SQLServerCentral.com Script Library Get Notified When Accounts Are Changed
SQLServerCentral.com Script Library sp_kill

Web Dev - ASP

ADO.NET and SQL Server Performance Tips
Execute a package from Active Server Pages (ASP)
Javascript Smart Popups That Don't Pop Off Screen
Marzie's Toolbox DevTools Centralized ASP Error Handling in IIS 5
Matthew Reynolds' .NET 247 Newsgroup - How do I upload files
p2p.wrox.com - asp_web_howto archive
301077 - Windows 2000 Winbond Super I-O Floppy Disk Controller May Not Report Data Underrun or Overrun Condition Correctly
321185 - HOW TO Identify Your SQL Server Service Pack Version and Edition
96269 - Using FTP Batch Scripts
ACID - a searchDatabase definition - see also atomicity, consistency, isolation, and durability
American Remanufacturers Inc
ARI - Member Login
ARInet - Inventory Management System
Contact Microsoft - Overview
Detailed Locking View sp_lock2
DShield - Distributed Intrusion Detection System
Microsoft Community SQL Server
Microsoft Community
Microsoft Newsgroups SQL Server.Server
Microsoft Newsgroups SQL Server
Microsoft Newsgroups
Microsoft SQL Server Database Performance Monitor Counters
MSDN TV AppSettings in ASP.NET
MSN.com
My Sprint PCS
Orphaned Sessions
p2p.wrox.com - Help populating sysperfinfo table...
Professional Support Options
ProvideX ODBC Manual
Quest Presentations
Radio Station Guide
SQL Server 2000 Some Useful Trace Flags
SQL Server Configuration Performance Checklist (cont.)
SQL Server Performance Tuning Questions & Answers Q&A #42
SQLSecurity.com - Lockdown Script Project
SQLSecurity.com - SQLSecurity Checklist
SQLSecurity.com
University of Arkansas Computing Services Disaster Recovery Plan
WA EasyTrac Dashboard
Warehouse Advantage
Windows 2000 User Permissions
XML and Microsoft Office Excel 2003 Creating an Expense Report Template