(Jason Thomas) As a response to my previous post, one of my readers asked me this question – “ why are you hell-bent on making a star schema? You yourself have told that a snowflake schema would give the best performance during cube processing and once the cube is processed, it doesn’t matter which
Other News
SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server
(Pinal Dave) SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS.
What is an Enclave?
(Craig Mullins) If you are a DB2 professional dealing with distributed workload… or if you are enabling zIIP specialty processors… chances are you’ve heard the term “enclave” or “enclave SRB.” But just what is an enclave?
Using Control Files for Backup and Recovery
(W. Jason Gilmore and Bob Bryla) In this second part of a three-part series on backing up and recovering an Oracle database, you’ll learn about multiplexing control files and enabling ARCHIVELOG mode.
Data architect: Securing DB2 data
(Robert Catterall) Role-based security gives you a way to protect your organization’s information assets and has been available since the release of DB2 V9.5 for Linux, UNIX, and Windows(LUW), and DB2 9 for z/OS.
Filtered Indexes
Filtered Indexes As you may or may not know there are two basic types of indexes available in SQL Server. Clustered and Non-Clustered. A table (or view) having a clustered index stores the data within the clustered index leaf nodes. A Non-Clustered index stores pointers to the location of the data within the clustered index, if one exists, or the […]
XML Authoring and the ‘Big Aha!’
(pgbartlett) Quark just announced the release of Quark XML Author 4.0. Now, while a new release of a current product may seem like standard business for a software company, with this one came a few big “aha” moments. The most intriguing one is creating a lot of buzz both within our team and with tho
VB.NET Data Types
(Paul Ferrill) Understanding data and how it is represented is key to making use of it in a program. In this segment we’ll walk thru VB.NETs standard data types and talk about how to make use of them.
ASP.NET MVC 3 Filters
(Brian Mains) The ASP.NET MVC framework applied a popular technique of aspect-oriented programming, which incorporates the idea of using attributes to apply to a controller or action. These attributes are filters that can affect the runtime process. An action can run before or after an action or res
DOM Scripting and the
(Mike Taylor) We’ve created a fun demonstration (well, at least it was fun to Andreas and me last night at 1AM) of how to make use of the element via DOM scripting. Behold our mighty date robot.