Microsoft SQL server principal consultant at Lexel Systems, where I lead our Managed Services and Professional/Project Services capability for SQL Server.
Auckland, New Zealand
Joined October 2010
- Tweets212
- Following47
- Followers26
- Likes66
A simple guide to drawing with SQL Server in SSMS. A technical article.
linkedin.com/pulse/simple-gu…
🤗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
#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?
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! sqlsaturday.com/978
#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?
Check out my latest article: Want to connect to SQLExpress without using the instance name? Follow these easy steps. linkedin.com/pulse/want-conn… via @LinkedIn
Jillian Goodman #Kudos Wow! Just when I thought your work couldn't get any better #GoingAboveAndBeyond lnkd.in/eiCf3pb
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
29%Yes, gotta pay
71%No, it's free
17 votes • Final resultsFun things to do with SQL. Drawing.
Hard things to do with SQL. Drawing.
Stupidly hard things to do with SQL. Coloring in like a 5 year old.
Here is a link to the code.
gist.github.com/SQLAdrian/8f…
Thanks @MJSwart for your blog posts with guidance on coloring in.
Thanks Zoran Barac for running us through Database Experimentation Assistant for SQL upgrades.
Come learn more about migrations and from Zoran at future Auckland SQL User Group sessions.
Adrian Sullivan retweeted
@sqlsullivan talking about building teams and starting a practice at #sqlSatAuckland , awesome session! @sqlpass #sqlserver
Adrian Sullivan retweeted
Be sure to attend #SQLsatAuckland #866 and be in to win @DetectaIO's prize of a:
" @HamptonDowns - Super Fast Dash Experience "
Awesome session on AGs. Thanks @EdwinMSarmiento.
Join us for future session on Meetup for the Auckland SQL User Group
Adrian Sullivan retweeted
A new self-paced #SQLServer 2019 FREE lab is now live at github.com/microsoft/sqlwork…. You can do this entire lab on your laptop!
Thanks @DetectaIO
I can now manage my SQL Server patch life cycle a whole lot easier.
Really valuable for an MSP with lots of different environments to look after.
Fun to talk about SQL migrations.
Who could imagine listening to me talking about Data Migration Assistant could be so entertaining.
Thanks for attending another awesome Meetup.
#AucklandSQLUserGroup
What main pain points should I consider when moving a SQL cluster and AG to a new domain?
Any fancy AD footwork needed?
#sqlhelp