SQL Server General DBA

SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning

This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective. In the coming weeks, expanded articles will be published in the following areas: Part 1 – Upgrade Overview and Project Planning SQL Server 6.5 and 7.0 Critical Upgrade Decisions and Redundant Upgrade Architecture […]

SQL Server 2000 Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000. sp_MSget_qualified_name This stored procedure is used to get the qualified name for the given object id. Syntax sp_MSget_qualified_name object_id, qualified_name where object_id - is the object id. object_id is int.qualified_name – is the qualified name of the […]

Using Stored Procedures to Manage SQL Server Security

Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures, you can ensure that your data can be accessed in a much more controlled, restricted medium. Ad hoc SQL no longer […]

Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions

Disaster recovery is a topic on the minds of many DBAs. Learn some of the basics about SQL Server disaster recovery from a leading expert in the area, Greg Robidoux of Edgewood Solutions. Greg is currently the Vice Chair for the PASS DBA Special Interest Group (SIG). In addition, he recently gave two presentations at […]

Introduction to Data Mining with SQL Server

Data Mining Defined In order to fully comprehend, much less implement enhanced Decision Support Systems in an organization, it is necessary to understand the basic precepts behind the requirements, methodologies and business drive to obtain information. Information about an organization gathered from various sources and coalesced into a format in which business decision makers and […]

Troubleshooting SQL Server Full-Text Search Problems

Should you have problems with the SQL Server full-text search, review this troubleshooting checklist to help find potential solutions. 1. Check the hardware requirements For SQL Server 7.0, you should have: Alpha AXP, Intel or compatible platform Pentium 166 MHz or higher 64MB RAM or more (recommended) 180MB hard disk space For SQL Server 2000, […]

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. The stored procedure, called sp_JobSchedule_rpt, creates this report by joining the sysjobs and sysjobschedules tables and […]

Server System Architecture, 2002

Continues…

A Comparison of SQL Server 7.0 with SQL Server 2000

Should you stick with SQL Server 7.0, or spend the big bucks to move to SQL Server 2000? To help you make your decision, here are some things to think about. Hardware and Software Requirements ComparisonTo install SQL Server 7.0, you should have the following hardware: Alpha AXP, Intel or compatible platform. Pentium 166 MHz […]

Interview with Tim Hayes, dbPAL Developer and CEO of IT-Map

Learn about the “big picture” of SQL Server-based software development from an industry veteran. Tell us a little about yourself. How did you get involved in databases? I started my IT career back in 1975 – at the time when I thought I was a late entrant into the game. Now, I guess you could […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |