Notes from the R2 Tweetup
Several weeks ago I was invited to attend a ‘tweetup’ by Microsoft on April 8th, an almost all expenses paid...
2010-04-12
441 reads
Blog Posts
PASS BI Virtual Chapter – Thursday’s Session Postponed
The PASS BI Virtual Chapter’s scheduled session for this Thursday, April 15th, will have to be postponed until a later...
2010-04-12
672 reads
Reporting Services 2008 R2 Data Bars
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be...
2010-04-12
2,089 reads
SCSUG April Meeting Follow-up
The April meeting went well. I had hoped that the prospect of a couple of Technet subscriptions would increase attendance...
2010-04-12
402 reads
Seacoast SQL Users Group
Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...
2010-04-12
735 reads
SQLSaturday PowerPoint Template – Looking for Suggestions
Sanj Gandham from PASS HQ set up a basic template for SQLSaturday presentations, you can download it from here. Our...
2010-04-12
737 reads
Visual Studio 2010 Download Interruptus
Microsoft has made the RTM bits for the various versions and components of Visual Studio 2010 available on MSDN Subscribers...
2010-04-12
336 reads
What to do about certification
After my editorial “The Missing Certification” I was amazed at the debate that took place. As of the time I’m...
2010-04-12
995 reads
2010-04-11
1,581 reads
Northwest Arkansas TechFest Set for July 18
David Walker, the organizer of the popular Tulsa TechFest, is organizing the first annual NWA TechFest, to be held Thursday,...
2010-04-11
610 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