Time for a new, simple WordSearch – this time focused on SQL Server development!
Have fun!
SQL Saturday Austin 2019
Saturday! Saturday! Saturday!
Come to SQL Saturday in Austin, TX on July 13 for a full day of FREE SQL Server/Data Platform training!
I will be delivering one of my favorite sessions: “Your SQL Servers are Mi$ConFiguReDed” currently scheduled for 1:15PM.
Nope…I’m not at all worried that you might go to Joe Celko’s session instead 🙂
I will also be at the Dallas DBAs GOLD sponsor booth/table all day to talk to you about your SQL Server DBA needs. Or family. Maybe sportsball…you decide. We’re kind of chill around here…
There will be a SQL Server Saturday Super Summer Special Savings offer…make sure to ask! Spoiler: its a discount on our Pocket DBA™ service.
Thanks for reading!
WordSearch 1: Junior DBA
Video: SQL Server HA/DR Overview
This is meant to be a high-level overview, not an exhaustive setup guide. I skip over some relevant bits so the main points don’t get buried.
In my DBA Fundamentals pre-conference, we spend a good hour going over the various High Availability and Disaster Recovery options available in SQL Server. From simple Backup/Restore up to Distributed Availability Groups.
This video is a more succinct version of that conversation. Enjoy!
If you have questions or comments, please add them in the YouTube comments, so I’ll see them more quickly.
Thanks for reading!
IRL: SQL Server HealthCheck
IRL #3 – Slow Server
Problem:
I was recently approached by a firm outside the US for some help with his SQL Server which was “running slow.”
Background:
They don’t have a DBA, and I don’t support international customers so I told him I would donate 30 minutes of my time out of pure curiosity.
Action Taken:
I sent my HealthCheck tool along with instructions to run it once the server has been up at least 7 days.
Results:
After reviewing the gathered info for 30 minutes, these are the results I sent back as recommendations to look into:
- Backups and Data on the same drive
- Other databases never backed up
- No CheckDB since 2011, if ever
- Max Server Memory: 24,000 MB of 32GB installed
- Memory used -3.4GB
- Windows Server 2008
- Auto-Shrink enabled on prod databases
- No alerts when bad things happen
- No Operators
- SQL Agent offline
- Balanced Power Plan
- Priority Boost enabled
- TempDB on C drive, only 1 data file
- 10 years of backup history
- PLE – 292 seconds
- 32-bit SQL Server 2014 (unsupported build)
- I didn’t even get back any index information, as those queries timed out.
Solution:
- Immediate:
- Upgrade to 64-bit O/S (assuming 32 bit here) and SQL Server
- Patch to supported build
- Turn off Priority boost
- Set up proper alerts and maintenance
- High performance power plan
- Next
- Address everything else
Lessons:
Start at the outside and work your way in. The SQL version can be the biggest issue. Start at Hardware and O/S, then Instance settings, then indexing, then queries (in most cases).
All of this took less than 30 minutes to find. I can do similar (but much more thorough) work for you. If you are in the US 🙂
Thanks for reading!
SQL Saturday Dallas 2019 aftermath…
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
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!