This Month’s Speaker : David Stokes
David has been working as a SQL Server database administrator for the past 19 years. He has worked extensively with all versions of SQL Server from 2000 to 2016. He spent the first 14 years working as a Department of Defense contractor with Northrop Grumman and Lockheed Martin. He worked on various contracts for US Joint Forces Command and the Department of the Army. He is currently employed by Ferguson Enterprises (the nation’s largest supplier of plumbing and HVAC equipment) in Newport News. His primary focus has been on making the Relational engine “go faster” when the end users complain that “the database is slow.” David has been an active member of PASS since 2005 and help revive the Hampton Roads SQL Server Users Group (HRSSUG) as a member of the leadership team in 2014. He regularly attends SQL Saturdays and any other SQL Server training events whenever possible. In his off time David enjoys drawing, golf and reading science fiction.
A Brief Introduction to the PowerShell DBATools Module
SQL Server DBAs are busy! Whether you work as part of a team for a large organization or are the “lone DBA” in a SMB, time and money to train on new technologies is difficult, if not darn near impossible, to come by. As SQL Server DBAs, we’ve been hearing about the need to learn PowerShell for a number of years. It’s part of Microsoft’s Common Engineering Criteria (all server product functionality, even in the GUI, behind the scenes, must be able to be done using PowerShell.) Several prominent members of the SQL Server community have been evangelizing the product for years. We’ve all heard the reasons, but I never found that one compelling, “A Ha” reason to learn this new “scripting language” (Hint: it’s more than a scripting language!) …. until now!
A few years ago, a talented DBA (Crissy Lemaire, @cl) was assigned the task of migrating many SQL Servers supporting SharePoint. She knew there had to be a better way than just manually generating all the T-SQL scripts and so was the genesis of the PowerShell DBATools module. This open source module is being built by a dedicated group of PowerShell and SQL Server folks, specifically to make the job of SQL Server database administration easier.
This presentation is designed to give a brief overview of the tools and demonstrate several of the commands that changed this “GUI Guy” into a newbie, “wanna-be” PowerShell aficionado.
Speaker – Kenneth Jensen (view bio)
Session – Amazon Web Services (AWS), business and the data professional
In this session we will discuss why businesses of all sizes and verticals are moving to the cloud and what impact that business decision is having on all data professionals.
We will cover what services and solutions Amazon Web Services (AWS), the largest public cloud provider, has to offer so businesses and data professionals can remain competitive.
With a bias towards SQL Server, we will discuss; EC2, RDS, Glacier, S3, Glue, Redshift, Lamdba, Active Directory, alerting, data migration solutions and the AWS marketplace. We will also identify which third party SQL Server tools work with AWS.
By the end of the session you will understand the advantages the AWS cloud gives business and what tools are available for the data professional. You will be able to create your own free AWS account and start exploring AWS.
Register for this meeting
Monthly Meeting Announcement
This Month’s Speaker : Devin Jaiswal, Microsoft
Devin is a part of a highly skilled architecture team dedicated to delivering a high return on investment for our client’s IT spend in the data platform space. Devin’s rich history in business analytics, management information reporting, IT compliance, and production environment management provides a unique cross section of experience that allows him to assess performance along the entire data delivery chain (source extract, ETL, data modeling, BI reporting, and ad hoc analytics). This ability to address all aspects of the client’s environment provides the increase in business value clients realize from their business intellectual property.
Introducing Azure SQL Database Managed Instance
SQL Database Managed Instance is an expansion of the existing SQL Database service designed to enable database migration to a fully-managed database service, without re-designing the application.
It’s important to note that Managed Instance isn’t a new service – it is a third deployment option within Azure SQL Database, sitting alongside single databases and elastic pools. As part of Azure SQL Database, Microsoft’s fully managed cloud database service, it inherits all its built-in features.
Discount Code to PASS Summit
Thanks to our Sponsors!
Speaker – Jim Donahoe (view bio)
Session – Getting started with Azure SQL 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.
Register for this meeting
Speaker – Tracy Boggiano (view bio)
Session – Collecting Performance Metrics
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.
In this session, we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.
Register for this meeting