(Don Schlichting) This article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio. The Studio itself consists of four components, Expressio
Other News
Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
(Carl Rabeler) This article identifies the top 10 connectivity scenarios in which users may experience connectivity problems and explores error messages generated by common client applications. It shows you how to quickly isolate each error, and then provides the information you need to resolve the
11i: ATG RUP5 and CPU Impact
Oracle has released the latest ATG rollup RUP5 (official name is 11i.ATG_PF.H.delta.5). From a security perspective, RUP5 is important in three regards – –The ATG rollups contain a number of security enhancements –RUP5 incorporates ATG CPU patches from January 2005 to January 2007 –Starti
Debugging SSIS packages
(Eric Johnson) New to SQL Server 2005, SQL Server Integration Services (SSIS) adds an enterprise-level extract, transform and load (ETL) tool to the ever-growing suite of SQL Server tools. SSIS replaces DTS, which was only around for two releases of SQL Server and grabbed limited following. Besides
Monitoring OS statistics with INFORMATION_SCHEMA plugins
(Mark Leith) With all the talk lately of the new INFORMATION_SCHEMA plugin API, I thought I’d have a go at making a couple. I’ve now made three different pluggable INFORMATION_SCHEMA tables – one that works from df -k – which will only work on UNIX like systems (other than AIX or HPUX) – and two whi
Special: Kat Meadows: What’s in Your Toolbox?
Pro-Center Video Programming for IT Professionals
Bar chart HTML generator
This article contains PHP function ae_bar_html for generating HTML/CSS based one-column bar charts. It is suitable for simple diagrams and does not require libgd.
Set the Key, Then Let It Be
(Justin Hay) Retaining the history of slowly changing dimensions, such as Store or Product, in the context of a star schema data mart is well documented. There are three approaches: –Update the existing row with the new value, –Create a new row for the new value, and –Create a set of field
Security and Compliance: Bringing Order to Information Chaos
(Mark Leon) Governing data is a little like governing people. Left to themselves, people will devolve into a “state of nature” in which civilization as we know it cannot exist.
Rational Data Architect and DB2 9: Building an SQL Statement
(Paul Zikopoulos) In an article called “Rational Data Architect and DB2 9: The Database Explorer,” I introduced you to the IBM Rational Database Architect (Rational DA) Database Explorer view and showed you how to add database connections to it. If you’re not familiar with that process, or you didn’