The annual SQL Saturday event in Denver is scheduled for this Saturday, September 28, but you may not know that there is also a full day of training just one day earlier. There are a total of three sessions scheduled for Friday and I have the privilege of presenting one of them, Predictive Analytics in the Enterprise. If you’ve been reading the tech news and paying attention to where analytics is headed, predictive analytics is a great topic to dive into, especially for BI developers, analysts, architects, and DBAs. Here’s a look at the session abstract:
Data Science is a red-hot subject, but what does that mean for SQL Server DBAs and developers? The Data Mining algorithms in Analysis Services provide capabilities to achieve predictive analytics and modeling with your SQL Server data and any other data you have access to. In this session you’ll get the chance to cover the data mining process from start to end. By the end of the day, you’ll have a practical understanding of how to develop predictive models for your data. The session includes a brief overview of data mining followed by an opportunity to complete actual predictive modeling exercises. You’ll see how to fine-tune and compare the results using various algorithms, and how to make the best use of the models in your enterprise. With Predictive Analytics having achieved the Plateau of Productivity in Gartner’s Hype Cycle for Emerging Technologies, now is a good time to learn what these powerful tools can do for you.
Like the abstract says, the session will cover the concepts and terminology in the predictive analytics world and will include case studies to review. It will also include instructor-led labs so you can create your own predictive models. Bring a laptop with SQL Server Analysis Services (multi-dimensional), Business Intelligence Development Studio (or SQL Server Data Tools), Excel and the Data Mining add-in for Excel. If you don’t have a laptop with these tools readily available, we can pair you up with a partner who has the tools ready to go. Working in pairs will also be a good way to learn the topic better.
If you’re looking for training in other areas, Tim Mitchell will have a full day session for ETL developers on Real World SSIS: A Survival Guide, and Dmitri Korotkevitch will target DBAs with a session titled SQL Server Internals from the Practical Angle
See you Friday!
The SQL PASS Performance Virtual Chapter has put together an exceptional event this week called the Summer Performance Palooza, an encore to the highly attended Winter Palooza held last December. The Palooza will take place this Thursday, June 27, with an all-star lineup of SQL experts that promises to deliver a full day of high quality SQL Server Performance sessions. The day begins with three morning sessions if you live in the Americas, starting at 10am Central Time/3pm GMT. These sessions, while not beginner level, cover foundational topics in SQL Server such as indexing, statistics and bad performance habits that are required knowledge for any DBA. Jes, Erin and Aaron will show you practices and techniques that you can put to use today to achieve top database performance.
10am Jes Borland Index Methods You’re Not Using
11am Erin Stellato Updates to Statistics and the Effect on Query Performance
12pm Aaron Bertrand 10 Bad Habits that can Kill Performance
These sessions are followed by Wendy Pastrick showing us how to use our old friend Performance Monitor in a virtualized environment. This is important for so many DBAs dealing with virtual databases today, and knowing how to interpret PerfMon data is vital to pinpoint virtual DB performance problems.
1pm Wendy Pastrick Using Performance Monitor for your Virtual Servers
The afternoon delivers three sessions that show you how to approach, attack, and solve SQL Server performance issues. Janis, Brian and Brent will take you beyond the obvious and get you digging into areas of SQL Server you may not have known existed.
2pm Janis Griffin Looney Tuner? No, there IS a method to my madness!
3pm Brian Flynn Pivoting Performance Data & Pinpointing Problems
4pm Brent Ozar How the SQL Server Engine Thinks
Finally, Todd Kleinhas shows us how to quickly and easily build a SQL Server Lab using virtual machines to help us solve our performance issues. Make sure to catch this session if you are in need of spinning up environments to run through specific scenarios or to facilitate repeatable testing.
5pm Todd Kleinhas How to Build an Affordable SQL Server Lab
The Performance VC wants to thank our sponsor Confio whose support as our sponsor has helped us get this done for you. Click here to go to the Performance Virtual Chapter web site and register. See you Thursday!
This Saturday February 23 I’ll be in Silicon Valley speaking on Big Data for SQL Server DBAs for a SQL Saturday event. The SQL Saturday events have become so prevalent that it I see them as being grouped together by season. For me the spring season started a couple of weeks ago in early February when I went to Albuquerque for their inaugural event, which was very well put together. I was impressed with the participation, considering the size of the city, and the enthusiasm.
I went to the Silicon Valley event at the Microsoft offices in Mountain View, CA last year and it was a first-rate experience too. Everything was great, including the speakers, the food, and location. If you’ve been wondering what a SQL Saturday is all about, make it a point to attend one this spring. If you are in the USA, there will be one near you no matter where you live. There are also numerous events planned internationally.
I know Mark Ginnebaugh, the organizer of SQL Saturday in Silicon Valley, is putting together another fantastic event this year. I hope to see you there!