Consolidation Matters
Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.
2014-04-21
140 reads
Editorial
Advice for Newcomers
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.
2017-12-12 (first published: 2014-04-18)
699 reads
One Database to Rule Them All
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
2014-04-17
306 reads
2014-04-16
742 reads
Doing What It Takes To Get The Job Done
It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts.
2014-04-15
213 reads
2014-04-14
160 reads
How Long Before You Upgrade?
This Friday Steve Jones wants to know about the lifetime of your instances. Do you have some idea on how long you'll run a particular version of a platform?
2017-11-10 (first published: 2014-04-11)
347 reads
If or When?
Are data breaches a question of if they will happen to you or when will they happen to you?
2014-04-10
172 reads
Problems with Big Data
Today Steve Jones notes that Big Data isn't a panacea. It's not going to just solve all problems.
2014-04-09
226 reads
Lobbying for Change
The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change.
2014-04-08
130 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