Wish you were here?
As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.
2011-05-16
77 reads
Editorials
Dropping a Row
How important is it that your server record all changes to every row? Probably very important and that is one of the foundations on which RDBMS platforms are built. Steve Jones talks about this being a difference with some NoSQL systems, and why it might not be acceptable to most businesses.
2011-05-10
203 reads
Tiered Storage
Storage costs are constantly rising, especially for databases as we gather more and more data. However not all of our data is necessarily the same priority or requires the same hardware. Steve Jones talks about the benefits you might get if you can tier your storage.
2011-05-09
226 reads
The Titanic Cloud
The outage at Amazon's Web Services recently affected a lot of different companies. However not everyone was affected. The reach of the cloud and the competition for attention means that while we have to learn to expect failures, they are not necessarily evenly distributed.
2011-05-05
189 reads
Cascading Human Error
The recent Amazon AWS outage was blamed on human error. Steve Jones notes that the more interconnected our systems are, the more likely that a human error might cause cascades between the systems.
2011-05-03
295 reads
100% Microsoft?
This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.
2011-05-02
218 reads
The Intelligence Cloud
More cloud talk today as the Air Force is building a new intelligence sharing system in the cloud? Why the cloud? Is the cloud really better?
2011-05-02
262 reads
Temporary Indexes
Temporary indexes can speed up processes that run periodically in your applications. This Friday Steve Jones asks how many of you use temporary indexes and how you do so.
2011-04-29
576 reads
When To Hire a DBA
When should you hire a DBA? Always, of course! Actually Steve Jones doesn't have an answer, but he does talk about why a DBA can help you.
2011-04-28
307 reads
Showing Its Age
Computer Systems are aging and as companies try to save money by extending their lifetimes, are we going to see more issues?
2011-04-27
176 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers