@MSSQLServerDBA
 Atlanta, GA
MsSQLServerDBA.com
Joined January 2018
  • Tweets126
  • Following255
  • Followers107
7Media
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
87
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
1
141
I was able to get it to work only in ADS by setting Encrypt to Optional.
1
51
Actually it works in ADS when set to True as well but not in SSMS.
1
46
Well, it looks like it's happening. October 1st Data Saturday Atlanta CfS just went live. Event page will go live soon. Registration will open Aug 1st. sessionize.com/data-saturday… #DataSatATL #AzureDataCommunity

Data Saturday Atlanta: Call for Speakers

sessionize.com
2
18
6
36
I’m testing backup to URL as block blob with 35 SQL 2019 databases on an Azure VM. Most restore but about 5 of them take a few tries and about 8 never restore. The error is 12175 msg 3203 msg 3183 msg 3013. Has anyone else experienced this? #sqlhelp
2
2
5
How do you or would you handle a SQL agent job that calls a stored procedure every five minutes to update data in a database that’s part of a distributed availability group? #sqlhelp
3
1
At Amazon HQ in Seattle for my first #sqlpass #sqlsummit
1
1
#cloudninja #legos
Load more