DallasDBAs.com

SQL Server Database Consulting

Accidental DBA

Getting Started with Index and Execution Plan Basics

by Leave a Comment

If you are a developer or new SQL Server DBA and have never really worked with query tuning, this post is for you.  If you are an experienced DBA/Tuner and want to nit-pick me saying field vs. column, feel free to leave a comment that I will delete or never publish, lol.  This is basics, yo…

I concentrate on how to measure the performance of a query, as well as the basics of “seeing” how SQL Server is executing the query to return the results.

I could type all of this up, but watching the video is going to be a WHOLE lot better teacher, so here you go:

As always, feel free to reach out via the comments here or on the video.  Or, follow me on Twitter and ask away!

Thanks for reading!

Kevin3NF

SQL Saturday Dallas 2018

by Leave a Comment

Hey all!

I am doing my DBA Fundamentals all day pre-conference at SQL Saturday Dallas on Friday, May 18.  Register HERE. $120 until May 1, then $140.  If you are not sure if this is the class for you, please go watch this promo video I threw together, then email me if you still have questions.  If you are a mid or senior level DBA, this is not a good use of your money and time…check out the others that are happening that day.

And then on Saturday, May 19 (Free!) I will be giving my Disaster recovery is everyone’s job! presentation, currently scheduled for 11am, subject to change at the whim of the organizers (spoiler alert…I’m one of the organizers, lol)

This is going to be a great event…the theme is “SQL de Mayo”, because Texas!  Go register now to reserve your spot, because it will fill up and being on the wait list is kind of a drag.  And buy lunch too!  No free lunch…

Hey…we still need more sponsors at Bronze, Silver and Gold levels to make this event even more awesome and I’m the guy to contact about that, so…contact me!

Thanks for reading!

Kevin3NF

^^^ follow me, you stalker 🙂

 

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

 

Home Blog About Privacy Policy