SQL Lunch – Pick your favorite Logo
We have been working on the logo for a month now, but instead of making the final decision I have...
2009-09-23
774 reads
SQLDownSouth
TSQLScripts.com – Script of the Week
After about 3 weeks of digging through .css files and html code I finally found the problem with the site. ...
2009-09-21
509 reads
Upcoming SQL Lunch (Live Meeting) – Historical DMV Information
The next SQL Lunch is scheduled for Monday, September 28. See below for details
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas...
2009-09-21
469 reads
SQL Server 2008 R2 August CTP – Utility Control Point (UTP)
I finally carved out some time in my day to try and get the August CTP of SQL Server 2008...
2009-09-18
1,360 reads
Article of the Week – Kevin Kline “Social Media Scene”
This weeks article is written by Kevin Kline, which is titled “Getting Up-to-Speed on the SQL Server Social Medial Scene”. ...
2009-09-16
934 reads
Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
2009-09-14
4,377 reads
Today’s SQL Lunch - Oracle-CDC for SQL Server Integration Services
Join us today for a SQL Lunch
Date: 9/14/2009
Time: 11:30 AM
Reserve your seat:https://www1.gotomeeting.com/join/509742840
Presenter: Jeff Cole. Jeff has been designing and building...
2009-09-14
713 reads
.Net SQLConnectionStringBuilder ApplicationName Property
We have several “Home Grown” applications at my current place of employment. This provides our development staff with a great...
2009-09-11
1,948 reads
SQL Lunch - Oracle-CDC for SQL Server Integration Services
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-09-10
702 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,010 reads
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Ampenan WhatsApp 08388331786
Call 08388331786.Jl. Saleh Sungkar No.37, Bintaro, Kec. Ampenan, Kota Mataram, Nusa Tenggara Bar. 83114
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