(Tony Patton) An important topic when working with .NET directories is security; that is, you want the users who need to access a directory to have it and restrict other users from the directory. This article examines the details of controlling and setting security at the directory level.
Author: SSWUG Research
Preserving XML queries during schema evolution
(Mirella Moura Moro, Susan Malaika and Lipyeow Lim) The always evolving context of the Web imposes the challenge of how to accommodate new functionalities and new data types in the database that underlies a Web application or service. For XML databases, new schema versions can be released as frequen
Gathering RSS Feeds using Visual Studio and RSS.NET
(John Papa) This article will explain how to create a custom Windows Service that retrieves posts from multiple RSS feeds and then stores them in a SQL Server database. Once you store the posts in the database you can then retrieve them and display them on a web site, so you can combine multiple fee
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’
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.
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
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.
How to warm up the Analysis Services data cache using Create Cache statement?
(Eric Jacobson and Cristian Petculescu) This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first.
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
(Rick F. van der Lans) The GROUP BY clause groups rows on the basis of similarities among them. For example, we could group all the rows in the PLAYERS table on the basis of the place of residence. The result would be one group of players per town. From there, we could query the number of players in
Three ways to avoid Case Not Found errors in PL/SQL
(Bob Watkins) PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE function does), and it also lets you execute one or more statements for the first matching value. The searched CASE statement lets you test multiple expression