Put Your Thinking Caps On
Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.
2010-12-10 (first published: 2010-12-08)
1,541 reads
Press Release
SQLServerCentral Webinar Series #4: How to Monitor your SQL Servers
You can monitor your servers with the new SQL Monitor software from Red Gate Software. MVP Brad McGehee showed how the SQLServerCentral servers are being monitored publicly. The slide decks and Q&A transcript at available.
2010-12-02 (first published: 2010-11-09)
4,766 reads
SQLServerCentral Webinar Series #5: Setup Your Source Control With Help from PowerShell
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
2010-11-30 (first published: 2010-11-10)
1,243 reads
SQL Saturday #61 - DC
A day of free training near Washington DC in December. Come and learn how more about SQL Server.
2010-11-29 (first published: 2010-11-23)
1,920 reads
SSIS Training Live and In-Person
MVP and author of our Stairway Series on SSIS, Andy Leonard, is holding an SSIS class this December in northern Virginia. If you are interested in top notch SSIS training, read on.
2010-11-19 (first published: 2010-11-02)
5,610 reads
SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
2010-11-18
516 reads
SQL Saturday #59 - New York City
A free day of training in New York City just before Thanksgiving. Come see Steve Jones and Grant Fritchey, along with a number of other great speakers.
2010-11-16 (first published: 2010-11-04)
2,471 reads
SQL Server R2 in Luxembourg
On Nov 16, 2008, the Luxembourg SQL Server User Group will hold a SQL Server 2008 R2 event in conjunction with Microsoft.
2010-11-12
367 reads
SQL Saturday #61 - DC
A free day of training in Reston, VA, just outside Washington DC. Come join Andy Leonard, Allen White and others for some SQL Server learning.
2010-11-11
1,284 reads
Live Blogging from the PASS Summit
Tim Mitchell is the SQLServerCentral correspondent at the 2010 PASS Summit.
2010-11-10
355 reads
Blogs
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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Bumiayu Telp/wa 085169998765
Telp/wa 085169998765 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273
BCA KCU KEDOYA PERMAI HUB/WA 08216366654
Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5, Kb. Jeruk, Kec. Kb....
Kantor BCA KCP Bumiayu Telp/wa 085169998803
Telp/wa 085169998803 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273
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