Most Work is Mundane
Today we have a guest editorial from Andy Warren. Work can seem mundane and tedious at times, and today Andy asks you you remain engaged when the work isn't exciting.
2011-02-11
223 reads
Editorials
OldSQL
Support for SQL Server 2005 expires in April. Should you care? Steve Jones thinks it might not be a big deal for many people.
2011-02-10
360 reads
You Should Know
Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.
2011-02-09
312 reads
Life Without Keyboards
The way we input data is changing with the advent of the iPad and tablets. Is that good or bad for the acquisition of data? Steve Jones has a few thoughts today.
2011-02-08
194 reads
I lied, now what?
What do you do if you've lied to get a job and now are in a bad position? Steve Jones offers his advice today.
2011-02-07
597 reads
Let the optimizer drive
For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.
2011-02-07
210 reads
Toys V. Tools
What's a toy and what's a tool? This Friday, a guest editorial from Jason Brimhall asks what in technology might be considered a toy or a tool, or perhaps, both.
2011-02-04
230 reads
Cloud Hacking
Steve Jones thinks that security will be one of the biggest impediments to the adoption of cloud computing might be the security issues and hacking targets it provides.
2011-02-03
326 reads
Hybrid Hires
Will you be a hybrid worker in your next job? Steve Jones notes that many of the new jobs that will be created in the future might involve hybrids.
2011-02-02
198 reads
What's a Passive Server?
Today Steve Jones talks about licensing and the complexity if brings in various scenarios. Do your passive servers have to be licensed? What is the definition of "passive"?
2011-02-01
260 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