SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
770 reads
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
770 reads
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,221 reads
Recently in the news an article circulated about a coordinated attack by a team of hackers known as Anonymous. Information...
2012-11-19
502 reads
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
917 reads
SP1 for the RTM of SQL Server 2012 has been announced during PASS Summit 2012. It can be downloaded here:...
2012-11-09
740 reads
Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...
2012-10-23
682 reads
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
409 reads
I was approached with a unique problem to solve; find out who has what permissions on my Database Servers. This...
2012-10-08
453 reads
It has been a long morning for me. It was supposed to be a standard run for our quarterly data...
2012-10-05
675 reads
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,173 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