SQL Server 2000 used to have a black box trace which could be used to diagnose and troubleshoot issues with SQL Server. The name probably stems from the flight data recording black box. It was typically used to diagnose AV (Access Violations) or crashes though it could be used for tuning purposes as
Other News
A LOT of SQL Server Info Today, Top 10 List and More
New SelectViews SQL Server Show Posted How do you keep up with technology? Find out about the sync framework, Visual Studio updates, ASP.NET updates and more. Interviews with Microsoft, our 60-second SQL Server tip of the day and a whole lot more are on the show today. > Watch here Also available: – [Watch] SQL on Call – Top 10 […]
(92) How do you keep up with technology? Find out about the sync framework, Visual Studio updates, ASP.NET updates and more.
Pro-Center Video Programming for IT Professionals
Call for SQL Server Authors, Commerce Server and More
Featured Article(s) Understanding Microsoft Commerce Server (Part I) Microsoft Commerce Server offers a boon to the developers and provides a state-of-the-art platform with tools and services to develop a classy web site at a very faster pace. Commerce Server Development Platform helps the developers to develop web applications, customization of commerce server business logic, integration with other third party softwares. […]
Federal DBA Day
MySQL and Carahsoft invite you to a complimentary seminar providing you with sufficient training and knowledge transfer, to enable experienced Oracle DBAs to deploy and manage MySQL in a production environment. (R)
DB2 9.5 and IBM Data Studio: Using OLE DB to Integrate Data
(Paul Zikopoulos) So far, in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2
DB2 9 DBA Exam Sample Questions: The dbls command and the Design Advisor
(Roger Sanders) If DB2 9 DBA certificiation is on your list of resolutions this year, spend some time looking over some sample questions to help you prepare. Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC P
XML Documents from Comments
(Paul Kimmel) I like writing. I like writing books, articles, and I especially like writing code. Comments. Not so much. I tell people: my code is self-documenting. The truth is that avoiding prefixes, abbreviations, and using whole words and short function helps make code comprehensible. That said,
Automate Row Change Timestamp Used for Optimistic Locking
(Troy Coleman) Over the years database administrators have had to deal with locking issues and performance. IBM has continued to improve DB2 by reducing the number of times applications take locks and or reduce the amount of time a lock needs to be held. The general term for this is optimistic locki
The Design Goals of XML
(Rick Jelliffe) One of the really neat things about the XML specification is not just that it makes its design goals explicit (I gave a twist to this idea in the Schematron standard by mentioning various non-goals too) but that the goals were really well chosen.