(Jon Winer) Connecting to and executing commands against a database is a simple task. We do it without much thought because in today’s applications, data access is common place and necessary. For those of us who work in a Microsoft ‘Shop’, ADO and ADO.NET is the norm when it comes to reading and wr
Other News
Oracle chief gambles $1m on 9i
Larry Ellison, Oracle’s chief executive, has bet that firms that swap IBM’s DB2 or Microsoft’s SQL server for Oracle 9i will see websites run three times faster or be awarded $1m.
The ReverseString Component Explained
(Allan Mitchell) This article is meant as a very gentle introduction into creating your own custom transformation component in SQL Server 2005 Integration Services. In the article we will be touching upon a few of the essential methods available to us in the new object model and showing you how
Using Profiler to Identify Poorly Performing Queries
(Brad M. McGehee) For this part of the performance audit, you will be using the SQL Profiler tool that comes with SQL Server. As this article focuses on how to perform a performance audit, and not on how to use tools, it is assumed that you know how to use SQL Profiler. If you have not used it b
XML Matters: Get the most out of gnosis.xml.objectify
(David Mertz) The XML binding gnosis.xml.objectify was designed, in many ways, more as a toolkit than as a final tool. But this leaves some (potential) users confused about how to specialize it for some common tasks. In this article, the author shows readers how very thin wrappers can customize
Increase .NET Performance Using Threads
(Doug Thews) You can have a huge impact on customer satisfaction by improving your .NET application’s perceived performance—that is, users’ perception of the application’s performance. You can have the fastest box in the world running the latest OS and an application developed with the latest tools,
Locking, Blocking, and Deadlocks in SQL Server 2000: Part I
(Tim DiChiara) Locking is a natural part of any application. But if the transactions in your application are not designed correctly, you could have serious performance and scalability problems. Rahul Sharma discusses those design issues and gives you ways to troubleshoot locking problems to make
Vrooooom! How .NET and C# Drove an Entry in the DARPA Grand Challenge
(John Hind) This article discusses: –Autonomous vehicle control with the .NET Framework –An extensible real-time control architecture based on a whiteboard metaphor –Implementation of an accurate GPS-synchronized timer component for .NET
SAML: The Secret to Centralized Identity Management
(Hank Simon) The last time some of our internal users and external partners counted, they had more than 15 passwords they had to keep track of. Of course, they could keep all those 15 passwords in their heads. Yeah, right! Every time they needed new access to a new resource, application, or data
No-cost System Lockdown, Part 2: Open Source IDS in Use
(Alexander Prohorenko) Part 1 of this article explained IDS and examined the most popular open source IDS solutions. Part 2 demonstrates some common, practical uses for these solutions.