Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
55 reads
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
55 reads
After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...
2013-03-21
53 reads
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
197 reads
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
507 reads
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
423 reads
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
80 reads
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
53 reads
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
113 reads
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
43 reads
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
202 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Telp/wa 085169998803 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121
BCA KCP Radio Dalam Hub.0821•3111•185 Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec....
BCA KCP Pasar Kebayoran Lama Hub.0821•3111•185 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran...
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