Join SQLServerCentral.com co-founder for this free webcast on SQL Server security best practices. In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.

Visual Studio 6 MCSD's Eligible to Take 70-300 Free

by Additional Articles

MSDN Communities

Certifications

MCSD's who certified using Visual Studio 6 are eligible to receive a free exam voucher for the 70-300 exam. You must register for the voucher and take the exam before Sep 30, 2003. Follow the link or visit the MCP secure site directly to register. It takes about a minute and you'll receive a code to prevent to your test vendor when you schedule the exam. Thanks, Microsoft!

Gathering Random Data

by Brian Knight

SQLServerCentral.com

T-SQL

Brian Knight recently had the basic need to retrieve a record from the database at random. What seemed to be an easy task quickly became a complex one. This case showed an interesting quirk with T-SQL that was resolved in an equally quirky way. This quick article shows you a method to retrieve random data or randomize the display of data.

Press Release - SQL Server 2000 for the Oracle DBA

by Press Release

SQLServerCentral.com

Miscellaneous

Chris Kempster (frequent contributor to the site) has released an ebook titled SQL Server 2000 for the Oracle DBA. The press release contains a brief overview of the book plus links to several reviews. Priced at $20 per copy, not bad at all!

How Do You Review a Product?

by Steve Jones

SQLServerCentral.com

What should SQL Server Central provide to the community in a review? Read on and give us some feedback so we can make this site better.

We Studied, We Passed, Was It Worth It?

by Andy Warren

SQLServerCentral.com

.Net

Several months ago Andy posted a 'Review of Developing Windows Based Applications for VB.Net and C#.Net' and mentioned that his company was requiring all developers to achieve the MCAD within 12 months. Read this to find out how the first exam went, how they studied, what they achieved, and their plans for taking the rest of the exams.

SQLWebReports Web Based Data Reporting

by Additional Articles

ApexSQL

Miscellaneous

Lockwood Tech continues to grow it's product line! This link points to an info page provided by the vendor that highlights the capabilities of this reporting product.

Change Management

by Chris Kempster

SQLServerCentral.com

Administration

This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.

Analyzing and Optimizing T-SQL Query Performance on SQL Server

by Additional Articles

SQLServerCentral.com

Performance Tuning

This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes

Autoclose for Databases - Part II

by Jon Reade

SQLServerCentral.com

Administration

In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.

Free Webcast: SQL Server 2000 Security Best Practices

Visual Studio 6 MCSD's Eligible to Take 70-300 Free

Gathering Random Data

Press Release - SQL Server 2000 for the Oracle DBA

How Do You Review a Product?

We Studied, We Passed, Was It Worth It?

SQLWebReports Web Based Data Reporting

Change Management

Analyzing and Optimizing T-SQL Query Performance on SQL Server

Autoclose for Databases - Part II

Blogs

2025 Wrapped for Steve

The Book of Redgate: Spread across the world

Merry Christmas

Forums

Finding Motivation

The Last Binary Value of the Year

SQL Art, Part 2: New Year Fireworks in SSMS

Question of the Day

The Last Binary Value of the Year