Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.
In this tip we look at the process of installing Reporting Services on a server that is already running Database Services.
Learn about SQL Server memory needs and settings including RAM amounts, how to enable AWE, maximum server memory and the differences of 32- and 64-bit platforms.
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
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 085169998765 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
Jl. HZ. Mustofa No.297, Kahuripan, Kec. Tawang, Kab. Tasikmalaya, Jawa Barat 46125
BCA KCU WISMA MILLENIA Tlpn Cs/WA:0821•3111•185 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5,...
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