T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,044 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Getting started with SQL Server on private cloud
I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service...
2012-06-06
1,534 reads
Review of “Start Here! Learn Microsoft Visual C# 2010?
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,072 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
891 reads
Your SQL Server database just failed, can you restore the backup?
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,503 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,368 reads
Who are the sysadmins in this sql server?
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,087 reads
10 must follow blogs that might not be in your list
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,760 reads
Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,504 reads
The evolving role of the database professional
The role of the database professional is quickly evolving to conform with the ever changing demands of the business world....
2012-04-04
1,222 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
BCA KCU PASAR BARU TLP/WA 083800119009
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCP MT Haryono WhatsApp 08388331786
Telepon 08388331786.Jl. MT. Haryono No.657, Wonodri, Kec. Semarang Sel., Kota Semarang, Jawa Tengah 50242
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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