SQLSaturday #130 - Jacksonville 2012
Event Date: 04/28/2012 00:00:00
Event Location:
- The University of North Florida Campus
- 1 UNF Drive
- Jacksonville, Florida
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).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server Internals: It’s What’s for Dinner!
Abstract: Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session’s end you should have a clear overview of what happens when a query hits your server.
Speaker(s):
- Christina Leo
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: Deep Dive into Indexes (Part 1)
Abstract: No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does “efficient indexing” mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint. This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: 5. DBA - N/A
Title: Deep Dive into Indexes (Part 2)
Abstract: No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does “efficient indexing” mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint. This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: 5. DBA - N/A
Title: It’s In There Somewhere!
Abstract: Focus: FileTable and Statistical Semantic Search In SQL 2012 It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It’s like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
Speaker(s):
- James McAuliffe
Track and Room: 5. DBA - N/A
Title: SQL Server 2012 Data Mining Add-ins for Office
Abstract: Take advantage of SQL Server predictive analytics in Office Excel 2010 and Office Visio 2010.! •Table Analysis Tools for Excel: Provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. •Data Mining Client for Excel: You can create, test, explore, and manage data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. •Data Mining Templates for Visio: Enables you to render and share your mining models as annotatable Visio 2010 drawings.
Speaker(s):
- Mike Milligan
Track and Room: 6. BI - N/A
Title: Taking the Scary out of Monster Reports
Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
Speaker(s):
- Pam Shaw
Track and Room: 6. BI - N/A
Title: Indexing your Data Warehouse
Abstract: One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.
Speaker(s):
- Troy Gallant
Track and Room: 4. BI Data Warehouse - N/A
Title: Jax IT - Trends, Demand Landing the Job
Abstract: We would like to offer a one-hour session that deals with the following 4 subjects: 1. a high level view of the IT job market along with comparisons to previous periods; 2. the high-demand skill sets related to SQL, BI, and MS in general; 3. tips from staffing firms and hiring managers on how to craft your resume for maximum impact; 4. tips on nailing the interview.
Speaker(s):
- Mike Maglin
Track and Room: 3. Personal Dev Azure - N/A
Title: Fast Track to BISM Tabular and PowerView
Abstract: Come learn how to get your executives and end users excited about analytics you can deliver quickly. The new Tabular features of Analysis Services are quicker and easier to develop and combine with PowerView (Crescent) to make for amazing (AND PORTABLE) visualizations that your end users will be excited about. As usual this will be all demo and you will get hands on exposure and experience with this new technology.
Speaker(s):
- Adam Jorgensen
Track and Room: 1. BI (Auditorium 1) - N/A
Title: Choosing a Microsoft Reporting Technology
Abstract: The Microsoft BI stack is fairly complex, especially on the front-end. In this session, we will cover when to use PerformancePoint, Reporting Services, Power View, PowerPivot or Excel Services. Brad and Devin will also show a little of each of these tools in action.
Speaker(s):
- Devin Knight
Track and Room: 1. BI (Auditorium 1) - N/A
Title: Hello, My Name Is DAX
Abstract: For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by jusst connecting to a custom view. However, for most other data sources (and for those users without develo9pment access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. This session will explore DAX functions and expressions and how they differ from Excel expressions.
Speaker(s):
- Michael Antonovich
Track and Room: 4. BI Data Warehouse - N/A
Title: The Fangorn Forest - ColumnStore Indexes
Abstract: In the fantasy world of Middle-earth live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes.If you are a production DBA who needs to find out about some of the additional hot features that have been included with CSI’s, like batch mode processing and data segments or if you are a BI developer who needs to find out how CSI’s can increase the performance of your aggregations and star-joins by up to 40 times, then this session is for you.
Speaker(s):
- Gareth Swanepoel
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: Integrating DQS, MDS and Your Data Warehouse
Abstract: With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.
Speaker(s):
- Christopher Price
Track and Room: 4. BI Data Warehouse - N/A
Title: Lego Sets: Relational Building Blocks
Abstract: Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you’re an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you’ll both enjoy and learn something during this session.
Speaker(s):
- Rob Volk
Track and Room: 5. DBA - N/A
Title: I am a DBA! Why do I care about Scrum?
Abstract:
This session will provide an overview of Scrum and answer the reason why a DBA should care about Scrum.
Speaker(s):
- Christopher Daily
Track and Room: 3. Personal Dev Azure - N/A
Title: SSIS Programming Using .NET
Abstract: Learn the secrets of how to build SSIS Packages using the .NET Library. Build your packages using Metadata tables without the need of Integration Services. Create standard templates, add or modified existing Components on the fly. Create Custom SSIS Components for your organization.
Speaker(s):
- Jorge Novo
Track and Room: 6. BI - N/A
Title: SRS Report Builder for Business Intelligence
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.
Speaker(s):
- David Eichner
Track and Room: 6. BI - N/A
Title: An Introductory Look at Execution Plans
Abstract: In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.
Speaker(s):
- Eric Wisdahl
Track and Room: 5. DBA - N/A
Title: MDX 101: An Introduction to MDX
Abstract: The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It’s easier than you might think. In this session, attendees will learn the basic MDX query syntax, how to navigate a hierarchy, how to create dynamic time calculations, and more.
Speaker(s):
- Dustin Ryan
Track and Room: 4. BI Data Warehouse - N/A
Title: Performance Tuning your SSIS packages
Abstract: In this session, you will learn valuable techniques on how to performance tune your SSIS packages. As many of you know, creating ETL to carry out a specific task is one thing, but optimizing that ETL to run in an acceptable amount of time is a whole different animal. You will learn about methods and properties that aren’t really mentioned in your introductory or even mid-level SSIS courses, as well as some unconventional tricks that I’ve picked up along the way. To get the most out of this session, you will need to have previous knowledge and experience with SQL Server Integration Services (Not an intro session).
Speaker(s):
- Kyle Walker
Track and Room: 4. BI Data Warehouse - N/A
Title: SQL Server 2012 AlwaysOn for HA and DR
Abstract: This presentation will focus on the concepts behind AlwaysOn, benefits it provides, and a demo of setting up AlwaysOn Availability groups
Speaker(s):
- Chad Churchwell
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: SQL Server 2012 TSQL Enhancements and Additions
Abstract: The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!
Speaker(s):
- Kevin Boles
Track and Room: 5. DBA - N/A
Title: PowerShell for Beginners
Abstract: PowerShell is Microsoft’s automation engine, which includes a command-line shell and scripting language. Since its initial release in 2006, it has become an essential tool for managing Microsoft technologies and products from vendors such as VMware. This session will explain what PowerShell is, demonstrate the fundamentals, and provide some reasons why everyone working with Microsoft products should know the basics.
Speaker(s):
- Jason Hofferle
Track and Room: 6. BI - N/A
Title: SQL University: Back That Thang Up!
Abstract: In this session we cover backups and restores from beginning to end. Want to know how to do point-in-time restores? Don’t understand what the different recovery models mean? How do you handle backups for different size databases? All of these questions and more will be answered in this session.
Speaker(s):
- Jorge Segarra
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: BI in the Cloud
Abstract: In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.
Speaker(s):
- David Liebman
Track and Room: 3. Personal Dev Azure - N/A
Title: Job Common Sense 101 - Don’t be that Guy!!
Abstract: In this session, Tom will go over how to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities.
Speaker(s):
- Tom Brenneman
Track and Room: 3. Personal Dev Azure - N/A
Title: Handling Advanced Data Warehouse Scenarios in SSIS
Abstract: So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.
Speaker(s):
- John Welch
Track and Room: 4. BI Data Warehouse - N/A
Title: Monitoring Databases in a Virtual Environment
Abstract: When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.
Speaker(s):
- Thomas LaRock
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: Develop Faster with SQL Server 2012
Abstract: Learn about some of the new developer features in SQL Server 2012. Brian will start by showing you the new SQL Server Data Tools (AKA Juneau) that allows you design, troubleshoot and deploy data changes easier. Then, learn what’s changed in the SQL Server 2012 T-SQL and data types that allow you to store amazing new data in SQL Server like files.
Speaker(s):
- Brian Knight
Track and Room: 1. BI (Auditorium 1) - N/A
Title: Page Row Compression How, When, Why in SQL 2012
Abstract: Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. In SQL 2012 we add Spatial Data Types. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.
Speaker(s):
- Bradley Ball
Track and Room: 2. DBA (Auditorium 2) - N/A
Title: Into to SSIS
Abstract: Knowledge of SSIS is essential in the world of BI today. It is a powerful tool for data cleansing and archiving. In this session for beginners, Shawn will cover all the basics of SSIS and package design. Attendees will gain a full understanding of what SSIS is and how to start using it effectively.
Speaker(s):
- Shawn Harrison
Track and Room: 3. Personal Dev Azure - N/A
Title: Surviving Your Sql Developer Interview
Abstract: This session will describe what to expect when interviewing for a sql server developer position. The session will include tips to strengthen your interviewing techniques and pit falls to avoid. The session will explain why “I don’t know.” is a perfectly acceptable answer and when it’s okay to brag.
Speaker(s):
- Jonathon Moorman
Track and Room: 3. Personal Dev Azure - N/A
Title: Building your First Cube with SSAS
Abstract: So now that your data warehouse is complete now what? In this session Tom will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS.
Speaker(s):
- Chris Albrektson
Track and Room: 1. BI (Auditorium 1) - N/A
Title: Advanced Charting Techniques in SSRS
Abstract: SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some advanced tips and tricks around them. Come to this session and take your charting skills to the next level.
Speaker(s):
- Jason Thomas
Track and Room: 6. BI - N/A
Title: The New SSIS in SQL 2012
Abstract: Learn about the awesome new features in the new release of SQL Server 2012. Mike will cover the new tasks and transforms. He will also explain the new SSIS catalog and how to configure and run your packages using T-SQL.
Speaker(s):
- Mike Davis
Track and Room: 1. BI (Auditorium 1) - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Michael Antonovich
Twitter: - @SharePointMikeA
LinkedIn: Michael Antonovich
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
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.
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 using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.
Christopher Price
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
Chad Churchwell
Twitter: - @chadchurchwell
LinkedIn: Chad Churchwell
Contact: http://www.sqlchad.com
Seasoned SQL Server DBA Professional with over 18 years IT experience with 15 years experience in databases. I have managed an enterprise DBA team and am currently in a strategic consulting role specializing in HA, DR, Replication, and Performance Tuning and Optimization. I am currently speaking at several SQLSaturday’s as well as local user group meetings.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Mike Milligan
Contact: http://bidn.com/blogs/MMilligan
I have been in love with computers since I was very young. My first computer was a Timex Sinclair 1000 which I programmed to run my paper route. I have always enjoyed discovering new ways that these wonderful machines can improve our lives. I derive an immense amount of satisfaction from developing solutions that allow businesses to make intelligent informed decisions efficiently.
Presently serving as a Senior Consultant for Pragmatic Works.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Mike Maglin
ManpowerGroup is a world leader in the employment services industry. Our global network of nearly 3,900 offices in over 80 countries and territories allows us to meet the needs of our clients in all industry segments, whether they are global, multinational or local companies. Experis IT has the deep industry knowledge to understand your needs. Our specialized recruiters match your specific IT needs to send you the right person whether you’re looking for a software engineer or your next CIO.
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.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
Mike Davis
Contact: http://mikedavissql.com
Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He is an author of several Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQLSaturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
Shawn Harrison
Twitter: - @ShawnBHarrison
Contact: http://www.thesqlgoth.com
Shawn Harrison is a BI Developer at Community Hospice and Palliative Care. He oversees the data warehouse and works within other levels of the MS BI stack. He also speaks at community events such as SQLSaturday, user group meetings.
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.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Dustin Ryan
Twitter: - @SQLDusty
LinkedIn: Dustin Ryan
Contact: http://sqldusty.com
Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.
Jason Thomas
Twitter: - @SqlJason
LinkedIn: Jason Thomas
Contact: http://www.SqlJason.com
Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).
James McAuliffe
LinkedIn: James McAuliffe
James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Christopher Daily
Contact: http://christopherdaily.com
With over 20 years of executive level positions with start-ups, emerging growth and Fortune 500 companies, Chris’s background includes extensive experience in software development, strategic planning, project management, sales, and operations. Chris joined Fidelity National Financial Corporation in 2011 as Director of Corporate Development. In this role, Chris is responsible for the transformation of the corporate development to Scrum in addition to the corporate development function.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Tom Brenneman
Contact: http://www.pragmaticworks.com
Tom Brenneman is the Vice President of Recruiting Services at Pragmatic Works. Tom has over 7 years of experience and has advise on and deliver improved business processes, operational models, and technology-driven solutions. Mr. Brenneman is highly active in the Microsoft community as President of the .NET Jacksonville users group (JaxDug) and helps run the Jacksonville SQL Server Users group.
Jason Hofferle
Contact: http://www.hofferle.com
Jason is an IT Specialist for the US Department of Defense and has been an IT professional since 1997. His experience includes enterprise desktop engineering for a Fortune 500 financial institution and Active Directory design and support for local governments. He is currently a federal employee with the Defense Contract Management Agency, where he is a technical lead on Windows 7 and Virtual Desktop Infrastructure.
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
Jon is currently a database architect at Lender Processing Services in Jacksonville. A developer for many years, Jon has been working with Sql Server since 6.0 in 1996. When not head’s down coding, Jon heads for outdoors to hike, camp, or canoe around the marsh.
Kyle Walker
I am a business intelligence consultant working for Pragmatic Works Consulting. I have a primary focus in SSIS and Data Warehouse development. I also have experience with SSRS and Crystal Report with Business Objects.
John Welch
Twitter: - @john_welch
LinkedIn: John Welch
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
Chris Albrektson
Contact: http://www.bidn.com/blogs/ChrisAlbrektson
Chris Albrektson is a Business Intelligence consultant for Pragmatic Works and is experienced in Reporting Services, Crystal Reports and Integration Services. Chris is an active member of the Jacksonville SQL Server User Group (JSSUG), and also volunteers/speaks at SQLSaturday and Code Camp events. He’s also a regular blogger on BIDN.com and recently a technical editor on SQL Server 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.
Jorge Segarra
Twitter: - @sqlchicken
LinkedIn: Jorge Segarra
Contact: http://sqlchicken.com
Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including “SQL 2008 Pro Policy-Based Management” and “SQL Server 2012 Bible” .
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.
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.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Sponsors
The following is a list of sponsors that helped fund the event: