The Need for Database Intelligence Software
A brief editorial on future database engines having built in intelligence.
2016-07-08
183 reads
Editorials
Fuzzy Processing
There are times when you don't want to get exact mathematical calculations in data processing, and Steve Jones talks about one of them today.
2016-07-07
116 reads
The Bad Data Shutdown
Not more hacking, but rather a data error in some cars is disturbing to Steve Jones.
2016-07-05
127 reads
2016-07-04
81 reads
An example of how networking netted a new job
Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.
2016-07-01
94 reads
Monitoring and Alerting
Knowing what is happening on your systems, and being told when a system is not behaving normally is very important for administrators. Steve Jones has a few thoughts on monitoring today.
2016-06-30
254 reads
Email or Username
One of the things that can be an issue in database design is the data used to identify a user.
2016-06-29
116 reads
Democratic Data Science
Data science is hot now, but work is being done to use the power of software to handle some of the grunt work with data analysis problems.
2016-06-28
94 reads
DevOps and Security
Are DevOps and security diametrically opposed? An interesting pieces says no, and Steve Jones comments.
2016-06-27
77 reads
SQL Server 2016 is Out and It's Fabulous!
On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
160 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers