Event Location:
Nova Southeastern University
3301 College Ave
Davie, Florida
Abstract:
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA's) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and what criteria do you use to make the choice? It’s incredibly important that you understand the decision tree that helps you pick the right options(s) for your business and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This presentation will give you a high level understanding of the options, the costs, complexities, reasons for t
Speaker(s): Kendal Van Dyke,
Abstract:
Simplicity and power of Microsoft SQL Server allows us to design and develop the working solution in virtually no time. Although there is a significant difference between the system that just works and the system that works efficiently. One of the challenges architects and developers often face is that the best practices and methods commonly used in the client development cannot be applied in the database world and rather hurt the systems than help them. The session focuses on a few obvious and not-so-obvious anti-patterns commonly encountered in production database systems. It shows how to refactor them and improve the system performance.
Speaker(s): Dmitri Korotkevitch,
Abstract:
The ability to audit in SQL server has been available for quite some time using different tools and techniques. This session will outline several methods to implement audtiting, but will focus primarily on SQL Audit. SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
Speaker(s): David Dye,
Abstract:
How to Fill in the Gaps for Missing Data When ETL lookups don’t match this can be a problem. In the case of ETL processing over large data sets, having to figure out the missed match conditions for large numbers of rows can be a problem. In the case of a dimensional warehouse, when you are processing large numbers of fact rows that have a lookup dependency, and you cannot get a match, what can you do? We’ll discuss strategies such as 1. Late Arriving Dimensions and Facts 2. Using a default values. 2. Use multiple default values. 3. Creating a partially populated dimension row for a late arriving dimension. 4. Using “Level Of Confidence” pattern matching techniques
Speaker(s): James McAuliffe,
Abstract:
This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.
Speaker(s): David Dye,
Abstract:
Developing a social media platform is a challenge for high-end professionals and consultants. The presenter has successfully leveraged web media to establish a blog (http://marktab.net), cofound an online journal (http://solidq.com/sqj), become a paid video presenter, secured a spot at Microsoft TechEd 2011, and earned credit toward his first Microsoft MVP. This presentation introduces the basic elements for 2011 of a successful web strategy, starting with discovering your own best personal focus given current market needs. The presenter includes experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft.
Speaker(s): Mark Tabladilo,
Abstract:
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!
Speaker(s): Bradley Ball,
Abstract:
During this session we'll cover the options for storing data on a Windows Phone including isolated storage, SQL Compact, and Sterling DB. If time allows we'll also take a look at pulling data into the phone using various service layers.
Speaker(s): Joe Healy,
Abstract:
This is an overview of how to understand SQL PowerShell and its difference with PowerShell v2. Covering some PowerShell basic, and see how SMO can assist in extending your PS Script. Also, I’ll be showcasing some of the tools that can provide and extend you PowerShell scripting. This session is intended to help the audience realized the benefits of learning PowerShell.
Speaker(s): Maximo Trinidad,
Abstract:
• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue? • Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are learning and using the latest, most marketable technologies? In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.
Speaker(s): Alex Funkhouser,
Abstract:
SQL Server DBA's face a lot of challenges now days, from maintaining servers to putting out fires. One of them is how to properly deal with Access databases in the workplace. Quite frequently they contain mission critical data and grown to be important to your business. Upsizing them to SQL Server is just the first step, you need to change Access's forms, reports, queries and code to avoid issues with your server. In this session we will discuss strategies; from importing data to optimizing the relationship between Access and SQL. Users will leave having a much better understanding of how to incorporate Access in the workplace and safeguard their data.
Speaker(s): Juan Soto,
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. 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,
Abstract:
I will demonstrate how to develop MS Excel BI Dashboards in the following ways: 1. Workbook style with Office data connections stored on local PC or networked document drive 2. excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render 3. Convert excel pivot table into excel OLAP formulas 4. Discuss SP 2010 BI Center 5. Discuss references to cap off session.
Speaker(s): Phillip E Rosen,
Abstract:
Have you ever been asked to troubleshoot an issue and then learned it happened a few days ago, and they wanted an root cause by 5PM? Have users complained that the "Slowness" has been plauging them all day, but by the time you are told, you can't find a bottleneck? If you have and couldn't find answers, you need Server Side Traces. In this session, I will take you through the creation of a process to setup server side trances, and how to use them to baseline and protect your servers.
Speaker(s): Don Stevic,
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
Speaker(s): Don Stevic,
Abstract:
In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. Jose will show how to optimize SSAS hierarchies by specifying attribute and dimension types, member uniqueness, and aggregations. Jose will also do quick intro on querying hierarchies with MDX.
Speaker(s): Jose Chinchilla,
Abstract:
Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker(s): William E Pearson III,
Abstract:
AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop.
Speaker(s): Geoff Hiten,
Abstract:
Microsoft has shifted gears towards the new Business Intelligence Semantic Model (BISM), but what does it mean to Analysis Services cube developers? Join Jose to understand what BISM is and the Analysis Services roadmap. Jose will demo how to develop and deploy BISM models to the new Vertipaq engine and how to interface with them.
Speaker(s): Jose Chinchilla,
Abstract:
A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
Speaker(s): Andy Warren,
Abstract:
This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.
Speaker(s): Andy Warren,
Abstract:
How often do you launch a remote desktop session to your SQL Server? And how often do you ALTER a TABLE during peak hours? These can cause performance problems. Mike Hillwig has a top ten list of operational mistakes to avoid and will help you understand why you should avoid them.
Speaker(s): Mike Hillwig,
Abstract:
Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.
Speaker(s): Thomas LaRock,
Abstract:
You've built your BI solution, but its just not performing the way you expect it. Regardless of the size of your solution, all can use these basic techniques of triaging our SSAS and SSRS environments. We will discuss the main culprits that affect scale and how to track them down using the tools available to you.
Speaker(s): Brian Mitchell,
Abstract:
One of the biggest challenges for modern OLTP Systems is the amount of data needed to be collected and processed. Business requirements, industry standards and regulations require systems to retain enormous amount of information. Offline data archiving is not often an option especially with the hosted solutions - customers expect old data to be available on the fly. Keeping all data in the single instance of SQL Server is the most expensive option from hardware cost and management standpoints. This session demonstrates several data sharding techniques that can be used to partition the data across multiple database servers focusing on the task of separating production and historical data in OLTP systems
Speaker(s): Dmitri Korotkevitch,
Abstract:
See live demos of how Microsoft IT is delivering BI to the masses (39,600+ users globally) at Microsoft using SharePoint, using Excel, PerformancePoint, SQL Server, SQL Azure, Windows Azure and other Microsoft BI products. Hear about 6 years of Microsoft IT BI success story. Learn best practices and technical details on how to implement large scale self-service Business Intelligence systems in your organization and enable BI for the masses in real life.
Speaker(s): Sanjay Soni,
Abstract:
Here is an opportunity to meet the PASS Board of Directors, ask them questions, and get up-n-personal with this great group!
Speaker(s): Andy Warren,
Abstract:
We all have tasks that run through the SQL Server Agent. Every once in a while, we need to provide a history, a schedule, or even just a listing of what jobs and steps are being run. And lets not forget about backups and maintenance plan history. Nothing is more frustrating than sifting through multiple screens and logs to put this into a meaningful format. Mike Hillwig will show you how to query and present this data without needing third party tools.
Speaker(s): Mike Hillwig,
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,
Abstract:
I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.
Speaker(s): Maximo Trinidad,
Abstract:
In this session Brad will walk you through some of the best practices for configuring SSIS. Each of the configuration types will be covered from XML to registry entries. The use of expressions for configuring your SSIS package will also be covered. Finally he will walk you through some best practices for moving your packages between environments and keeping your configurations up to date.
Speaker(s): Bradley Schacht,
Abstract:
This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
Speaker(s): Michael Antonovich,
Abstract:
In this presentation I will show you how to create a simple report and deploy the report to the Report Server using SQL Server Business Intelligence Development Studio(BIDS).
Speaker(s): David Liebman,
Abstract:
Complex data structures, Google metrics, and SQL code will be shared as Jacksonville SEO Expert Jared Nielsen demonstrates how he used databases and search engines in the mortgage industry, sports apparel, legal, and other industries.
Speaker(s): Jared Nielsen,
Abstract:
Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services.
Speaker(s): Bob Abernethy,
Abstract:
Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
Speaker(s): Mark Tabladilo,
Abstract:
In this session Brad will help get you past the learning curve of SSIS. He will cover the basics of the development environment, the control flow and data flow. Brad will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS.
Speaker(s): Bradley Schacht,
Abstract:
During this session we'll explore the basics of Kinect Programming using the Kinect SDK. This has nothing to do with SQL, but should offer a refreshing respitre from SSxS, SQL and other database stuff for any programmers attending.
Speaker(s): Joe Healy,
Abstract:
Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out What it does, What it doesn’t do, how it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), and other Advance Features as well as some tips on how to manage it.
Speaker(s): Bradley Ball,
Abstract:
Gain exposure to the Server side of PowerPivot with Microsoft BI Architect and SQL Server MVP Bill Pearson. The targeted audience of this session includes professionals who will be planning, deploying and maintaining the server side of PowerPivot. Among other BI architects and developers, this overview will be of particular interest to SharePoint Admins who are new to capabilities for sharing and managing PowerPivot applications created with PowerPivot for Excel.
Speaker(s): William E Pearson III,
Abstract:
A great session
Speaker(s): Mike Davis,
Abstract:
Software Development is EXPENSIVE! Jared Nielsen, a local Jacksonville SEO Expert will share with you his techniques for rounding up the capital and funding you need to launch that software development project you have always wanted to do. Comprehensive discussions on sources of funds, ways to attract capital, ways to attract revenue and who to ask will be covered in this highly lucrative discussion.
Speaker(s): Jared Nielsen,
Abstract:
This session is designed to present a high-level foundational knowledge of the project management process endorsed by the Project Management Institute (PMI). It will also focus on the tools that IT professionals can use to deliver projects on time and on budget.
Speaker(s): Richie Rump,
Abstract:
Mike Hillwig has ten rules for managing a SQL Server environment regardless of the size. His rules cover things from server configurations to planning for a disaster and a few things that should never be done.
Speaker(s): Mike Hillwig,
Abstract:
Are you suffering from memory issues? Is your SQL Server configured for proper memory management? Attend this session and learn how to best determine if you are suffering from memory pressure, how to resolve issues that result from memory pressure, and how to properly configure your SQL Server to minimize the chance of having memory issues.
Speaker(s): Thomas LaRock,
Abstract:
XML is a technology that Developers and DBAs alike share a love-hate relationship with; it's powerful and flexible yet it can be bloated and difficult to work with at the same time. Regardless, XML has found a home in many applications - including SQL Server (e.g. execution plans) - so it's important to understand how to work with it in your databases. This session will show you how to use the XML data type, perform basic operations on XML data, and how to use FOR XML to create XML from relational data. This isn't a session to convince you to use XML, but to show you what you can do with XML when you do need to use it!
Speaker(s): Kendal Van Dyke,
Abstract:
How to Incorporate Enterprise Code in SSIS Processing. For many SSIS scenarios, a desired outcome is to implement logic or rules that are used in existing enterprise applications, only to do so in an a bulk data loading scenario. Many times the logic being applied is complex and multi-step. We will examine various scenarios where complex logic from shared code sources can be applied in SSIS processing scenarios. 1. How to implement complex logic using code in SSIS 2. How to use code from shared enterprise sources 3. Using logic from external services 4. Performance comparisons.
Speaker(s): James McAuliffe,
Abstract:
In this session I will discuss various ways to import data, including BCP, regular INSERT statements and the Bulk Copy API from the .NET framework. I will compare performance results from various techniques and introduce you to the various aspects and challenges involved with each.
Speaker(s): Herve Roggero,
Abstract:
Hyper-V in Windows Server R2 is a playground for the I.T. Geek! Learn how to use Hyper-V, SQL Server 2008 R2 and free iSCSI software to create a virtual SAN, windows failover cluster, and Active-Active SQL cluster, all in a single physical server, for learning and development purposes.
Speaker(s): David Cobb,
Abstract:
This session takes you from using the PIVOT command with simple SQL databases to building simple cubes in Analysis Services with related tables. After using this cube to create a pivot table in SSAS, I will show how the Office Power User can take the same SQL tables and connect to them from excel with PowerPivot to create similar Pivot Tables and Pivot Charts.
Speaker(s): Michael Antonovich,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: http://linkedin.com/in/richierump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: https://www.linkedin.com/in/juansoto
Contact: https://accessexperts.com/blog/
I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Contact: http://www.strategycompanion.com/m_home.aspx
Bob Abernethy is SVP GM of Strategy Companion Corporation. A veteran of Oracle Corporation and Siebel Systems, Bob brings over twenty years of software industry experience to his discussions with customers about their Business Intelligence implementations. Most recently, Bob has worked closely with many Fortune 500 and mid-sized companies on the deployment of Strategy Companion’s Analyzer BI solution.
Contact: http://blogs.msdn.com/devfish
--- Joe Healy is a Technology Evangelist for Microsoft covering North and Central Florida. He can be reached at jhealy@microsoft.com or http://blogs.msdn.com/devfish ....
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Jared Nielsen believes that a "Jack of All Trades Is Master of None... Except Himself"™. His twenty year career has spanned projects in "wires and pliers" networking, database architecting, software design, marketing strategy, sales management, training and documentation, business administration, entrepreneurial investment, public company creation, and strategic analysis and consulting. Billing himself as "an IT guy that actually speaks English", he has managed to effectively bridge the gap between IT and Sales, IT and Marketing, and IT and Executive Management in a way that multiplies revenue for each project he works on. Always willing to speak his mind and challenge the status quo, he is featured throughout the world including the front page of the Wall Street Journal, Wired Magazine, the German Financial Times, Slash Dot, CNN (television, CNN.com and iReport.com), and thousands of blogs throughout the Internet. His work can be seen with companies such as Interline Brands / Barnett (formerly BNTT:NASDAQ), Hughes Supply/ Home Depot / HD Supply (formerly HUG:NYSE), Yahoo! Sports (YHOO:NASDAQ), CBS Television (CBS:NYSE), SAP Andina del Caribe (Caribbean Division), and automotive sector including Tire Kingdom, Big O Tires, Merchants Tire, and NTB, as well as dozens of other high profile projects that have multiplied in revenue due to his influence.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
LinkedIn: http://www.linkedin.com/profile/view?id=11710667amp;trk=tab_pro
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!
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
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.
LinkedIn: http://www.linkedin.com/in/AlexFunkhouser
Contact: http://www.SherlockTech.com
Alex Funkhouser wrote his first lines of code in 1980 on a TRS80. He is an avid supporter of the technology community, earned a Bachelor of Science from Washington University and an International MBA from The Netherlands. Alex#39;s recruiting philosophy: “Know who is best at what, and know who needs the best!quot;
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Contact: http://www.bradleyschacht.com
Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQLSaturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).
Contact: http://geekswithblogs.net/hroggero
Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.
LinkedIn: http://www.linkedin.com/profile/view?id=11710667amp;trk=tab_pro
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!
Contact: http://www.SQLBalls.com
Bradley Ball is a MCITP SQL 2005 MCTS 2008 DBA with over 10 years of IT experience. Bradley 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. He is currently a Sr. SQL DBA Staff Specialist for Publix Supermarkets. He has presented at SQLSaturdays 62, 74, 79, 85 for the MAGICPASS OPASS SSUG’s, SQL Rally, and at the PASS Summit in 2011. Bradley can be found blogging on http://www.sqlballs.com
Phillip E. Rosen is a Business Intelligence (BI) Developer who lives in the Miami, Florida area where he retired from the United States Marine Corps after 20 years of arduous service around the globe, combat tours in Operation Desert Storm 1991, Operation Iraqi Freedom 2004. He is a service disabled veteran who is employed as a virtual civil servant with the Department of Veteran’s Health Administration (VHA) based in Reno, Nevada. Phil conducts local and virtual training events/sessions for VHA BI developers employees about SQL Server 2008R2 Reporting Services, T-SQL queries, performance tuning and dashboards that are connected to analysis services data cubes. He has 3 years of experience developing BI dashboards using MS Excel which are rendered in Share Point Excel Services and as Excel workbooks for executive leadership to make efficient timely decision about finical, personnel staffing, and budgeting. Phillip has a wide range of BI experience with SQL Server as an accidental database administrator/developer of an instance of Microsoft SQL Server 2008 managing, maintaining, and updating it. His daily duties/responsibilities require the use of SQL Server 2008R2 client tools; Visual Studio 2008 Business Intelligence Development Studio (BIDS) and SQL Server Management Studio writing Transact-SQL (T-SQL) queries to develop ad hoc and custom reports. Phil enjoys discussing and learning about MS BI, applications tools.
Contact: http://www.SQLBalls.com
Bradley Ball is a MCITP SQL 2005 MCTS 2008 DBA with over 10 years of IT experience. Bradley 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. He is currently a Sr. SQL DBA Staff Specialist for Publix Supermarkets. He has presented at SQLSaturdays 62, 74, 79, 85 for the MAGICPASS OPASS SSUG’s, SQL Rally, and at the PASS Summit in 2011. Bradley can be found blogging on http://www.sqlballs.com
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
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.
LinkedIn: Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/
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.
Contact: http://www.bradleyschacht.com
Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQLSaturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).
Mark Tabladillo (Microsoft MVP and SAS Expert) empowers and inspires executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark has a primary career consulting with companies across commercial and non-profit industries in the United States and around the world. Mark also demonstrates his depth in his secondary role as graduate school professor at the accredited University of Phoenix, where doctoral candi
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
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.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
Mark Tabladillo (Microsoft MVP and SAS Expert) empowers and inspires executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark has a primary career consulting with companies across commercial and non-profit industries in the United States and around the world. Mark also demonstrates his depth in his secondary role as graduate school professor at the accredited University of Phoenix, where doctoral candi
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
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.
LinkedIn: http://www.linkedin.com/profile/view?id=33808310
Contact: http://brianwmitchell.com
Brian Mitchell, an MCM - SQL 2008 with a MBA from the University of Florida, is a Senior Consultant in the Microsoft Big Data Center of Expertise, where he focuses on SQL Server Parallel Data Warehouse, HDInsight, and Microsoft Business Intelligence. Brian has spent countless hours onsite at customer sites delivering Microsoft database and BI solutions. He has extensive experience creating and delivering advanced training for the full range of the Microsoft BI stack, with a particular passion for Analysis Services and Reporting Services. Brian has presented at TechEd, PASS Summit, SQLRally, and several SQLSaturdays and SQL Server user groups. You can read more about his deep involvement in Microsoft data technologies at http://brianwmitchell.com.
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
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.
LinkedIn: http://www.linkedin.com/in/mikedavissql
Contact: http://MikeDavisSQL.com
Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
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.
LinkedIn: https://www.linkedin.com/in/davidcobb
Contact: http://daveslog.com
David Cobb is a Systems Architect for CheckAlt Payment Solutions, providers of automated and electronic check transaction processing since 2005. He is a Microsoft Certified Trainer, with MCSE Data Platform certification for SQL 2012, training people on SQL Server since 2002. David is also the principal consultant for Cobb Information Technologies, Inc, founded in 1996, providing technology consulting with a focus on SQL Server.
LinkedIn: http://www.linkedin.com/in/mikehillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
LinkedIn: https://www.linkedin.com/in/geoffhiten
Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: http://www.linkedin.com/in/mikehillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
LinkedIn: https://www.linkedin.com/in/donald-stevic-03a5ab1/
I have spent the last 16 years of my life living, learning and teaching SQL Server. I am currently a Principal DBA at SAIC, and I teach online DBA courses at BYU-Idaho. My life before all this was as a high school Drama teacher here in Florida. It might seem an odd transition, but it really isn't. To me, part of being a great DBA is embracing the artistry of the process. How the design of a database ebbs and flows into its final form. So, I guess you could say I am a SQL artist.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
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.
Contact: http://www.SQLBalls.com
Bradley Ball is a MCITP SQL 2005 MCTS 2008 DBA with over 10 years of IT experience. Bradley 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. He is currently a Sr. SQL DBA Staff Specialist for Publix Supermarkets. He has presented at SQLSaturdays 62, 74, 79, 85 for the MAGICPASS OPASS SSUG’s, SQL Rally, and at the PASS Summit in 2011. Bradley can be found blogging on http://www.sqlballs.com
LinkedIn: Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/
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.
Contact: http://blogs.msdn.com/devfish
--- Joe Healy is a Technology Evangelist for Microsoft covering North and Central Florida. He can be reached at jhealy@microsoft.com or http://blogs.msdn.com/devfish ....
LinkedIn: https://www.linkedin.com/in/liebmandavid/
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.
Jared Nielsen believes that a "Jack of All Trades Is Master of None... Except Himself"™. His twenty year career has spanned projects in "wires and pliers" networking, database architecting, software design, marketing strategy, sales management, training and documentation, business administration, entrepreneurial investment, public company creation, and strategic analysis and consulting. Billing himself as "an IT guy that actually speaks English", he has managed to effectively bridge the gap between IT and Sales, IT and Marketing, and IT and Executive Management in a way that multiplies revenue for each project he works on. Always willing to speak his mind and challenge the status quo, he is featured throughout the world including the front page of the Wall Street Journal, Wired Magazine, the German Financial Times, Slash Dot, CNN (television, CNN.com and iReport.com), and thousands of blogs throughout the Internet. His work can be seen with companies such as Interline Brands / Barnett (formerly BNTT:NASDAQ), Hughes Supply/ Home Depot / HD Supply (formerly HUG:NYSE), Yahoo! Sports (YHOO:NASDAQ), CBS Television (CBS:NYSE), SAP Andina del Caribe (Caribbean Division), and automotive sector including Tire Kingdom, Big O Tires, Merchants Tire, and NTB, as well as dozens of other high profile projects that have multiplied in revenue due to his influence.
LinkedIn: https://www.linkedin.com/in/sanjay-soni-5990b36
Sr.Technical Product Manager - SQL BI/Data Warehousing at Microsoft. Sanjay Soni is a BI Platforms Evangelist in the Microsoft IT BI Engineering. He is an MCDBA, MCTS and specializes in Business Intelligence using Microsoft technologies including Microsoft SQL Server Analysis Services, SharePoint, ProClarity, PerformancePoint, etc. Sanjay has authored and presented a variety of papers at various BI conferences including TDWI, BI Conference, PASS, SQL Connections, SharePoint Conference and TechEd
LinkedIn: http://www.linkedin.com/in/mikehillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
LinkedIn: https://www.linkedin.com/in/donald-stevic-03a5ab1/
I have spent the last 16 years of my life living, learning and teaching SQL Server. I am currently a Principal DBA at SAIC, and I teach online DBA courses at BYU-Idaho. My life before all this was as a high school Drama teacher here in Florida. It might seem an odd transition, but it really isn't. To me, part of being a great DBA is embracing the artistry of the process. How the design of a database ebbs and flows into its final form. So, I guess you could say I am a SQL artist.
The following is a list of sponsors that helped fund the event.