Audio Attacks
We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.
2017-05-25
69 reads
Editorials
2017-05-24
163 reads
Naming Conventions for the Cloud
Today Steve Jones looks at how you might track the various items you use in the cloud.
2017-05-23
223 reads
Listening and Taking Action
Microsoft has changed SQL Server in response to the community. Read about some of the enhancements.
2017-05-22
81 reads
2017-05-22
60 reads
Pseudonymisation
Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.
2017-05-19
1,949 reads
Data Privacy and Security: The Implications of GDPR
There may be new changes to our jobs as data professionals because of GDPR in the European Union.
2017-05-18
147 reads
Array Element by Agonizing Array Element
Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.
2017-05-17
120 reads
2017-05-16
106 reads
Cracking the SQL Code
Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.
2017-05-15
228 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers