Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Celko's SQL Stumper: The Data Warehouse Problem
Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!
Importing Data and New Hardware (Database Weekly)
Steve Jones looks at some of the interesting news this week in the SQL Server world.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Architectural Options for Asynchronous Workflow
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
Fundamentals of Storage Systems - The Basics of Spinning Disks
Your servers are only as fast as the slowest part, hard drives.
To feed other parts of the system we have...
Introduction to Cube Storage
BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Blogs
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...
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...
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