Additional Articles

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

12 Essential Steps After Installing SQL Server

by Additional Articles

SQL Server Performance

Installation

Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.

2009-08-03

7,255 reads

Script to check that backup files still exist for SQL Server

by Additional Articles

MSSQLTips.com

Backup and restore

You have configured your database backup jobs without any problems. The backups themselves seem to be working, but are the files still where you think they are? How do you know they have not been moved, or worse, deleted to free up some space on your server? And when would you find out that the files were no longer there?

2009-08-03

2,892 reads

Attribute Discretization: Customize Grouping Names

by Additional Articles

Database Journal

Business Intelligence

Join BI Architect Bill Pearson as he continues 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-07-31

1,914 reads