Utilizing fn_virtualfilestats

• by Chris Kempster

• SQLServerCentral.com

• Administration

In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.

Comments on PASS Community Summit 2002

• by Andy Warren

• SQLServerCentral.com

• News
• Uncategorized

Andy attended the recent PASS Community Summit and had a great time. Read some of the highlights from his perspective and maybe decide that you'll want to attend next year!

Pro Developer: Improving Your Career In Any Economy

• by Christopher Duncan

• SQLServerCentral.com

• Miscellaneous

Like many other areas of business, the tech industry has weathered the occasional slump over the past few decades. It's only natural that the fate of techies is closely linked to the tides of the business. However, in any economy, weak or strong, some people prosper and advance while others suffer the consequences.

A Temporary Move

• by Steve Jones

• SQLServerCentral.com

• Administration

The third part of a series in moving system databases.

Review of Developing Windows Based Applications for VB.Net and C#.Net

• by Andy Warren

• SQLServerCentral.com

• Miscellaneous

Andy talks briefly about why the company he works for has decided to require all developers to obtain the MCSD, then takes a look at the book they chose for the initial round of study for the first exam.

Moving MSDB

• by Steve Jones

• SQLServerCentral.com

• Administration

Part two of moving system databases around. This one looks at model and msdb.

How to Diagnose and Fix Wait Locks

• by Cathan Kirkwood

• SQLServerCentral.com

• Administration

This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.

Review of Real-World SQL-DMO

• by Andy Warren

• SQLServerCentral.com

• Administration

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!

Removing Orphan Users from All Databases on Server

• by Gregory Larsen

• SQLServerCentral.com

• Administration

In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server.

Best SoftTool Announces SQLSourceSafe 2.0

• by Additional Articles

• Other

Best SoftTool, Inc. today announces that its flagship product SQLSourceSafe 2.0 is available for download and purchase. SQLSourceSafe is the integrated solution that Best SoftTool provides to meet the mounting market demand for a solid version control system for SQL Server database development. SQLSourceSafe integrates Microsoft Visual SourceSafe® and Microsoft SQL Server® together, offers robust and advanced version control functions to database scripts in SQL Server.