DallasDBAs.com

Explaining SQL Server in plain english

Header Right

Accidental DBA

SQL Saturday Cincinnati 2019

by Leave a Comment

Dallas DBAs is proud to announce that we are a ?Diamond Sponsor? of SQL Saturday Cincinnati on March 30, 2019, being held at the University of Cincinnati.  We will be presenting a lunch session: “Your SQL Servers Are Misconfigured!”

In addition, Dallas DBAs team members Kevin and Derek will present a pre-conference on Friday, March 29: “DBA Fundamentals: Give yourself a solid SQL Server foundation.”  This all day session is targeted to Developers, Students, System Admins, Managers, Oracle DBAs, etc.  Anyone that can benefit from knowing more about the Administration side of SQL Server. $75.

Please come Saturday for a free day full of training options. Register here.

DBA Fundamentals pre-cons 2019

by Leave a Comment

While this post is for everyone, it is specifically written for  SQL Saturday organizers…

I am filling out my 2019 schedule of target dates/locations of SQL Saturdays I want to attend/present (US only…I don’t even have a passport)

I am offering to do my DBA Fundamentals pre-con and one or two Saturday sessions (Security/DR) with a twist:

You keep my part of the pre-con proceeds for your group.  I’ll cover my own travel, meals, etc. if you provide the space.  This should allow you to increase your funding for the rest of the event, buy some pizza for your local group, or even discount the pre-con price should you choose to do so.

If you only have 1 or 2 pre-con spots and cannot secure an additional room at your venue, please pick from the other submissions 🙂

Tentative schedule:

  • January –
  • March – Chicago (23rd, submitted) or Cincinnati (30th)
  • April – Dallas *
  • June –
  • August –
  • October –
  • December –

* All of these are tentative, some dates not granted yet

So, dear organizer…if you think this offer will be a benefit to your SQL Saturday, please get in touch and let me know what your planned date is so I can be sure to submit.  Kevin@DallasDBAs.com

Thanks for reading!

Kevin3NF

SQL101: Import/Export wizard

by Leave a Comment

Do you need to quickly Import or Export data to/from SQL Server?  Do you want to avoid the hassle of creating and deploying an SSIS pacakge?

The SQL Server Import/Export wizard might be perfect for you!

The wizard steps you through the necessary pieces and is surprisingly flexible.  I cover the basics in this video (recorded in one shot, please excuse throat clears and “Ums”)

If you have comments, please leave them on the YouTube page (ideally) or down below.

Its very likely this is part 1 of at least two…trying to keep my videos to shorter lengths.

Thanks for reading!

Kevin3NF

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 🙂