- 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!
- 2017 SSIS Scale Out Packages for High Availability & Disaster Recovery
2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment. Speaker bio: Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul's database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul's responsibility now, he has also been a Production DBA, worked heavily in the GIS database community, and has been known to use SQL Server in an AWS cloud environment. Also for those who are new or haven't noticed, the next SQLSaturday Pensacola (http://www.sqlsaturday.com/743/eventhome.aspx) event is open for registration. This year's event will be held on June 2nd. Start spreading the word! We are looking for sponsors and speakers for both the SQLSaturday and for this user group. Please contact me if interested or know of anyone who may be interested. We hope to see you in February! Cheers, Karla and Rodney
- Holiday Dinner Get-together
Hello Pensacola SQL Members, For the month of December we will not be hosting any training, but instead would love to just get together for dinner and drinks. We typically don't have enough time every month at the meetings to network, so hoping this will allow the members the chance to get to know each other better. We have space reserved at Buffalo Wild Wings on Bayou Blvd. We'll be there at 6:00 for drinks, then dinner will be at 6:30. Everything consumed will be "dutch" (no sponsors for this...keeping it very low key and casual - although we may have a giveaway or two). Please feel free to bring your significant other or a friend. Please be sure to RSVP on this meetup, as we have to give BWW a final head count the day prior. We hope to see you many of you there as we wind down 2017! Cheers, Karla and Rodney
- Monster Text Manipulation: Regular Expressions for the DBA, by Sean McCown
Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods. Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in high-end 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. He is also an international speaker and the creator and author of the wildly popular (and free) Minion Maintenance tools and is President and Chief Architect of MinionWare Software.