Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,683 reads
James Serra's Blog
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...
2012-11-20
1,052 reads
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,169 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter.
Here is the PowerPoint presentation: Data Warehouse...
2012-11-15
1,695 reads
Dell Quickstart Data Warehouse Appliance 2000
As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second...
2012-11-13
909 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,037 reads
SSIS: Execute SQL task vs Execute T-SQL Statement task
In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL....
2012-11-08
16,374 reads
Problem copying large files to a USB flash drive?
I thought I would write a quick blog on a problem I see frequently: You try to copy a large...
2012-11-06
1,013 reads
Jumping from SSIS 2008 to SSIS 2012
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I...
2012-11-01
2,500 reads
SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,663 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
Alamat BCA KCP Ampera Telp/Wa (+62) 821-8200-233
Call Cs 08218200233 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu,...
Alamat BCA KCP Ambasador Telp/Wa (+62) 821-8200-203
Call CS 08218200203 Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lt Dasar,...
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