• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
    • SQL Server Health Check
    • Fractional DBA
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

Training

SQL Saturday Dallas 2019 aftermath…

June 4, 2019 by Kevin3NF Leave a Comment

The 2019 event was held June 1 on the amazing UT-Dallas campus in the Naveen Jindal School of Management building, which was a nice upgrade from last years event on the same campus but in a different building.

This is not going to be an exhaustive post of all the great sessions, conversations, etc.  Mostly because I was there as a sponsor again this year so I didn’t get to any sessions.  But, I DID get to talk to a massive number of people that stopped by the table.

First off…a shout out to the North Texas SQL Server User Group board and all of the volunteers that dedicated many, many hours of time and sweat (and homes!) to make this thing happen.  The Dallas event is one of the biggest in the world.  The very unofficial count of attendees I *think* I heard was just over 700, from 1100+ registrations.

A second shout out to our sponsors that made this event possible.  Their dollars made it easy to do all we wanted to for the speakers, volunteers and attendees.  From high quality speaker gifts to cool attendee bags, to a great fajita lunch.  And cookies.  And lots of coffee all day long!

There were 4 fantastic pre-conferences to choose from.  As a full-time DBA I decided to learn something new and went to Adam Saxton‘s Power BI class.

Adam, aka ‘Guy In A Cube’

The other 3 pre-cons were from Brent Ozar (sold out twice), Andy Leonard (b|t) and Chris Hyde (t)…all fantastic teachers and overall nice humans.

After the pre-cons, NTSSUG board member Fernando hosted the traditional Speaker Dinner at his home in North Dallas.  Fernando is a brave, brave man.  The only pic I got was of the Tres Leches cake, already partly demolished:

I love the speaker dinners, as it gives me a chance to hang out with people in a low-key environment.  A stark contrast to trying to catch up at something like PASS Summit, which takes SQL geek craziness to a whole ‘nother level.

Saturday

As a Gold sponsor of this event, I got good placement of my booth, and was close enough to the NTSSUG booth to be able to help out there as well.  Brent was kind enough to come by for some pics between sessions:

Brand new DBA (Day 1 on staff) Jeff Miller (t) and Brent

Brent and the entire Dallas DBAs staff (Including Liz’s elbow)

Another benefit for Gold sponsors is the Lunch Session.  I was able to give my “Your SQL Servers are Mi$ConFiguReDed” session to 35-40 people.  I didn’t do a formal count, and this pic is not wide enough to catch those on the far left and right of this room:

This was a great session, as there was some fantastic audience participation…from multiple people!

Something that is a great way to encourage attendees to stay all day is the end of day sponsor raffle.  Sponsor agree to bring something worth $100 or more…must be present to win.  We had 13 sponsors plus PASS and Microsoft, as well as 8 signed copies of Bob Ward’s book, Pro SQL Server on Linux to give away.  There were TONS of people that stuck around for the raffle:

The Grand prize (provided by Microsoft) was a Surface Go!  All the buckets in the pic are the raffle tickets for the sponsors.  Half of them are not showing.

Once again…this was an amazing event.  Last year was great, this was better.  I can’t wait to see how we up our game for next year!

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: SQLSaturday, Training

Pluralsight: Getting Started With Your First SQL Server Instance

March 14, 2019 by Kevin3NF Leave a Comment

Almost a full year after I first thought I might have something relevant to contribute, my first Pluralsight course has been published!

Its called “Getting Started With Your First SQL Server Instance” and is targeted to non-DBAs that want to know more about SQL Server Administration, or just want to understand SQL Server beyond the random Google Search when something breaks.

I’m hoping this is just the first of many “Getting Started…” courses that take SQL Server all the way down to entry-level training so people can learn, then test, then do as they go.

The trailer for the course:

I want to thank Chris and Derek at Pluralsight for their guidance along the way…and a huge shoutout to Eugene Meidinger (b|t) for his valuable input before, during and after the course creation.

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Accidental DBA, Beginner, Career, Pluralsight, Training

SQL Saturday Cincinnati 2019

January 8, 2019 by Kevin3NF 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.

Filed Under: Accidental DBA, Beginner, SQLSaturday, Training

2018 Highlights and 2019 Goals

January 1, 2019 by Kevin3NF Leave a Comment

Happy New Year!

They say focus on the positive and make your goals public, so that’s exactly what I’m going to do here!

Dallas DBAs had a great 2018, by every measurable category.  No formal goals were laid out, other than “don’t close the doors” and “help people”.

The stats:

  • 7 new clients added – mix of short-term and long-term
  • 1 customer carried from 2017 into the year and 3 extensions signed for 2019
  • 21K views/115K minutes watched on our YouTube channel
  • 26,415 page views on DallasDBAs.com
  • 1 new employee added (part-time Junior DBA)
  • 2 new contractors working on skills not in house (Power BI and SQL Dev)
    • 3 other sub-contractor agreements signed
  • 1 SQL Saturday sponsored (Dallas, May) with a booth (many others at the “personal” level)
  • 2 Pre-conference sessions and 2 regular session presentations given at SQL Saturdays (Cincy and Dallas)
  • 3 scripts updated or added to the Microsoft Technet Gallery
  • 2 Databases rescued from corruption issues (Thanks Red-Gate!)
  • 6 free HealthChecks
  • At least $12 in net profit

The goals for 2019:

  • 6 new long-term part time DBA support clients
  • Add one Senior SQL Server DBA to staff
    • Add one apprentice to this DBA
  • Add one new Oracle DBA to the team
  • Sponsor 2 SQL Saturdays with a booth (Dallas and Cincy)
  • Deliver “DBA Fundamentals” training for free once per quarter (Cincy, Dallas(?), Q3/Q4 TBA)
  • 30K views/180K minutes on YouTube channel
    • 6 new videos – Accidental DBA target audience
  • 40K Hits on DallasDBAs.com
  • At least $13 net profit
  • 12 Free HealthChecks, bare minimum once a month

The things we put in place this year have worked well, so I may be fudging the number too conservatively for 2019.  Check back next year…we may actually hit $14 net profit!

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Career, Dallas DBAs, Goals, SQLSaturday, Training

DBA Fundamentals pre-cons 2019

November 12, 2018 by Kevin3NF 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.  [email protected]

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Accidental DBA, Beginner, SQLSaturday, Training

PASS Summit 2018 – My Schedule

November 6, 2018 by Kevin3NF Leave a Comment

If you are going to PASS Summit in Seattle and want someone to sit with, check out my schedule (primary and backup sessions) – very much subject to change:

 

Wednesday, November 7, 2018

============================

10:15 AM – 11:30 AM Room: 2AB

dbatools Powershell Library – The Complete Introduction (Yes, my very first session is Powershell, lol)

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85712

10:15 AM – 11:30 AM Room: 612

Uncovering Duplicate, Redundant, & Missing Indexes

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=77036

1:30 PM – 2:45 PM Room: 606

Improving Availability in SQL Server and Azure SQL Database

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=84728

1:30 PM – 4:00 PM Room: 6E

SQL Server Migrations Done the Right Way

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=84219

4:45 PM – 6:00 PM Room: 6A

SSMS & T-SQL Tricks: Working Smarter, Not Harder

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78153

Thursday, November 8, 2018

============================

10:45 AM – 12:00 PM Room: 6B

Containers, Pods, and Databases- The Future of Infrastructure

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78022

1:30 PM – 4:00 PMRoom: 606

Query Tuning Internals for the Advanced SQL Developer

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78050

1:30 PM – 2:45 PM Room: TCC Tahoma 2

Top 5 Power BI Custom Visuals

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=82110

1:30 PM – 2:45 PM Room: 6C

Top Tips for Deploying AGs and FCIs On Premises or In the Cloud

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78041

3:15 PM – 4:30 PM Room: 618

An Introduction to Partitioning

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=77002

4:45 PM – 6:00 PM Room: 604

Data Science 101 for the SQL DBA

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=86521

4:45 PM – 6:00 PM Room: 6C

Validate Your SQL Server Estate with Ease Using dbachecks

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78382

Friday, November 9, 2018

============================

8:00 AM – 9:15 AM Room: 6C

T-SQL Habits and Practices That Can Kill Performance

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78111

9:30 AM – 12:00 PM Room: 6E

Migrating to SQL Server 2017

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78285

11:00 AM – 12:15 PM Room: 3AB

BI Power Hour

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=86517

2:00 PM – 3:15 PM Room: 3AB

Lightning Talks: DBA

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85592

2:00 PM – 3:15 PM Room: 618

What’s New With Adaptive Query Processing?

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78238

3:30 PM – 4:45 PM Room: TCC Yakima 1

A DBAs Guide to the Proper Handling of Corruption

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=78274

3:30 PM – 4:45 PM Room: TCC Tahoma 4

SQL Server Performance Monitoring Made Easy

https://www.pass.org/summit/2018/Sessions/Details.aspx?sid=85138

 

PLEASE feel free to come introduce yourself like we are old friends.  My brain is defective in remembering names and where we met, so you may have to remind me if in fact we have met before 🙂  Fair warning…I may ask you to take a selfie with me.  I suck at selfies so I may actually get a shot of your shoes, or the ceiling 🙂

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Career, Summit, Training

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2025 · WordPress · Log in

 

Loading Comments...