2014-11-27
2,264 reads
2014-11-27
2,264 reads
This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2014-11-25 (first published: 2009-11-12)
238 reads
I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS)....
2014-11-25 (first published: 2014-11-19)
8,344 reads
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
2014-11-24
146 reads
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
2014-11-21
717 reads
Steve Jones completed a task this year that he's rarely completed in the past.
2014-11-20
115 reads
Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I...
2014-11-20
925 reads
I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more...
2014-11-20
802 reads
My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt,...
2014-11-19
869 reads
There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.
2014-11-19
264 reads
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...
Jl. Pegangsaan Timur No.121, RT.1/RW.1, Pegangsaan, Kec. Menteng, Jakarta, Daerah Khusus Ibukota Jakarta 10320
By Buka blokir bws mobile Bank Woori Saudara
Berikut cara mengatasi buka blokir bank woori saudara (bws) akibat salah pin 3 kali....
Jl. Letjen Suprapto No.62, Cemp. Putih Bar., Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah...
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