(Lucas Jellema) With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way too much time on pretty nonsensical exercises like the Gauge and Stacked Bart Chart in SQL, I had decided not to do it a
Other News
Implement Parallel Execution in SSIS
(Runying Mao) SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are controlled by two properties as outlined below.
Disaster recovery features in SQL Server 2005
(Hilary Cotter) Disaster recovery refers to the ability of a company to continue operations after an event interrupts normal business functions. For example, many businesses in New York City faced considerable disruption during the power failure in the summer of 2003, and of course in the aftermath
Precaching MySQL Replicated Data
(Kevin Burton) This is a hack I’ve heard about a couple times now: Paul wrote a script that reads from the logfile the queries that are going to be executed moments later. He parses the queries and constructs new select queries that populate the cache with the data that speeds up the upcoming wri
System Administration Certification exam 918 for IBM Informix Dynamic Server V11.10 prep, Part 1: IDS installation and configuration
(Manjula Panthagani, Rashmi Chawak and Siva K. Ane) Install and configure IBM Informix Dynamic Server, Version 11.10 (IDS 11), manage space and logs, and configure the different security options available in IDS. The first in a series of eight tutorials, use this tutorial to help prepare for the IDS
Reflections on Reflection
(Mike Repass) Are your goals of clean componentization frustrated by the need to share too much type information across libraries? Perhaps you want the efficiency of strongly typed data storage, but it’s costly to update your database schema whenever your object model evolves and so you’d like to in
A Primer on Managing Data Bitemporally
(Adam Machanic) A central truth that we need to embrace to be successful as database developers is that not all data is as great as it could be (or as we might wish it to be). Sometimes, we’re forced to work with incomplete or incorrect data, and correct things later as a more complete picture of re
Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server
(jsmith8858) The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET
(63) SelectViews: Business Intelligence not ready for prime time, triggers and indexes, SQL Server 2005 Adoption rates…
Video Programming for IT Professionals
Working with ASP.NET AJAX UpdatePanel Properties
(Dan Wahlin) This video tutorial demonstrates the affect the UpdatePanel’s UpdateMode and ChildrenAsTriggers properties have on updating a panel’s content. The video starts out by discussing the UpdateMode property and shows why you may want to know about it when using multiple UpdatePanel controls