(Karl E. Peterson) There are probably as many strategies for downloading files from the Internet as there are .NET programmers — that is, no where near the number of Classic VB developers, but still more than a mere handful. Ask the question in a newsgroup, and you’ll quickly get a good half-dozen
Other News
Tips for scheduling and testing SQL Server backups
(Denny Cherry) A database administrator can choose from several SQL Server backup and recovery models. Most of the available options you can choose from would not be considered wrong, but some models will fit your environment better than others. (R)
Information architecture essentials, Part 5: Business intelligence in your information architecture
(S. E Slack) If you’re not using business intelligence in your information architecture, you’re missing a key opportunity to help your organization stay ahead of the competition. Take steps to help your executives with decision making, strategic planning, and tactical responses to evolving business
GridView Tips and Tricks using ASP.NET 2.0
(Suprotim Agarwal) In this article, we will explore some of the most frequently asked questions about the GridView control. The article discusses ten tips and tricks that you can use while using the GridView control.
Questions about .net Exceptions
(Tess Fernandez) One of my readers emailed me the following question I have a simple questions that my management asks me. When I see all kinds of exceptions thrown (null exceptions etc..), what is the user experience? Does their system hand these back to the user? does it return an error message
Performance impact of controller cache: SQL Server read only workloads
(Linchi Shea) In my previous post, I looked at how a typical OLTP workload may be affected by various controller cache configurations. And the conclusion was that giving too much cache (say all 512MB) to reads hurt the OLTP performance. The primary reason was that the writes from the OLTP workloads
Diagnose SQL Server performance issues using sp_lock
(Tim Chapman) A common misconception among IT pros is that “locks are bad,” and you must do everything possible to ensure database locking doesn’t prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use o
Overhead of Row Versioning
(Sunil Agarwal) Last week I was teaching a class on snapshot isolation and we discussed the overheads of snapshot isolation. There are three main overheads that you need to be aware of when you enable snapshot isolation read-committed-snapshot on a database. First, each UPDATE/DELETE operation gener
MySQL Proxy recipes: returning an error
(Giuseppe Maxia) Returning an error message is one of the tasks that may become common when working with MySQL Proxy.
Oracle BI EE 10.1.3.3/2 – Merging Repositories – Substitute for Import From Repository – 2 way Merge with No Parent – Part 2
(Venkatakrishnan J) If you look at the comments section of my blog entry here, there are quite a few users who have mentioned that the procedure did not work on their setup. One of the main reasons for that was that the changes being merged was not shown to the end user. Also, the procedure did not