PerformancePoint wish list – change a datasource
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
820 reads
James Serra's Blog
How to become an expert in your field
I have been compiling a list of what things a person can do to become an expert, or guru, in...
2011-05-30
5,090 reads
Search Active Directory (AD) from your desktop
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
690 reads
ABL: Always Be Learning
If you have been in the IT field for any length of time, I’m sure you have heard the phrase...
2011-05-25
1,540 reads
Show correct totals when using SSAS role security
When using role security in SSAS, one point of confusion is when a person sees the grand total for a...
2011-05-23
870 reads
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,031 reads
New Microsoft BI Labs site
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,120 reads
DBA’s, want to earn the big bucks? Learn BI
While there are many DBA’s who do business intelligence, or BI, I believe there are even more who do not. ...
2011-05-16
1,185 reads
SSAS error when processing the cube
Every couple of weeks I see this SSAS error when processing one of my cubes:
Internal error: Invalid enumeration value. Please call...
2011-05-13
1,458 reads
Dirty looking SQL or MDX? Clean it up
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a...
2011-05-11
682 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers