Version Update, Code Signing and publishing to the PowerShell Gallery with VSTS
At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how...
2018-05-01
472 reads
At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how...
2018-05-01
472 reads
It’s been 45 days since we released dbachecks
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9
— Rob Sewell (@sqldbawithbeard) February...
2018-04-18 (first published: 2018-04-08)
2,226 reads
PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November...
2018-04-11
302 reads
So I always like to show splatting PowerShell commands when I am presenting sessions or workshops and realised that I...
2018-03-11
1,287 reads
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,602 reads
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You...
2018-02-22
1,073 reads
I love VS Code. I love being able to press ALT + SHIFT + F and format my code.
The Problem
Yesterday all I...
2018-02-10
481 reads
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,590 reads
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in...
2018-02-03
762 reads
Before you run a PowerShell command that makes a change to something you should check that it is going to...
2018-01-23
1,014 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Pert, Indah Blok B, Jl. Gn. Sahari Jl. Budi Mulia No.13 11-12, Pademangan Bar.,...
Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...
LODAN CENTER, Ruko Jl No.6-7 Blok O, Ancol, Kec. Pademangan, Jkt Utara, Daerah Khusus...
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