Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier.
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]
PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.
Time is running out to submit your abstract for our hybrid PASS Data Community Summit 2022 conference! If you're an expert in a data-related topic that you think would be perfect for the Summit 2022 program, we want to hear from you. Whether you're planning to attend in-person or online, all session submissions and speakers will be considered for this year's event. Don't miss your chance to speak at the leading conference for data platform pros, submit your proposal before March 31.
Learn about high availability in the cloud at a conceptual level.
Learn about high availability in the cloud at a conceptual level.
There are many ways to work more efficiently, but tracking and saving your work might be one of the best.
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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