Additional Articles

T-SQL Best Practices – Part 2

by Additional Articles

Database Journal

T-SQL

Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).

2009-08-10

9,037 reads

Richard Stallman: Geek of the Week

by Additional Articles

SimpleTalk

Interviews

Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".

2009-08-07

2,874 reads

Simple Doughnut Chart for Analysis Services Data

by Additional Articles

Database Journal

Analysis Services (SSAS)

Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.

2009-08-07

3,212 reads

An Introduction to SQL Server FileStream

by Additional Articles

SimpleTalk

FILESTREAM

Filestream allows us to store and manage unstructured data in SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly. However, it became clear that we were missing out on some extraordinarily useful functionality, so we asked Jacob Sebastian to come up with a simple and clear-cut account of the FILESTREAM feature in SQL Server 2008. You'll agree he has managed the feat superbly.

2009-08-06

3,929 reads

Different ways to determine free space for SQL Server databases and database files

by Additional Articles

MSSQLTips.com

database size

In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.

2009-08-06

4,986 reads

Foreign Key Constraints Revisited

by Additional Articles

Database Journal

Database Design

Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.

2009-08-05

3,175 reads

Installing Hyper-V and Beyond

by Additional Articles

SimpleTalk

Hyper-V

In his previous article “Hyper-V, an introduction” Jaap Wesselius explained about the Hypervisor, the parent partition, the child partition, and Integration Components. In this article Jaap discusses installing Hyper-V, all kinds of Virtual Hard Disks, Virtual Networks, and some best practices.

2009-08-05

2,325 reads

Attribute Discretization: Using the “Clusters” Method

by Additional Articles

Database Journal

Clustering

Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.

2009-08-04

2,163 reads

SQL Server 2008 Analysis Services Performance Guide

by Additional Articles

Microsoft MSDN

Analysis Services (SSAS)

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.

2009-08-04

2,866 reads