Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
820 reads
Blog Posts
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
724 reads
More Laptop Issues
My laptop died on Dec 1, 2009. I was on vacation, but on Dec 2 I called Toshiba (I have...
2010-01-11
1,070 reads
New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
550 reads
PASS Update #22 (Speaker Bureau – Call for Comments)
One of my big projects this year is to build a speaker bureau, so in this post I’m going to...
2010-01-11
754 reads
Permon Counters Missing Windows 64 Bit SQL Server 32 Bit
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
746 reads
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-11
1,251 reads
GodMode - in Windows 7
It's very interesting if you create new folder with name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Try it and you will find a lot of stuff there...
2010-01-10
514 reads
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon (a link to video of Parliament online, please forward to about half way through),...
2010-01-10
2,212 reads
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
2010-01-10
8,142 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