Troubleshooting Database Mirroring Error 1418 Updated
Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...
2012-06-28
3,830 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn't Apply to Dropped Databases or Does...
2012-06-26 (first published: 2012-06-22)
4,284 reads
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month...
2012-06-12
1,902 reads
Session Files from SQL Saturday #107 Houston
Session Files from SQL Saturday #107 Houston
Houston Skyline
SQL Saturday Houston was a great event hosted by the Houston Area SQL...
2012-05-15
1,245 reads
SQL Rally 2012 Recap and Session Files
SQL Rally 2012 Recap and Session Files
Dallas Convention Center
SQL Rally 2012 was hosted by the North Texas SQL Server User...
2012-05-15
1,036 reads
SQL Saturday #107 in Houston, TX
SQL Saturday #107 in Houston, TX
Houston Skyline
SQL Saturday #107 in Houston, TX is almost here. I will be leaving for...
2012-04-09
1,610 reads
Reflections on Leaving Microsoft
Reflections on Leaving Microsoft
Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)
Several members of my SQLFamily have made adjustments to their career...
2012-03-31
2,300 reads
Whitepaper: Demystify Tempdb Performance & Management
Whitepaper: Demystify Tempdb Performance & Management
Demystify Tempdb Performance & Management
There are many misconceptions and myths about tempdb and purported best practices are...
2012-03-21
1,546 reads
Why We Follow Best Practices
Why We Follow Best Practices
Best Practices
There are many reasons why we follow best practices. My own reasons have changed over...
2012-03-05 (first published: 2012-02-26)
3,579 reads
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
Goodbye Microsoft, Hello World
The cowboy’s job is done here, and it’s time for him to move on...
2012-03-03
2,017 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