SQLSaturday #649 - Jacksonville 2017

Event Date: 08/12/2017 00:00:00

Event Location:

  • The University of North Florida Campus
  • 1 UNF Drive
  • Jacksonville, Florida

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Supercharge Your Maintenance Plans!

Abstract: Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.


  • Troy Gallant

Track and Room: Enterprise Database Administration Deployment - 1201

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract: This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.


  • Jeff Taylor

Track and Room: Enterprise Database Administration Deployment - 1202

Title: Create lightning fast Dashboard with Power BI and its Components

Abstract: Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.


  • Vishal Pawar

Track and Room: Analytics and Visualization - 1205

Title: In a Perfect World, Azure is Green… Green as in, all is well

Abstract: This session will present the fundamentals needed to setup monitoring and alerting for a global Azure PaaS application to insure the application is available to your customers and is performing correctly.

I’ll review the Azure Portal navigation fundamentals in order to demonstrate how to monitor uptime and application performance for a globally deployed Azure PaaS application currently in use by major companies like ATT, Bell, and Vodaphone. Coverage will included how to monitor and alert on individual components in the Azure Portal, setting up alerts in Application Insights and configuring shared dashboards so that a production support team on a Follow-The-Sun schedule can effectively monitor the application.


  • Ronald Dameron

Track and Room: Cloud Application Development Deployment - 1104

Title: Intro to MongoDB for SQL DBAs

Abstract: MongoDB is an open-source, document-oriented NoSQL database that provides high performance, high availability, and easy scaling. It has become the leader in non-relational database for Fortune 500 companies and SQL DBAs are inheriting the responsibility to deploy and maintain this new technology with little outside help and training. This session will focus on educating SQL DBAs in the necessary skills needed to perform day to day tasks to keep your MongoDB healthy, available and fast. This presentation will introduce MongoDB, provide a brief overview of the NOSQL platform, how to get started with MongoDb, patching MongoDB instances, intro to replica set, setting up backups restore and if time allows a brief introduction to perform most of these operations through Ops Manager 3.4.


  • Ahmad Drshen

Track and Room: Enterprise Database Administration Deployment - 1104

Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Abstract: In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered! In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!


  • Luis Figueroa

Track and Room: BI Information Delivery - 1103

Title: Using R, SQL Server Advanced Analytics, and Baseball to Hit a Home Run

Abstract: The last two releases of SQL Server provided the capability to use SQL Server as the hub in a hub and spoke model for big data and data science. Our hub will use R In-database advanced analytics and Power BI. The technology is impressive, but data needs to be interesting. We are using data provided by RetroSheets.org to create a data set of play by play data and box scores for Major League Baseball games from 1922 to 2015. We set out to discover the answer to questions every baseball fan wants to know! Do you have a better chance to see your team win by going to a Double Header or regular game? Is there ‘a the best day of the week’ to see your favorite team win? How do winning and losing seasons impact this or home and away games? Come for the baseball, stay for the science!


  • Bradley Ball

Track and Room: Advanced Analysis Techniques - 1205

Title: Training by the Twos: Two Sites, Two Tools, Two Tidbits

Abstract: Come join Susan Schneider for a new session on how to move from the non-technical realm to the fully employed technical realm, as she explores the latest free learning sites and developer tools for 2017; she will also throw in her top learning tidbits to help you excel in your career. Building on her SQLSaturday session from last year, Susan makes it easy to get started on the technical path by utilizing free learning sites and training. We can’t learn everything all at once, but we can focus on what will provide us the best leverage in today’s technical job market. We’ll focus on the top two 2017 free training sites to expand your technical skills, the top two Business Intelligence presentation tools you need to know, and the top two tidbits to increase your professionalism and efficiency levels.
Join Susan as we continue our technical journey and increase our learning pace, two at a time!


  • Susan Schneider

Track and Room: Professional Development - 1102

Title: Training: Have It Your Way (Lunch time Session)

Abstract: Stagnancy in learning and personal growth often leads to frustration and undesired stress. It is vital to our everyday success that we seek to not only better ourselves through professional and personal development, but it is just as critical to ensure the methods we are using to absorb this content are effectively presented and better suit our learning abilities.

I believe the question we need to answer, is not what we’re learning, but rather how do we best learn? In this session, we will discuss three popular training methods and how we can customize these options to best fit our needs.

This session will help the attendees better prepare themselves for Learning Development and will motivate the attendees to take action.


  • Kenneth Wood

Track and Room: Professional Development - 1209

Title: DevOps for the DBA

Abstract: DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.


  • Kellyn Pot’Vin-Gorman

Track and Room: Enterprise Database Administration Deployment - 1209

Title: Running SQL Server in AWS

Abstract: Amazon Web Services (AWS) is the world’s largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.


  • Brian Carrig

Track and Room: Cloud Application Development Deployment - 1205

Title: How to be a Great DBA

Abstract: Please join me in this adventure of being a Great DBA. In this session you will learn what is needed and how you can get there. Measure / Automate / Promote Measure = How to get the numbers your manager wants to see Automate = Automation as a tool to improve your career Promote = Share your knowledge, create on the side projects


  • Valentin Iamandi

Track and Room: Professional Development - 1209

Title: Virtualize FCI and Availability Groups

Abstract: High availability can be different when in a virtual environment. Attendees will learn the pros and cons of running SQL server clusters or AlwaysOn Availability Groups in a virtual environment. Comparing all of the different high availability options between all of available technologies. How features of VMware and Hyper-V are impacted and how to work with the administrators of virtual environment. Walking through all of the storage options to determine which one is the best fit. Review key settings and configurations for the virtual platform, the virtual machine, and SQL server, and show which need to be set to ensure proper performance.


  • Shawn Meyers

Track and Room: Other - 1102

Title: Handling Late Arriving Dimension Records in a Datawarehouse using SSIS/SQL

Abstract: Data Warehouse Theory can be a tough nut to crack. A late arriving dimension record tends to occur when you receive a fact record before the dimension record arrives in the data warehouse so you must create a placeholder record.

In this session, we will give you a brief overview of Facts and Dimensions, and then do an in-depth discussion on what late arriving dimension records are, why they are important, and how to handle them. We will explain how not properly handling these can negatively affect your Financial Reports. We will also cover how to correct those records in the data warehouse once the proper dimension record arrives on the doorstep of the data warehouse.


  • Felix Asencio

Track and Room: BI Information Delivery - 1103

Title: What’s New In SQL Server 2012/2014/2016 For The Developer

Abstract: This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.


  • Jeff Taylor

Track and Room: Application Database Development - 1209

Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Abstract: SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.


  • Dmitri Korotkevitch

Track and Room: Enterprise Database Administration Deployment - 1205

Title: Tell the story with Power BI visualizations embedded in your web site based on Azure Data

Abstract: Honey, Let Me Drive!
See how husband and wife tech team, Steve and Susan Schneider, set up a Florida traffic database in Azure and build dynamic interactive presentations using Power BI, without killing each other or ‘driving’ each other crazy!
In this fast pace seminar, you’ll get a quick overview of how to set up an Azure database and move data to Azure; then it’s off for a road trip with Power BI. Using Power BI visualizations, we’ll answer some questions like: 1- What color of vehicle is most likely to be in an accident 2- What make and model get into crashes most often 3- What counties in Florida have the highest amount of accidents? Hint: It is not Duval! 4- Do more accidents really happen on one day of the week over another day? And much more! Come along on this trip to see how you can stand up your own database in Azure and use Power BI to make your data ‘ready for the road’


  • Steve Schneider

Track and Room: BI Information Delivery - 1104

Title: Are They Hearing What You Said - or Something Completely Different?!

Abstract: In this 60 minute interactive workshop, attendees are given the knowledge tools to take charge of their listening skills to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” volunteer activity called the “Alien Press Conference” – a hilarious take on verbal non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn: • How to control their voice tone and inflection to improve their message delivery; • How to develop and improve their active listening skills; • How to use non-verbal cues to their advantage; more


  • Brad Raney

Track and Room: Professional Development - 1209

Title: Dynamic Data Flows in SSIS without Programming

Abstract: This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.


  • Diane Schuster

Track and Room: BI Platform Architecture, Development Administration - 1205

Title: A Tour of Cloud Data Platforms as a Service

Abstract: With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.


  • Richard Weiss

Track and Room: Cloud Application Development Deployment - 1104

Title: Creating Predictive Models using Azure Machine Learning

Abstract: Azure Machine Learning is a fully managed predictive analytics service that you can use to create predictive models against your data in SQL Data Warehouse, and then publish as ready-to-consume web services. You will learn how to read data from your database; how to create, train, and score a predictive model; and how write data to your database or create a web service.


  • Bogdan Visinescu

Track and Room: Analytics and Visualization - 1205

Title: Database Project Makes Deployment Consistent

Abstract: The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.


  • Thomas Norman

Track and Room: Application Database Development - 1102

Title: XpressInsight Framework as a Service - Rapid Implementation Data Warehousing Solution

Abstract: XpressInsight is a Framework as a Service product that provides the modules and tools to rapidly implement an Enterprise Data Warehouse and Business Intelligence solution, at a fraction of the cost. It is built entirely on the Microsoft BI stack using SQL Server 2016, SQL Server Analysis Services (tabular), SQL Server Reporting Services, and Microsoft Power BI. In this session, we will demonstrate loading a data warehouse from multiple sources (A SQL server on Windows and an ORACLE DB on Linux) into a Kimball style dimensional model. We will demonstrate how to measure and report on data quality, correct data quality issues, load auditing, self-service reporting with SSRS and Power BI, and publishing your Power BI reports and dashboards to the cloud while allowing those applications to retrieve the data from a secure on-premise location.


  • Paul Williams

Track and Room: BI Platform Architecture, Development Administration - 1103

Title: Beyond the Stars…Alternative Date Warehouse Structures

Abstract: Beyond the Stars…Alternative Date Warehouse Structures to Empower Your Reporting and Analytics Team. Star schema has become ubiquitous with Data warehouses and unless you have a well define cube modeled on top of it, they can be difficult for even experienced report writers to use. In this session, we will explore alternative structures that once built, with allow for rapid report development, by anyone who can write a simple select statement; empowering your developers to provide business insight without the dubious task of ‘starting from scratch’.
The following concepts and structures will be discussed: • Base/Detail Structures • Current State Structures • ‘Point In Time’ Data • Band Structures • Lifecycle/Timeline Structures Additionally, we will discuss the importance of granularity, naming, object selection and refresh rates within the context of the aforementioned SQL structures.


  • Thomas Banyan McGowen

Track and Room: BI Platform Architecture, Development Administration - 1201

Title: Migrate your enterprise reporting into Power BI: process canvas, pitfalls best practices

Abstract: In this session, we will discuss how to efficiently migrate your retrospective analytics from where it is now to Power BI, and do it in a way that saves you time in the future.

Some of the topics include: • How to create a solution that is simple, automated, standardized and scalable • How to avoid common pitfalls and “death by a thousand reports” • How to most efficiently distribute the reports afterwards


  • Taras Kaduk

Track and Room: BI Information Delivery - 1202

Title: DataViz 101 - Creating Effective Visualizations

Abstract: Bar graph, or pie chart? Color, or grayscale? Percentage, or absolute numbers? If you ever asked yourself these questions before presenting data, ever needed to put together a graph and didn’t know where to start, ever wanted your numbers to make a bigger splash - this talk is for you. We will cover the “why” and “how” of data visualization; and explore the do’s and don’ts. Come learn something new!


  • Haim Shternshus

Track and Room: Analytics and Visualization - 1202

Title: Embed analytics into your web apps using Power BI

Abstract: In this presentation I will be showing you how to get Power BI added to your current web application. We will be using the Power BI API’s to embed the analytics into you company web application.


  • David Liebman

Track and Room: Analytics and Visualization - 1103

Title: Tracking Change is the Backbone of Your Data Platform

Abstract: Features or concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I’m here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.


  • Doug McClurg

Track and Room: BI Platform Architecture, Development Administration - 1201

Title: Power BI Administration and Governance

Abstract: Power BI is an incredible tool and as more companies and individuals adapt this new technology it is time to turn our focus from report development to Administration. Noone really wants to discuss Administration but it’s important to understand the security risks and how to mitigate those risks through proper administration. In this session, we will discuss an overview of Power BI Administration as it relates to security and governance.


  • Mitchell Pearson

Track and Room: BI Platform Architecture, Development Administration - 1202

Title: SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain

Abstract: SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain I will share my experience over the years in Staffing to provide some tips and tricks to help the community. I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!


  • Ben Cusson

Track and Room: Professional Development - 1202

Title: How To Fully Automate Database Deployments

Abstract: This session will cover how to setup your database source code in a source code repository and configure continuous integration and continuous deployment of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.


  • Jeff Taylor

Track and Room: Application Database Development - 1102

Title: Does your performance tuning need a 12-step program?

Abstract: Performance tuning can be complex.It’s often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

  1. Quickly fine tune a SQL statement
  2. Identify performance inhibitors to help avoid future performance issues
  3. Recognize and understand how new SQL Server features can help improve query


  • Janis Griffin

Track and Room: Enterprise Database Administration Deployment - 1209

Title: Json document generation using Integration Services

Abstract: How you can create json documents for sql server 2014 and below using integration services? On this session we are going to cover what is needed, how it can be done. This session will show you each step of the way to finally deliver that Json document across your organization.


  • Jorge Novo

Track and Room: Application Database Development - 1102

Title: Deploying SQL 2016 with PowerShell DSC

Abstract: If you need a dependable way to deploy SQL time after time, Powershell DSC provides methods for customizing deployments based on the type of role the Database server will take in your environment. Even though the SQL installer already has a script builder for automating installs, by using PowerShell DSC and community resources you may either push or pull a deployment to a full gui or core server.


  • Joshua Corrick

Track and Room: Enterprise Database Administration Deployment - 1102

Title: What’s new in Reporting Services 2016

Abstract: With the release of SQL Server 2016, Microsoft has blown the dust off the tried and true SSRS and injected some much needed life. SSRS 2016 introduces a shiny new portal with a new Dashboard/Mobile report types. In this session, we’ll take a look at what has changed in SSRS 2016 and how to get up and running using the new Dashboard/Mobile reports. Through demos we’ll walk through everything you need to create your first Mobile ready SSRS 2016 Dashboard!


  • Chris Albrektson

Track and Room: BI Information Delivery - 1104

Title: Using Word Clouds to Sneak Past Applicant Tracking System

Abstract: Ever wonder why your resume ends up in a black hole when you submit it online? You know what your resume looks like, but do you wonder how a computer sees your resume? Let Brandi and Amanda teach you how to use word clouds for job postings and your resume. Guaranteed to be a light bulb moment for your career search efforts!


  • Brandi Kiehl

Track and Room: Professional Development - 1202

Title: What’s new in Power BI Embedded

Abstract: How to embed Power BI visuals on web pages has changed since the launch of Power BI Premium. This session will teach you how to get started on the new, unified Power BI API.


  • T.J. Brown

Track and Room: BI Platform Architecture, Development Administration - 1103

Title: Data Modeling Student Registration and Student Retention in Higher Education

Abstract: In higher education, student registration leads to student retention. In the session, I will explain the strategy we have used to model star schemas for these two critical business processes in our data warehouse. The presentation will focus on the logical model as well as some physical implementation decisions and successes using SQL Server 2016.


  • Jason Jones

Track and Room: Application Database Development - 1201

Title: 100% Chance of Clouds – Migrating to Azure SQL DB

Abstract: Looking for a simple way to get started with Azure? Not sure if Azure SQL DB is right for you? Try it out by moving an existing database to the cloud!

In this session, you will learn techniques to migrate your on-premises SQL Server databases to Azure SQL DBs, and why backup and restore is not one of the three.

This session will also provide guidance on determining whether your on-premises SQL Server database is compatible with Azure SQL DB.


  • Bob Rubocki

Track and Room: Cloud Application Development Deployment - 1104

Title: How to Build your Brand and Become a Thought Leader

Abstract: Your personal brand is how you distinguish yourself from other people but how you develop and nurture your brand can be the difference between stagnation and opportunity in your career. We’ll discuss your branding, the importance of taking control of your brand, and how to begin developing your personal brand. By the end of this session, you’ll have a better idea of how to begin building your personal brand into something that can take your career to the next level.


  • Dustin Ryan

Track and Room: Professional Development - 1209

Title: Data Driven Digital Transformation

Abstract: Go beyond the buzzwords and let’s get real about how you can help transform your company as a data professional. Adam will walk through the major areas of business that are transforming, how you can help and give you tips on becoming more influential in your organization by leading this change.


  • Adam Jorgensen

Track and Room: Strategy and Architecture - 1205

Title: Working with SQL Server for Linux Cross-Platform

Abstract: I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session


  • Maximo Trinidad

Track and Room: Enterprise Database Administration Deployment - 1102

Title: Master Data Management with SQL Server 2016 MDS

Abstract: Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.


  • Neal Waterstreet

Track and Room: BI Platform Architecture, Development Administration - 1103

Title: Kids Camp

Abstract: Kids camp! Pre-registered event.


  • Eric Wisdahl

Track and Room: Other - 1101

Title: Women in Technology Luncheon

Abstract: A panel discussion with some of the great Women of the community.


  • Brandi Kiehl

Track and Room: Professional Development - 1202

Title: TSQL Tips and Tricks for Developers

Abstract: Common mistakes you can avoid to run your queries very effiently


  • Victor Ivantsov

Track and Room: Application Database Development - 1201

Title: Database Security Permissions ( you don’t need to grant SA )

Abstract: Lets talk about Database Security Permissions Roles and I’ll show you how to correctly grant the access needed to allow other to their job without risking the entire database. I will also touch on auditing so you can prove who did what!


  • Scott Gleason

Track and Room: Enterprise Database Administration Deployment - 1201

Title: Azure Sql PAAS: Lessons from the Real World

Abstract: So you’re using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What’s a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore…? We’ll go over these questions and any others that you may have.


  • Jonathon Moorman

Track and Room: Strategy and Architecture - 1104


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Haim Shternshus

Twitter: - @shushaim

LinkedIn: Haim Shternshus

Haim Shternshus is an Intelligence Analyst at the Citizens Property Insurance Special Investigation Unit (try to say that five times fast), and holds a Mechanical Engineering degree. He uses his engineering experience and analytics expertise to interact daily with endless rows of data, and find the stories within. Haim specializes in designing interactive dashboards that enable users to make smart, data-driven decisions in real time. He has been speaking and training throughout his career.

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

Ahmad Drshen

Twitter: - #adrshen

LinkedIn: Ahmad Drshen

Contact: https://adrshen.wordpress.com/

Over 15 years of Information Technology experience with the last 12 years focused on mastering the Microsoft SQL Server platform including Power BI and data Science algorithms. My diverse background of hands-on experience has resulted in a strong foundation of SQL Server knowledge, a mastery of the art of architect, managing and maintain very large scale of databases (2TB+ transnational). My background of administrating financial, healthcare, mortgage, and retails data makes me very unique database administer to work with.

My overall experience and exposure to the IT infrastructure like virtualization, SAN planning and monitoring and understanding of advance networking concepts really compliments my dba skillset.

After being expose

Brandi Kiehl

Twitter: - BrandiKiehl

LinkedIn: Brandi Kiehl

Co-Organizer of the Women in Information Technology of Jacksonville, PyJax, IT Pro/Florida IT Server Group, IT Pro Camp, Tech Coast Conference, Women and Minorities in IT Conference, Bsides of Jacksonville, and Career Network Outreach. Co-Owner of Stardust Techologies and Career Network Outreach. A certified Project Manager and experienced IT professional with over 10 years of data science, analysis, and management experience. Enjoys teaching and helping people to find new or transition careers, with mock interviews, elevator speeches, clean up or create more professional social media profiles, change their way of thinking about job searching, reinvent their resumes, and how to network.

Thomas Banyan McGowen

LinkedIn: Thomas Banyan McGowen

Let the power of data compel you!!! Banyan is a data expert who strives to find new ways to transform and utilize data to drive process and organizational change. A believer that to empower an organization one needs to move past the star and the pivots tables, he has spent a career blurring the lines between IT and business, analysis and architecture. Holding such titles as Financial Analyst, Developer, Business Systems Analyst, DBA, Data Architect and Assistant Director, he has spent the bulk of his career working in Finical Services and Higher Education. Most recently, he has spent the last 1.5 years supporting the mission of Community Hospice and Palliative Care here in Jacksonville, FL.

Ronald Dameron

Twitter: - @RonDBA

LinkedIn: Ronald Dameron

Contact: http://RonaldDameron.com

Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.

He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.

He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.

He is most active on Twitter as @RonDBA.

Mitchell Pearson

Twitter: - @MitchellSQL

Contact: http://www.mitchellpearson.com

Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.

Richard Weiss

Twitter: - @RichardAWeiss

LinkedIn: Richard Weiss

Contact: http://www.Pythian.com

Richard Weiss is a Principal Consultant and Solution Architect at Pythian specializing in Cloud, SQL Server, and Wintel technologies. Over the past 20 years, he has held senior technology roles at First Data, Western Union, and AAA. Additionally, Richard serves on the Data and IOT standards committee for the National Retail Foundation

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Jason Jones

Contact: https://jasonjonesdata.blogspot.com/

After 10 years in the United States Air Force as a linguist, I decided to go into the world of computing. I graduated from the University of North Florida with a Bachelor of Science in Computing Info Sciences. Before graduating, I completed a yearlong internship with an excellent company where I learned how important it was to teach myself and follow my passions. As a .Net programmer my biggest surprise was how interested I was in database development. My current interest is getting information to decision makers as fast and easy as possible. From conceptual and logical data models to physical implementation, I want to get the right information to the right people with as little technological effort as possible.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Luis Figueroa

Twitter: - @luisefigueroa

LinkedIn: Luis Figueroa

Contact: http://blog.luisfigueroa.net

Luis Figueroa is a data professional with more than 15 years of experience in Information Technologies across many industry verticals. Luis has held a variety of positions in IT such as Network Administrator, Systems Engineer, Database Administrator and EDW / BI Architect. In the most recent years Luis found his passion in architecting and developing open source data centric solutions that help businesses manage their data and gain a competitive advantage through analytics. Luis currently holds a position as Solutions Engineer for Hortonworks, Inc. where he works with many clients including Fortune 500 companies. Luis’ main focus areas are in Data Warehousing, Business Intelligence, Advanced Analytics, Big Data, IoT and Cloud Computing.

Victor Ivantsov

Twitter: - @victorivantsov

Senior SQL Server developer with 20+ years of experience. I have enjoyed many SQLSaturday as participant, now is my time to contribute

Susan Schneider

LinkedIn: Susan Schneider

Contact: http://susansblog.sqlinsight.net/

Susan Schneider is a certified Microsoft Professional with a concentration in Database Fundamentals. She is a Data Engineer for MoneySolvers , a Tax Defense Network company, in Jacksonville, Florida. Her passion is data, with a focus on T-SQL, Power BI and SSRS. She started her own technical journey ten years ago at a SQLSaturday event; and she wants to give back to the technical community that helped and encouraged her along the way. She has spoken at various SQLSaturday and IT Pro Camp gatherings, and enjoys meeting people new to technology. When she’s not working, learning, or blogging; she enjoys traveling and sailing with her husband, Steve. You can find her on LinkedIn or follow her blog. Happy Learning!

Eric Wisdahl

Twitter: - @EricWisdahl

LinkedIn: Eric Wisdahl

Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.

Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.

Chris Albrektson

Twitter: - @ChrisAlbrektson

Contact: https://chrisalbrektson.wordpress.com/

Chris Albrektson is an experienced Business Intelligence consultant and trainer for Pragmatic Works in Jacksonville, Florida. Chris is an experienced speaker and has presented at many SQLSaturdays and Code Camps across the United States. He’s also an active member of the Jacksonville SQL Server User Group (JSSUG), is a regular blogger on WordPress and has been a technical editor of a few Business Intelligence related books.

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

Bob Rubocki

Twitter: - @BobRubocki

LinkedIn: Bob Rubocki

Contact: http://bobrubocki.wordpress.com

Bob is a Senior Consultant at Pragmatic Works and a Microsoft Certified Professional. He has spent most of his career working in Business Intelligence, Data Warehousing, and Data Integration, both in industry and as a consultant. He has implemented solutions in financial services, healthcare, manufacturing, retail, and consumer goods industries. Bob has spoken at SQLSaturday, user group events, and webinar sessions. He is fascinated by the variety of opportunities available in the cloud.

Taras Kaduk

Twitter: - https://twitter.com/taraskaduk

LinkedIn: Taras Kaduk

I solve problems using data. Power BI, Tableau, and lots of R.

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.

Neal Waterstreet

Twitter: - @nealwaterstreet

LinkedIn: Neal Waterstreet

Contact: http://www.nealwaterstreet.com

Neal is a BI Architect/Consultant with more than 20 years of industry experience. Neal is skilled in the entire BI spectrum, including dimensional modeling, ETL design and development using Integration Services (SSIS), designing and developing multidimensional cubes and Tabular models using Analysis Services (SSAS) and Master Data Management using Microsoft Data Services (MDS). He’s also involved with the database community and is the co-founder and co-leader of the PASS Healthcare Virtual Chapter and the Atlanta Modern Excel User Group.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

Diane Schuster

LinkedIn: Diane Schuster

Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!

In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.

Dustin Ryan

Twitter: - https://twitter.com/SQLDusty

LinkedIn: Dustin Ryan

Contact: https://sqldusty.com

Dustin Ryan is a Data Platform Solution Architect at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQLSaturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant for a Microsoft partner. Dustin resides outside Jacksonville, Florida with his wife, three children, two cats, two dogs and enjoys spending time with his family and serving at his local church. You can learn more about him at http://SQLDusty.com.

Brandi Kiehl

Twitter: - BrandiKiehl

LinkedIn: Brandi Kiehl

Co-Organizer of the Women in Information Technology of Jacksonville, PyJax, IT Pro/Florida IT Server Group, IT Pro Camp, Tech Coast Conference, Women and Minorities in IT Conference, Bsides of Jacksonville, and Career Network Outreach. Co-Owner of Stardust Techologies and Career Network Outreach. A certified Project Manager and experienced IT professional with over 10 years of data science, analysis, and management experience. Enjoys teaching and helping people to find new or transition careers, with mock interviews, elevator speeches, clean up or create more professional social media profiles, change their way of thinking about job searching, reinvent their resumes, and how to network.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Doug McClurg

Twitter: - https://twitter.com/dpmcclurg

LinkedIn: Doug McClurg

Doug McClurg is the principal and founder of SOSRA Inc., an analytics leadership company. He brings both military and corporate experience to organizations who want to build or accelerate their analytics program. Doug has been building tailored Microsoft SQL Server solutions for many years. He brings deep knowledge of modern information architecture to projects ranging from innovating the traditional data warehouse to capturing WiFi presence and machine data to democratizing corporate analytics. He has served as a leader, mentor, and architect to teams in Government, Oil Gas, Hospitality, and Retail.

Brad Raney

Twitter: - https://twitter.com/Brad_Raney

LinkedIn: Brad Raney

Contact: https://bradraneyblog.wordpress.com/

Brad Raney is a national speaker, international author, sales/leadership/management trainer, entrepreneur and has almost 30 years’ experience in creating and developing high performance teams in a variety of industries across the country.

Brad’s first book on how to find your perfect job has now sold on three continents and his latest book called Reach YOUR Peak:Become CEO of Your Success! is selling fast across the country in traditional and e-book formats.

Brad has spoken to almost 100,000 people and was part of the highly successful “Pink Slip Tour presented by Virgin Mobile,” that made stops in Miami, Orlando, Jacksonville, Atlanta, Minneapolis, and Detroit.

Brad has been on Advisory Boards for: • The University of North Flori

Paul Williams

LinkedIn: Paul Williams

With over 20 years of experience in creating solutions for various industries’ complex business problems, I have a proven track record of success. My experience is best suited for meeting with business stakeholders to determine how they measure success in their organization and identify the different business processes that contribute to that. With that information and access to their subject matter experts, I can build them a BI solution that provides a single unified view of their entire business and a single source of truth. This will drive efficiency into their organization allowing them to focus on their larger goals rather than spending all of their time manually gathering data.

Bogdan Visinescu

LinkedIn: Bogdan Visinescu

I am working as an Assistant Professor of Mathematics at University of North Florida. As an Assistant Professor, I taught various statistics and mathematics courses. My research interests are in Operator Algebras, Matrix Theory and Data Science. I worked as an Actuarial Analyst at Kemper, where he prepared actuarial analysis of rates and rating plans for certain lines of insurance. Education • Microsoft Professional Program Certificate in Data Science • Microsoft Azure HDInsight Big Data Analyst • PhD in Mathematics - University of Cincinnati. • B.S. Degree in Computer Science and Mathematics, University of Bucharest.

Jorge Novo

Twitter: - @ETLDEVDBA

LinkedIn: Jorge Novo

Contact: http://etldevelopernotes.blogspot.com

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tuning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.

Ben Cusson

LinkedIn: Ben Cusson

Contact: http://www.snitechnology.com/Blog

SNI Technology earned the Best of Staffing® Award for providing remarkable service quality. Fewer than 2% of all staffing agencies in the U.S. and Canada earned the 2015 Best of Staffing Award for service excellence. With satisfaction ratings more than three times higher than the industry average, the Best of Staffing winners truly stand out for exceeding expectations. This award identifies the staffing industry’s elite leaders in service quality.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.

Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

David Liebman

Twitter: - @BISQLDave

LinkedIn: David Liebman

Contact: http://www.bisqldave.com

I’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL.

Valentin Iamandi

Contact: http://logicalreads.wordpress.com/

Valentin brings more than 10 years of database experience in tuning, architecture, backup, large data transaction, and more. He has a solid background in database analysis and development and his skills cover SQL Server and Oracle as well as a slew of different operating systems. Valentin fluently speaks English, French, and Romanian. Valentin has a passion for performance and optimization and shares his experience on the topic in his blog http://logicalreads.wordpress.com/

Steve Schneider

LinkedIn: Steve Schneider

Contact: http://sqlinsight.net/blog/

Speaker Bio: Steve Schneider is a Business Intelligence developer for the City of Jacksonville (Florida), and has been embedded in SQL for over 20 years. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. Along with his passion for SQL, he spends his time running half marathons and sailing. His current focus of interest is performance tuning, security, and cube building. He tries to maintain a constant sense of gratitude to God for the wonderful things he has been enabled to do.

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

Contact: http://www.sqlballs.com

Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has 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 the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com

Jonathon Moorman

LinkedIn: Jonathon Moorman

Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.

Scott Gleason

LinkedIn: Scott Gleason

Scott is a vice president of the Jacksonville FL SQL Users group with over 10 years experience as a database administrator, working in both Healthcare and Financial industries. He is both Energetic and animated teacher. His passion is learning new technology and sharing his Sql experiences (the good and the lessons learned) with others.

Joshua Corrick

Twitter: - @joshcorr

LinkedIn: Joshua Corrick

Contact: http://corrick.io/blog

Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2.5 years. Josh has many different hats on his team, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys. They have lived in Jacksonville FL since 2014.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.

Vishal Pawar

Twitter: - Vishal_BI

LinkedIn: Vishal Pawar

Contact: http://bimentalist.com/

Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.

Kenneth Wood

LinkedIn: Kenneth Wood

Currently I serve as the Learning Development Manager at Pragmatic Works. In this role, I am responsible for training content and distribution.

I seek to build new business relationships with those in need of IT Training within Microsoft based applications (SQL, BI, SSAS, SSIS etc.) and nurture existing relationships.

While IT was not my initial venture, I made the career move and have fallen in love with the world of technology over the last several years!

I have a passion for Growth and motivating others to reach their potential. I firmly believe, if you’re not challenging yourself, you’re not growing.

T.J. Brown

Twitter: - @SQLTJ

LinkedIn: T.J. Brown

I’m a Sr. Business Intelligence consultant with over 5 years of experience consulting in the SQL Server BI stack, and big data workloads on Azure. I’m from University of Florida graduate and currently reside in Jacksonville, FL.

Felix Asencio

LinkedIn: Felix Asencio

My professional experiences includes Extracting, Transforming and Loading (ETL) using SQL Server Integration Services data into data warehouse using the Kimball methodology into MS SQL Server Database. In addition, my experience includes reporting using SQL and Access and data analysis using excel MS Reporting Services and Crystal Reports. I love the field I work in due to the variety of assignments and the ability to acquire new skills.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page