(Willie Favero) must be missing English class because this entry had me searching for a dictionary to look up the definition of my title word. The current web version of the Merriam-Webster’s dictionary defines coexistence as: 1) to exist together or at the same time 2) to live in peace with each
Other News
Build a Data Access Layer with VS 2005 DataSet Designer
(Brian Noyes) A good data access layer is critical for most business applications, whether that layer resides on a middle tier application server, a web server or on the client. Data access layers tend to involve a lot of error-prone, repetitive coding if you try to do it by hand. You can allevi
Living the ‘Least Privilege’ Lifestyle, Part 3: Surviving as a Mere User
(Don Kiely) In the first two parts of this series, I explained why running as an admin on your local Windows workstation is a bad thing, giving malware nearly free rein over the machine, and why running with a least-privileged user account (LUA) is far safer. But as I explained in part 2, runnin
Integrating PayPal into E-Commerce Applications with ASP.NET
(Rick Strahl) If you run a Web shop that uses direct credit card processing and you want to integrate PayPal, you’ll find that using PayPal as a processing service is not as straightforward as using a payment gateway. In this article, I’ll describe how you can minimize the external PayPal intera
Isolated unit testing of persistence with Derby
(Guy Davis) Get help developing your database-driven unit-testing skills. Without isolation and automation, database-driven unit tests can become a maintenance nightmare of sporadic failures and bad test data. The open source Apache Derby database is ideal for completely automating and isolating uni
Small and Unreadable Part II
(Scott Swigart) In this two-part article series, you’ll see how you can easily add encryption and data compression (ZIP) capabilities to existing VB6 applications using the .NET Framework. While encryption and compression may not seem like related technologies, if you think about it, each one ta
List index information for all databases :: (Script Library)
Category: Managed Hosting Services, Tools, and Solutions Tags: hosting, managed hosting, host Compatibility: SQL Server 2000 and later Description:
List index information for the current database :: (Script Library)
Category: Managed Hosting Services, Tools, and Solutions Tags: hosting, managed hosting, host Compatibility: SQL Server 2000 and later Description:
Performance of .Net Code in SQL Server 2005
(Andrew Novick) Writing stored procedures and other code in .Net languages is a very attractive idea to a lot of developers. But is it a good idea? What’s the performance going to be like? Is it going to bring my server to its knees?
FIX: An access violation may occur when you remove all elements from the procedure cache for a linked server over an interrupted remote access connection
You may receive an access violation exception if all the following conditions are true: • You connect to a linked SQL server by using remote access. • You run the DBCC FREEPROCCACHE Transact-SQL statement on the linked server to remove all elements from the procedure cache. • The remote acces