SQL Saturday Returns to Rochester!
The Rochester, NY chapter of PASS is holding our 6th annual SQL Saturday on April 29th, 2017! As always, RIT is hosting our event on campus.
SQL Saturday is a free day of training centered...
2016-12-23
3 reads
alevyinroc
- Website: https://flxsql.com
Don't Count on Me
This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...
2016-11-26
3 reads
T-SQL Tuesday #83: Why Leave Well Enough Alone?
It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?
In the 15 years I have been using databases professionally, we’re still...
2016-10-11
4 reads
Name Your Defaults So SQL Server Doesn't
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...
2016-01-19
8 reads
SQL New Blogger Challenge November 2015 Edition - Week 3 Digest
This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...
2015-11-19
7 reads
Selectively Locking Down Data - Gracefully
I have a situation where I need to retrieve the data in an encrypted column from, but don’t want to give all my users access to the symmetric key...
2015-11-18
5 reads
SQL New Blogger Challenge November 2015 Edition - Week 2 Digest
This week’s #sqlnewblogger posts!
Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time - An Introduction to Temporal Tables in SQL...
2015-11-12
4 reads
Don't Trust the Wizard
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...
2015-11-11
6 reads
SQL New Blogger Challenge, November Edition, Week 1 Digest
Ed Leighton-Dick has renewed his New Blogger Challenge this month. Here are all (I think) the posts for this week after Ed posted his announcement. If I’ve missed any, please let...
2015-11-05
1 reads
Why Ask Why?
Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this:
Please do this thing Why? Reasonable answer Why? Restatement...
2015-11-04
6 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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