70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
628 reads
- Interests: cooking, F1 grand prix, internet, mobile apps
Amazon Partners With Cloud vLab To Teach Developers How To Use AWS
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,374 reads
How secure is your IT career? Really?
I was reading some articles from my favorite influencers in LinkedIn and I came across this one. I was enlightened...
2013-07-30
1,227 reads
Using MSX and TSX to scale out your maintenance plans
For our front office alone, I manage about 15-20 SQL database servers. Add to that other database servers that I...
2013-07-30
1,341 reads
Free Ebooks! Free Ebooks!
There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot...
2013-07-29
700 reads
SQL Server Management Studio Rainbow Edition
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
694 reads
What I’m sayin’ is…everything is fine.
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
634 reads
Go ahead. Laugh.
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
534 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,829 reads
70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,847 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers