Public Role and Security
Having flown a fair amount lately, I was thinking about the various levels of security within an airport. Part of...
2011-12-29 (first published: 2011-12-20)
3,536 reads
Jason Brimhall
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out...
2011-12-28
839 reads
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out of curiosity, I decided to take a look at...
2011-12-28
3 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down thrown the tree trying to find that one specific...
2011-12-21
12 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down...
2011-12-21
1,982 reads
Public Role and Security
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
16 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....
2011-12-17
4 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is...
2011-12-17
695 reads
T-SQL Tuesday #025 – Holiday Gifts
Tis the Season
It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And...
2011-12-15 (first published: 2011-12-13)
1,485 reads
T-SQL Tuesday #025 – Holiday Gifts
Tis the Season It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And whether you celebrate Christmas or Chanukkah or Kawanzaa...
2011-12-13
7 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