The Team You Want
Steve asks about your team at work today. What you like, what you need, even what you want to see in those with whom you work.
Decision Tree - Credit Card Fraud Detection
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.
A Brief Introduction to PowerShellAI, an Intelligent Command-line
Learn how you can interact with ChatGPT from PowerShell.
Rogue Colleagues
Can you trust your colleagues? We all want to, but there are always temptations, especially when life gets hard. Steve wonders today how we look at the issues of security inside of our organizations.
PASS Data Community Summit 2023 - Sessions are available to view!
As hosts, Redgate are delighted to announce PASS Data Community Summit 2023 sessions are now live and available to view!
Quickstart: Connect SQL Server machines to Azure Arc
Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.
How To Use Flyway for Database Migration in Spring Boot
In this article, we're going to look at how we can use Flyway to manage our SQL database schema in a Spring Boot application.
Optimized Plan Forcing with Query Store in SQL Server 2022
In this Article , We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers