Goals for 2010
Posting goals online is great as long as you meet your goals, can be something less than great if you...
2010-01-12
800 reads
Blogs
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
2010-01-12
929 reads
How to obtain RecordCount (or Number of cases) from a DMX query
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
2010-01-11
1,153 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-08
2,756 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-08
4,918 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2010-01-04
2,795 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2010-01-04
1,635 reads
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-31
15,057 reads
Running a Small User Group - Getting Quality Speakers
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-30
1,349 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-29
3,772 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