Amy @MSSQLServerDBA

MsSQLServerDBA.com Atlanta, GA Joined January 2018

Tweets

126
Followers

107
Following

255
Likes

268

Amy @MSSQLServerDBA

2 years ago

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

1 0 0 23 0

View Details

Amy @MSSQLServerDBA

2 years ago

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

1 0 0 86 0

View Details

Amy @MSSQLServerDBA

2 years ago

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

0 0 0 29 0

View Details

Amy @MSSQLServerDBA

2 years ago

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

0 0 0 9 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 0 46 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 0 51 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 1 140 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

0 0 0 11 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

0 0 0 14 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 0 27 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 1 34 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 0 15 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 0 32 0

View Details

Amy @MSSQLServerDBA

3 years ago

@erikdarlingdata @JonathanGennick Mine uses the toilet.

0 0 2 51 0

View Details

Amy @MSSQLServerDBA

3 years ago

@furt1v3ly @erikdarlingdata Glad you found it!

0 0 1 20 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

0 0 1 65 0

View Details

Amy @MSSQLServerDBA

3 years ago

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

1 0 2 72 0

View Details

Amy @MSSQLServerDBA

4 years ago

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

0 0 1 28 0

View Details

Amy @MSSQLServerDBA

4 years ago

@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

0 0 1 16 0

View Details

Amy @MSSQLServerDBA

4 years ago

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