Amy

@SQLGrease I know it’s single threaded, that’s why I mentioned the edition, overall CPU stays low. I’ve enabled page compression many times and I’ve always seen CPU drop, I’ve never seen the negligible rise reported in the documentation. Have you?

@MSSQLServerDBA In se dbcc checkdb runs single threaded (not sure if you can change that). When I’ve enabled page compression the trade off against less physical io is cpu usage. I’m guessing you are consuming a single cpu and bumping up against the limit of what that one cpu can do.

I just enabled page compression for all of the databases on a SQL 2022 SE server and DBCC CHECKDB has gone from 2 hours to 5 hours. I've never noticed this before. Has anyone else? Old slow spinning disks #sqlhelp

@SQLRunr I experienced something similar last year when developers were changing their initial passwords for SQL logins. They had to use Azure Data Studio instead.

SSMS 20.1, problem is when I have an Agent job which executes SSIS packages. If I bring up the step details, and click OK, it tells me the connection isn't trusted. There's no connection string in the execute package dialog, so how do I set them to trusted? #sqlhelp

@RochieWBZ @RedSox @wbz Very sad but the “kids” are adults.

This is so incredibly sad. Statement from @redsox on the passing of Stacy Wakefield RIP to a loving wife and mom. My heart aches for the kids. @wbz

Actually it works in ADS when set to True as well but not in SSMS.

I was able to get it to work only in ADS by setting Encrypt to Optional.

When creating a new SQL Login with MUST_CHANGE, the user can connect with SSMS if Trust server certificate is true but the Change Password popup doesn't seem to honor that because the users are getting an error. RDS SQL 2022 #sqlhelp @erinstellato

@SqlWorldWide @kewlsmoove A gMSA is different. It’s a computer account not a user account. I think your image is of permissions on the path. Either Everyone or Authenticated users must be given permissions on the share which looks like this image. Also gMSAs do not sync to Azure.

#sqlhelp Does gMSA work for sql backups.. can someone please send me a link/instructions on how to give the proper rights to the network shares or other components to make sure native backups to share work?

@stridergdm Did you ever figure this out? I’ve seen that happen when there wasn’t enough space on the disk for the snapshot. Paul Randal has an old post called CheckDB from every angle that helped me a lot. Also the first release or CU of SQL 2019 broke CheckDB so make sure you’re patched.

#sqlhelp 3/3 DBCC CheckDB Msg 7928, Level 16, State 1, Line 1 The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams....

@codegumbo I know this is late but next time just pay here. You don’t need that dumb account. irs.gov/payments

I don't understand why the Federal government makes it so damn difficult to pay estimated taxes. Third attempt to get my EFTPS account set up.

@MatthewCargile @leemarkum They can view it first like this: $result = Invoke-Dbaquery $result | Out-GridView If they like it then: $result | Export-Csv

@leemarkum Invoke-dbaquery | export-excel

Anyone have thoughts about whether AzureDataStudio is better at hamdling large result sets than SSMS? We have some large queries that crash unless SSMS runs them on the sql server. Looking for something other than an etl solution or reporting secondary. #sqlhelp

@MarlonRibunal 1 P30 will give you 5000 IOPs and 200 throughput so 8x5000=40000 and 8x200=1600.

@MarlonRibunal Use storage spaces to stripe. It’s a math problem. In Azure 8 P30 disks striped together will give you 8TB of space/40000 IOPs/1600 throughput for $983 per month and 1 P60 disk will give you 8TB of space/16,000 IOPs/500 throughput for $860 per month.

Is there any good documentation out there on the comparison between single disk vs striped disks for #sqlserver performance (IOPS, MBps, etc)? #sqlhelp

@erikdarlingdata @JonathanGennick Mine uses the toilet.

@JonathanGennick they shit in a box in the house.

i actively hate every cat.

@furt1v3ly @erikdarlingdata Glad you found it!

@erikdarlingdata @MSSQLServerDBA Doktor Google had already indexed it, thankfully. sqlbek.wordpress.com/2023/02/06/ssm…

i wish solarwinds would do the decent thing and sell sentryone assets to someone who is interested in developing them further.

@erikdarlingdata @furt1v3ly lol I wasn’t sure if y’all wanted it or not.

@MSSQLServerDBA @furt1v3ly Don’t link to the post or anything 🥵

@furt1v3ly @erikdarlingdata Andy Yun just blogged about a way to get it to integrate with SSMS 19.

@erikdarlingdata LITERALLY I just got on twitter to ask if there was any hope at all for a plan explorer that works w/ ssms 19. I has a sad.

@BuckWoodyMSFT @mwdarab @DesertDBA And here I was thinking that word was just a buckwoodyism.

@SqlWorldWide @psdbatools Yes - like this Get-DbaDbStoredProcedure -SqlInstance SQL1 -Database DB1 -Name SP1 | New-DbaDbTransfer -SqlInstance SQL1 -DestinationSqlInstance SQL2 -Database DB1 -DestinationDatabase DB1 | Invoke-DbaDbTransfer

@SqlWorldWide @psdbatools Use Start-DbaMigration and exclude the objects you don’t want to copy to the other server or use any of the copy commands under the migration category like Copy-DbaDbMail or Copy-DbaLinkedServer.