- That's So Metadata: Discover Your Database From The Inside presented by Rob Volk
Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team? SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you: - Document your database schema objects such as procedures, functions, tables, columns and indexes - Investigate performance and look for bottlenecks and tuning opportunities - Discover metadata to administer your databases backups, index maintenance, and security - Apply your own metadata using extended properties We will also cover the official Microsoft documentation on these features and other resources on how to use them.
- Watch Brent Tune Queries, presented by Brent Ozar
Ever wonder how somebody else does it? Watch over the virtual shoulder of Microsoft Certified Master Brent Ozar as he walks you through the Stack Overflow public database export, shows you two queries, and then tunes them to make them dramatically faster. Along the way, you'll see several free tools in action that help make the process easier. Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
- Double-Header Covering Migrations with AGs and Data, Data Everywhere
Beginning at 6:30, we'll have Elizabeth Noble teaching us how to "Migrate Your Database(s) with Distributed AGs". You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want. In this session, Elizabeth will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration. NOTE: This session is an intermediate level. Attendees are expected to already be familiar with Availability Groups. Elizabeth's BIO: Elizabeth Noble is a Database Engineer in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym. At 7:30ish, Rodney Landrum will present "Data, Data Everywhere, a lot of it is free". This session focuses on the techniques to discover, consume and analyze the limitless amounts of open data sets available for the taking. Pick any topic of interest and chances are there is a data set just waiting to be loaded into your favorite (and free) analytics tools. This process often yields fascinating results like you will see demonstrated in this session. Rodney's BIO: I spend 82.25 percent of my time thinking about proving concepts, writing about, talking about and implementing solutions for SQL Server technologies. I have an affinity for HADR, Reporting, BI, data analysis, SQL internals, capacity planning, architecture, virtualization, performance tuning and optimization and aggregations. The other 22 percent of my time I spend working on how to make accurate percentages. I work from home out of my Office Del Castillo. I am an author, sometimes-blogger and presenter on SQL technologies. I am happily back in Pensacola from Orlando, where the traffic was miserable.
- SQLSaturday Pensacola
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, Azure, Analytics and more! This event will be held on Jun[masked] at Pensacola State College. Register at: https://www.sqlsaturday.com/884/eventhome.aspx
- Rodney's Novel is Published! Celebrate with us June 21st, Gallery Night
We are excited to announce that Pensacola Bay Brewery is co-hosting our first "pop-up" book signing of Rodney's first published novel, Chronicles of Shameus. We'll be hanging out all night during Gallery Night on the patio at the brewery. We hope you'll stop by for a brew and pick yourself up a signed copy! Can't make it in person? You can check out the book at: https://www.amazon.com/Chronicles-Shameus-Rodney-Landrum/dp/0578508559/ref=tmm_pap_swatch_0?_encoding=UTF8&qid=1560441697&sr=8-1
- It's 2018. Why aren't you using Azure Search?
Open up your website. Click Search. Tell me, do you like what you see? Are you BLOWN AWAY by the functionality? Does it return the exact results you were looking for, and let you customize what you see? I’m betting that there’s more than a little room for improvement. Don’t worry, most people are in the same boat. What if I told you could build amazing search experiences with just a little bit of code – all backed by Microsoft’s Cloud? By implementing Azure Search into your sites, you can quickly provide result faceting, inline highlighting, synonym mapping, and even customized text analyzers. My name is Bryan Soltis and I’m a Technical Evangelist and Kentico and Microsoft Azure MVP. In this session, I’m going to introduce you to this often-overlooked cousin of the Azure family and show you how to build some amazing search solutions. And maybe a few Simpsons quotes along the way. Bryan Soltis is a Technical Evangelist at Kentico and Microsoft Azure MVP. With nearly 20 years of web development experience, Bryan has completed projects for Microsoft, IMG, HP, and other Fortune 500 companies. A former Azure VTSP, Bryan has developed numerous applications with Microsoft’s cloud and Kentico, including custom software development, integrated solutions, and globally-available enterprise applications. As a Technical Evangelist, Bryan enjoys working with the development community and educating developers on best practices, new technologies, and utilizing .NET, Azure, and Kentico to their fullest potentials. And he really likes beer.
- SQLSaturday Pensacola 2018
This event is free, outside of a $15 charge who those who would like us to provide a lunch. You are welcome to bring your own lunch. Whether you're a DBA, developer, helpdesk, business analyst, this event will have some great free training that seldom can you get locally here in Pensacola. Please register at: https://www.sqlsaturday.com/743/registernow.aspx Check out the full schedule at: http://www.sqlsaturday.com/743/Sessions/Schedule.aspx We are still accepting sponsors for this event. Details can be found here: http://www.sqlsaturday.com/743/Sponsors/SponsorPlan.aspx We look forward to seeing you there! Cheers, Team SQLSaturday Pensacola
- Getting Started with SQL Azure Database: What you need to know
Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease. Our presenter for this is Jim Donahue. Jim is a Database Administrator with RDX. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018. Jim is @SQLFlipFlopsDBA on twitter, which Karla just had to add because she loves this name...it's so fitting for a Florida user group!