The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
Other News
Data Collector in SQL Server 2008
This is a wonderful new feature in SQL Server 2008. Data Collector in SQL Server 2008 is a component that is installed in a SQL instance and which can either be configured to run on your defined schedule or can run all the time and collect different sets of data pertaining to performance diagnostics
SQL Server 2005 Exposed – Static Port Assignments
We have noticed some connection issues on a variety of our web based applications when the corresponding SQL Server is rebooted. We have noticed the issue with SQL Server 2005 Express edition as well as the SQL Server 2005 Standard edition. It seems like after the reboot we have to change our appl
Slippery Slope – Arguing Open Source v. Proprietary Software
Featured Article(s) Understanding Authentication, Authorization and Impersonation in ASP.NET (Part I) Authentication, Authorization and Impersonation are three of the most important concepts that are related to ASP.NET Security. This series of two articles present these concepts in detail with code examples to illustrate the concepts covered. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, […]
The Other Side of Open Source, A Rebuttal
Featured Article(s) Tips for using SQL Server 2005 constraints (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 constraints. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL […]
SQL 2005 Auditing With Triggers Using XML
(Havagan) I very rarely post any of my own code online (with the exception of helping folks over at Experts Exchange) because most of my coding is done at work and there’s so little about work I can post. So here’s a rare one inspired by Jon Galloway’s post on simple trigger-based auditing.
WHS and SmugMug – A Word About XML
(rbonini) XML is a markup language in the same family as HTML. This means you have nested elements in a structured document.
Referential Integrity: Application-Based or DB2-Based?
(Robert Catterall) This is a debate that has interested me for years. I’ve heard very good arguments on both sides, but before I get into that I’ll state that what I don’t like to see is the use of both DB2-based and application-based methods used to define and enforce the same referential integrity
What Visual Studio Developers Should Know About Crystal Reports 2008
(Julia Lerman) Crystal Reports 2008 was released in October 2007. This article (written in Jan 08) explains the ins and outs of the CR2008 versions, integration with VS versions, side-by-side compatibility, upgrading reports and general features of interest to Visual Studio Developers.
DB2 History 101: Version 1
(Willie Favero) So why the nostalgia? As I mentioned Friday, a few post on the DB2-L list started me thinking about how much history there is with DB2. Couple that with the fact that this year we will be celebrating the 25th anniversary of the announcement of DB2. I not prepared to through a birthda