In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
Integration Services is a great system for performing ETL operations between databases. In this video we show how you can use Data Viewers to determine if you are correctly transforming data.
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
Steve Jones talks about starting your own business and some of the challenges and advantages.
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...
Jl. KH.Moh.Mansyur No.15 F, Duri Pulo, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Telp/wa 085169998765 No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang, Jawa...
Tower, Apartemen Cosmo Terrace, Gd Thamrin City Lt Dasar 1, Jl. M.H. Thamrin Boulevard...
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