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

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: 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • Troy Gallant

Track and Room: 4. BI Data Warehouse - N/A

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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • Rob Volk

Track and Room: 5. DBA - N/A

Title: I am a DBA! Why do I care about Scrum?


This session will provide an overview of Scrum and answer the reason why a DBA should care about Scrum.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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).


  • 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


  • 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!


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • 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.


  • Mike Davis

Track and Room: 1. BI (Auditorium 1) - N/A


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.


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

Back to the SQLSaturday Event List

Back to the home page