GoodwinSQL's profile picture. SQL Server DBA

Justin Goodwin

@GoodwinSQL

SQL Server DBA

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


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

GoodwinSQL's tweet image. 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.


Justin Goodwin reposted

Tonight Show Music Break: @TheWarOnDrugs performs "Pain" for Studio 6B! youtube.com/watch?v=u6CAq-…


2018 Goal: Be as lazy as possible. More query shortcuts ftw.

GoodwinSQL's tweet image. 2018 Goal: Be as lazy as possible. More query shortcuts ftw.

🙌🙌🙌

Finally, support for recent SSMS versions downloadable at architectshack.com/PoorMansTSqlFo…. Took long enough, but looks like we made it!



Here's a better picture of the squirrel in data center.

GoodwinSQL's tweet image. Here's a better picture of the squirrel in data center.

hahaha someone got photo proof

GoodwinSQL's tweet image. hahaha someone got photo proof

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 Trends

Loading...

Something went wrong.


Something went wrong.