(Jay Miller) This week, I’m passing along a tip I ran across several months back when trying to track down some resources that weren’t being released as I expected. Normally, you can let .NET’s garbage collection take care of cleaning up after your objects, unless you are using unmanaged resources s
Other News
Managing SQL Server 2005 Master Keys for Encryption
(Tim Cullen) I recently accepted the challenge of designing a database for an employee application, and the first thought to cross my mind was,” I will need to encrypt at least one piece of data”. Along with SQL Server 2005 came the native ability to encrypt data in the database. Prior versions depe
Programming SQL Server 2005 Compact Edition with ADO
(Prashant Dhingra and Trent Swanson) SQL Server Compact Edition allows you to store data on a desktop or mobile device. A majority of application code consists of retrieving data from a database, updating it, and storing it back to the database. You can use an OLE DB Provider for accessing or manipu
Effective Remote Communication between Businesses for Accomplishing .NET Software Projects
(Mike Gold) Global warming is an indisputable fact and the unfortunate by-product of lax industrial regulation and poor consumer education. Another discernible truth is global shrinking. Conversely, global shrinking is a good thing. Human communication is no longer impeded by distance. We can condu
Performance Impact: Manual Checkpoints are not Necessarily Evil
(Linchi Shea) In my two previous posts on the performance impact of frequent manual checkpoints and the I/O behavior of frequent manual checkpoints, I demonstrated that frequently issuing manual checkpoints can be bad for performance and why it’s bad from the storage perspective. If you were led to
How fast can you sort data with MySQL ?
(Peter Zaitsev) I took the same table as I used for MySQL Group by Performance Tests to see how much MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set which is the most typical way sorting is used in practice.
Gain Design-Time Power with Control Editors, Part 1 of 2
(Rod Stephens) See if you can tell what’s wrong with the following sequence: ND, MN, WI, SD, NE, KS, MO, IL, IN. Unless you have a PhD in North American geography, you may have trouble even realizing that there is a potential problem much less finding it. If you take a look at Figure 1, however, the
Unit Testing ASP.NET User Controls
(Brian Mains) I wrote in a past article about unit testing ASP.NET pages. It is also possible to work with user controls, with some additional considerations. User controls inherit from System.Web.UI.UserControl class; however, it is possible to create an intermediate class, between the UserControl
SQL Server Management Tools, SQL Server 2008 NOT Slipping
New SQL Server Weekly Show Tomorrow Catch the current show by watching it here. Thanks for all of the excellent feedback and comments on the shows! Featured Article(s) We have always done it that way! How many times have you looked at an issue and thought what were they thinking? Maybe you even asked the question out loud. Save Development […]
Merge Replication, SQL Server Reporting Services Help
Watch The Latest Weekly SQL Server Show > Watch SelectViews – now with the segment selector in Beta, allowing you to jump around the show. Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 1) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. It’s Like A SQL Server Private Investigator… When […]