SQL Server 2008 R2 SP1 Cumulative Update 2
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...
2011-08-16
1,512 reads
Blog Posts
SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,948 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
549 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,115 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put...
2011-08-16
9 reads
T-SQL Enhancements: OVER clause
With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of...
2011-08-16
1,452 reads
You Are Allowed to Care About Whatever You Want
I wanted to write this because its often overlooked. I care about things that may not interest you, things that...
2011-08-16
574 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,477 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,392 reads
ColoradoSQL in August
All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...
2011-08-15
581 reads
Blogs
Agentic Architect – Future IT Roles (comparison)
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
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...
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