Tutorial: Using the hierarchyid Data Type
This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type.
2024-02-19
Articles
JQ - Tool for Querying JSON documents using the CLI
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
2024-02-16
8,381 reads
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it
2024-02-16
Attention SQLBits 2024 Attendees!
Microsoft will be featured at SQL Bits with a keynote speaker, a full day of training and a few other sessions. Register today for the conference in March and we hope to see you there.
2024-02-14
1,259 reads
Scientific Calculations in Power BI - Cube, Square, Logarithms, Powers, Inverse and more
Microsoft Power BI Desktop provides users with multiple ways to help shape and transform their data. One of the options users have is scientific calculations, which support operations like cube, square, logarithms, etc. Power BI has this option in the Power Query Editor mode, where the user can easily apply one of these transformations for any number-based columns. In this tip, we will overview this utility in Power BI and how to benefit from it.
2024-02-14
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
2024-02-12
13,527 reads
Planning a Database Testing Strategy for Flyway
With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.
2024-02-12
Leveraging AI Tools for SQL Queries
This article covers the basics of how different AI tools can be used to write SQL.
2024-02-09 (first published: 2024-01-19)
8,678 reads
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.
2024-02-09
2,698 reads
Fun with Powershell
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
2024-02-09
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers