SQL Server Database Consulting
I put this video together in about ten minutes of T-SQL code prep, and one-take of the video. It is not meant to be an all-inclusive lesson…merely an introduction to how to read SQL Server Execution Plans (Right to Left, Top to Bottom, etc.) and some basic things to look at. Senior performance tuning DBAs…you probably don’t want to watch this 🙂
Comments and likes are appreciated if you think it has value…
Thanks for watching!
A lightweight video to explain the basics behind the Cost Threshold for Parallelism SQL Server setting, and how to change it:
Thanks for reading!
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.
A quick video for the Accidental DBAs in the crowd:
Thanks for watching!
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:
* 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!
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!
