PASS Summit 2013 - Highlight Q&A - Where Will You Be?
PASS SQL Summit time, 2013is in full blown progress. Fantastic keynotes and presentations taking place all day long! For those...
2013-10-16
1,440 reads
Robert Pearl
PASS SQL SUMMIT 2013 - Day 1 - Highlights, Questions & Answers
Today, October 15, 2013: PASS SUMMIT DAY1
It’s October, and it’s PASS SQL Summit time, 2013! PASS Summit is the world's largest,...
2013-10-15
1,240 reads
PASS SQL Summit 2013 - Highlights Q&A - First Timer's Advice from the Experts
So, is this your first time attending PASS Summit? Confused, shy, overwhelmed, and don’t know what to do first? Or...
2013-10-15
1,036 reads
TSQL Tuesday #47 - SWAG - Where Does He Get Those Wonderful Toys?
Where does he get all those wonderful toys? In the line made famous by Jack Nicholson’s Joker in the original...
2013-10-08
1,524 reads
It's Just Another Manic SUNDAY - OT
Warning, this is just a non-technical anecdotal blog of a silly time-warp incident that happened to me yesterday. Thought it...
2013-09-23
874 reads
Geometry in the Cloud - where geospatial data meets the cloud.
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,546 reads
NJ SQL UG presents Hilary Cotter - Next Tues. 9/17
Next Meeting: Tue, Sep 17 2013
Take note, the New Jersey SQL Server User Group, led by John Dempsey, will be...
2013-09-11
881 reads
SQLSaturday #235 NYC Super Countdown! - Almost Here!
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
859 reads
Page Split Mini-Series - Part II - Page Latch Contention
Last time, in Part
I of my page-split mini-series, we began speaking about page
splits, defining what they are, how they occur,...
2013-07-26
13,614 reads
Tonight: NYC UG Presents: Replication vs. Always-On with Meir Dudai
TODAY, JULY 25: the NYC SQL Server User Group is honored to have a visiting SQL Server MVP all the...
2013-07-25
1,228 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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