Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
339 reads
Blog Posts
Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
7 reads
Storage Field Day 23 – SIOS
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-17
33 reads
Comparing Daily Estimates to Actuals–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post I wrote about using...
2022-05-16 (first published: 2022-05-04)
194 reads
Daily Coping 16 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-16
33 reads
How to Deploy an Azure Function with PowerShell using Azure Devops
In the blog post Azure Function with PowerShell and the Power BI REST API I explained how you could create an Azure Function using the PowerShell scripting language. This...
2022-05-16 (first published: 2022-04-27)
233 reads
SQL Server Backups
I’ve written many blog post and articles over the years about SQL Server backups and restore options. I am constantly amazed at how often I find databases that are...
2022-05-16
12 reads
Storage Field Day 23 – HammerSpace
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-16
49 reads
SQL Saturday Jacksonville Slide Decks
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous Integration Using Local Agents Adopting a DevOps Process for Your Database
2022-05-14
58 reads
Daily Coping 13 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-13
13 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Berikut cara menutup kartu kredit UOB sampai tuntas
Untuk menutup kartu kredit Bank UOB, Anda dapat mengh??bungi UOBCall melalui Whats?????? (62 0882^201^14008):...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers