By Meredith B. Derby – It’s time to re-arrange your thinking. Consider your SQL Servers not as regular database servers but as data centers, said Kent Erickson. “Think of them as critical business applications,” with the goal of achieving the highest availability possible. Better overall business pr

by Steven Warren – When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the dat

From SQLTeam – I’m continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft’s site. So here’s an article with all the SQL Server version information I can track down.

By Brian Moran – Have you ever considered using SQL Server Profiler to troubleshoot problems you’re having or to find answers to your questions? You should. As a SQL Server Most Valuable Professional (MVP), I answer many questions on the public Microsoft SQL Server newsgroups (msnews.microsoft.com).

by Ramon Mata-Toledo, Pauline Cushman – Standard SQL guarantees that no matter what the database implementation, the features of the language will be applicable across all platforms. Over 200 completely solved problems plus 200 supplementary problems reinforce students’ understanding and skills. Fea

by Randy Dyess – Learn how to audit login security in your SQL Servers.

(Older, but good info) by Jon Honeyball – For me the most significant aspect of Cliff Reeve’s keynote was the sneak preview of ‘Yukon’, the codename for the next release of SQL Server. This will probably be called SQL Server .NET, or some such jazzy title. The claims for it were fascinating, partly

CNET – Brief Mention – The company also is banking on a new technology code-named Yukon “that will be key to our next-generation storage, database, file system, email, and user interface work,” Ballmer wrote.

CNET – In addition, Microsoft has already developed the database technology it needs for a new file system. A future release of its SQL Server database, code-named Yukon, is being designed to store and manage both standard business data, such as columns of numbers and letters, and unstructured data

CNET – Microsoft is developing a version of its SQL Server database, code-named Yukon, to integrate data from multiple sources and let people query that data as if it were stored in one place. The same technology is expected to find its way into the next major release of Windows, code-named Longhorn