Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,384 reads
PracticalSQLDba
Memory configuration in SQL server and break up of memory utilized by SQL server
In this post I would like to explain memory configuration option and memory utilization pattern in SQL server.I have seen...
2012-03-11
3,733 reads
How to log off remote desktop users from a remote machine ?
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,214 reads
Resource Governor Configuration
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,620 reads
How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,425 reads
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,158 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