2014-05-28
603 reads
Editorial
Patching Problems
After some issues with a recent Windows patch, Steve Jones is concerned about the future of software updates.
2014-05-27
366 reads
2014-05-26
167 reads
No reason to abandon SQL
The early signs are that we can now run a SQL-based relational database with distributed execution plans over commodity hardware, leaving just the task of splicing together of the result to the engine itself, then why can’t Microsoft or Oracle do it?
2014-05-26
194 reads
Should We Move to Azure?
This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?
2017-11-08 (first published: 2014-05-23)
243 reads
One Final Patch
Vote for final service packs for SQL Server 2008 and R2. Let Microsoft know that we want regular support across the entire lifecycle.
2014-05-22
136 reads
Balancing Learning
How do you determine when you use a new technique or stick with a tried and true method? Steve Jones notes that we try to teach you new things at SQLServerCentral, but do you use them?
2014-05-21
153 reads
The Development Backup
Backing up your development environment can be important. After all, aren't your developers producing products that you use?
2014-05-20
151 reads
Patching Problems
Problems with SQL Server after applying the Windows 8.1 update have Steve Jones concerned about software updates.
2014-05-19
103 reads
What are you worth?
When negotiating your salary, it helps to know what the ranges are for your experience and area. Steve Jones gives a little advice today.
2017-11-07 (first published: 2014-05-19)
426 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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