Belt and braces
A moment ago, I was deep in some coding. What it was is not entirely relevant, With a page-full of...
2011-06-30
2,589 reads
Blog Posts
Google Correlate
My friend Rob Hatton pointed me to Google Correlate, a new service that lets you explore data trends in a...
2011-06-30
1,793 reads
July 2011 Version of SQL Server 2008 Diagnostic Queries
Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information...
2011-06-30
1,636 reads
Minnesota SQL Server Study Group (July)
Study Group
For the past few months, I’ve been openly working towards the SQL Server MCM. I failed a couple times...
2011-06-30
1,797 reads
Performance Benefits of Adding RAM to a Laptop
I have a pretty nice Dell Latitude E6420 that I am using as a loaner laptop while I wait for...
2011-06-30
1,829 reads
Protected: Google Correlate
This post is password protected. To view it please enter your password below:
Password:
2011-06-30
1,480 reads
SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chathri (twitter), I came across a need to call a stored procedure drom within a Data Flow Task. I...
2011-06-30
12 reads
SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chathri (
twitter), I came across a need to call a stored procedure drom within a
Data Flow Task. I have...
2011-06-30
45 reads
SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chandri (twitter), I came across a need to call a...
2011-06-30
8,788 reads
The Austin Fall Classic, SQLSaturday is Coming To Austin, TX
Come Get Your Learn On!
You heard right, on October 1st 2011 you need to be in Austin, TX. We have...
2011-06-30
1,458 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
BCA KCP Buaran Raya Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kantor resmi BCA KCU SCBD Telp: 0817-82-5533
WhatsApp: 0817825533, Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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