Additional Articles


SQLServerCentral Article

SQLMatcher Added to Freeware Library

SQLMatcher allows the user to compare Microsoft SQL Server DDL scripts. SQLMatcher is available in two different forms. The standard freeware version has just been made available for download on SQLServerCentral.com. The professional version is also available for download and purchase.

You rated this post out of 5. Change rating

2002-03-20

60 reads

Technical Article

RAC v2.0 released

RAC is a native utility for MS Sql Server 2000 designed exclusively for data
manipulation.RAC can perform complex tasks while minimizing the need for complex
sql.RAC offers many computational options and has report writer features.RAC comes with a easy to use gui for novice users.

2002-03-20

3,213 reads

Technical Article

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.

2002-03-08

2,221 reads

Technical Article

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.

2002-03-01

2,857 reads

Blogs

Penetration Testing your SQL Server, Part 1 – The Recon Mission

By

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Read the latest Blogs

Forums

Running a Service

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running a Service

Creating Two Keys

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Two Keys

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers