People That Get It Done
Today we have a guest editorial from Andy Warren. This one follows on from his "are you easy to work with" piece.
2011-12-16
292 reads
Editorials
Careful with your Smartphone
Do you connect to your work network with your smartphone? If so, you should be careful and ensure you are taking precautions to prevent any security issues.
2011-12-15
211 reads
Propose this to your boss
If you would like to tackle an interesting project at work or find yourself something new to do next year, read this idea from Steve Jones.
2011-12-14
394 reads
Jacks of all trades
Instagram has a complex architecture for it's technology infrastructure. The people that work there have to be jacks of all trades. Is that the type of environment you'd like to work in?
2011-12-13
162 reads
Does the Role of the DBA Need to Evolve?
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
2011-12-12
282 reads
Encryption Works
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
2011-12-12
370 reads
The Employment Contract
This Friday Steve Jones wants to know if you'd like to have an employment contract of some sort. Do you want your duties, or maybe exlcusions, explicitly spelled out in an agreement?
2011-12-09
170 reads
Not So Unbreakable
Oracle touted its database software as unbreakable, but many security researchers think the company is not spending enough effort on security. Steve Jones has a few comments.
2011-12-08
129 reads
Sharing Your Database Server
Is is time to consider sharing your database server with other applications? Steve Jones thinks with today's powerful servers and changes to licensing, this might make sense.
2011-12-07
162 reads
Layers of Security
A good security scheme will contain many layers. Today Steve Jones talks about one of those: good habits.
2011-12-06
185 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
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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