SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,272 reads
James Serra's Blog
Can you query a SSAS cube while it is processing?
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,601 reads
Miss SQLBits 8? No problem, all videos are online
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all...
2011-06-28
878 reads
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. ...
2011-06-27
3,191 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,120 reads
SQL Server “Denali”
SQL Server “Denali” is the code name for the next version of SQL Server. The CTP1 of Denali was released...
2011-06-23
3,084 reads
Three must-have tools you should use everyday
There are three tools I use every day without exception. They all save me valuable time in surfing the net:
Delicious...
2011-06-22
1,302 reads
Miss TechEd 2011? No problem, all videos are online
While nothing beats going to a conference, the next best thing is to watch the recorded sessions. Fortunately, Microsoft has...
2011-06-20
824 reads
SSMS Add-in for Analysis Services
A nice new little add-in available for SSMS on Codeplex. It helps with repetitive tasks involved with SSAS such as processing and deployment. ...
2011-06-17
1,074 reads
Data Mining and Analytics hot career
Researchers at the University of California, San Diego have published a list of job-market hotspots, and in the top ten is...
2011-06-16
826 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