The Cloud Security Problem
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
131 reads
Security
No Backdoors
Governments want backdoors built into encryption software, which Steve thinks is a bad idea.
2024-09-23
117 reads
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Learn about object-level, column-level, and row-level security in Microsoft Fabric Warehouse and how this can be implemented to limit access to data.
2024-08-28
Prevent SQL Injection
SQL Injection continues to be a problem and Steve has a few thoughts today on how to reduce your vulnerabilities.
2024-08-14
236 reads
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
2024-07-20
181 reads
Least Privilege
Steve wonders how well most organizations and their staff adhere to the principle of least privilege.
2024-07-15
195 reads
Protecting Schools
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
2024-07-06
70 reads
SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
322 reads
2024-03-02
66 reads
Using AI for Security
Steve thinks AI might have a place in security, something Microsoft is investigating now.
2024-03-01
131 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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