Presentations: Slides and Demos
Over the past couple of weeks I have given several presentations. At each presentation I have promised to post the...
2011-02-09
660 reads
SQLDownSouth
Speaking at the Houston SQL Server Users Group
Since I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users...
2011-02-07
592 reads
SSIS: Custom Folder in your Package Store
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I...
2011-02-07
1,471 reads
Second Book Available for Pre-Order
Over the past six months I have writing chapters for my next book. The book is titled SharePoint 2010 Business...
2011-02-07
766 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
447 reads
SQL Lunch - Introduction to Change Data Capture
Join me tomorrow for a little CDC.
#47-Introduction to Change Data Capture
Speaker: Patrick LeBlanc
Add To Outlook: Add To Calendar
Meeting URL:https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend
Date and...
2011-01-31
1,964 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
470 reads
SQLLunch and SQL University have Combined Forces - SSIS Tips & Tricks (Advanced SSIS)
The SQL Lunch and SQL University have combined forces. Come and watch, laugh, and learn.
#48-SSIS Tips&Tricks (Advanced SSIS)
Speaker: Josef Richberg
Add To...
2011-01-27
731 reads
SQL Lunch - SQL Azure (Cloud Database Coolness) With MVP Scott Klien
#46-SQL Azure – Cloud Database Coolness
Don't miss this lunch.
Speaker: Scott Klein
Add To Outlook: Add To CalendarMeeting URL: https://www.livemeeting.com/cc/usergroups/join?id=3BGZJG&role=attend
Date and Time:1/26/2011 11:30:00 AM...
2011-01-25
718 reads
SQL Lunch - Build Your First PerformancePoint Dashboard with MVP Adam Jorgensen
SQL Lunch - Building a Performance Point Dashboard
Don't forget to attend the SQLLunch tomorrow.
#35-Building your first PerformancePoint Dashboard in SharePoint 2010
Speaker:...
2011-01-18
1,222 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