Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,079 reads
Basit's SQL Server Tips
Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
505 reads
Monitor availability groups and availability replicas status information using T-SQL
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,804 reads
SQL Server monitoring and optimization
To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL...
2013-12-18
953 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
960 reads
How to work around Azure database migration limitations
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
612 reads
Understanding SQL Server Query Optimization – Part 3
A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...
2013-12-14
502 reads
Understanding SQL Server Query Optimization – Part 2
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,262 reads
SQL Server Encryption Options
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
679 reads
Bulk Transfers: Some guidelines
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
543 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 RAWAMANGUN Hub.0851•8812•0691
BCA KCU RAWAMANGUN Hub.0851•8812•0691 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
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