Fines for Data Access
A government is fined for allowing inappropriate access to data. That might be something we deal with in other companies at some point.
2019-07-03
192 reads
Editorials
Balancing Hard and Soft Skills
Today Steve talks about the soft skills and why these might be important as you advance in your career and grow into a senior role.
2019-07-02
535 reads
CCPA Preparation
The California Consumer Privacy Act takes effect in a year and there is lots of work to be done. One firm is trying to help companies get ready.
2019-07-01
340 reads
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
341 reads
Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
292 reads
The Road to Better Data Handling
As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.
2019-06-27
233 reads
2019-06-26
180 reads
Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
2019-06-25
438 reads
Killing FTS
Steve wonders today if the Full-Text Search system in SQL Server is due for a replacement, perhaps with other technologies.
2019-06-24
255 reads
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
402 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