The SQL Scrabble Puzzle
An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.
2014-12-05
8,421 reads
Contest
IT staff would rather pocket $100k than blast off into space
Red Gate survey asks would you take cash or trip of a lifetime?
2011-11-18
1,508 reads
The DBA in Space Deadline is Extended
The deadline for entering the DBA in Space competition has been extended until Nov 22, 2011, noon GMT. Enter today and get the chance to fly into space or take the vacation of your dreams.
2011-11-17
1,794 reads
The Final Question
Check out the final question for the DBA in Space contest. It's a math tease that needs research. If you can solve it, and you work with databases, enter the contest at dbainspace.com
2011-11-16
2,212 reads
Win a Trip into Space
The DBA in Space competition ends this Friday, November 18. You can still enter, and answer all the questions this week. If you work with databases in any way, you're eligible.
2011-11-15
1,731 reads
The SQL Server BI Quiz
From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.
2011-06-02
2,796 reads
T-SQL Quiz 2011
The 2011 edition of MVP Jacob Sebastian's T-SQL Quiz is underway. You can take part in the quiz each day, submitting your answers for the chance to show off your knowledge and perhaps win some prizes.
2011-03-04
4,394 reads
Put Your Thinking Caps On
Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.
2010-12-10 (first published: 2010-12-08)
1,541 reads
The SQL Server Quiz
There's a SQL Server quiz taking place during the next 31 days, challenging you to answer questions from a number of SQL Server experts and MVPs.
2010-10-01
2,954 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers