Jack Corbett

SQL Server DBA\developer & former data platform MVP who also loves sports

[Jack Corbett @unclebiguns]

A problem was encountered granting access to MSDB database for login '(null)'. Make sure this login is provisioned with SQLServer and rerun sqlagent_msdb_upgrade.sql "

[Jack Corbett @unclebiguns]

#sqlhelp Has anyone seen the security update released on 2023-02-14 fail because of the ##MS_SSISServerCleanupJobLogin## login? Seeing this in the install log:
"Granting login access'##MS_SSISServerCleanupJobLogin##' to msdb database...

[Jack Corbett @unclebiguns]

@NESN for $30/month @nesn360official needs these features: 1. Pause, rewind, fast forward. 2. All @RedSox and @NHLBruins games should be available on demand 48hrs after they air. I can't justify paying that mutch just to be able to watch games live when radio is free.

[Jack Corbett @unclebiguns]

#pats have sucked but the officials have sucked even more.

[Jack Corbett @unclebiguns]

Refs in #pats game aren't doing a very good job. Worst sequence I've seen this season. Pick up late hit o. #bills and then call unsportsmanlike on #pats.

[Jack Corbett @unclebiguns]

@scottzolak @BobSocci dipping fries in mayo is great

[Jack Corbett @unclebiguns]

@gbargsley 2/2
DATABASE_OBJECT_PERMISSION_CHANGE_GROUP
SERVER_OBJECT_PERMISSION_CHANGE_GROUP

Details about what the groups capture here, https://t.co/LVTnXFV3kX

[Jack Corbett @unclebiguns]

@gbargsley You can use SQL Audit. Actions I'd look at capturing in an Audit for this:
DATABASE_ROLE_MEMBER_CHANGE_GROUP
SERVER_ROLE_MEMBER_CHANGE_GROUP
SERVER_PRINCIPAL_CHANGE_GROUP
SERVER_PERMISSION_CHANGE_GROUP
DATABASE_PERMISSION_CHANGE_GROUP
DATABASE_PRINCIPAL_CHANGE_GROUP
1/2

[Jack Corbett @unclebiguns]

@AndyLeonard That was years ago. I can only spell SSIS now.

[Jack Corbett @unclebiguns]

#sqlhelp Anyone see an issue when upgrading SQL 2017 to CU23? Seeing an odd issue where jobs have stopped updating sysjobhistory since updating to CU23.

[Jack Corbett @unclebiguns]

@SQL_SKIPPY Services need to be restarted for an edition upgrade to take effect, https://t.co/Pyy57qstWh

According to the docs you can't go from EE to DEV. just from DEV to EE, https://t.co/OY7gPAb9RU

[Jack Corbett @unclebiguns]

@DBHawkSQLTool Please keep the #SQLHelp hashtag for community-driven Q&A rather than advertising, promotion, marketing, or generic advices. Thank you.

[Jack Corbett @unclebiguns]

#sqlhelp Any issues with Log-shipping and FileTable to be aware of?

[Jack Corbett @unclebiguns]

@SQLBeat @Tim_Mitchell @SQLSaturday @Jorriss @CBellDBA @SQLDBA @SQLBalls @mikehillwig @KarlaKay22 That was back when I didn't even think about work when I was at Summit.

[Jack Corbett @unclebiguns]

@gbargsley Tried Connect-DBAInstance -SQLInstance dbserver. https://t.co/NT526MaHkk -Database dbname -AuthenticationType 'AD Universal with MFA Support' and getting an error this error:
"When using Tenant, SqlCredential must be specified. " dbatools version 1.0.145

[Jack Corbett @unclebiguns]

#sqlhelp #dbatools Anyone used dbatools against Azure SQL DB with AAD login and MFA? Not enough PoSH and Azure experience to figure it out or search for the right thng.

[Jack Corbett @unclebiguns]

@bflippin So why not use the Catalog in 2012 or 2014? I've been using it since then. I don't notice a big difference in the catalog between versions. The only upgrade I liked was being able to deploy a single package from a project instead of the whole project

[Jack Corbett @unclebiguns]

@SQLBeat @Tim_Mitchell @SQLSaturday @Jorriss @CBellDBA @SQLDBA @SQLBalls @mikehillwig @KarlaKay22 Yeah that is great. I also just noticed I don't have any facial hair in that photo. Now I feel really old because it's been like 10yrs since I was clean shaven and my beard is getting gray.

[Jack Corbett @unclebiguns]

@Tim_Mitchell @mike_walsh To be clear I still have hair. It is Mike that doesn't

[Jack Corbett @unclebiguns]

@Tim_Mitchell @SQLSaturday @Jorriss @CBellDBA @SQLDBA @SQLBalls @mikehillwig @KarlaKay22 I think I was one of the odd balls who really liked that orange shirt.