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.
2009-10-20
131 reads
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.
2009-10-19
599 reads
Feel like making a prediction this Friday? Steve Jones looks to the future with information workers and a knowledge economy. Answer this Friday poll and give us your guess about the future.
2009-10-16
136 reads
Is it hard for technology workers to ask for help? Or accept it? We seem to often be the type of people that want to solve problems and fix things on our own. Is that a problem? Steve Jones thinks that we should sometimes put aside our pride and get things done.
2009-10-15
108 reads
What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.
2009-10-14
111 reads
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
2009-10-13
118 reads
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
2009-10-12
688 reads
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
2009-10-09
963 reads
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
1,058 reads
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2009-10-07
491 reads
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
I’ve been learning more about the google knowledge panel and it seems like one...
I’m currently researching the best wireless credit card terminal for a growing business and...
Comments posted to this topic are about the item 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