Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the consolidation iceberg - and it might not actually save you as much as you think. Thomas LaRock takes us deeper.
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
Microsoft is very willing to lend its ear to new feature requests, but sometimes forgets to finish off the ones we've got.
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
A new feature is available on SQLServerCentral, and Steve Jones talks a little about how it fits in with your strategy here at the site. Visit ask.sqlservercentral.com and let us know what you think.
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...
Komplek Perkantoran Mitra Krekot, Jl. Samanhudi No.21 1, RT.1/RW.7, Ps. Baru, Kecamatan Sawah Besar,...
Jl. Pembangunan I No.25A, RT.11/RW.1, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
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