SSAS Architect Bill Pearson examines another intrinsic member property, LEVEL_UNIQUE_NAME, which allows us to exercise a great deal of presentation “sleight of hand” in working with MDX in Analysis Services, as well as within Reporting Services and various other reporting applications that can access an Analysis Services cube.
2009-03-05
1,511 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
649 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
889 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
609 reads
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
2009-03-04
3,505 reads
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
2009-03-04
11,287 reads
The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
2009-03-04
4,119 reads
It's been pretty busy since my last post. Just in one week I had at least 12 hours devoted to PASS activities, and I'll share details of some of that here. To start with, I was able to mark another of my Q1 goals complete as Sanj from PASS HQ...
2009-03-04
1,324 reads
Adding a field to a database table is sometimes not as simple as it may seem. If certain situations are not considered when adding fields, you may find yourself looking at some long nights fixing database code. Today, database consultant Tim Chapman looks at two such scenarios, and how you can plan for their occurrence.
2009-03-04
4,537 reads
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2009-03-04
118 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers