Using the PowerShell AST to find a ForEach Method
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
329 reads
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
329 reads
Photo by Farrel Nobel on Unsplash
Welcome to another edition of T-SQL Tuesday!
This T-SQL Tuesday is hosted by Wayne Sheffield ( blog | twitter ) and he has asked...
2018-08-14
222 reads
I like to write Pester checks to make sure that all is as expected! This is just a quick post...
2018-07-25
1,266 reads
in my last post I showed how you can save the results of dbachecks to a database and created a...
2018-06-07 (first published: 2018-05-28)
1,866 reads
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,053 reads
With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...
2018-05-25 (first published: 2018-05-19)
2,363 reads
There was an announcement on the Visual Studio Code blog about the public preview of Live Share. This enables you...
2018-05-17 (first published: 2018-05-08)
2,075 reads
I love showing dbachecks to people. It’s really cool seeing how people will use it and listening to their experiences....
2018-05-15
322 reads
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want...
2018-05-10
362 reads
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
234 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...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
<!--more-->BRI KANCA JAMBI WhatsApp 08980343752 Jl. Dokter Sutomo No.12, Ps. Jambi, Kec. Ps. Jambi,...
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