Adrian Sullivan

When #ninjacat makes it into #SQL Server. Ninjactmas. github.com/SQLAdrian/draw…

A simple guide to drawing with SQL Server in SSMS. A technical article. linkedin.com/pulse/simple-g…

@sqlpass What happens to how the local User Groups are organized? With no barrier to entry anyone can now start a User Group, or run their own SQL Saturday event. Is there anyone who can offer a similar framework for User Groups to operate in?

🤗Optimist: "This glass is half full"🥛 🤔Pessimist: "The glass is half empty"🥛 👩‍💻 DBA: "No! Well, it depends. Do you need it Highly Available? Have you enabled table compression on the glass?"🍨 DBAs are great! Need help with SQL server? 🚑 We have…lnkd.in/gRBSGcr

@Michael_DSpain Good point. I can confirm that this is not the case in this environment.

@sqlsullivan If it’s a VM environment they might have licensed the host. Might be one reason they are saying that.

#sqlhelp Asking for a friend... They have SQL Enterprise Editions running Test/Dev/Uat workloads. Will they incur licensing if they can prove they are for Tes/Dev/Uat only? What is the official licensing position?

@jdanton @mrdenny Uninstall and Reinstall would be the only option.

@mrdenny @sqlsullivan I think they’ll have to actually reinstall too, right? #sqlhelp

@mrdenny Thanks Denny. Their current EA license vendor is telling them they don't need to worry about it. I feel they have been grossly misinformed.

@sqlsullivan They need to install the Dev edition to get a free license. If they have EE installed in UAT/QA/DEV they need to license it. Dev = EE for feature purposes.

The New Zealand Government should FULLY FUND ambulances, it's a travesty they aren't already! - Sign the Petition! chng.it/f8sbFGyj via @Change

Want to build a million dollar SQL DBA practice? Spoiler alert, margin is hard. I am speaking @SQLSatLA. Join me on Saturday, Jun 13, 2020 for a #free #training day on #data! www.sqlsaturday.com/978

@SQLHA @SQLDBA I'd run away, but with social distancing there is nowhere to go... I'll see it through, but next week I'm recommending a SQL2016 instance on there. We are bound to 2016 on the source.

@sqlsullivan @SQLDBA If that's your use case, I stand by my recommendation of running away ;) It wasn't designed to run that way in perpetuity. If you just need reporting and no HA, I'd go all 2017 or 2019 and use a cluster type of NONE.

#sqlhelp Distributed Availability Group. SQL 2016 to SQL 2019 (reporting only). Direct seeding does not work, thanks to database version mismatch on SQL 2019. How do I seed and sync databases using "backup and restore" on Secondary Availability Group?

@SQLDBA Thanks Kendal, I will give this a go. Does it mattet at what time I take the FULL backup, like before creating the DAG or after, or just as long as there's no LOG backup in between?

@sqlsullivan Restore DB on AG 2 replicas without recovering. Distributed Availability Group needs to already exist and set to manual seeding with both sides joined. On forwarder run “ALTER DATABASE [dbname] SET HADR AVAILABILITY GROUP = [AG 2 name]”. #sqlhelp

@SQLHA @SQLDBA Thanks Allan. This is more of a POC replication replacement. Cross domain using certificates. We might go with a stacked solution on the target after this. It's painful.

@SQLDBA @sqlsullivan We're all good. Just be careful, Adrian. I really wouldn't recommend what you're doing at all. If you need reporting and it's a permanent sol'n, I'd strongly recommend keeping same version of SQL Server.

@AzureSupport No solid answer as yet.

@sqlsullivan No problem! We've escalated the post internally, so keep an eye out for a reply! ^JR

Is running SQL 2016+ Developer Edition allowed inside a commercially hosted VM? I rent a VM from ABC Corp/Azure/Rackspace. Is there any licensing liability if I install SQL Developer Edition? Terms exclude "use the software for commercial software hosting services." #sqlhelp

Check out my latest article: Want to connect to SQLExpress without using the instance name? Follow these easy steps. linkedin.com/pulse/want-con… via @LinkedIn

Jillian Goodman #Kudos Wow! Just when I thought your work couldn't get any better #GoingAboveAndBeyond lnkd.in/eiCf3pb

@AzureSupport Legend, thanks. social.msdn.microsoft.com/Forums/en-US/9…

@sqlsullivan Hey there! This question would be best posted on our SQL Forums here: aka.ms/sqldbMSDNforumq If you link us to the post, we can flag a community expert to respond. :) ^JR

@MJSwart It's a crazy type of problem to solve, and way more fun than it should be.

That’s so fun. I love doing stuff like this.