What is MongoDB?
How does MongoDB Store Data?
What is MongoDB? MongoDB is a document oriented database. This means it stores its data in...
2014-05-12 (first published: 2014-05-04)
3,874 reads
A few words about simplicity: Using Red-Gate Ecosystem framework
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
536 reads
Presentation Slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas. The abstract is below. Great...
2014-05-04
1,161 reads
PROVIDING LOGGING INFORMATION AT COMMAND LINE
For providing logging information at command line utility use the option /l
for example
dtexe /f "some path" /l "logging type; connection...
2014-05-03
450 reads
Data Quality Matching in SQL Server
Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join...
2014-05-02
202 reads
Building the SQLSaturday Orlando Marketing Plan–Part 6 (Seminars)
Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...
2014-05-02
488 reads
Hekaton 2014 – The Saviour vs The Lost Cause
With the release of the SQL Server 2014, Microsoft has finally unleashed their long-time in work In-Memory solution (codenamed XTP...
2014-05-02
140 reads
Sabbatical Decisions
My employer, Red Gate Software, offers a sabbatical to their employees, and this year I’m taking mine. I’ll be gone from...
2014-05-02
1,051 reads
Reblog: April 25 to May 1
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-05-02
1,258 reads
Building the SQLSaturday Orlando Marketing Plan–Part 5
More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...
2014-05-02
326 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
Forums
BCA KCP Pasar Kebayoran Lama Telp:0821-8200-174
Telp/Wa 62 8218200174 Jl. Raya Kby. Lama No.174, RT.8/RW.3, Cipulir, Kec. Kebayoran Lama, Kota...
ALAMAT BCA KCU SCBD Telp/Wa:0821-8200-233
Tlp Cs Bca 08218200233 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Alamat BCA KCP Mayestik Telp/Wa:0821-8200-2031
Phone Cs 08218200203 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta...
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