Other MDX Entities: Perspectives
Leverage Perspectives, new to Analysis Services 2005, through MDX. BI Architect Bill Pearson leads hands-on practice with this means of visually focusing data retrieved from the UDM.
2006-08-24
2,599 reads
Articles
The Pitfall of "Not Equal To"
Writing complex queries can be a little tricky, especially when you get into outer joins and inequalities. New author Amin Sobati takes a look at a tricky situation with the "Not Equal To" operator and shows how you can avoid inaccurate results.
2006-08-23
14,842 reads
Clustering Windows 2003 R2
In this presentation, you'll learn step-by-step how to cluster Windows 2003 R2. Brian shows you how to configure and cluster a two node cluster, preparing it for any future services like SQL Server or Exchange.
2006-08-23
2,131 reads
How do I install SQL Server 2005 Express Edition and SQL Server Manag
With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. Although it is free, it is still important for you to install this application correctly, Scott Lowe shows you how.
2006-08-23
3,214 reads
Stress
As a DBA, stress is probably a given in your career, but are you aware of the effects on others. Andy Warren takes a look at the effects of stress, how you can identify them and a few ways to cope.
2006-08-22
6,892 reads
Old Model DA Model
True business value lies in using the data model as an entry point for a program of data management that treasures data as the most valuable corporate asset.
2006-08-22
1,643 reads
The Enterprise Library for .NET Framework 2.0
What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.
2006-08-21
15,370 reads
Executing a Package from Visual Basic
So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.
2006-08-18 (first published: 2004-01-23)
25,404 reads
How Do I create an XML document from undefined legacy data?
This article explains how to transform a nebulous application requirement like "take a flat file that was produced by an upstream mainframe application and produce an XML document for a downstream application," into a flexible working solution.
2006-08-18
2,197 reads
Read Only Tables
Do you know how to setup a read-only table in SQL Server. Steve Jones takes a look at a few methods to achieving this and examines the pros and cons of choosing different methods.
2006-08-17
15,057 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers