A lightweight video to explain the basics behind the Cost Threshold for Parallelism SQL Server setting, and how to change it:
Thanks for reading!
SQL Server Database Consulting
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. Kevin@DallasDBAs.com
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!
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!