The Backup Passwords
Today Steve Jones asks how you handle those passwords across time for backups in this week's Friday poll.
2011-05-27
189 reads
Editorials
Greed Is Good (for IT)
Can greedy executives be good for IT? Steve Jones thinks so and gives us a few reasons today.
2011-05-26
213 reads
Treat People Like People
Steve Jones thinks that the Millennials have the right approach to work. There are many things that are more important than money.
2011-05-25
297 reads
Hints Are Not Always Better
This week Steve Jones reminds us that improving performance in T-SQL is not always obvious. Those little nuggets of knowledge can be very handy, which is why you should be regularly looking to acquire more of them.
2011-05-23
192 reads
Negotiating Your Raise Before Your Annual Review
Today we have a guest editorial from Andy Warren. Andy talks about your annual review and how you might want to think about negotiating for a raise in advance.
2011-05-23
197 reads
Which Bugs Do You Find?
This Friday Steve Jones wonders what types of bugs you find in software. Are there more prevalent because of design or coding?
2011-05-20
147 reads
The Three Percent Difference
Today we have a guest editorial from Andy Warren. Most people get an annual review that determines what their salary change might be for the next year. Does 3% make a difference? Andy Warren asks the question today.
2011-05-19
279 reads
Stalking the Bad Guys
What do yo do if you find malicious code in your system? Delete it? Steve Jones suggests that a honeypot might be a better idea.
2011-05-18
187 reads
Working Long or Working Hard?
Would you rather work longer hours or tackle harder work? Steve Jones comments today on a recent post by Seth Godin. The answer as to what most people prefer might surprise you.
2011-05-17
289 reads
Competing with an MBA
If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.
2011-05-16
222 reads
Blogs
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...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
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