We are excited to invite you to the next meeting of the Oklahoma City SQL Server Users Group and we’re trying something a little different this month! We will be doing a lunch meeting from 11:00am-1:00pm and the regular evening meeting.
Sean And Jen McCown are our in person speakers. Below are the details:
Sean McCown is a Certified Master in SQL Server 2008 and a SQL Server MVP with 20 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight.Jennifer McCown is an independent consultant, Microsoft SQL Server MVP awardee, developer, and DBA. She’s senior editor at MidnightDBA.com, where she creates training videos, the “DBAs at Midnight” webshow, blogs, reviews, and podcasts. Jennifer is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology Virtual Chapter.
The title for the Lunch talk is Small Question/Big Answers and will cover:
The longest days in a DBA’s life start with small questions.
Who has sysadmin in all of our databases? How big will our databases be next year?
Which servers will be affected if we change the AD account password?
If you’re a DBA in this shop and you have hundreds of databases, then your entire week just got really long. What you need is a way to organize your environment in such a way that you can get the answers easily and turn these into trivial questions. We’re going to show you how our new product Minion Enterprise lets you manage your environment in a way so that you get all of your time back. While Minion Enterprise can work wonders in your environment, we’re also going to discuss other ways to bring your shop under control.
When: Monday, June, 8th
Time: 11:00 a.m.- 1:00 p.m.
OKC Downtown Library
Friends of the Library Room Room 4130 (4th Floor)
300 Park Ave Oklahoma City, OK
The Evening Double Header will be Held at the Dell Building and will Consist of:
Introduction To Powershell Cmdlets For DBAs
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Monster Text Manipulation: Regular Expressions for the DBA
As DBAs there are many tasks we’re asked to do every day that we just accept as taking a long time because of some manual component we can’t get around. Many of these tasks can be brought into line with regex. You can use it to format your own T-SQL and create code that writes code with relative ease. I’m going to teach you the basics of regex and show you how to perform many tasks that’ll make your life much easier like deploying code, formatting T-SQL, and much more.
When: Monday, June, 8th
Time: 6:00 p.m.- 8:00 p.m.
Food and Drinks will be provided by GDH
Location: Dell – Lobby A
3501 SW 15th OKC, OK 73120
Be sure to check in with security when you arrive
Our Website/MailingList: http://okcsql.org
SQL Saturday Oklahoma City – Aug 29th, 2015 – https://www.sqlsaturday.com/442/eventhome.aspx
Interested in learning about other local technology groups? Check out Techlahoma’s User Groups page at http://us.techlahoma.org/groups for a list of many local technology groups.
We would like to thank:
GDH Consulting for sponsoring food
Dell for sponsoring location.
We would also like to thank our other prize sponsors: