#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql ... Continue reading
2021-10-04 (first published: 2021-09-21)
625 reads
Blog Posts
Daily Coping 4 Oct 2021
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...
2021-10-04
21 reads
Facebook, Instagram and WhatsApp just had a really bad Monday
It’s the end of the work day here on the east coast and I see that the Facebook is still unavailable. Facebook acknowledged the problem in the following two...
2021-10-04
79 reads
Getting Up and Running with Dapr
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood it that well. I had a webinar coming up, so I decided to spend a...
2021-10-04 (first published: 2021-09-22)
426 reads
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-04
4 reads
Daily Coping 1 Oct 2021
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...
2021-10-01
44 reads
Data Platform products for Microsoft gaps
Microsoft has a ton of data platform-related products, but there are certain areas where they either don’t have a product or what they have is limited and you need...
2021-10-01 (first published: 2021-09-22)
517 reads
Lambda Architecture in data systems and possible meaning of this name
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists were asked to explain certain anomalies that were projected on a computer screen. One of...
2021-10-01 (first published: 2021-09-21)
446 reads
Power BI: Adding Columns to a Published Data Model using the XMLA Endpoint & TMSL
Goal of this demo: Update a Power BI model schema by adding a column to the data model without opening a PBIX file and ensure the scheduled refresh still...
2021-10-01
10 reads
Daily Coping 30 Sep 2021
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...
2021-09-30
47 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers