Look Beyond the First Result
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
2013-02-26
137 reads
Editorials
Deploying Databases to the Azure Cloud: an extended plea
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
190 reads
The Dark Side
Steve Jones talks a little about Oracle after speaking at an event devoted to that technology.
2013-02-25
213 reads
Early Software
This week Steve Jones reminisces about the first software he used. He asks you what inspired you to start working with computers.
2013-02-22
119 reads
Fix the Little Things
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed. Today's editorial was originally published on Nov 11, 2008. It is being re-run as Steve is out of town.
2013-02-21
154 reads
Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about. Today's editorial was originally published on Nov 3, 2008. It is being re-run as Steve is out of town.
2013-02-20 (first published: 2008-11-03)
221 reads
Are Triggers a "Legacy" Feature?
It is late evening. Something is wrong with a database. You narrow down the possibilities, getting more frustrated and puzzled. Stay calm. Check the inputs systematically. No! The data going into that table is right, but when you then read it in the table, it's wrong. Why did I stop believing in the supernatural? Then it hits you. Every time it comes as a surprise. They're using triggers. (This editorial was originally published on Nov 10, 2008)
2013-02-19 (first published: 2008-11-10)
641 reads
The Group Account
Our desktop OSes have evolved to support group accounts, but much of the ecosystems around them do not and many mobile and tablet devices do not. Why don't they?
2013-02-13
94 reads
Data Freedom and Regulation
There are a lot of regulations around data in the medical field. Most of the exceed HIPAA, but end up causing confusion and problems. Steve Jones thinks simplication is important if our technology systems are to support future regulations.
2013-02-11
108 reads
Rethinking Your Design
This week Steve Jones notices some good advice from Brent Ozar and the fastest query in your database.
2013-02-11
228 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers