Making a Change Log Easier With PowerShell
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,152 reads
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,152 reads
T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...
2014-12-09
793 reads
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...
2014-11-28 (first published: 2014-11-24)
6,791 reads
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,148 reads
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,411 reads
I have a lab on my laptop running various servers so that I can problem solve and learn and recently...
2014-11-05
548 reads
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...
2014-11-04
4,903 reads
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
704 reads
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...
2014-09-09
731 reads
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
525 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...
Telp/WA.0821°3111°179 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara,...
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