Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Service Pack 3
Vote for Service Pack 3!!! For SQL Server 2005. As of now, Microsoft has no plans to release Service Pack 3 for SQL Server 2005. I sent them our poll results, but we need more votes. Let them know this is important by voting on Connect. Vote Now!!!! Update: There's a post that they hear […]
Employ Metadata to Enhance Search Filters
Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.
Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans
This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures
Not In v Not Equal
Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.
XML Workshop XV - Accessing FOR XML results with ADO.NET
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
Data Generator Source Adapter
The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
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