Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,239 reads
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,239 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
855 reads
Following my last post about using Power Bi with my DBA Database I have been asked if I would share...
2015-09-09 (first published: 2015-08-31)
2,497 reads
This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...
2015-09-08
595 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-07
918 reads
A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...
2015-09-06
495 reads
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...
2015-08-21 (first published: 2015-08-16)
4,326 reads
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots....
2015-07-24
1,494 reads
First I must say thank you to all of the wonderful people who have put time and effort into providing...
2015-06-16 (first published: 2015-06-08)
1,760 reads
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
2015-05-20 (first published: 2015-05-06)
5,890 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