Virtual database storage for SQL Server: Friend or foe?
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.
Infinite Seizure - Database Weekly (2008/8/4)
This week's Database Weekly editorial examines the US policy of potentially seizing laptops for an infinite period when you enter the country.
Moving TempDB
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.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Alerts for when Login Failures Strike
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?
SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause
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.
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Kartini Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, Daerah Khusus Ibukota...
Alamat kontak resmi BCA KCP Sultan Agung Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Agung No.115, Gajahmungkur, Kec. Gajahmungkur, Kota Semarang, Jawa Tengah 50232
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers