(Baya Pavliashvili) Those of us who have used SQL Server Profiler acknowledge it as one of the best tools for troubleshooting and tuning relational database applications. If you need to find what indeed is happening “under the hood” Profiler is by far the best place to start. If you want similar fun
Author: SSWUG Research
Customize an application with XML fragments
(Burkovsky) Many articles on Code Project discuss how to save application settings. My solution is an attempt to make the saving non-destructive, transparent and traceable. It is based on merging XML files that contain the serialized class instances identified by GUIDs.
Mini-Tip #10 – Implicit vs. Explicit Conversion
(Lewis Cunningham) I’ll start off by saying that I believe implicit conversion to be bad. Badder. Evil. A serious no-no!
ProData Goes Cross-Platform with DBU
(Alex Woodie) ProData Computer Services has released a version of its Database Utility (DBU) that can access other relational database management systems in addition to DB2/400. With the new capability, available from ProData as a plug-in called DBU Remote Database (RDB), System i programmers can no
Implementing Extension Methods in VB.NET
(Paul Kimmel) I wrote my first VB code in 1978. I am not surprised that programming is still fun, still interesting, still amusing after all these years. Computers really got interesting for the average person around 1986, ten years after Bill Gates started Microsoft, but just two years after Micros
MySQL System Architecture
(Mike Kruckenberg and Jay Pipes) In this article, we’re going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL’s implementation is a fascinating mix of technology that is truly a remarka
Sorting and case sensitive collations
(Louis Davidson) One of the more confusing parts of collation is how they affect the ordering of data when sorted and how that can affect other operations like the LIKE operator. When it comes to case insensitive collations, it is pretty clear, data is sorted as if ‘A’ and ‘a’, are the same charact
Introduction to LINQ, Part 2: LINQ to XML
(Marius Bancila) In the first article of the series, I introduced the LINQ to Objects API, showing how the language integrated queries can be used for querying sequences with C#. In this second article, I will introduce LINQ to XML, formerly code-named XLinq.
Block Change Tracking Internals: X$ Tables Research — X$KRC ‘Snappack’
(Alex Gorbachev) With this post, I’m starting a series about Oracle Block Change Tracking internals. The feature was introduced in Oracle 10 Release 1. I have already published my past presentations and the white paper about that, so what pushed me to get back to this topic again?
Rolling Your Own Website Administration Tool – Part 1
(Dan Clem) Forms-based authentication combined with ASP.NET 2.0’s Membership and Roles systems makes creating and managing user accounts incredibly easy. I continue to be amazed at how the login-related Web controls encapsulate the array of tasks that I had always had to code by hand in classic ASP.