SQL Server 2014!
Just when you thought you got a handle on SQL Server 2012, here comes the next version! SQL Server 2014 was announced...
2013-06-07 (first published: 2013-06-04)
6,979 reads
James Serra's Blog
Power View for Multidimensional Models Released
As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via...
2013-05-31
1,836 reads
Ralph Kimball Books
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:
The Data Warehouse Lifecycle Toolkit: Practical...
2013-05-30
2,546 reads
Business Intelligence Requirements Gathering
There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):
Identify...
2013-05-28
4,900 reads
I’m presenting at the PASS Summit!
I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October...
2013-05-23
747 reads
Consulting company: Perm/Salaried vs 1099/W2
One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company...
2013-05-21
1,997 reads
When the person you hire is not the person you hire
This is something I just heard about recently, but then experienced it for myself.
This story was told to me: A...
2013-05-16
894 reads
Should placement companies use a markup %?
To expand on what I talked about in Should a placement firm tell you what they are billing the client?:...
2013-05-14
989 reads
Data cleansing in SSIS, DQS, and MDS
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The...
2013-05-09
2,671 reads
Billing rates – other side of the fence, part 2
Here is another response to my blog “Should a placement firm tell you what they are billing the client?” (the...
2013-05-07
1,112 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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