(Tess Fernandez) This is the last debugging lab in the .NET Debugging Demos series. By now you should have the basics down for troubleshooting hangs, perf issues, memory leaks and crashes in .net applications. Hope you have enjoyed your debugging sessions.
Other News
Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?
(Paul S. Randal) This is a really interesting question that came up in the Microsoft Certified Architect class I’m teaching at present – if a database has torn-page protection enabled, and page checksums are enabled, is all the existing torn-page detection lost?
MySQL engines and space usage
(Mark Robson) A lot of people seem to spend a lot of effort comparing storage engine in MySQL – chiefly focusing on the difference between MyISAM and InnoDB.
Oracle BI EE 10.1.3.3/2 – Executing iBots from Dashboards/Answers – Sending Emails to Administrators
(Venkatakrishnan J) In my previous blog entry here, i had shown you how to go about calling command line utilities(for Purging the Cache) from Dashboards/Answers. Along the same lines, lets look at another possible use case of the procedure that was used there today. Today, we shall see how to go ab
Joining XML with RDBMS, how and what are the consequences?
(Marc Van Cappellen) A few months ago, my friend Minollo blogged about XQuery against RDBMS: let the engine optimize your SQL. And last week again, a question on some newsgroup attracted our attention.
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
(Paolo Bruni, Sabine Kaschta, Marcel Kutsch, Glenn McGeoch, Marichu Scanlon and Jan Vandensande) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code
Oracle: Unusable Indexes
(JP Vijaykumar) It is beyond the scope of this document to present all the scenarios that mark an index as unusable and how to validate unusable indexes. Instead, we are going to see what happens to an index when it becomes unusable.
Methods, Delegates, Anonymous Delegates, and Lambda Expressions… Oh My!
(Matthew Cochran) This article covers different syntax we can use for declaring and executing methods.
Exposing a Database as a Web Service
(Deepal Jayasinghe) When you look back the computer industry, you can clearly identify different different technologies in different time periods. In any given time period, databases have a very high priority in the industry, from small scale to large scale business. You know that Web Services are b
How to join tables where columns include NULL values
When building database tables you are faced with the decision of whether to allow NULL values or to not allow NULL values in your columns. By default SQL Server sets the column value to allow NULL values when creating new tables, unless other options are set. This is not necessarily a bad thing, b