DallasDBAs.com

Explaining SQL Server in plain english

Header Right

Beginner

DBA Fundamentals at SQLSaturday Cincinnati

by Leave a Comment

I will be teaching my all day “DBA Fundamentals” pre-con at SQL Saturday Cincinnati on March 16, 2018.   There is a $125 fee for this class, which includes lunch.  Possibly a cool DBA t-shirt as well…

This class is targeted at pretty much everyone that wants to know more about how SQL Server works and is not an experienced DBA.

Probable topics (I adjust on the fly depending on time…) can be viewed on the registration page.

Some unedited comments from previous attendees:

DBA Fundamentals comments

I love that one at the bottom!

If you are unsure if this class is for you, email me or ping me on Twitter…I want you to get your money’s worth! Or, check out this promo video I made to help you decide.

If you are anywhere near Cincinnati but can’t/don’t want to do pre-cons, come to the Saturday events…everything is free except for lunch!

Thanks for reading.

Kevin3NF

Rant: Dead DBAs

by 1 Comment

Where I go on a rant about the “death of the DBA”…which by comparison to others barely even qualifies as a rant 🙂

This is the post I reference in the video:

My prediction of the DBA role

And these are the names I mentioned:

  • Grant Fritchey
  • Brent Ozar
  • Pinal Dave
  • Paul Randal

I’ll let you YaBingGoogleHoo them yourself…

One thing I forgot to mention:  If you are not improving your skills and learning all the time…you are not a dead DBA, but you are becoming a “Zombie DBA” (baaaackuuuupssss….)

Thanks for watching!

Kevin3NF

 

 

 

SQL Server Point In Time Restore

by Leave a Comment

20 minute video of me setting up and demonstrating a point-in-time database restore in SQL Server.

If you’ve ever been on a SQL DBA interview, more than likely you’ve been asked about this.   I was recently, and I’ve been a DBA for 18 years…it never goes away.  But, the reason for that is that many DBAs know the concept, but have never actually needed to do one.

Its a basics video, so please don’t be looking for Paul Randal level internals here 🙂

Thanks for watching!

Kevin3NF

 

September DBA Fundamentals training in DFW – Free

by Leave a Comment

I will be teaching an all day (9-5) class on SQL Server Database Administration fundamentals at the Microsoft building in Irving/Las Colinas on September 15, 2017.

Update: This is now a free class.  There will be a donation bucket, with 100% going to the Red Cross.

The target audience for this is System admins, Developers, Tier 1 support staff, IT managers…anyone that has to deal with SQL Server on a regular basis and finds themselves Googling everything.

Register (REQUIRED) on EventBrite to learn the following topics (subject to change due to time, class flow):

• What makes up a SQL Server

• How a database is structured

• How to install and what to look out for

• Finding what you need in Management Studio

• SQL Security Basics

• How to create and manage backups

• How to create a database, 3 different ways

• Basic performance troubleshooting

• Picking a Disaster Recovery option for your environment

Please see the FAQ section of the registration page, and feel free to contact me for anything not covered there.

Thanks!

Kevin3NF

SQL Saturday Minnesota 2017

by Leave a Comment

Now that the official schedule has been published, I am pleased to announce that I will be doing a pre-con and a regular session at SQL Saturday Minnesota on October 6-7. 2017.

The Friday pre-conference will be “DBA Fundamentals for the Junior, Accidental and non-DBAs.”  This will be a wide ranging day-long discussion on the underlying fundamental pieces of SQL Server Administration that are beneficial to both new DBAs, and those that have to work with or fill in for them.  Please see the link for details, and feel free to contact me with any questions.  There is a $110 (plus service fees) charge for this, which is split between me and the local SQL User group organizing the event, after expenses.

The Saturday regular session will be “Backups for new/non-DBAs…the Why, not the How”, where we will cover Disaster recovery scenarios and the part SQL Server plays in the recovery.  We won’t spend much time on specifically defining backup types, etc.    Currently this is scheduled for the 1-2pm time slot, but that may change.

Edit: my Saturday session is now 10:15am – 11:15am 🙂

I’m very excited to be coming to the MSP area!  I even have a friend that lives in the area that I get to see for the first time in 3 years…plus all of the new friends I will make at the events!

Thanks,

Kevin3NF