Het team achter SQL Zaterdag doet er in het najaar een schepje bovenop, we organiseren namelijk een PASS SQL Rally. Op woensdag 6 t/m vrijdag 8 november is de Meervaart in Amsterdam de plek om kennis te vergaren en te netwerken. De top van de SQL Server sprekers komen samen om sessies te verzorgen.
Het wordt niet zomaar een conferentie, je mag naast top sessies, en pre-conference seminars ook vele andere mogelijkheden om te netwerken verwachten.
Samen met onze vrienden van Microsoft en o.a. Thomas Kejser van onze hoofdsponsor FusionIO organiseren we de meest intense ask-the-expert locatie die je ooit gezien zult hebben.
De inschrijvingen zijn geopend en je kunt tot 5 juli gebruik maken van de Early Bird prijs.
Voor PASS NL leden hebben we een discount code beschikbaar die je hier kun lezen als je inlogt op deze site (Een account maken kost niets en verplicht je tot niets)
Voor de BI liefhebbers werken we nog aan een goeie pre-con, er zijn voor de DBA’s echter al een paar mooie keuzes te maken. De pre-conference seminars die op dit moment bekend zijn vind je hieronder. De beschikbare plaatsen hiervoor zijn beperkt, wees er dus snel bij!
We hopen veel bekende gezichten te zien in Amsterdam in het najaar.
En mochten jullie suggesties hebben om het evenement nog interessanter te maken dan horen we het uiteraard graag.
Bezoek de site voor meer informatie en de link voor het registreren…
Tot in het najaar!
Adam Machanic / Data Education
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. Focusing on large-scale data warehouse performance and development, he is author of the award-winning SQL Server monitoring stored procedure sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press, 2009) and Expert SQL Server 2005 Development (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft MVP for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.
No More Guessing! An Enlightened Approach to Performance Troubleshooting
by Adam Machanic
Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when.
In this full-day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper―pinpointing the exact problem and helping you quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.
Brent Ozar / Brent Ozar Unlimited
Brent Ozar specializes in making SQL Server faster and more reliable. He is a Microsoft Certified Master of SQL Server and an MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com.
This Year’s SQL Server Setup Best Practices
by Brent Ozar
You don’t build a lot of SQL Servers, but this year, you need to build one for your company – and it’d better work. You need it to be reliable and fast the very first time. Unfortunately, everything keeps changing, and yesterday’s best practices don’t cover solid state drives, FusionIO, AlwaysOn Availability Groups, and clusters without shared storage. In this all-day session, Microsoft Certified Master Brent Ozar will bring you up to speed. He’ll teach you how to pick storage, when it’s okay to use virtual servers, how to turn business requirements into clustering/mirroring/AlwaysOn/log-shipping, and where to put your data files, log files, and TempDB. This session is for developers and DBAs who need to pick SQL Server hardware and aren’t sure about the options today.
Denny Cherry / Denny Cherry & Associates Consulting
Denny Cherry specializes as an independent consultant working with platforms such as SQL Server, VMware’s vSphere, Hyper-V, and enterprise storage platforms such as EMC’s CLARiiON, DMX, VNX, VNXe, vMAX, vBlock, Celerra, etc. as well as IBM’s XVI array and NetApp’s filers in addition to a variety of server hardware platforms including blade systems such as isco’s UCS platform and C series servers I have over 12 years of experience working with enterprise solutions in a variety of capacities.
Storage and Virtualisation for DBAs
by Denny Cherry
This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution.
The storage portion of this session will focus on SAN storage, but most of the material will apply to direct attached storage as well.
In the first half of the session we’ll be focusing on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. Itís also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, weíll be looking at storage from both the database and storage perspectives. Weíll be digging into LUNs, HBAs, the fabric, as well as the storage configuration.
After going over the components we’ll dig into some advanced storage configurations. This includes RAID groups, multi-pathing software, and proper redundant storage network design. We will also be digging into some advanced storage array backup techniques including taking storage level clones and snapshots. After going over these advanced techniques we will dig into how these can best be used to backup the SQL Server environment to provide maximum redundancy with no recurring tape costs.
In addition to theory, weíll be looking at an actual SAN so that we can translate what we see in the Storage Array with what we see on the actual server.
In the second half of the day we’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically weíll be looking into when itís a good idea and when itís probably not a good idea. Like everything in the database world there are no hard set answers as to if virtualization is a good idea or not, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and virtualization isn’t a good idea. Weíll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
We’ll look into how tie the virtual platforms to the storage array so that you can maximize the storage performance for your SQL Servers and the virtual environment.