- Building Your First SSRS Report
Session Details -- SQL Server Reporting Services is one of the most popular reporting tools on the planet. Using it you can create reports not just for business users but to assist in your daily server management. In this session, Building Your First SSRS Report, you will gain the ability to create professional looking reports for SQL Server Reporting Services. First, you will learn to create a report using the Report Wizard. Next, you will discover how to generate a report manually, giving you more fine tune control over the report creation process. In addition you will learn to add professional touches such as charts and parameters. Finally, you will explore how to deploy your reports to the SSRS Report Portal for your entire organization to use. When you’re finished with this session, you will have the skills and knowledge of SQL Server Reporting Services needed to create great looking reports. Speaker Details -- Robert C. Cain (http://arcanecode.me) is the owner of Arcane Training and Consulting, LLC. Robert creates online courses for Pluralsight and has coauthored five books, is an author for Red Gate's Simple Talk website, in addition to his YouTube activity. He was also a Microsoft MVP from[masked]. A popular speaker, Robert has presented at events such as the PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.
- Robert Cain - The Joy of DevOps
Session Details -- Let's face it, your company is a mess. Well, it is if it's like most companies. Long release cycles, failed implementations, constant firefighting. You may have heard the term "DevOps" as a possible solution, but just what is it? Just as Dr. Goldratt revolutionized manufacturing with his book "The Goal", the founders of the IT Revolution have brought those same techniques to IT. In this session, we'll start with a fundamental understanding of the three ways of DevOps: Flow, Feedback, and Continuous Learning and Experimentation. We'll discuss examples of all three areas, and how they can be implemented in your organization. You'll see how Agile and Kanban fit into the DevOps framework. Finally, you'll learn how you can begin implementing DevOps on a personal level, affecting change even from a non-management position. Along the way the presenter will share stories of personal experiences from his 25 years in the IT field. Speaker Details -- Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate's SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
- John Baldwin - All About That Bass – Baselining SQL Servers
All About That Bass Base – Baselining SQL Servers As SQL Server DBAs, we can agree that baselining our SQL Servers is an essential task as part of our job function that we should all be doing on a regular basis. It provides us with valuable metrics to compare over time about how our SQL Servers are performing with the resources that they have under their given workload. In this session we will delve into the options for collecting baseline metrics and also look at a free tool to help analyze those counters once they have been collected. John Baldwin is an Enterprise SQL Server Database Administrator at the University of Alabama at Birmingham. During his IT career which began in 2000 he has worked with SQL Server starting with version 7 all the way up to the current version as a SQL Developer, DBA and Database Architect. He is active in the local SQL Server community and has been President of Steel City SQL, the Birmingham Chapter of the Professional Association for SQL Server (PASS), since 2008 and has organized or co-organized 10 SQL Saturdays in Birmingham and Atlanta starting with SQL Saturday #7 back in 2009.
- Azure DevOps, Continuous Integration & Pipeline Automation: Rule Them All
Session Details - Do you want to make your deployments risk-free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your team? Are your application and database deployments separate processes? Do you encounter issues while deploying your database changes? Is your database slowing you down? If the answer to any of the questions is yes, then this presentation is for you. You will understand the problems with traditional database development and why organizations are moving toward achieving continuous integration and database DevOps. You’ll also learn about the toolsets that will assist you in this journey towards painless database deployments in the Microsoft Platform. Speaker Details - Samir Behara is a Solution Architect with EBSCO Industries and builds software solutions using cutting edge technologies. He is a Microsoft Data Platform MVP with over 12 years of IT experience. Samir is a frequent speaker at technical conferences and is the Co-Chapter Lead of the Steel City SQL Server UserGroup. He is the author of www.dotnetvibes.com.
- Louis Davidson - How to Implement a Hierarchy in SQL Server
Session Details: One of the most common structures you will come across in the real world is a hierarchy (either a single parent “tree” or a multi-parent “graph”). Many systems will implement the obvious examples, such as a corporate managerial structure or a bill of materials. It turns out that almost any many-to-many relationship can be used as a hierarchy to find the relationship of parent rows to child rows (for example, the relationship of actors to movies they’ve been in). In this session, we’ll discuss several different implementations of hierarchies that you can use to optimize your hierarchy implementations, including SQL Server 2017’s graph tables, and put into practice immediately, with ready-made T-SQL examples. Speaker Details: Louis Davidson has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.
- 2018 Birmingham Dev BBQ (2nd Annual)
Join us for the 2nd Annual BHM Dev BBQ hosted by ITAC Solutions on July 31st at 6 PM. Like last year, this is a joint event with many of the local technology user groups including BASE, BHM.NET, SteelCity SQL, and many more, so it's a great way to connect with devs outside your typical scene! Our host and sponsor, ITAC Solutions is also graciously providing plenty of Full Moon BBQ, beer, raffles, prizes and more, so it's sure to be a great time! Please signup here -- https://www.eventbrite.com/e/2018-birmingham-dev-bbq-tickets-48142006036
- Neal Sivley - Auditing with Temporal Tables
Session Details: Auditing with temporal tables in SQL Server 2016. This type of auditing lets you have point-in-time data access. No need for creating triggers or stored procs to handle your auditing needs. It’s now all built-in, including the ability to query it without complex views or unions. Speaker Details: Neal Sivley is a Senior Database Administrator with Jack Henry & Associates, Financial Crimes division. He has been working in the information technology field for over 20 years including Help Desk Support, Server Admin, Network Admin, .Net Developer (It is NOT the database!) , and Database development and administration. He has certifications for Microsoft SQL Server, IBM Db2 and PostgreSQL.
- Brent Ozar - What to Do When SQL Server is Slow
Session Details: Someone comes running in and asks, "Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow." It's one of the most common complaints we get about our databases - and yet, most of us don't have a written plan with what steps to take, in order. I do this for a living, so I've had to make a written checklist to handle it. I'll give you the exact same checklist I use, then walk you through several performance emergencies. I'll show you how I use open source scripts like sp_WhoIsActive, sp_BlitzFirst, sp_BlitzCache, and more to find the root cause fast. We won't cover performance tuning - our goal in this hour is just to have a written triage process so we don't look like bumbling idiots. Let's get good at this! Speaker Details: 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.
- Robert Cain - Getting started with the new Kusto Query Language
Session Details: Azure provides some powerful tools to managing your infrastructure. Azure Log Analytics, Application Insights, and Windows Defender Advanced Threat Protection to name a few. But how to uncover the data inside them, to provide the most from the information they contain? That's where the new Kusto Query Language (KQL) comes to the rescue! KQL provides an easy to understand way of querying these underlying datasets to extract custom reports. Beyond that it has the ability to do Machine Learning based on data within the KQL environment. But as they say on TV, wait there's more! KQL interacts with the outside world. It can export to CSV, and even PowerBI! It also has the ability to import data from SQL Server and Python, further extending the dataset it can report on. Whether you just run a few SQL Server's in Azure VM's, or your entire corporations infrastructure in Azure, understanding the Kusto Query Language will be critical to understanding and managing your Azure platform. Speaker Details: Robert C. Cain (http://arcanecode.me) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, an author for Red Gate's Simple Talk site, and co-author of 5 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.
- Tim Radney - An Introduction to Azure Managed Instances
Session Details: Have you been hearing about Azure Managed Instances and want to know what all the fuss is about? Come see how Managed Instances is changing how we think about cloud databases. Managed Instances can be considered a hybrid of Azure SQL Database and on-premises SQL Server with all the awesome benefits of Platform as a Service. You’ll get to see first-hand how easy it is to migrate databases from on-premises to a Managed Instance. We’ll explore the differences between Azure SQL Database, Managed Instances, and SQL Server on an Azure VM to help you determine what is the best fit for your organization. If you’ve been considering Azure for your organization, this session is for you! Speaker Details: Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens, crops, and tilapias in his spare time. Email: [masked] Website: http://www.SQLskills.com Full Bio: http://www.sqlskills.com/about/tim-radney/ Blog: http://www.SQLskills.com/blogs/tim Twitter: http://twitter.com/TRadney Microsoft MVP since 2014