Auckland SQL Server

The AucklandSQL User Group is a community user group that strives to promote networking and professional interaction to help the IT Professional get the most out of SQL Server, and to strengthen the profile of SQL in the wider Auckland region.

The group meets 6pm on or around the third Wednesday of each month.

Membership, meetings, presentations and refreshments are free unless otherwise advised.


CONTACT

announce@aucklandsql.com

+64 (27) 323 4670

Auckland SQL Users Group
PO Box 65-435
Mairangi Bay
Auckland 0754
New Zealand

PASS

We're also affiliated with the Professional Association for SQL Server.  This is a world-wide SQL Server Users Group.  PASS holds a conference each year.

You Senior DBA life start here.

tl;dr Press your DBA turbo button, watch all of these Office Hours with Brent Ozar Unlimited®, all of them, starting at 1, and join the meetups. https://www.meetup.com/Auckland-SQL-User-Group/

There are always some basic things on SQL server that come up, kind of like “hot topics”. These are super important as 85% of your SQL work will relate to these topics. 

You need to become familiar with them and understand what they mean if you want to progress as a DBA.


So let's jump in on the things that will make you a better DBA.

  1. It’s okay to make mistakes, you are not a DBA if you don’t know how to fix what you break.
  2. You will get bored with all of the learning bits, deal with it now, we all get bored with consuming content.
  3. You will get frustrated and distracted with issues, deal with it, we all do.
  4. Before doing anything read current Microsoft Best Practice guidance, or just follow Microsoft how-to guides.

i.    You don’t have to follow these steps now, this is just an example for configuring Always On Availability Groups

ii.    https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/creation-and-configuration-of-availability-groups-sql-server

iii.    Oh wait, I need some prereqs: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability

iv.    Oops, need a cluster, https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server

v.    Now work your way back up and follow the steps, BOOM, new Always On Availability Group in line with Microsoft best practice for implementation, easy right.

vi.    Don’t think when you don’t have to, and don’t make up your own best practice, follow Microsoft. That is what I do.

"But this is not technical? You are not showing me how to become a DBA!"

Becoming a DBA, and a good DBA, is about setting up frameworks for yourself. If you have a good framework for troubleshooting and triage you can get a lot of things done without being an expert in those items. You don't need to know how the optimizer works, but you need to know how to look for symptoms of it not behaving as expected.

Observation, situation awareness and tooling will allow you to build a mental framework for looking at issues. That is the difference between a DBA and a Senior DBA. 

First learn, then ask questions. There is a whole community waiting to help you out. Show some initiative and ask questions and you will get all the help you could ever want.

To start on this journey you need to know what language to speak when you get there, so learn how to talk about SQL. 

Come talk to us https://www.meetup.com/Auckland-SQL-User-Group/

Download, listen or watch all of these.

Office Hours with Brent Ozar Unlimited®

http://www.groupby.org/

 

 

 

PASSChapterLogo.jpg

 

          

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids