With a Geo-Replicated Azure SQL DB that is already replicated with ALLOW_CONNECTIONS = ALL, is there a way to alter the replica to ALLOW_CONNECTIONS = NO after it is already setup without a drop and recreate? #sqlhelp
If Azure managed disks are already encrypted at rest by default, would it be overkill to also enable TDE on our IaaS databases using those same managed disks? azure.microsoft.com/en-us/blog/azu… #sqlhelp
azure.microsoft.com
Announcing Storage Service Encryption for Azure Managed Disks | Microsoft Azure Blog
Today, we are excited to announce Azure Storage Service Encryption (SSE) with keys managed by Microsoft for Managed Disks.
#sqlhelp Anyone have any ideas on how to accomplish this? It must still need to hit the primary replica in some manner before being routed to readable secondary.
#sqlhelp Trying to create a login with ONLY access to a database on a readable secondary. I create login on both primary and secondary, deny connect on primary. Connect with readonly intent, and get login failed. verified RO routing is working without DENY connect on primary.
man... Major Azure south central data center outage at the moment... this is fun.
Anyone have any examples or blog posts on how they've setup monitoring & alerting for blocked processes in Azure SQL DB? #sqlhelp
Real quick, is it possible to have an asynchronous secondary act as a readable secondary in an AG? #sqlhelp
They weren't kidding about "sometimes more than 24 hours" to deploy a managed instance for the first time...
Currently listening to Paul Randal talk to us about wait stats. 🔥
Big thanks to @SQLHammer for presenting for us at the NW Arkansas #SQLPASS user group today. He gave a great primer on Azure SQL Data Warehouse.
Tonight Show Music Break: @TheWarOnDrugs performs "Pain" for Studio 6B! youtube.com/watch?v=u6CAq-…
🙌🙌🙌
Finally, support for recent SSMS versions downloadable at architectshack.com/PoorMansTSqlFo…. Took long enough, but looks like we made it!
Was just sent a RED ALERT email There's a squirrel loose in the data center. Chewed through some fibre and brought one server offline so far
Boarding flight to SEA-TAC (@ Dallas Fort Worth International Airport in DFW Airport, TX) swarmapp.com/c/5UzUMwqYgvo
First stop of the day en route to #SQLSummit #SqlPass (@ Northwest Arkansas Regional Airport - @flyxna) swarmapp.com/c/9V3wO5SjZvu
United States 趨勢
- 1. #SixKingsSlam 5,004 posts
- 2. Dork Cult Protest Day 22.6K posts
- 3. Semaj Morgan N/A
- 4. Vandy 4,032 posts
- 5. Araujo 570K posts
- 6. Andrew Marsh N/A
- 7. Duke 73.8K posts
- 8. #GoBlue 1,424 posts
- 9. Jelly Roll 1,234 posts
- 10. Pavia 1,395 posts
- 11. Gil Manzano 25.7K posts
- 12. Gameday 31.5K posts
- 13. Haaland 47.5K posts
- 14. McLaren 31.5K posts
- 15. Girona 42.5K posts
- 16. Mateta 10.8K posts
- 17. Vanderbilt 4,039 posts
- 18. Bournemouth 19.9K posts
- 19. Saban 7,774 posts
- 20. Georgia Tech 3,178 posts
Something went wrong.
Something went wrong.