SQL Server General DBA

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 […]

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 […]

Server System Architecture, 2002

Continues…

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 […]

SQL Server 7.0 and 2000 Trace Flags

Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL  Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will […]

How 11GB of SQL Server Data Mysteriously Disappeared, and How I Ended Up Better Off than Before

The previous weekend, I had spent most of it working, upgrading a SQL Server 7.0 cluster to a SQL Server 2000 cluster. Fortunately, the rather complex upgrade went without a hitch. What made the upgrade complex was that the cluster held a 31GB ERP database that was used on a 24/7 basis, and unplanned down-time […]
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 |