Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
645 reads
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
645 reads
In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup
Today I thought I would...
2017-04-05 (first published: 2017-03-22)
1,925 reads
If your server collation is different to your database collation then you may find that you get an error similar...
2017-04-03
658 reads
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...
2017-04-01
1,585 reads
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
978 reads
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,043 reads
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...
2017-03-27
349 reads
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,001 reads
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...
2017-03-17 (first published: 2017-03-12)
2,679 reads
One of the most visited posts on my blog is nearly two and half years old now – Add User to...
2017-03-16 (first published: 2017-03-06)
1,727 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...
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...
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