New MySQL Entry Level Certification
Last week I received an email indicating that MySQL had made available an entry level certification, the Certified MySQL Associate....
2007-07-16
1,558 reads
Blog Posts
QOD Day
Quite a few complaints on the QOD section from last week, mostly justified. A couple I had to defend, which...
2007-07-16
1,586 reads
The meaning of Database Administrator
In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what...
2007-07-16
1,568 reads
SQL Server Reporting Services (SSRS) Templates and Styles
Ever wanted to change the default template and style for the Reporting Services Wizard? Just think how much time this...
2007-07-15
8,434 reads
Beta Testing
I'm not big on beta testing, or at least haven't been for a number of
years because I can't afford the...
2007-07-13
1,383 reads
Buy a $10 Raffle Ticket to Help Katie
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,389 reads
The Business of Software
It's interesting being at a software company, especially one that's
building on another platform. I've never done this before, having
worked for...
2007-07-12
1,409 reads
Working in solitude
If you've spent much time at all reading Steve Jones's blog posts and SSC editorials, you quickly glean that he...
2007-07-12
1,486 reads
Reminder: Midlands PASS Chapter Meeting Tomorrow Night
What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM
Speaker: SQL Server MVP...
2007-07-11
1,447 reads
Upgrade or Wait
Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...
2007-07-11
1,442 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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