Make a Backup First
The hack on a Gizmodo writer using Amazon and Apple customer service security holes was shocking. Steve Jones notes that while security is important, backups are even more important.
2012-08-22
174 reads
Editorial
Big Data Jobs
Big Data is in the news and there is a lot of job growth. Steve Jones lists a few industries and areas where you might find one.
2012-08-21
309 reads
Time Off
Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.
2016-09-01 (first published: 2012-08-20)
258 reads
Brad McGehee Moves On
The SQLServerCentral and Database Weekly editors recognize the contribution of Brad McGehee to the websites and newsletters, and to DBA education in general, over the past 5 years.
2012-08-20
162 reads
The Influence of the Cloud
This Friday Steve Jones is talking clouds. In the next year, will the cloud influence your job or will it be a fad for you?
2012-08-17
142 reads
Marketing Data is Exploding
The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.
2012-08-16
152 reads
Learning C
As we use computers more and more, and more people must develop algorithms or simple programs, Steve Jones says everyone should learn C. Perhaps they should learn SQL as well.
2012-08-15
338 reads
Milk
Genome research into producing the best cows for milk has Steve Jones thinking about the implications for other industries. There could be new opportunities for data professionals.
2012-08-14
127 reads
No Limits
Google recently promised no limits to their computing engine online. Is that going to change how we use cloud computing? Read Steve Jones' thoughts and give us your opinion.
2012-08-13
103 reads
Avoiding Stored Procedures
This week Steve Jones argues against stored procedures. Is it a good argument or do want to stick with your stored procedures.
2016-08-30 (first published: 2012-08-13)
1,079 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