Confessions of a DBA - Part 1
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,495 reads
Roy Ernest
Should a DBA be involved in the physical set up of a Database Server? Part 3
This series of blog is to give a general idea what you could look at when setting up a new...
2011-04-07
1,489 reads
Should a DBA be involved in the physical set up of a Database server? Part 2
Part 1 of this blog talked about the bad experience we had with a badly configured SQL Server. The second...
2011-04-06
1,609 reads
Should a DBA be involved in the physical set up of a Database server? Part1
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,636 reads
The one bright spot in an otherwise bad day.
April 1st is a fun day for almost everyone. Playing tricks or just enjoying the tricks played by others. For...
2011-04-04
1,253 reads
Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,744 reads
How to make Net Meeting a success
This article is a basic guide line to chapter leaders who are planning to have Net meetings as part of the User Group meetings.
2011-01-20
1,079 reads
MVP Program
There is one thing that have been bothering me for quite some time. I thought I would blog about it....
2010-12-27
1,280 reads
SQL Pass Voting forum
So far I have seen lots of blogs about SQLPASS regarding the Slate for this years BoD. I do not...
2010-08-25
709 reads
Congrats to all MVPs (New and Renewed)
Today twitter is buzzing with news about MVPs being confirmed. Some new and some old getting renewed. I am sure...
2010-07-01
568 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
Question of the Day
Creating a JSON Document III
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