(Bob Newstadt) Say you score 570 on the verbal section of the SAT. How well did you do? According to the College Board, 570 falls into the 71st percentile. This means you did better than 71% of the other students who took the test. Percentiles are a useful way to present rankings among a large popul

(Benoyraj Baskaran) Yukon is a proposed new 32 – bit version of Microsoft SQL Server aka, MS SQL 2000, which is not yet released from Microsoft, which may expect to be release in the year 2004. It contains a lot of additional tools which improves a rich scale of performance, reliability and ease of

(Muthusamy Anantha Kumar) In certain environments, there will be multiple databases with the same structure. When Database Administrators make the same kind of changes or production releases on those databases it is tedious to open different windows in Query analyzer. In addition, it is tedious to o

(Brian Kelley) The SQL Server 2000 Resource Kit has been out for a while now. Much like the various Windows Resource Kits, however, it’s still useful as a source of information. It’s one of the resources I keep handy on my bookshelf as well as on my workstation. In this review I’ll cover why. But si

This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2. By default, Windows Firewall is enabled on computers that are running Microsoft Windows XP Service Pack 2. Windows Firewall closes ports such as 445 that are used for file and printer sharing to prevent In

(Nick Wienholt) The focus of the material covered in previous chapters relates to performance characteristics of specific areas of the CLR and Framework Libraries. When searching for a solution to a performance issue that manifests itself simply as general “slowness,” information on performance spe

(Luis Garcia) With the Data Transformation Services (DTS) in SQL Server 2000, you can import, export, and transform data from disparate sources into single or multiple destinations. This article shows you how to build your own DTS packages and the basics on how to use ActiveX code to transform data.

This step-by-step article lists the steps you must use to enable SSL encryption for SQL Server 2000 if you have a valid Certificate Server in your network environment. If you have purchased certificates from a third party certificate vendor, follow the instructions provided by the vendor. SQL Se

The replication options of immediate updating, queued updating, immediate updating with queued updating as a failover, and transforming replicated data require additional considerations during replication planning. If users do not need to update data at the Subscriber, consider using snapshot replic

(Leo Peysakhovich) After my publication Monitoring Failed Job Steps in SQLServerCentral.com, I got an email from the representative of a company called InterCerve asking me to evaluate SQLSentry tool that the company produces. (R)