Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?
Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.
This week's Database Weekly editorial examines the US policy of potentially seizing laptops for an infinite period when you enter the country.
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
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...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Plaza Kenari Mas, Lt 4, Blok K37/38, Jl. Kramat Raya No.101, RT.18/RW.1, Paseban, Senen,...
VR4W+7F8, JIEXPO, RW.10, Pademangan Tim., Kec. Pademangan, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
Mangga Dua Square, Komp. Ruko, Jl. Gn. Sahari Blok G No. 8-9, Daerah Khusus...
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