PASS Update #60
I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...
2011-07-18
649 reads
Blog Posts
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
7 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present...
2011-07-18
1,142 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
6 reads
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
807 reads
Second Chances: PASS Community Choice Sessions
Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the...
2011-07-18
794 reads
SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,245 reads
SQL Server Backup – Inadvertent Striping
When I started working with SQL Server I got bit in the rear one day while I was testing backups....
2011-07-18
1,703 reads
SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,248 reads
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,981 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 KCU MUARA KARANG TLP/WA 08216366654
Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
Kantor BCA KCP Kas Karang Jati Telp/wa 085169998803
Telp/wa 085169998803 Komplek Ruko, Jl. Karang Jati Blok C 3 & 5, Karangjati, Kec....
BCA KCP Kramat Jaya Huby/WA 08218573837
Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...
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