(Randy Dyess) This article is the first of a series that I plan on writing and placing on my website to help other DBAs in auditing a new SQL Server environment. This article deals with determing which SQL Server logins have weak passwords, with the definition of weak being, no password, password th

When you use Query Analyzer (or any other ODBC application) to retrieve data using the FOR XML AUTO clause, only 2033 characters are returned per row. The application’s maximum output width setting cannot be used to make the rows longer.

by Sayed Geneidy – If you use Visual FoxPro to connect to SQL Server, then you will want to read this article.

Download the latest version of this tool to lower your costs and reduce the time it takes to build your customized business intelligence application.

Welcome to the Microsoft® SQL Server™ 2000 Resource Kit. This resource kit is designed for people who are already users of SQL Server and who want some helpful tips, advanced techniques, and useful tools or samples to enhance their work with SQL Server 2000.

(Roger Jennings) Replacing ADODB with SqlClient’s Command and DataReader objects delivers a significant performance boost.

By Russ Whitney – Working with any OLAP solution can help you better understand the technology, but using data that has personal meaning can help you learn even more about OLAP. Here’s a practice solution that uses data you’ll care about–your personal finances.

by Dino Esposito – Take a look under the hood of the SQL Server .NET Data Provider and discover how it can help you improve your ADO.NET code.

by Jeffrey McManus and Jackie Goldstein – This book provides real-world solutions to the data-access issues VB.NET developers face every day and shares the authors’ secrets for becoming a more effective database programmer using .NET technologies. Chapter 8 explains the use of Visual Studio Database

There are a number of different ways to migrate SQL Server logins. Greg Larsen discusses one of those ways to streamline the migration of SQL Server logins, by using the stored procedure (SP) sp_help_revlogin.