n this lesson, we will examine another function / property in the MDX toolset, the .UniqueName function. The general purpose of the .UniqueName function is to return the Unique Name of the object to which it is appended. .UniqueName can be used in conjunction with hierarchies, dimensions, levels, and members, in a manner similar to the .Name function that we examined in String Functions: The .Name Function, and, also like .Name, .UniqueName can be useful in a host of different applications.

Controlling Transactions and Locks in SQL 2000 and 2005 - Part 2

by Additional Articles

Database Journal

Performance Tuning

In order for a transaction to meet the requirements of ACID, locks are employed to insure data integrity and multi-user access. The scope, or number of rows held by a lock, is referred to as Lock Granularity. This month, we will begin by introducing several different types of lock modes employed by MS SQL.

Come To The PASS 2005 Summit

by Press Release

SQLServerCentral.com

Less than two weeks away, sessions tried and tested at the PDC, the Microsoft SQL Server development team and gambling with SQLServerCentral.com! Register today!

On the Road...Part II

by Robert Pearl

SQLServerCentral.com

Interviews

Continuing on an interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts.

Big SQL Server 2005 News

by Steve Jones

SQLServerCentral.com

Confidential until the official release at 9:00am Pacific Time today. Check back after that time to get the big news!

TechNote: Installing SQL Server 2005 and Visual Studio 2005

by David Russell

SQLServerCentral.com

Administration

If you are working with SQL Server 2005, you really need Visual Studio 2005 as well. And since they are both in Beta, there are some interesting issues when installing both of these pre-products. New author David Russell brings us some technical notes he made while installing both of these many times in a corporate environment.

SQL Server Barcodes

by Michael Coles

SQLServerCentral.com

Advanced Querying

You may never need to work with them, but if you do then you will quickly realize how complicated barcodes can be. Michael Coles recently had a project and developer a toolkit to actually print barcodes from SQL Server.

Regular Expression Transformation

by Additional Articles

sqlis.com

The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows are passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.

Extreme SQL Server

by Press Release

SQLServerCentral.com

Clustering, partitioning, database snapshots, database mirroring, SQL Server SAN storage design and more are all in the September issue of the SQL Server Standard.

No Outlook for Alerts!

by Roy Carlson

SQLServerCentral.com

Administration

SQL Server 2000 has a fantastic subsystem for alerting the DBA and keeping him or her informed as to the state of the server. However the email subsystem introduces a dependency on Outlook for alerts that can be a problem for some environments. Author Roy Carlson brings us an ingenious method for reading logs and sending alerts without Exchange or Outlook.

MDX Essentials: String Functions: The .UniqueName Function

Controlling Transactions and Locks in SQL 2000 and 2005 - Part 2

Come To The PASS 2005 Summit

On the Road...Part II

Big SQL Server 2005 News

TechNote: Installing SQL Server 2005 and Visual Studio 2005

SQL Server Barcodes

Regular Expression Transformation

Extreme SQL Server

No Outlook for Alerts!

Blogs

The Book of Redgate: Do the Right Things

How to Connect to SQL Server When Nothing Else Works – DAC

Get a Range of Sequence Values: #SQLNewBlogger

Forums

Let's Talk Community Events!

that one limitation in replication

Local Agents

Question of the Day

Detecting Deadlocks