Hello GETDATE() My Old Friend...
So you’ve decided that your new web application needs to record some page load time metrics so you can keep tabs on performance. Terrific! You set up a couple page load/complete...
2015-06-16
6 reads
alevyinroc
- Website: https://flxsql.com
Getting Over It or: How I Learned to Stop Worrying and Love Speaking
Consider this the outtakes from my previous post about speaking at SQL Saturday.
It took a while for me to build up the courage to finally get up in the...
2015-06-02
6 reads
I Spoke at SQLSat (and I Liked It)
That is the first and last Katy Perry reference you will find on this blog or anywhere else in my life.
Last weekend I spoke at the 4th edition of my “home”...
2015-05-22
4 reads
Slides & demos from SQL Saturday Rochester
Slides & demos from my SQL Saturday Rochester presentation “Easing into Scripting with Windows PowerShell” have been posted on the SQL Saturday site.
Thank you to everyone who came out for...
2015-05-19
3 reads
Speaking at SQL Saturday Rochester this weekend!
I’ll be presenting my session Easing into Scripting with Windows PowerShell this Saturday, May 16th at SQL Saturday Rochester.
SQL Saturday is a free, all-day event for learning about SQL Server and...
2015-05-15
2 reads
SQL New Blogger Challenge Digest - Week 4
This week marks the end of Ed Leighton-Dick’s New Blogger Challenge. It’s terrific seeing everyone sticking with the challenge all month and I’m looking forward to catching up with all the...
2015-05-01
2 reads
Are You Backing Everything Up?
We hear the common refrain among DBAs all the time. Back up your data! Test your restores! If you can’t restore the backup, it’s worthless. And yes, absolutely, you...
2015-04-29
4 reads
SQL New Blogger Digest - Week 3
Here are the posts collected from week three of the SQL New Blogger Challenge. It’s been compiled the same way previous weeks’ posts were. Everyone’s doing a great job keeping up...
2015-04-24
6 reads
Padding Fields for Fixed-Position Data Formats
Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...
2015-04-22
7 reads
SQL New Blogger Digest - Week 2
I didn’t intend for last week’s digest to also be my post for week two of the challenge, but life got in the way and I wasn’t able to...
2015-04-15
5 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