Not having TDE in all editions is stupid
Transparent Data Encryption is only available in Enterprise Edition and above. Steve Jones thinks that's a mistake.
2011-12-05
123 reads
Editorials
A Welcome Intruder
This Friday Steve Jones asked about penetration testing of your security. Have any of you ever tested your systems?
2011-12-02
123 reads
Fast Migrations
Virtualization is an important technology for anyone working with servers, and as vendors look to improve the performance of their hypervisors, this technology might be more important for data professionals to understand.
2011-12-01
138 reads
A Refreshing Break
Steve Jones talks about his recent vacation break and one change that made it a huge success.
2011-11-30
122 reads
Thinking Time
Do you get time to stop and think, without being pressured to solve a specific problem? Steve Jones notes that it's important to get that creative time to grow and produce better work.
2011-11-29
228 reads
Little Love Lost for SMO
SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.
2011-11-28
222 reads
Stress – It’s Not Fair
Today we have a guest editorial from Andy Warren that looks at stress and how it impacts your job. He offers a few ways that you might better deal with it as well.
2011-11-28
221 reads
Snack Attack
This editorial was originally published on Jan 11, 2007 and is being re-run as Steve is on vacation. A fun poll today asking what you like to eat at work.
2011-11-25
93 reads
Are You Easy To Work With?
Today we have a guest editorial from Andy Warren that looks at the relationships you have with your co-workers.
2011-11-23
472 reads
Power Tools at Work
This editorial was originally published on Jan 17, 2007. It is being republished as Steve is on vacation. This one deals with data security.
2011-11-22
118 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