(Lauren Walker) In 2006, Microsoft will ramp up its redesigned certifications program, publishing curricula and offering the first exams for the new SQL Server 2005-based credentials and rolling out new certifications. That’s all in conjunction with its anticipated major product releases for Windows
Other News
Oracle Data Modeling, Breaking & Fixing First Normal Form (1NF)
(James F. Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.
Embedding SQL Server Express into Custom Applications
(Robert Walters) This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.
Anatomy of a Native XML Database
Learn about the design and architecture of a native XML database, how it gives developers great flexibility storing and indexing XML documents, and how specific design choices drive performance, scalability and features. (R,pdf)
Downloading from OTN Directly to your Database Server
(Marc Fielding) It often comes up that you need to download Oracle software directly to your database server from OTN. Unfortunately, technet.oracle.com is hostile to non-GUI downloads. GNU wget would be the ideal tool for this and binary versions are available many places (AIX binaries for instance
How To Create an RSS Aggregator with PHP and AJAX
(Kris Hadlock) Imagine using a simple HTML file to send a request to a server-side script, receive a custom XML file based on that request, and then display it to the user without ever refreshing the browser! Kris Hadlock explains how to use a combination of PHP and AJAX to create real-time data tra
Unlocking the Inner Secrets of WinForms
(Adam Calderon) The new version of Windows Forms in .NET 2.0 brings some exciting and much-needed enhancements that not only allow for more productivity, but also allow for creating some extremely professional looking applications that have the look and feel of many of the office applications we use
Clustered Indexes in SQL Server: Things You Need to Know
(Geert Vanhove) This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I’ll also give you some tips on how to use them in a not so obvious context.
Checklist: Prepare SQL Server for peak workloads
(Hilary Cotter) Not surprisingly, many e-commerce sites experience periods of high activity at the holidays. For instance, 1-800-Flowers.com Inc. (1-800-flowers.com) experiences bursts of ordering activity around Valentine’s Day, Mother’s Day, Christmas, Easter, Thanksgiving, Secretary’s Day and Tea
SQL Server 2005 – SQL Server Integration Services – Part 14 – Debugging Data Flow
(Marcin Policht) In the previous installment of our series, we discussed various approaches to debugging Control Flow components of SQL Server 2005 Integration Services. While this satisfied our primary goal of facilitating real-time monitoring and troubleshooting of the package workflow, it is impo