Join SQLServerCentral.com co-founder Brian Knight for this free webcast on SQL Server security best practices. In this session on Technet, 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.

Identifying performance issues using Profiler

by Additional Articles

Other

Administration

It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output.

Worst Practices - Blank Passwords

by Steve Jones

SQLServerCentral.com

Worst Practices

Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.

Cluster That Index!

by Christoffer Hedgate

SQLServerCentral.com

Performance Tuning

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.

Should you buy a SAN?

by Andy Warren

SQLServerCentral.com

Miscellaneous

Andy recently implemented a SAN and shares some of the info he picked up during the purchase and implementation. This article also discusses briefly the differences between SAN and NAS, and has some links to other sites for more info as well.

Free Webcast: SQL Server 2000 Security Best Practices

by Additional Articles

TechNet Blogs

Best Practices

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.

Free Webcast Today: SQL Server Security Best Practices

Identifying performance issues using Profiler

Worst Practices - Blank Passwords

Cluster That Index!

Should you buy a SAN?

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?

Blogs

Advice I Like: Experience and Aptitude

Plan Time for Self-Development

BK’s Bookshelf: Never Split the Difference

Forums

Insiders Selling Data

Join 2 tables

Impact of Not Including Foreign Keys in an SQL Archive Database

Question of the Day

Quiesce