Adrian Sullivan

Microsoft SQL server principal consultant at Lexel Systems, where I lead our Managed Services and Professional/Project Services capability for SQL Server.

[Adrian Sullivan @sqlsullivan]

When #ninjacat makes it into #SQL Server. Ninjactmas.

https://t.co/ya5vVSl34P

[Adrian Sullivan @sqlsullivan]

A simple guide to drawing with SQL Server in SSMS. A technical article.
https://t.co/qU7Hj73d54

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

🤗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…https://t.co/XhF4ySqZC0

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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! https://t.co/zDVugaug03

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

@AzureSupport No solid answer as yet.

[Adrian Sullivan @sqlsullivan]

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

[Adrian Sullivan @sqlsullivan]

Check out my latest article: Want to connect to SQLExpress without using the instance name? Follow these easy steps. https://t.co/iflaGNwx5v via @LinkedIn

[Adrian Sullivan @sqlsullivan]

Jillian Goodman #Kudos Wow! Just when I thought your work couldn't get any better #GoingAboveAndBeyond https://t.co/QzWEy08U1c

[Adrian Sullivan @sqlsullivan]

@AzureSupport Legend, thanks.

https://t.co/Er8YXaH6fx

[Adrian Sullivan @sqlsullivan]

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