• It's 2018. Why aren't you using Azure Search?

    Pensacola State College

    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.

    1
  • SQLSaturday Pensacola 2018

    Pensacola State College

    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

    4
  • Getting Started with SQL Azure Database: What you need to know

    Pensacola State College

    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!

    1
  • 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

    3
  • Holiday Dinner Get-together

    Location visible to members

    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.

    2
  • Why Defragmenting Your Indexes Isn't Helping, presented by Brent Ozar

    For years, you've heard that you're supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense - keep things in order, right? But you keep doing it, and SQL Server isn't getting any faster. You've even heard that setting fill factor will help prevent fragmentation, and you're doing that too - but your indexes still keep getting fragmented every day, and users aren't happy with performance. This advice made a lot of sense at the turn of the century, but today, things are different - and we're not just talking solid state drives. In just the first 15 minutes, you'll have a series of ah-ha moments when you realize that your daily index maintenance jobs might just be making the problem worse instead of better. Then, you'll learn what you need to do instead. This session is for people responsible for the care and feeding of production SQL Servers. You don't have to have the word "DBA" in your job title - you just have to be the one responsible. This session is for people responsible for the care and feeding of production SQL Servers. You don't have to have the word "DBA" in your job title - you just have to be the one responsible. 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. He holds a bunch of certifications and awards including the rare Microsoft Certified Master. Be sure to let your friends and colleagues know about this one. It's going to be a great one! And as a reminder, anyone who brings a first timer (and they join the meetup), you'll be entered into a drawing for a $25 Visa gift card. We'll see you in a couple of weeks!

    8
  • SQLSaturday Pensacola 2017

    Pensacola State College

    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free training event, the only charge which is optional if you want to bring your own lunch, is a $15 fee to cover lunch, beverages, and that ever so needed coffee. Please register soon as seating is limited, and let friends and colleagues know about the event. Please be sure to RSVP at the main website: http://www.sqlsaturday.com/617/eventhome.aspx If you only RSVP on the meetup, you won't be able to win any of the great prizes that the sponsors will be raffling off...everything from several $100+ gift cards to an XBox One!

    2
  • Baseball Analytics: SQL Server 2016 In-Database R, presented by Bradley Ball

    With baseball season nearly upon us here in Pensacola and for the Blue Wahoos, this seemed like an appropriate and exciting topic for our group! This session is meant to dive into the world of R using awesome data to make learning memorable. We will discuss a brief overview of the syntax, how to write an In-Database R query, and then dive into a data set using the Lahman database & data from Retrosheets.org to examine baseball games from 1990 – 2016 to answer the following questions: If I want to see my team win a game should I go to a double header? What is the best day of the week to see my team play? What is the best day if they are above .500 or below? What if they have home vs. away games? Then we will display the results in Power BI or and Excel Dashboard. Come for the Science, stay for the data! Bradley Ball is currently a Premier Sr. Consultant for Microsoft on the PSfD Team, Premier Support for Developers. He is a current Microsoft MVP Reconnect member and former MVP. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and is the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at many SQL Saturdays, for PASS SSUG’s across the US from California to Florida to New Hampshire, SQL Rally, DevConnections, SQLBits 2015, TechReady 24, SQL Live[masked], & the PASS Summit[masked]. He wrote Chapter 14 Page & Row Compression for PRO SQL Server 2012 Best Practices and he can be found blogging on the Deeper Insights blog on MSDN https://blogs.msdn.microsoft.com/deeperinsights/ or on http://www.sqlballs.com about anything else that interests him. Be sure to RSVP, and let your colleagues know about it! We'll also be discussing the upcoming SQLSaturday event being held at Pensacola State College on June 3rd. See you April 27th! Cheers, Karla and Rodney

    4
  • SQL Sons of Beaches Tour with Denny Cherry and Grant Fritchey

    Pensacola State College

    Pensacola SQL is excited to announce the SQL Sons of Beaches Tour. A fabulous expert line-up of data professionals will be touring throughout the entire state of Florida, starting first right here in our beautiful city! Microsoft MVP Grant Fritchey will be presenting: The Query Store and Query Tuning in SQL Server For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store. This session will explore how the Query Store works and how it’s going to change how you tune and troubleshoot performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need to apply it to your own SQL Server 2016 tuning efforts as well as your Azure SQL Databases. Microsoft MVP Denny Cherry will be presenting: Optimizing SQL Server in a Virtual Environment In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be. This will include how to look for CPU performance issues at the host level. We will also be discussing the Memory Balloon drivers and what they actually do, and how you should be configuring them, and why. We'll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server. Then we will finish up with some storage configuration options to look at. Learn how to get the most from your SQL Servers which have been virtualized. Learn how to configure SQL Servers to play nice within a virtual environment without compromising performance. Learn which battles to fight and which to let the VMware/Hyper-V admin win. We'll have some good eats (BBQ this meeting), along with some great giveaways from our sponsors Redgate (http://www.red-gate.com/?gclid=CjwKEAiA6rrBBRDsrLGM4uTPkWASJADnWZQ4PAxaCnt7_k83osExGsuVbNIYraVG6TPSQXvDF0JVChoCpl3w_wcB), SIOS Technology (http://us.sios.com/), and ScaleArc (http://www.scalearc.com/). We hope to see you there!

    7