Event Location:
Seminole State College of Florida
100 Weldon Blvd Building UP
Sanford, Florida
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
Speaker(s): Wayne Sheffield,
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s): Rob Volk,
Abstract:
I will review the fundamentals needed to define a configurable permission model currently in use at a large insurance company that allows database administrators to do routine work without having unfettered access to business data. I will show that many DBA tasks can be done without sysadmin access and explain what permissions are required for the most common tasks. Attendees will learn how to deploy a permission model that allows DBAs to do routine work and how to elevate permissions quickly to respond to emergencies. I will demonstrate several T-SQL and PowerShell scripts that secure the database server, undo the permission model in case of unforeseen circumstances, and discover which servers are non-compliant. Attendees will leave this session with the realization that DBAs don’t need to be sysadmin as often as typically believed, that most administration tasks can be done without elevated permissions, and with the means to deploy this model in their own environment.
Speaker(s): Ronald Dameron,
Abstract:
How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration. While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries! In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
Speaker(s): Prakash Heda,
Abstract:
Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.
 She wants you to help plan for the implementation and ongoing administration. Where do you begin? This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and "big data.” Although we will talk about basic techniques for querying data, the focus is on basic understanding of how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster. Additional discussion will cover the complementary nature of Hadoop and SQL Server. Examples and demos will highlight basic query tools, including transferring data to and from SQL Server.
Speaker(s): Stuart Ainsworth,
Abstract:
On this session we are going to show at end-to-end solution for complex data structures such as IBM-37 using Comp-1, Comp-3 numeric fields, from the initial requirement using excell, creation of custom components, and finally the data loading using metadata to generate ssis dynamic at run time.
Speaker(s): Jorge Novo,
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,
Abstract:
Operational Analytics: Insights on operational data, works with in-memory OLTP or on disklt;br/gt; lt;br/gt; In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUslt;br/gt; lt;br/gt; Query Data Store: Monitor and optimize query plans with full history of query executionlt;br/gt; lt;br/gt; Native JSON: Parsing storing of JSON as relational data exporting relational data to JSON lt;br/gt; Temporal Database: Track historical changeslt;br/gt; lt;br/gt; PolyBase: Manage relational non-relational data with the simplicity of T-SQLlt;br/gt; lt;br/gt; Power Query for Analytics and Reporting: Pull data from countless sources into data models and reportslt;br/gt; lt;br/gt; Enhanced SSIS: Designer support for previous SSIS versions and support for Power Querylt;br/gt; lt;br/gt; Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Serviceslt;br/gt; lt;br/gt; Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projec
Speaker(s): Charles Hyman,
Abstract:
Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output? In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options. Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.
Speaker(s): Colleen Morrow,
Abstract:
For beginning database professionals, execution plans can be intimidating. This session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
 How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
Speaker(s): Karlyn LeBlanc,
Abstract:
What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ? If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
Speaker(s): Gareth Swanepoel,
Abstract:
This is a must attend session for every data professional. Join me as I provide an overview of DataZen, Microsofts newly acquired on-premises mobile BI solution. Datazen is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of DataZen, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.
Speaker(s): Patrick LeBlanc,
Abstract:
In this session we will cover new SQL Server 2016 features, Query Store and Live Query Statistics. Query Store is designed to help with query performance by making it easier to identify poorly performing statements and finding scenarios where performance regresses. We will discuss how Query Store collects and presents historic information and how it can be used to reduce the time it takes to diagnose and resolve issues. If a query generates different plans, you can use Query Store to analyze the plan changes, identify performance degradation, and even force the query processor to use a particular plan for your query. Live Query Statistics is a feature added into SQL Management Studio that provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into query execution process as the controls flow from one query plan operator to another. These execution statistics are extremely useful for debugging performance issues.
Speaker(s): David Pless,
Abstract:
If you've ever had to answer "why was the database server was slow at 3 AM?", then you'll want to learn about the Management Data Warehouse feature in SQL Server. If you're already familiar with Server-side Tracing and Data Collector, then you'll also want to add the Management Data Warehouse to your toolkit. This session will cover installing and configuring the Management Data Warehouse feature in SQL Server, along with some customizations that can be added with additional Data Collector sets and custom SSRS Reports.
Speaker(s): Ian Lanham,
Abstract:
Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker(s): James McAuliffe,
Abstract:
The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we'll go over the basics of Data Factory like structure, billing, and building blocks. We'll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.
Speaker(s): Josh Luedeman,
Abstract:
SSIS is an extremely powerful ETL tool, but with great power comes great responsibility. The responsibility to not just create SSIS package, but create SSIS package that perform as efficiently as possible. This session will share best practices for developing packages that perform well from the start. It will also walk you step by step through identifying and fixing performance issues in an existing package. After watching this demo filled session you’ll be able to get your package performing better than ever!
Speaker(s): Mitchell Pearson,
Abstract:
Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Speaker(s): George Walkey,
Abstract:
Join this session by security expert Sebastian Meine (PhD) for an introduction to the fascinating new SQL Server 2016 feature Always Encrypted. In this session, geared towards the Database Developer, you will learn what makes Always Encrypted more secure and easier to use than prior encryption technologies available in SQL Server. After exploring the architecture behind this new feature, you will be able to observe how to implement Always Encrypted in SQL Server and discover how it might affect your maintenance and recovery strategies. After attending this session, you will be able to: • Explain how Always Encrypted works. • Setup and use Always Encrypted in your own SQL Server 2016 environment. • Identify places in your application that might require small changes. To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and not be scared when seeing C# code.
Speaker(s): Sebastian Meine,
Abstract:
Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework. Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.
Speaker(s): Richie Rump,
Abstract:
So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.#160; It includes grids and charts of varying sizes and complexities.#160; Did I mention they want it pretty as well?#160; 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.#160; 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.#160; We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.#160; To get the most out of this session, you should be able to build a report in SSRS.
Speaker(s): Pam Shaw,
Abstract:
SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
Speaker(s): miguel Cebollero,
Abstract:
Microsoft provides several technologies in and around SQL Server which can be used for casual to serious data science. This presentation provides an authoritative overview of five major options: SQL Server Analysis Services, Excel Add-in for SSAS, Semantic Search, Microsoft Azure Machine Learning, and F#. Also included are tips on working with Python and R. These technologies have been used by the presenter in various companies and industries. Bring your beginner to advanced questions!
Speaker(s): Mark Tabladillo,
Abstract:
With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.
Speaker(s): Louis Davidson,
Abstract:
Have you ever found yourself in a situation where data mysteriously disappears from your database? Or a stored procedure or function was altered without your knowledge. How do I recover and get back to the original state? Recovering data and/or database code can be a frustrating and time-consuming effort without the proper tools. In this session, I will show how to recover data and/or database code using native SQL Server tools. Do I have space to restore a copy of the database, do SLAs allow me to do this now or after hours, etc. Then I will show how NetVault LiteSpeed for SQL Server's Object Level Recovery (OLR) functionality can simplify the process and get back to the original database state in a fraction of the time. The result is you are the hero and everyone is happy.
Speaker(s): Todd Phillippe,
Abstract:
This session will show the integration and use of PowerShell Tools for Visual Studio with SQL Data tools. Also demostrate how the use of a PowerShell script in SSIS "Script Task" component as part on a ETL flow. Covering some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.
Speaker(s): Maximo Trinidad,
Abstract:
SQL Server 2016 is on the way! SQL Server 2016 represents the largest release of SQL Server in almost 20 years. This will be the largest release in SQL Server since SQL 2000. Why? After SQL 2000 Microsoft took an approach to have major releases to the Database engine or the Business Intelligence Platform. That was the pattern for SQL Server 2005, 2008, 2008 R2, 2012, and 2014. In this release we will get change to SSRS, SSAS, SSIS, In-Memory OLTP, and AlwaysOn Availability Groups. We get new features like R integration, JSON Support, Polybase (the ability to query big data sources with T-SQL), Data Zen Integration, HTML 5 support, and much much more. If you use SQL Server, this release will impact you. Come find out how!
Speaker(s): Bradley Ball,
Abstract:
As the value of Dev/Ops becomes more apparent to IT organizations, increasing demand is placed on the SQL Server DBA to manage a more agile and resilient database environment. A Dev/Ops model requires management of dozens of copies of each database across many servers, The need to provision and refresh these copies quickly is key to the success of any Agile development effort. In this session we will discuss the SQL Server DBA's role within Dev/Ops - we'll talk a bit about things like Sprints, Chef and Puppet, but most importantly we will discuss how you can present a database to any host in your environment in a couple of minutes regardless of size. Come see a copy of a 1.6TB SQL Server database presented to a host (same host or different doesn't matter) in less than 2 minutes - try doing that from a database restore!
Speaker(s): Jeff Abbott,
Abstract:
oin SQL Server MVP Kendal Van Dyke as he demonstrates how to create an SANless AlwaysOn Failover Cluster Instance using SIOS DataKeeper Cluster Edition - no shared storage, SAN, or SAN Admin required - in under an hour. At the conclusion of this sponsored session one lucky attendee will win an Amazon gift card courtesy of UpSearch!
Speaker(s): Kendal Van Dyke,
Abstract:
As a hiring manager, I see the same mistakes over and over again. In this session we'll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We'll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.
Speaker(s): Leigh Freijo,
Abstract:
In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".
Speaker(s): Damu Venkatesan,
Abstract:
The fact of the matter is that SQL injection is still a problem at the end of 2015. Web sites are still being hacked by using SQL Injection on a regular basis. Are you ready to learn as to protect your systems?
Speaker(s): Andrey Korshikov,
Abstract:
Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: *Pyramid Analytics BI Office*. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML! Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics BI Office suite.
Speaker(s): Mark Scott,
Abstract:
Power BI is quickly becoming the tool of choice for self-service reporting. It’s time to get up to speed! In this session we will build a basic dashboard from the ground up using an existing database and the Power BI tools. You’ll take away examples to start building great looking dashboards for your organization Monday morning. Prepare to be inspired! The goal of this session is to empower you to start providing insights about your data that have previously been unexplored as well as enabling stakeholders to make data driven decisions that impact your organization.
Speaker(s): Wes Springob,
Abstract:
Comparison of one application done with both technologies using multi-threading to run simultaneous operations in a large set of servers and databases
Speaker(s): Jorge Besada,
Abstract:
SQL Server 2014 In-Memory OLTP comes with a large set of limitations that prevents its widespread adoption and often makes refactoring and migration of existing systems cost ineffective. This session discusses two set of topics: 1. How to address and workaround some of In-Memory OLTP limitations, such as 8,060-byte maximum row size, missing support for unique and foreign key constraints and different indexing behavior. 2. How you can benefit from In-Memory OLTP objects even when system migration is cost ineffective.
Speaker(s): Dmitri Korotkevitch,
Abstract:
There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.
Speaker(s): Janis Griffin,
Abstract:
In today's world of technology interview, employees have come up with more and more tricks and puzzles to test your brain. How would you move mount fuji? How many basketballs would fit in this room? In this session Mike will cover these questions and many more. You will leanr what not to say and how to handle tough questions.
Speaker(s): Mike Davis,
Abstract:
SQL Server 2016 and Windows Server 2016 are just around the corner. There are changes and enhancements to the availability features that SQL Server deployments - Windows Server failover clusters (WSFCs), clustered instances (FCIs), and availability groups (AGs). This session will cover what is new and what has changed since Windows Server 2012 R2 and SQL Server 2014 for WSFCs, FCIs, and AGs.
Speaker(s): Allan Hirt,
Abstract:
Tired of dealing with Replication issues? Want high availability and readable replicas for reporting? The you should consider availability groups! This session provides a run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies.
Speaker(s): Jeff Reinhard,
Abstract:
Developers and DBAs: How do you determine what DataType will be required for your database? Far too often, Database Development teams are pressured into making quick decisions for their database models, usually full of NVarChars and GUIDs, typically based on a suggestion that these datatypes were the only useful datatypes for Web development. In this session, we will discuss the pro's and con's of the differing datatypes, and arm the Database Developers and DBAs with the analysis necessary to create databases that are easily maintained.
Speaker(s): Susan Rickman,
Abstract:
Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.
Speaker(s): Jason Carter,
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
Speaker(s): Steve Jones,
Abstract:
Are you a developer, network or systems admin that wants to become a database administrator? Or are you new to IT and think th role of the DBA might be the one for you? This presentation will start with discussing what a DBA does and how it varies from company to company, and then discuss how to acquire knowledge and experience as you try to land that first job as a working DBA.
Speaker(s): Andy Warren,
Abstract:
Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal? In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker(s): Dave Mattingly,
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,
Abstract:
Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.
Speaker(s): Lindsay Clark,
Abstract:
Flash Storage (Solid State Disks) have been proclaimed to be a DBA's best friend. But not all flash storage is the same. In this talk, we will drill down a bit into the technology, and talk about the issues that can degrade your application's performance. This talk examines those issues in detail, looking at how they specifically affect databases and the structured applications that depend on those databases. And just like the free version of Pandora Radio, there will only be one slide that is commercial in nature.
Speaker(s): Patrick Pinchera,
Abstract:
Many seasoned DBA's don't want developers to use triggers because of the many common mistakes made when coding triggers that can adversely affect performance. We will discuss the different types of triggers: DDL and DML (Instead of and after) and see many common mistakes made and how to fix them. We will also discuss when a trigger may be the best solution and other options when a trigger is not the best solution.
Speaker(s): Jack Corbett,
Abstract:
Many DBAs still hold onto the notion that each implementation of SQL Server requires a dedicated physical server. In today’s world dominated by virtualization and an ever increasing eye towards all things cloud, the infrastructure under SQL Server has a greater impact than ever before. This session will discuss the key differences between physical, virtual, and cloud; how the platform choice affects SQL Server deployments; and how Cisco’s UCS can benefit not only SQL Server and the DBAs, but also system administrators.
Speaker(s): Allan Hirt,
Abstract:
What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.
Speaker(s): Dustin Ryan,
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. You'll return to work with the confidence and know-how that you need to set up and manage a transactional replication topology.
Speaker(s): Kendal Van Dyke,
Abstract:
In case you missed the memo, times have changed in the Microsoft BI world! We are now seeing massive investment in both cloud and on-premises Microsoft BI with rapid weekly releases. In this roadmap session, we will cover the Microsoft BI vision and then dive deeper into what is coming next for SQL Server BI and Power BI. There are many enhancements being made across SQL Server, MDS, SSIS, SSRS, SSAS, Power BI cloud, Power BI Desktop and other areas. Please join me in this "not-to-miss" session to explore upcoming innovations and enjoy a few bleeding edge demos.
Speaker(s): Jen Underwood,
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker(s): Janis Griffin,
Abstract:
Data Science is a relatively new discipline. Core to this is the visualization of data. R is a language and environment used for data visualization and statistical computing. In this session we'll explore the basics of the R language and review some examples. Additionally we'll review an implementation that integrates R into an ASP.NET application, allowing for sophisticated ways to display dashboards.
Speaker(s): Robert Biddle,
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.
Speaker(s): Jeffrey Garbus,
Abstract:
Microsoft SQL Server and Microsoft Azure have been announcing so many features it’s hard to keep up. If you’ve heard of Cortana Analytics, you may be a little confused about what it is, and when you would use it. Buck Woody from the Cortana Analytics team is here to help with an overview of the Cortana Analytics stack, examples of how it works, information on what components to use when, and references to learn more. You’ll be able to amaze friend and family alike with your knowledge of the Blue side of the Force. No, really, you’ll be able to do that. He’ll prove it.
Speaker(s): Buck Woody,
Abstract:
This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.
Speaker(s): Daniel Janik,
Abstract:
In this session we will be covering one of Microsoft's latest Azure offerings SQL Data Warehouse, which leverages the massive parallel processing (MPP) architecture. We will talk about the differences between SMP vs MPP architectures and benefits of an MPP architecture in the cloud.
Speaker(s): Pankaj Satyaketu,
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/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
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.
Todd has been a Sales Engineer with Dell Software since April 2011. He has 20+ years of database design, development, architecture and administration experience. Todd has a B.S. in Management/MIS from Georgia Tech, and an MBA from Florida Atlantic University.
LinkedIn: http://www.linkedin.com/in/joshluedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft's Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
Contact: http://www.mitchellpearson.com
Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: https://www.linkedin.com/in/patrickdleblanc
Contact: http://patrickdleblanc.com
Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world. My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.
LinkedIn: https://www.linkedin.com/pub/allan-hirt/1/b72/673
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
LinkedIn: https://www.linkedin.com/in/sqlmiguel
Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015
LinkedIn: https://www.linkedin.com/in/marktab
Contact: http://marktab.net
Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft's strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.
LinkedIn: http://www.linkedin.com/in/louisdavidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.
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.
LinkedIn: http://www.linkedin.com/in/leighfreijo/
Leigh Freijo is a Manager in Database Administration for Raymond James Financial. Leigh is an experienced SQL Server DBA and the chapter leader of the Pinellas SQL User Group.
LinkedIn: https://www.linkedin.com/pub/jorge-novo/1/546/b70
Contact: http://etldevelopernotes.blogspot.com
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tuning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.
LinkedIn: https://www.linkedin.com/in/ericwisdahl
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.
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.
LinkedIn: http://www.linkedin.com/pub/colleen-morrow/2a/95a/651/
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
LinkedIn: http://www.linkedin.com/in/damuvenkatesan/
Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.
LinkedIn: https://www.linkedin.com/in/mikelawell
Contact: http://sqlserverassociates.com/Blog
Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant. He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services. He is also a certified Scuba instructor with a long bucket list of dive sites. He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.
LinkedIn: https://www.linkedin.com/pub/ian-lanham/1b/287/364
Ian is a Database Administrator in the Orlando area, and is a regular attendee of SQLSaturday#39;s and MagicPASS#39; monthly meetings.
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: https://www.linkedin.com/in/pinchera
Pat Pinchera is a senior storage architect with Tegile Systems covering Florida and the Caribbean, and has spent 27 years in the IT industry. Prior to Tegile, Pat was with EMC where he worked storage pre-sales for Microsoft applications (Exchange, SQL, Hyper-V), and he was with Sun Microsystems for 15 years. Pat got his Bachelors in Chemical Engineering, and Masters in Computer Science from Florida Institute of Technology. He has been married for 27 years, and has two college-aged children.
LinkedIn: https://www.linkedin.com/profile/view?id=AAMAAAAH_sgB9J_PJ0wL09W8JSW4Z6WEksORaMo
Jeff has been certified in various versions of SQL Server going back to version 4.2 - waaay back. He is a former Microsoft employee where he did SQL Server development. Jeff was the SQL Server lead for Veritas Storage Foundations product efforts while at Veritas Software and has provided consultative input to a wide range of international and fortune 500 companies. He has been a speaker at Microsoft TechEd, Veritas Vision and EMC World conferences and currently works for a Boston based
LinkedIn: http://www.linkedin.com/in/rdameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software. He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux. He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International. He is most active on Twitter as @RonDBA.
LinkedIn: https://www.linkedin.com/in/jeffreinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
LinkedIn: http://www.linkedin.com/in/pshaw1129/
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.
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.
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: http://www.linkedin.com/in/WayneSheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
LinkedIn: http://www.linkedin.com/in/buckwoody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
LinkedIn: http://www.linkedin.com/in/SQLWes/
Contact: http://SQLWes.com
Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.
LinkedIn: https://www.linkedin.com/in/briandavis78
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
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: 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: http://www.linkedin.com/in/blackwyrm
Contact: http://www.davemattingly.net
Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.
Contact: http://jason-carter.net
Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator
Работать с SQL Server начал в 2003 году. Довелось работать и сдавать сертификационные экзамены по версиям SQL Server от 2000 до 2012. Участник конференций SQLSaturday, Платформа, DevCon и TechEd. География выступлений от Тампы до Красноярска, от Санкт-Петербурга до Тбилиси. Основатель сообществ Krasnodar SQLamp;BI Usergroup и Global Russian Virtual Chapter. На данный момент являюсь PASS Regional Mentor for Central Eastern Europe.
Susan Rickman, Principal Consultant at Intellinet, has over 14 years of experience in leading enterprise-wide data solutions. She specializes in data integration and migration, performance tuning, clustering/high availability, disaster recovery, security, and virtualization. Susan lives in Atlanta, Georgia with her family and is actively involved in many local and global charities, as well as the local SQL Server Community.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
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.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Mr. Hyman is an IT professional with over twenty years experience, currently specializing is Business Intelligence, Data Warehousing and Back-End Process IT systems. Mr Hyman currently splits his time, between consulting assignments, and mentoring/training assignments. Mr. Hyman is considered an Expert in the Microsoft SQL Server Products as well as the ETL and Reporting tools, BizTalk and SharePoint. Building Data Warehouses from disparate systems is his specialty
LinkedIn: http://www.linkedin.com/in/jackcorbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016. Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control. Jack has presented at many user groups and SQLSaturday even
Contact: http://www.sqltwist.com
Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft's Flagship Database Engine, SQL Server. Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation. Pankaj is an active supporter of local user groups and SQLSaturday events in Florida. He is also a graduate of Florida Atlantic University.
Jorge Besada is a SQL Server DBA with more than 15 years experience as a DBA. An electronic engineer in a previous life with an MSEE degree, Jorge morphed into an Information Technology professional and is enjoying every minute of it. His main interest is in automation of all tasks using PowerShell and Python and switching between them as needed.
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: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.
LinkedIn: https://www.linkedin.com/pub/lindsay-clark/58/5b/29
Lindsay started out in network administration with a BA in Computer Science from South University prior to finding her true love in database administration. Whether it#39;s mentoring in the office or presenting sessions at SQLSaturday, Lindsay loves to find new ways to collaborate and share information. In addition to her role as DBA at American Credit Acceptance, she actively recruits speakers for her user group and chairs her local SQLSaturday event.
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
LinkedIn: https://www.linkedin.com/in/stuartainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He's a former DBA, developer, consultant, and public speaking professor. He's one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday's. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
LinkedIn: https://www.linkedin.com/pub/allan-hirt/1/b72/673
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
LinkedIn: http://www.linkedin.com/pub/robert-biddle/8/266/630
Contact: http://robert-biddle.com
Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.
LinkedIn: http://www.linkedin.com/pub/prakash-heda/8/a60/b77
Contact: http://www.sqlfeatures.com/
Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.
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.
LinkedIn: https://www.linkedin.com/in/sqlballs
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
LinkedIn: https://www.linkedin.com/in/usafmjscott?
Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx
Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.jenunderwood.com
Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/in/sqldusty
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.
The following is a list of sponsors that helped fund the event.


This is a dummy page that helps us demonstrate reusable CSS stylesheets. Go back.
Want tot try crossing out an obsolete link? This is your chance!


2018
My background
I studied architecture in Buenos Aires, Argentina. The intersection between aesthetics and functionality has always interested me. After moving to San Francisco, I rediscovered my love for technology and decided to make a career change to web design
Where do I stand now?
My background in architecture, design and research makes me confident in my abilities when developing design strategies
I enjoy design challenges and I believe collaboration is key for great solutions, I am a fan of design systems and I value partnering with developers and learning from them.


CubCon
One of our goals at Cal Hacks is to make hacker culture
accessible to anyone who wants to be a part of it, regardless of level of expertise in
programming and tech. In Spring 2017, we hosted our first ever CubCon, a series of
talks, workshops, and breakout sessions hosting several industry speakers and prominent campus
tech clubs geared torwards hackers with little or no experience. I chose to market the
event in a pixelated, video-game-inspired style.


Description
Gemini Checklists is a web-based tool to edit and browse daily checklists for the
observatory operations
Change Log
Version 0.6.1
- Fixed bug when a user wants to delete an engineer or technician entry
Version 0.6
- CHECKS-8 Add a field for a general comment on a check. You can indicate that you only want comments for a given check
- CHECKS-9 Support the concept of choices that trigger a warning if selected. On the template editor you can indicate what states are warnings
- CHECKS-4 Update to play framework 2.1
- CHECKS-5 Add gzip compression
Version 0.5.1
- Added Progress bar to each group indicating how many checks have been set
- Added Feedback button connected to JIRA
- FIX When simultaneous users edit engineers/technician names they overwrite each other, now they are merged
Version 0.5
- When closing a day an email can be sent. Email addresses and content can be configured on each template
Version 0.4.1
- Fixed bug when opening and closing the choices list on the template editor
Version 0.4
- Added support to create checklists in general. Checklists require a key and a name. The key cannot be changed
Version 0.3
- To each Checklist you can add Engineers names supervising the task and Technician names performing the task.
Names can be added directly on the checklist and will be remembered in the future. Names can be edited in the Template settings section.
- The status choices can be user defined and enabled differently for each check.
- A free text choice is also possible where you enter any text to the status instead of a list of choices.
- Groups on the checklist page are by default collapsed for easier navigation.
- Added date picker to easily move between dates
- Added back button to the template editor, let's you go back to the last edited checklist.
- Removed checklist top headers.
Version 0.2
- Checklists can be closed. A closed checklist cannot be edited anymore
- Added Report showing a monthly summary
- Elements on the template can be moved up and down
- Show About box with change log
- Support themes
- A nicer multiline input for checklist comments
Version 0.1
- Initial experimental release
- Support saving checklists and viewing day by day
- Template can be edited
Credits
Built by the Software Group.


Getting started:
User guide:
Functions:
Credits:
Shot detection:
Without perspective:
Accounting for perspective:
Using the GUI:
Calibration procedure:
Velocity:


Reports files with package statements that do not correspond to the directory structure.
The quick-fix suggests adjusting the package statement or moving the file into the correct directory.


Avoid tasks failing under spark_apply()
and multiple concurrent partitions running while selecting backend port.
Added support for numeric arguments for n
in lead()
for dplyr.
Added unsupported error message to sample_n()
and sample_frac()
when Spark is not 2.0 or higher.
Fixed SIGPIPE
error under spark_connect()
immediately after a spark_disconnect()
operation.
Added support for sparklyr.apply.env.
under spark_config()
to allow spark_apply()
to initializae environment varaibles.
Added support for spark_read_text()
and spark_write_text()
to read from and to plain text files.
Addesd support for RStudio project templates to create an “R Package using sparklyr”.
Fix compute()
to trigger refresh of the connections view.
Added a k
argument to ml_pca()
to enable specification of number of principal components to extract. Also implemented sdf_project()
to project datasets using the results of ml_pca()
models.
Added to ml_random_forest()
the following hyperparameter arguments: min.info.gain
, col.sample.rate
, min.rows
, impurity
, and thresholds
. Also added seed
for reproducibility.
Fixed error in spark_apply()
that may triggered when multiple CPUs are used in a single node due to race conditions while accesing the gateway service and another in the JVMObjectTracker
.
spark_apply()
now supports explicit column types using the columns
argument to avoid sampling types.
spark_apply()
with group_by
no longer requires persisting to disk nor memory.
Added support for Spark 1.6.3 under spark_install()
.
Added support for Spark 1.6.3 under spark_install()
spark_apply()
now logs the current callstack when it fails.
Fixed error triggered while processing empty partitions in spark_apply()
.
Fixed slow printing issue caused by print
calculating the total row count, which is expensive for some tables.
Fixed sparklyr 0.6
issue blocking concurrent sparklyr
connections, which required to set config$sparklyr.gateway.remote = FALSE
as workaround.
Added packages
parameter to spark_apply()
to distribute packages across worker nodes automatically.
Added sparklyr.closures.rlang
as a spark_config()
value to support generic closures provided by the rlang
package.
Added config options sparklyr.worker.gateway.address
and sparklyr.worker.gateway.port
to configure gateway used under worker nodes.
Added group_by
parameter to spark_apply()
, to support operations over groups of dataframes.
Added spark_apply()
, allowing users to use R code to directly manipulate and transform Spark DataFrames.
Added spark_write_source()
. This function writes data into a Spark data source which can be loaded through an Spark package.
Added spark_write_jdbc()
. This function writes from a Spark DataFrame into a JDBC connection.
Added columns
parameter to spark_read_*()
functions to load data with named columns or explicit column types.
Added partition_by
parameter to spark_write_csv()
, spark_write_json()
, spark_write_table()
and spark_write_parquet()
.
Added spark_read_source()
. This function reads data from a Spark data source which can be loaded through an Spark package.
Added support for mode = "overwrite"
and mode = "append"
to spark_write_csv()
.
spark_write_table()
now supports saving to default Hive path.
Improved performance of spark_read_csv()
reading remote data when infer_schema = FALSE
.
Added spark_read_jdbc()
. This function reads from a JDBC connection into a Spark DataFrame.
Renamed spark_load_table()
and spark_save_table()
into spark_read_table()
and spark_write_table()
for consistency with existing spark_read_*()
and spark_write_*()
functions.
Added support to specify a vector of column names in spark_read_csv()
to specify column names without having to set the type of each column.
Improved copy_to()
, sdf_copy_to()
and dbWriteTable()
performance under yarn-client
mode.
Support for cumprod()
to calculate cumulative products.
Support for cor()
, cov()
, sd()
and var()
as window functions.
Support for Hive built-in operators %like%
, %rlike%
, and %regexp%
for matching regular expressions in filter()
and mutate()
.
Support for dplyr (>= 0.6) which among many improvements, increases performance in some queries by making use of a new query optimizer.
sample_frac()
takes a fraction instead of a percent to match dplyr.
Improved performance of sample_n()
and sample_frac()
through the use of TABLESAMPLE
in the generated query.
Added src_databases()
. This function list all the available databases.
Added tbl_change_db()
. This function changes current database.
Added sdf_len()
, sdf_seq()
and sdf_along()
to help generate numeric sequences as Spark DataFrames.
Added spark_set_checkpoint_dir()
, spark_get_checkpoint_dir()
, and sdf_checkpoint()
to enable checkpointing.
Added sdf_broadcast()
which can be used to hint the query optimizer to perform a broadcast join in cases where a shuffle hash join is planned but not optimal.
Added sdf_repartition()
, sdf_coalesce()
, and sdf_num_partitions()
to support repartitioning and getting the number of partitions of Spark DataFrames.
Added sdf_bind_rows()
and sdf_bind_cols()
– these functions are the sparklyr
equivalent of dplyr::bind_rows()
and dplyr::bind_cols()
.
Added sdf_separate_column()
– this function allows one to separate components of an array / vector column into separate scalar-valued columns.
sdf_with_sequential_id()
now supports from
parameter to choose the starting value of the id column.
Added sdf_pivot()
. This function provides a mechanism for constructing pivot tables, using Spark’s ‘groupBy’ + ‘pivot’ functionality, with a formula interface similar to that of reshape2::dcast()
.
Added vocabulary.only
to ft_count_vectorizer()
to retrieve the vocabulary with ease.
GLM type models now support weights.column
to specify weights in model fitting. (#217)
ml_logistic_regression()
now supports multinomial regression, in addition to binomial regression [requires Spark 2.1.0 or greater]. (#748)
Implemented residuals()
and sdf_residuals()
for Spark linear regression and GLM models. The former returns a R vector while the latter returns a tbl_spark
of training data with a residuals
column added.
Added ml_model_data()
, used for extracting data associated with Spark ML models.
The ml_save()
and ml_load()
functions gain a meta
argument, allowing users to specify where R-level model metadata should be saved independently of the Spark model itself. This should help facilitate the saving and loading of Spark models used in non-local connection scenarios.
ml_als_factorization()
now supports the implicit matrix factorization and nonnegative least square options.
Added ft_count_vectorizer()
. This function can be used to transform columns of a Spark DataFrame so that they might be used as input to ml_lda()
. This should make it easier to invoke ml_lda()
on Spark data sets.
cbind.tbl_spark()
. This method works by first generating index columns using sdf_with_sequential_id()
then performing inner_join()
. Note that dplyr _join()
functions should still be used for DataFrames with common keys since they are less expensive.Increased default number of concurrent connections by setting default for spark.port.maxRetries
from 16 to 128.
Support for gateway connections sparklyr://hostname:port/session
and using spark-submit --class sparklyr.Shell sparklyr-2.1-2.11.jar <port> <id> --remote
.
Added support for sparklyr.gateway.service
and sparklyr.gateway.remote
to enable/disable the gateway in service and to accept remote connections required for Yarn Cluster mode.
Added support for Yarn Cluster mode using master = "yarn-cluster"
. Either, explicitly set config = list(sparklyr.gateway.address = "<driver-name>")
or implicitly sparklyr
will read the site-config.xml
for the YARN_CONF_DIR
environment variable.
Added spark_context_config()
and hive_context_config()
to retrieve runtime configurations for the Spark and Hive contexts.
Added sparklyr.log.console
to redirect logs to console, useful to troubleshooting spark_connect
.
Added sparklyr.backend.args
as config option to enable passing parameters to the sparklyr
backend.
Improved logging while establishing connections to sparklyr
.
Improved spark_connect()
performance.
Implemented new configuration checks to proactively report connection errors in Windows.
While connecting to spark from Windows, setting the sparklyr.verbose
option to TRUE
prints detailed configuration steps.
Added custom_headers
to livy_config()
to add custom headers to the REST call to the Livy server
Added support for jar_dep
in the compilation specification to support additional jars
through spark_compile()
.
spark_compile()
now prints deprecation warnings.
Added download_scalac()
to assist downloading all the Scala compilers required to build using compile_package_jars
and provided support for using any scalac
minor versions while looking for the right compiler.
copy_to()
and sdf_copy_to()
auto generate a name
when an expression can’t be transformed into a table name.
Implemented type_sum.jobj()
(from tibble) to enable better printing of jobj objects embedded in data frames.
Added the spark_home_set()
function, to help facilitate the setting of the SPARK_HOME
environment variable. This should prove useful in teaching environments, when teaching the basics of Spark and sparklyr.
Added support for the sparklyr.ui.connections
option, which adds additional connection options into the new connections dialog. The rstudio.spark.connections
option is now deprecated.
Implemented the “New Connection Dialog” as a Shiny application to be able to support newer versions of RStudio that deprecate current connections UI.
When using spark_connect()
in local clusters, it validates that java
exists under JAVA_HOME
to help troubleshoot systems that have an incorrect JAVA_HOME
.
Improved argument is of length zero
error triggered while retrieving data with no columns to display.
Fixed Path does not exist
referencing hdfs
exception during copy_to
under systems configured with HADOOP_HOME
.
Fixed session crash after “No status is returned” error by terminating invalid connection and added support to print log trace during this error.
compute()
now caches data in memory by default. To revert this beavior use sparklyr.dplyr.compute.nocache
set to TRUE
.
spark_connect()
with master = "local"
and a given version
overrides SPARK_HOME
to avoid existing installation mismatches.
Fixed spark_connect()
under Windows issue when newInstance0
is present in the logs.
Fixed collecting long
type columns when NAs are present (#463).
Fixed backend issue that affects systems where localhost
does not resolve properly to the loopback address.
Fixed issue collecting data frames containing newlines \n
.
Spark Null objects (objects of class NullType) discovered within numeric vectors are now collected as NAs, rather than lists of NAs.
Fixed warning while connecting with livy and improved 401 message.
Fixed issue in spark_read_parquet()
and other read methods in which spark_normalize_path()
would not work in some platforms while loading data using custom protocols like s3n://
for Amazon S3.
Resolved issue in spark_save()
/ load_table()
to support saving / loading data and added path parameter in spark_load_table()
for consistency with other functions.
connectionViewer
interface required in RStudio 1.1 and spark_connect
with mode="databricks"
.Fix to spark_connect
affecting Windows users and Spark 1.6.x.
Fix to Livy connections which would cause connections to fail while connection is on ‘waiting’ state.
Implemented basic authorization for Livy connections using livy_config_auth()
.
Added support to specify additional spark-submit
parameters using the sparklyr.shell.args
environment variable.
Renamed sdf_load()
and sdf_save()
to spark_read()
and spark_write()
for consistency.
The functions tbl_cache()
and tbl_uncache()
can now be using without requiring the dplyr
namespace to be loaded.
spark_read_csv(..., columns = <...>, header = FALSE)
should now work as expected – previously, sparklyr
would still attempt to normalize the column names provided.
Support to configure Livy using the livy.
prefix in the config.yml
file.
Implemented experimental support for Livy through: livy_install()
, livy_service_start()
, livy_service_stop()
and spark_connect(method = "livy")
.
The ml
routines now accept data
as an optional argument, to support calls of the form e.g. ml_linear_regression(y ~ x, data = data)
. This should be especially helpful in conjunction with dplyr::do()
.
Spark DenseVector
and SparseVector
objects are now deserialized as R numeric vectors, rather than Spark objects. This should make it easier to work with the output produced by sdf_predict()
with Random Forest models, for example.
Implemented dim.tbl_spark()
. This should ensure that dim()
, nrow()
and ncol()
all produce the expected result with tbl_spark
s.
Improved Spark 2.0 installation in Windows by creating spark-defaults.conf
and configuring spark.sql.warehouse.dir
.
Embedded Apache Spark package dependencies to avoid requiring internet connectivity while connecting for the first through spark_connect
. The sparklyr.csv.embedded
config setting was added to configure a regular expression to match Spark versions where the embedded package is deployed.
Increased exception callstack and message length to include full error details when an exception is thrown in Spark.
Improved validation of supported Java versions.
The spark_read_csv()
function now accepts the infer_schema
parameter, controlling whether the columns schema should be inferred from the underlying file itself. Disabling this should improve performance when the schema is known beforehand.
Added a do_.tbl_spark
implementation, allowing for the execution of dplyr::do
statements on Spark DataFrames. Currently, the computation is performed in serial across the different groups specified on the Spark DataFrame; in the future we hope to explore a parallel implementation. Note that do_
always returns a tbl_df
rather than a tbl_spark
, as the objects produced within a do_
query may not necessarily be Spark objects.
Improved errors, warnings and fallbacks for unsupported Spark versions.
sparklyr
now defaults to tar = "internal"
in its calls to untar()
. This should help resolve issues some Windows users have seen related to an inability to connect to Spark, which ultimately were caused by a lack of permissions on the Spark installation.
Resolved an issue where copy_to()
and other R => Spark data transfer functions could fail when the last column contained missing / empty values. (#265)
Added sdf_persist()
as a wrapper to the Spark DataFrame persist()
API.
Resolved an issue where predict()
could produce results in the wrong order for large Spark DataFrames.
Implemented support for na.action
with the various Spark ML routines. The value of getOption("na.action")
is used by default. Users can customize the na.action
argument through the ml.options
object accepted by all ML routines.
On Windows, long paths, and paths containing spaces, are now supported within calls to spark_connect()
.
The lag()
window function now accepts numeric values for n
. Previously, only integer values were accepted. (#249)
Added support to configure Ppark environment variables using spark.env.*
config.
Added support for the Tokenizer
and RegexTokenizer
feature transformers. These are exported as the ft_tokenizer()
and ft_regex_tokenizer()
functions.
Resolved an issue where attempting to call copy_to()
with an R data.frame
containing many columns could fail with a Java StackOverflow. (#244)
Resolved an issue where attempting to call collect()
on a Spark DataFrame containing many columns could produce the wrong result. (#242)
Added support to parameterize network timeouts using the sparklyr.backend.timeout
, sparklyr.gateway.start.timeout
and sparklyr.gateway.connect.timeout
config settings.
Improved logging while establishing connections to sparklyr
.
Added sparklyr.gateway.port
and sparklyr.gateway.address
as config settings.
The spark_log()
function now accepts the filter
parameter. This can be used to filter entries within the Spark log.
Increased network timeout for sparklyr.backend.timeout
.
Moved spark.jars.default
setting from options to Spark config.
sparklyr
now properly respects the Hive metastore directory with the sdf_save_table()
and sdf_load_table()
APIs for Spark < 2.0.0.
Added sdf_quantile()
as a means of computing (approximate) quantiles for a column of a Spark DataFrame.
Added support for n_distinct(...)
within the dplyr
interface, based on call to Hive function count(DISTINCT ...)
. (#220)


In my opinion, Object-Oriented Programming is more fun to work on than Functional Programming. Take note though that both of these have a purpose and each of them has their own advantages and disadvantages. I believe the best way to show it is through practical examples.
Lets start off with Functional Programming. This is a programming style where you simply code on how you want your script to act on an specific instance.
colors = {:first => "Red", :second => "Blue", :third => "Green"}
p colors
# => {:first => "Red", :second => "Blue", :third => "Green"}
p colors[:first]
# => "Red"
Object Oriented Programming on the other hand considers each part of your code an "Object". This means that each of them will have their own state and methods. For the example below, instead of assigning colors to a value, each color has it's own variable @name (this is called an instance variable) and its own method display (this is called an instance method)
class Color
def initialize(name)
@name = name
end
def display
p @name
end
end
colors = {:first => Color.new("Red"), :second => Color.new("Blue"), :third => Color.new("Green") }
colors[:first].display
# => "Red"
As you can see, each color now has it's own name and display method. Hope I was able to shed some light on the difference of Functional Programming and OOP.


Datetime
Delorean for Datetime Manipulation
This year’s pandemic necessitated different conference formats for data science professionals. The organizers of PyOhio decided to ask speakers to create 5- or 10-minute pre-recorded talks to be streamed continuously while participants discussed the content in a live chat session. The format was a success! And I am proud to have created this video all about the Python library Delorean.
Delorean makes working with datetimes in Python much less of a burden. Its simple syntax allows users: to do datetime arithmetic, to handle time zone shifts, to convert datetimes into human language like “3 days ago,” and to generate equally spaced datetime intervals.
Check out my video for a look at Delorean (along with many, many Back to the Future references) or watch the full PyOhio 2020 conference playlist on YouTube.
PYTHON · DATETIME


Sure, just bring the ingredients I need and I'll make it for you right away.
What would you like?
Choose Item


Once upon a time, was with his or her best friend superhero
named had plan to go to Hawaii for vacation. They bought their tickets
on the th of the month. They decided to go shopping together and buy matching
for their trip. They reached to Hawaii on time. Everything was going
well and they were enjoying from their vacation until the third day when they walked through the forest they heard
a strange voice and after that they saw some s that they were running.
Suddenly an earthquake happened. jumped to action and got everyone to safty.
Everything happened together and the heaven became a scary hill.
With 's help everyone was moved to safty.
there on time. it was a worse vacation for ever. The End.


|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object junit.framework.Assert junit.framework.TestCase android.test.InstrumentationTestCase roboguice.test.RoboUnitTestCase<AppType>
AppType
- The type of your Application class. This class must have a
constructor that accepts a Context argument and calls
ContextWrapper.attachBaseContext(android.content.Context)
public class RoboUnitTestCase<AppType extends RoboApplication>
Use RoboUnitTestCase when you'd like to make simple unit tests that
may depend on Context resources, but do not depend on Activities,
Services, ContentProviders, or other Contexts directly.
An example:
public class MyTest extends RoboUnitTestCase
Also, see the notes about your Application class below.
| Field Summary | |
|---|---|
protected com.google.inject.Injector |
injector
|
| Constructor Summary | |
|---|---|
RoboUnitTestCase()
|
| Method Summary | |
|---|---|
protected java.lang.Class<? extends RoboApplication> |
applicationType()
|
protected com.google.inject.Injector |
getInjector()
|
protected void |
runTest()
|
| Methods inherited from class android.test.InstrumentationTestCase |
|---|
getInstrumentation, injectInsrumentation, injectInstrumentation, launchActivity, launchActivityWithIntent, runTestOnUiThread, sendKeys, sendKeys, sendRepeatedKeys, tearDown |
| Methods inherited from class junit.framework.TestCase |
|---|
countTestCases, createResult, getName, run, run, runBare, setName, setUp, toString |
| Methods inherited from class junit.framework.Assert |
|---|
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail, failNotEquals, failNotSame, failSame |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Field Detail |
|---|
protected com.google.inject.Injector injector
| Constructor Detail |
|---|
public RoboUnitTestCase()
| Method Detail |
|---|
protected void runTest() throws java.lang.Throwable
runTest
in class android.test.InstrumentationTestCase
java.lang.Throwable
protected com.google.inject.Injector getInjector()
protected java.lang.Class<? extends RoboApplication> applicationType()
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |


-
Peter Thiel disagrees with you
fortune.com
The tech financier and intellectual provocateur has some ideas that may turn you off. But there's no arguing with his commercial achievements. That's ...
-
The Most Fascinating Profile You'll Ever Read About a Guy and His Boring ...
www.wired.com
Ariel Zambelich/WIRED Stewart is hungry. He’s munching on potatoes smothered in chicken fat drippings, sitting by a long metal table that once served ...
-
Input: Fonts for Code
input.fontbureau.com
Input is a typeface for code, designed by David Jonathan Ross and released by Font Bureau.
-
You Are Not Late
medium.com
Can you imagine how awesome it would have been to be an entrepreneur in 1985 when almost any dot com name you wanted was…
-
The digital degree
www.economist.com
FROM Oxford’s quads to Harvard Yard and many a steel and glass palace of higher education in between, exams are giving way to holidays. As students ...
-
The problem with home-cooked meals
www.vox.com
"The idea that home cooking is inherently ideal reflects an elite foodie standpoint."
-
xkcd: Lisp Cycles
xkcd.com
Warning: this comic occasionally contains strong language (which may be unsuitable for children), unusual humor (which may be unsuitable for adults), ...
-
Burn Baby Burn – AVC
avc.com
Andy sent me a WSJ piece with Bill Gurley yesterday. I don’t like to link to paid content so here’s a good Business Insider summary of the article ...
-
Y Combinator, a Start-Up Incubator, Goes to College - NYTimes.com
bits.blogs.nytimes.com
Stewart Brand, a counterculture icon of the 1960s, is known for a phrase technologists love to quote: “Information wants to be free.”
-
Zero to One: Notes on Startups, or How to Build the Future:Amazon:Books
www.amazon.com
Amazon Zero to One: Notes on Startups, or How to Build the Future
-
How to see into the future - FT.com
www.ft.com
Irving Fisher was once the most famous economist in the world. Some would say he was the greatest economist who ever lived. “Anywhere from a decade ...
-
What Twitter Followers Tell Us
foundersatwork.posthaven.com
Twitter recently allowed all its users to see data about their followers. I almost tumbled out of my chair when I discovered that mine were 19% ...
-
Why Amazon Has No Profits (And Why It Works)
ben-evans.com
(I also did a podcast with Ben Horowitz discussing these themes: see here) Amazon has a tendency to polarize people. On one hand, there is the ...
-
YC Investment Policy and Email List
blog.ycombinator.com
We’re making a change to the rule for YC partners making follow-on investments. Previously, partners could invest in companies after they had either ...
-
Breaking News, World News & Multimedia
www.nytimes.com
The New York Times: Find breaking news, multimedia, reviews & opinion on Washington, business, sports, movies, travel, books, jobs, education, real ...
-
My year with a distraction-free iPhone (and how to start your own ...
medium.com
In 2012, I realized I had a problem: Infinity in my pocket was too much.
-
Google Discussiegroepen
groups.google.com
Met Google Discussiegroepen kun je online forums en e-mailgroepen maken en eraan deelnemen. Bovendien profiteer je van uitgebreide ...
-
This Is The Terrifying Result Of The Militarization Of Police
www.businessinsider.com
When did this become OK? When did "protect and serve" turn into "us versus them"?
-
Why Some Schools Are Selling All Their iPads
www.theatlantic.com
Four years after Apple introduced its popular tablet, many districts are switching to laptops.
-
I was an Extraordinary Alien... For a Week
philsturgeon.uk
A personal write-up of something I've not been able to talk about for a while. Probably the most complicated year of my life.
-
Think Pinterest Is Stupid? This Interview Might Change Your Mind
www.theatlantic.com
Evan Sharp, one of the co-founders of Pinterest, delves into what the wildly popular image-collecting site is really about, and what it's likely to ...
-
The Happy Demise of the 10X Engineer | Andreessen Horowitz
a16z.com
Whatsapp had 450 million monthly users and just 32 engineers when it was acquired. Imgur scaled to over 40 billion monthly image views with just ...
-
Black Swan Seed Rounds
blog.samaltman.com
I started seed investing in 2010 (and much more actively in 2012) before becoming a full-time YC partner. In this period, I invested in about 40 ...
-
With immigration reform off the agenda, some in tech turn to plan B
www.washingtonpost.com
The immigration issue fell down the tech industry's political priority list. But it's not totally gone.
-
Understanding SaaS: Why the Pundits Have It Wrong | Andreessen Horowitz
a16z.com
Tune into any cable network stock market channel and the airwaves resonate with one consistent theme: SaaS companies are simply too expensive. In ...
-
The New York Times Calls for Marijuana Legalization
www.nytimes.com
The federal government should follow the growing movement in the states and repeal the ban on marijuana for both medical and recreational use.
-
Last Week Tonight with John Oliver: Net Neutrality (HBO)
www.youtube.com
Cable companies are trying to create an unequal playing field for internet speeds, but they're doing it so boringly that most news outlets aren't ...