Jack Corbett

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 "

#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...

@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.

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

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.

@scottzolak @BobSocci dipping fries in mayo is great

@gbargsley 2/2 DATABASE_OBJECT_PERMISSION_CHANGE_GROUP SERVER_OBJECT_PERMISSION_CHANGE_GROUP Details about what the groups capture here, docs.microsoft.com/en-us/sql/rela…

Do you track/audit permissions changes? If so, what is your tool of choice? Want to see if someone or something took away or added permissions to a AD or SQL Login/User. #sqlhelp

@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

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

Started the day refactoring the #SSIS Framework Manager (dilmsuite.com/ssis-framework…) framework application script generation routines. I like the updated look. The parameters at the top are clean. Shoutout to @unclebiguns for that suggestion years ago. :{>

#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.

@SQL_SKIPPY Services need to be restarted for an edition upgrade to take effect, docs.microsoft.com/en-us/sql/data… According to the docs you can't go from EE to DEV. just from DEV to EE, docs.microsoft.com/en-us/sql/data…

#sqlhelp is the sql server offline during the process of changing the edition from developer to enterprise?

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

Drag and drop feature in SQL query builder online allows to build queries, SQL expression, apply aggregate functions and many others. Visit at datasparc.com/sql-query-buil… #Database #sqlhelp #sqlserver #Redshift

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

@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.

@gbargsley Tried Connect-DBAInstance -SQLInstance dbserver. database.windows.net -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

@unclebiguns If you use dbatools and do a connect-dbainstance using type AAD MFA and store the results in a variable you can then use those credentials with other commands. I can send example tomorrow.

#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.

@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

@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.

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

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