SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,761 reads
PracticalSQLDba
SQL Server: List Explicit Permission on Database for Login and Database Role
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,495 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,281 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,990 reads
SQL Server : List Login's Database and Server Level Role Permission
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,521 reads
SQL Server : Fixing the Orphaned Users
In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...
2012-08-02
1,438 reads
SQL Server:Finding the Orphaned Users
Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...
2012-08-02
1,714 reads
SQL Server : Implementation of Table Valued Parameter (TVP)
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,337 reads
SQL Server : Dedicated Administrator Connections
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,740 reads
Windows Cluster: Moving Quorum Disk to Another Node
In my earlier post I have explained about various quorum settings available in Microsoft windows 2008 cluster environment. While we plan to...
2012-07-23
15,391 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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...
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