String Functions: The .Properties Function
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
2007-09-14
2,842 reads
Additional Articles
Reduce Aggravating Aggregation: Improve the Performance of History or
Optimize the performance of a database which includes history or status tables.
2007-09-13
2,625 reads
SQL Server 2005 Express vs. Desktop Engine (MSDE)
SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) are both free and redistributable. Each product provides a medium where database administrators can work between MS Access and the full version of SQL Server. But there are key differences to consider.
2007-09-13
3,862 reads
Why Data Models Do Not Work: The Role of Reference Data
There is an urgent need to acknowledge the limitations of data models and find a way to bridge the logical-physical divide between models and actual databases so that database designs can be fully understood.
2007-09-13
3,221 reads
How to troubleshoot Service Broker problems
In this one I'll discuss some of the problems that can arise and how to troubleshoot them.
2007-09-12
2,853 reads
Script Task Breakpoints in SQL Server 2008
One of the things coming from our look at SQL Server 2008 Integration Services is that you are not going to see a lot of change visually. What you are going to see is things going on underneath the covers that makes SSIS perform better, and improved informational messages from the components. Just such a change is seen in the Script task.
2007-09-12
2,072 reads
Making the Most of Operational Analytics with Enterprise Decision Mana
EDM solutions are a logical and often necessary complement to operational analytics.
2007-09-11
1,296 reads
Setting Up Delegation for Linked Servers
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
2007-09-11
2,732 reads
ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control
This article shows how to retrieve both remote and local XML data and display it in a data Web control.
2007-09-10
4,105 reads
What Specification Server Should I Buy?
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
2007-09-10
4,327 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers