SQLSaturday Houston 2017 - I'll be there, will you?
Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!
Will be happy to see the...
2017-06-12
353 reads
Will Assaf
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
270 reads
SQLSaturday Pensacola 2017
It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two...
2017-05-30
539 reads
Why SQLSaturday? A SQLSat Career Case Study
We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story...
2017-04-10
472 reads
Return to Birmingham for SQLSaturday Bham 2017!
It's been 2.5 years since I last spoke atSQLSaturday Birmingham, and I'm eager to make a return, this time with...
2017-03-16
283 reads
Actual Chats: RIGHT OUTER joins in the wild
Colleague:
I think I just encountered my first Right join
*shocked* Me:
huh. weird.
a rare Right Join has appeared!Colleague:
catch it!Me:
You use ON. It's...
2016-12-22 (first published: 2016-12-06)
2,886 reads
SQL SSRS Express Edition Cannot Connect to Azure SQL Databases
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,150 reads
"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016
I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by...
2016-09-17
360 reads
"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
378 reads
SQL UG Leaders: Reach Out to Your .NET Friends
In Baton Rouge we make no secret that our user groups and our578-personSQLSaturday combines the volunteers and attendees of our...
2016-08-09
592 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