Some Pester Tests for SQL Defaults
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
613 reads
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
613 reads
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
792 reads
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
659 reads
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,690 reads
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,220 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,765 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-04 (first published: 2016-01-31)
1,701 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
854 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
717 reads
This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
451 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
BCA KCP Tebet Telpon/wa:0813.7887.595.Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
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