We travel to SQL Server user groups and give seminars on SQL Server training, database administration, performance tuning and more. They’re usually arranged in a class-style setup: we’ll talk through demos and slides for about an hour, and then you can ask questions. Sometimes these are taped for video release later.
May 21 – Managing SQL Server Databases in VMware – Brent Ozar
SQL Servers can run faster and more reliably under VMware vSphere/ESXi, but they can also run craptastically. You can’t just use SQL Server’s defaults and expect databases to fly, but thankfully, it’s not hard to get high performance and uptime with a few important tweaks. Learn more about this 3-hour online session.
May 22 – Perfmon: Your Server’s Vital Stats
Brent Ozar, Technology Triage Tuesday
Your doctor monitors your heart rate, blood pressure, and weight. You’re a server doctor, and there are vital metrics you should watch about your SQL Servers. Even if your servers are healthy today, learn the ten most important Perfmon metrics you should be tracking so you’ll know if things are getting better or worse. Microsoft Certified Master Brent Ozar will help you along your internship. Register now.
May 22 – How to Make SQL Queries Run Faster – Brent Ozar
Whether you’re a developer or a DBA, you’re probably frustrated with query performance. Why is the app running slow? Why does query performance vary so much? Why can’t your queries run consistently fast? You’ll learn the tricks of performance tuning in this three-hour session. Learn more now.
June 5 – SQL Server Max Memory Myths
Jes Schultz Borland, Technology Triage Tuesday
SQL Server wants memory the way a runner wants food after a
marathon: it wants it all and it wants it right now. You can configure max memory settings, but will that cover all of SQL Server’s uses for memory? Jes Schultz Borland will uncover the truth about how SQL Server is handling memory in this free 30 minute webcast. Single page and multi page allocations will be discussed, along with changes in SQL Server 2012. This talk is designed for DBAs with a couple years of experience poking under the hood who are interested in learning more about how SQL uses memory. Register now.
June 12 – A Developer’s Guide to Dangerous Queries
Jeremiah Peschka, Technology Triage Tuesday
SQL Server does a good job of working with whatever garbage we throw at it, but sometimes a helping hand is needed to smooth things out. You may have meant well when you wrote that sloppy SQL, but that predicate lurking under the surface is poisoning your performance. This talk will expose your worst habits, anti-patterns, and bad practices. By the time we’re done, your T-SQL will be on the path to make things right again. This talk will be therapeutic for anyone from a junior DBA or a senior developer. Register now.
June 19 -Which Queries are Killing Your Server? A Developer’s Guide
Brent Ozar, Technology Triage Tuesday
What’s slowing down production? It’s easy to find out in 60 seconds by running a simple plan cache query. See, in order to turn your beautifully written query into a set of results, SQL Server needs a plan – an execution plan. It caches these plans in memory along with statistics like the number of times a query has been run, how long it’s taking on average, and the execution plan itself. Whether you’re a junior DBA or a senior developer, you can use this data to find the culprit. Register now.
June 26 – The Use and Abuse of ‘Recompile’ in SQL Server
Kendra Little, Technology Triage Tuesday
What are the costs when you ask SQL Server to recompile a statement or a stored procedure each time it runs? In this 30 minute talk Kendra Little explains the impact on query execution– and on your SQL Server instance– of forcing recompilation. This talk is appropriate for DBAs and Developers who have a working knowledge of execution plans in SQL Server. Register now.
July 6 – Managing SQL Server Databases in VMware – Brent Ozar
SQL Servers can run faster and more reliably under VMware vSphere/ESXi, but they can also run craptastically. You can’t just use SQL Server’s defaults and expect databases to fly, but thankfully, it’s not hard to get high performance and uptime with a few important tweaks. Learn more about this 3-hour online session.
July 25 – Index Tuning with the DMVs
Brent Ozar, Madison WI (MADPASS)
SQL Server is constantly watching queries and taking notes about what indexes could have made the queries – and which ones aren’t helping at all. Learn how to use the Dynamic Management Views (DMVs) to build better indexes and dump the ones you don’t need.
This session will be at 2310 Crossroads Drive Madison, WI 53718 at 5:30pm. It’s the building with the “Cisco” logo on it facing the interstate near East Towne Mall.
Want One of Us to Speak At Your Event?
We would love to give a presentation at your next user group meeting or conference. With today’s economy, travel costs can be tough to justify, though, so we’ve started doing remote presentations via Microsoft LiveMeeting. If you’ve got a projector and a good set of computer speakers, we can present remotely anytime. We use a webcam, too, so your attendees can see me making faces when they ask tough questions.
Check out our list of presentation topics, and contact us to let us know what dates you’d like us to present. We’d be honored!
