The State of the Cloud
The state of cloud computing is confusing and unstable. Steve Jones has a few thoughts about the good and bad things in this industry.
2013-05-06
117 reads
Editorials
The Security of You
There is a lot of data out there that is specific to an individual, none more important perhaps than biometric data. Steve Jones writes a bit about the security implications involved in working with this data. (This editorial was originally published on Nov 10, 2008. It is being re-run as Steve is at SQL Bits.)
2013-05-03 (first published: 2008-11-10)
308 reads
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this. (This editorial was originally published on Jan 20, 2009. It is being re-run as Steve is at SQL Bits.)
2013-05-02 (first published: 2009-01-20)
285 reads
If you're confident about a change in your DB, triple check
Even planning allows for failure, sometimes you can't see everything else where you're standing.
2013-05-01
180 reads
2013-04-30
712 reads
BACPACs be gone: Managing real backups in Azure
While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.
2013-04-29
106 reads
Factivism
There are many people trying to make the world better for others. Bono is one of them, with the elimination of hunger as his goal. He calls himself a "factivist" trying to use data to inspire others to join him.
2013-04-29
123 reads
The Vacation Dilemma
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel. This editorial was originally published on June 12, 2008. It is being re-run as Steve is traveling.
2013-04-26 (first published: 2008-06-13)
400 reads
Flight Data
Travel can be stressful and complicated. As much as computer systems have made things easier, when they fail, your trip can turn awful in a hurry.
2013-04-25
137 reads
Natural Data
Can you own data itself or patent it? There's a Supreme Court case dealing with this right now. Steve Jones notes that the outcome could affect our jobs as we deal with more and more data and laws to control data are enacted.
2013-04-24
121 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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