Additional Articles

Administering your Windows Internal Database (MICROSOFT##SSEE) instance

by Additional Articles

MSSQLTips.com

Embedded Edition

Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-fledged DBAs, how do they manage the Windows Internal Database?

2008-09-17

3,273 reads

Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

by Additional Articles

Database Journal

Clustering

Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.

2008-09-17

1,778 reads

How To Collect Performance Data With TYPEPERF.EXE

by Additional Articles

MSSQLTips.com

Performance Tuning

One of the things I typically need to do is to collect performance data on the server which includes CPU, memory and disk utilization as well as SQL Server-specific data. What command line tools are available to do this?

2008-09-15

4,384 reads

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

by Additional Articles

DMReview

Data Warehousing

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following corollaries to Murphy’s Law relate this inevitability of something going “bump” in the night to data warehousing.

2008-09-15

3,411 reads

Attribute Member Keys – Pt 1: Introduction and Simple Keys

by Additional Articles

Database Journal

Analysis Services (SSAS)

Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.

2008-09-12

2,459 reads

Best Practices for Data Warehousing with SQL Server 2008

by Additional Articles

TechNet Blogs

Best Practices

There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.

2008-09-12

5,318 reads

Automatically Running Stored Procedures at SQL Server Startup

by Additional Articles

MSSQLTips.com

Administration

I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?

2008-09-11

3,855 reads

Managing SQL Server Database and Application Metadata

by Additional Articles

MSSQLTips.com

Administration

Unless you are the Database Administrator or the Application Analyst for a particular database you are usually oblivious to the naming conventions of the databases that support the applications you rely upon daily. This is why it is important to have the metadata repository in place to provide that translation when the need arises.

2008-09-11

2,992 reads

Benefits and limitations of using synonyms in SQL Server 2005

by Additional Articles

MSSQLTips.com

Synonyms

A SYNONYM is new to SQL Server 2005. It is a way to give an alias to an already existing or potential new object. It is just a pointer or reference, so it is not considered to be an object.

2008-09-10

5,600 reads

Terminate User processes in SQL Server

by Additional Articles

Database Journal

Administration

This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.

2008-09-10

4,612 reads

All authors

Additional Articles

Administering your Windows Internal Database (MICROSOFT##SSEE) instance

Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

How To Collect Performance Data With TYPEPERF.EXE

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

Attribute Member Keys – Pt 1: Introduction and Simple Keys

Best Practices for Data Warehousing with SQL Server 2008

Automatically Running Stored Procedures at SQL Server Startup

Managing SQL Server Database and Application Metadata

Benefits and limitations of using synonyms in SQL Server 2005

Terminate User processes in SQL Server

Blogs

The end of an era – why I chose not to renew my MVP

PowerShell Strikes Back: A New Script

Claude Desktop

Forums

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

QUOTENAME Behavior

Running script without having permission to Function

Question of the Day

QUOTENAME Behavior