What we're about
Upcoming events (2)
Session Details: Recent years have seen an increase in end-user reporting, where reporting tools, notably Tableau, are provided to business teams in order to offload analytics and reporting from Information Technology groups. In practice, this has often resulted in the rise of business reporting teams with varying levels of database and SQL skill. In this presentation I’ll discuss what it’s like to work on a business side reporting team, capabilities and limitations of Tableau, and business reporting team experiences with source data and data layer teams. Based on that review, I will propose best practices for DBAs and data architects to set up business reporting teams for success while maintaining data security and appropriate process. Speaker Bio: Bob Lambert is a Data Analyst in Anthem’s Medicare Revenue and Reconciliation group. As a developer of Tableau reports on a business team, he extracts data using SAS, Transact-SQL, and Teradata SQL. In a career as a consultant Bob worked in various roles including data architect, SQL developer, business analyst, project manager, and trainer specializing in data warehousing and business intelligence. Bob’s articles on analytics, data architecture, and agile methods are available at Information-Management.com, SmartDataCollective.com, and RobertLambert.net.
Session Details: 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 discuss sp_whoisactive and Query Store. Then 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. Attendees will see how easy it is to get good performance data and visualize in an interactive way and combine with other tools to troubleshoot issues. For an example, we will combine this solution with Query Store and/or sp_whoisactive to find a problem that occurred on a system and caused me to get my nap interrupted on a Saturday. Speaker Bio: Tracy is a Database Superhero. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy is a co-organizer TriPass local user group in Raleigh, NC. She tinkered with databases in middle/high school to keep her sports card collection organized. Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court. This is her life’s passion outside of Database Platforms, her favorite and most important job.