(Ravi Pachipala, Neeraj Kapoor and Manoj Ghogale) This article discusses the merge statement of IBM Informix Dynamic Server, which follows the SQL 2003 standard. The merge command is especially useful in data warehouse (ETL) environments where transaction tables are merged into bigger warehouse tabl
Other News
Working with SQL Server Profiler Trace Files
(Bru Medishetty) In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.
Accessing Your SQL Server
Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices – This Friday Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find […]
Size Matters
Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices – This Friday Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find […]
Code Metrics, Reporting, and XSLT Debugging
(Cameron Skinner) In my last post, I announced a new power tool that allows you to analyze your managed assemblies to determine various complexity metrics. The output of the power tool is a fairly simple XML file, so in this post, I wanted to show you how simple it is to turn that simple xml file in
Subterranean IL: Exception handler semantics
(Simon Cooper) In my blog posts on fault and filter exception handlers, I said that the same behaviour could be replicated using normal catch blocks. Well, that isn’t entirely true…
Use ASP.NET and DotNetZip to Create and Extract ZIP Files
(Scott Mitchell) This article shows how to use DotNetZip to create and extract ZIP files in an ASP.NET application, and covers advanced features like password protection and encryption.
Hierarchy XML Based C# Statemachine Generator
(Jon_Slaughter) Statemachines allow one to represent a problem in a concrete and manageable form that generally has a common solution.
Convert your Data Transfer Object to XML (XML Serialization and Deserialization)
(Hasibul Haque) When we need to transfer our object through internet or need to write in a file then it is necessary to convert it to XML.
How to set DataGridView column properties at run time
(Ged Mead) In an earlier blog here, I looked at using an XML document as the data source for a DataGridView. One side effect of this approach is that you don’t get all the usual options of setting up the look of the DataGridView at design time that you’d get with, for example, a SQL Query that popu