Event Location:
Loyola Marymount University ("LMU")
1 LMU Drive, Los Angeles, California
Los Angeles, California
Abstract:
In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker(s): Phil Robinson,
Abstract:
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls. In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker(s): Jeff Mlakar,
Abstract:
We all know that execution plans and indexes are important pieces to performance tuning jobs. However, they are definitely not the only tools in the toolbox. This session will take a more high-level, holistic, approach to performance tuning jobs and their components. We will talk about where to start, how to identify problem areas, and many ways to improve performance. Many of the topics covered in the presentation come from real-world situations I've encountered. One example describes how we stopped a job after 13 hours and were able to tune it down to 8 minutes. Adding additional hardware is not always an option or the answer. Do more with what you have and tune your jobs. I'll show you how.
Speaker(s): Jeff Prom,
Abstract:
If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same. In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.
Speaker(s): Andrew Karcher,
Abstract:
Have you ever come across such business scenarios when you feel you have challenged your Reticular Activating System to find an “out-of-the-box solution for Master Data Management in your Reporting System”? Have you ever thought about a self-service BI system, designed and customized, only for your Master Data? Often times, in IT industry executives neglect the fact that 30% of their data visualization contains Master Data. Integrating Master Data Services with Power BI, and presenting analytics on top only Master Data, can provide a high-end leverage to your organization. Whether it is a location model, a product model, a customer model etc., executives can highly be insightful from a report that contains all master data domains consolidated with a better visualization. Using individual subscription views from Master Data Services(SQL Server 2017) in Power Query, and utilizing all the cross references entities across models in MDS – can lead to a great one page report via Power BI.
Speaker(s): Swagatika Sarangi,
Abstract:
Take a dive into SQL on Linux and take on some sea monsters that are lurking in your bathtub. We'll take on the biblical Leviathan and answer: Why learn SQL on Linux anyway? We'll hunt down Moby Dick by sharpening our harpoons, by using tools you're probably already using with on Windows. After getting our feet wet, we'll go after the legendary beast, The Kraken, by leveraging your existing skills with Linux. Don't be eaten alive by Jaws and all the new fast-paced piranha-like features of SQL 2017. You can sail safely into the sunset by making SQL on Linux fun, memorable and learning lasting skills that will future proof your career. If you can install, backup, and restore SQL on Windows in your sleep, then perhaps now is the time to jump in. Be careful, you might get wet in the splash zones so dress accordingly or at least bring weather proof gear. Anchors Away!
Speaker(s): Andrew Nakamura,
Abstract:
Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or if a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? If only you had performance metrics from your existing servers to answer these questions. In this session, we will be combining three open source tools (Telegraf, InfluxDB, and Grafana) into an inexpensive system that collects performance metrics you can use to troubleshoot and answer important questions about your SQL Server instances, including your SQL Server on Linux instances. We will learn what data to collect, how to use the tools mentioned to collect that data and then we'll put it all together in an interactive dashboard for easy visualization.
Speaker(s): Tracy Boggiano,
Abstract:
This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency. We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda
Speaker(s): Leonard Lobel,
Abstract:
Microsoft’s Power BI service has allowed end users and business analysts to exercise their creativity as developers. The expansion of department resources to create elegant and visually appealing reports for themselves and their organization at a fast pace, has taken some of the burden off developers, or has it? Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports? In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and data modeling. In this session, we will look at potential data management concerns that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity. We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.
Speaker(s): Jeremy Frye,
Abstract:
Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.
Speaker(s): Konstantin Melamud,
Abstract:
Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL. Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker(s): Daniel Janik,
Abstract:
With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality in SSRS 2016: A look at the new Report Manager interface, Mobile reports, KPIS and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to take an existing report and make it mobile friendly. The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.
Speaker(s): Ted Stathakis,
Abstract:
SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started! In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Speaker(s): Chris Hyde,
Abstract:
Join our interactive discussion on diversity and inclusion. This WIT talk is open to all attendees. Let’s share our perspectives in career growth in this inevitable diverse industry. Learn some tips and tricks on how you can grow your potential and help others to grow as well. Session format: * Improve style, no PowerPoint required * Multiple speakers, 10 to 15 minutes each * Talk about your career, how you got started, what worked for you, what didn’t, advice on getting ahead, and what you love most about your job Speakers: Amy Herold, Mindy Curnutt, Swagatika Sarangi, Amie Mason, Tracy Boggiano, Marsha Pierce
Speaker(s): SQL Saturday in LA,
Abstract:
This session will explore how to host your SQL Server databases on Amazon Web Services (AWS), comparing the Relational Database Service (RDS) SQL Server platform to hosting your databases on EC2. We will explore the versions supported, provide an overview of how licensing works, explain options around High Availability, and also explore migration options from on-premise, EC2, or other hosted SQL Server solutions.
Speaker(s): Richard Waymire,
Abstract:
Way, way back in SQL 2008 Microsoft added the capability to store and work with geospatial data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things. Come to this session to learn about: ● The two elusive data types (geography and geometry) ● T-SQL Spatial routines and functions ● How to load spatial data ● Spatial Indexes - how they work and when they're useful ● Where you can get lots and lots of free spatial data to supplement your existing systems
Speaker(s): Mindy Curnutt,
Abstract:
The way you tune your SQL Server workloads are changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, we will harness the ways you improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.
Speaker(s): John Sterrett,
Abstract:
In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution. Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Speaker(s): Jason Horner,
Abstract:
One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s): Chris Hyde,
Abstract:
The General Data Protection Regulation (GDPR), which took effect on May 25, 2018 heralds a new era of enhanced personal privacy rights and adds additional duty to companies for protecting data. However, it’s not just about protecting the privacy of personal data of EU citizens. Data breaches such as at Target, Equifax, Uber and many others, result in loss of customers, loss of profits and cost executive jobs. A survey by Forrester reveals that 74% of individuals are ready to switch to a competitor if their bank or insurer suffers a data breach. Security and Privacy capabilities ranks as the number 1 initiative by 55% of organizations in a 2017 Customer Priorities Journey Survey. In this session, we will discuss all things data protection with the Microsoft Data Platform. Whether it is to comply with the requirements of GDPR or ensuring that your data is the most secure it can be.
Speaker(s): Rushabh Mehta,
Abstract:
We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.
Speaker(s): Armando Lacerda,
Abstract:
Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker(s): Amy Herold,
Abstract:
In this session we will go over the steps involved with getting a Database Dev environment set up on your Mac using SQL Server on Linux,Docker and SQL Operations Studio. We will go over installation of Docker and SQL Server, tips and tricks on data persistence in Docker, and how to connect and work with SQL Server running Docker using SQL Operations Studio.
Speaker(s): Charles Embry Jr,
Abstract:
Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.
Speaker(s): Rick Lowe,
Abstract:
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that. NOTE: This is an intro to Linux for Windows users, only brief references to SQL Server on Linux will be made.
Speaker(s): Jay Falck,
Abstract:
This session will discuss the trials and tribulations encountered when shifting from on-premise databases into AWS. We will cover topics such as: permissions, EC2 RDS setup, Database Migration Services, using Amazon S3 to transfer and restore databases, and cost analysis.
Speaker(s): Nathaniel Payumo,
Abstract:
Many organizations have over- or under-utilized assets in their cloud infrastructure. While running infrastructure in the cloud can yield many benefits in terms of agility and innovation, it can also lead to increased costs. In this session we will walk you through the process of rightsizing, as well as how to take advantage of Reserved Instances once your infrastructure is running efficiently. This session will be beneficial for anyone using AWS, Azure, or both!
Speaker(s): SQL Saturday in LA,
Abstract:
Learn about Azure SQL Data Warehouse (SQL DW) which is a fully managed elastic database built for data warehouse workloads supporting up to petabytes of data. It has unique features like disaggregated compute and storage allowing customers to be able to utilize the service to match their diverse needs. In this session, we take a look at the architecture of SQL DW and features such as elastic scale (grow, shrink, and pause) and Polybase and how you take advantage of them for your data warehousing solution.
Speaker(s): Kevin Ngo,
Abstract:
In a cloudy, virtualized world where we have less physical deployments of SQL Server, those responsible for SQL Server still need to understand basic infrastructure concepts whether you are deploying on Windows Server or Linux. Without them, your VMs and IaaS deployments will not scale, will underperform, and most likely will have poor availability. This session will cover the basics of what you need to know whether you are deploying SQL Server on premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.
Speaker(s): Allan Hirt,
Abstract:
Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.
Speaker(s): Benjamin Nevarez,
Abstract:
Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program.
Speaker(s): Brodie Brickey,
Abstract:
Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.
Speaker(s): Steve Jones,
Abstract:
For most DBAs virtualization is no longer a matter of "If" but "When". This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We'll also cover how to troubleshoot performance issues when they arise.
Speaker(s): Brandon Leach,
Abstract:
Dexter and Dee Dee are at it again! They managed to save the city with his super intellect and sister's hyperactive charm. We won't have to keep our lab a secret as you attend this session. Learn how to build your own Machine Learning Lab, without the keeping it underground. We will cover the fundamental knowledge to get started because you don't want you blowing up things in production. Learn step-by-step in my demo to build a full lab so you too can save the city…or at least get started with Machine Learning today.
Speaker(s): PEIXIN WANG,
Abstract:
In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before! Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Speaker(s): Peter Kral,
Abstract:
We will be discussing the lifecycle of a Power BI Dashboard beginning from Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.
Speaker(s): Suresh Datla,
Abstract:
Amazon Web Services (AWS) is the world's largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.
Speaker(s): Brian Carrig,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
Microsoft report authors work in several tools, including T-SQL, SSMS, SSRS, and Power BI. Come to this session to learn 60 rapid fire tips that will make you not only be better, but increase you enjoyment working with those tools.
Speaker(s): Ike Ellis,
Abstract:
A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker(s): Marsha Pierce,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you. However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.
Speaker(s): Randy Knight,
Abstract:
The purpose of this presentation is to provide a better understanding of SSISDB and how it can be utilized to make the lives of developers and DBAs easier. This presentation will demonstrate how to use SSISDB to script out deployments of folders, projects, environments and packages, and dynamically assign environment variables. We will write scripts to run our SSIS packages and use SSRS to kick them off. We will learn how to create SSRS Reports that recreate the All Executions and All Messages built-in reports and make them available to user developers.
Speaker(s): Elaena Bakman,
Abstract:
TBD
Speaker(s): SQL Saturday in LA,
Abstract:
Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation’ This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.
Speaker(s): Marco Russo,
Abstract:
Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.
Speaker(s): Amie Mason,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/jeffmlakar/
Contact: http://www.mlakartechtalk.com/
Jeff Mlakar is a database professional specializing in Microsoft SQL Server. He has worked the past 15 years as a database developer and administrator (admini-loper or develo-strator…take your pick), analyst, and with Business Intelligence. A technology enthusiast – he is interested in data security and privacy topics. Jeff lives in the Raleigh-Durham area of NC.
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
LinkedIn: http://www.linkedin.com/in/jasonhorner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I'm a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
LinkedIn: http://www.linkedin.com/in/ikeellis
Contact: http://blog.ikeellis.com
Ike Ellis is a Senior Data Architect and partner for Crafting Bytes. He has designed and implemented data solutions for many well-known organizations. He has been a Microsoft Data Platform MVP since 2011. He co-authored the book "Developing Azure Solutions," now in its second edition. He is a popular speaker at SQLBits, PASS Summit, and SQL in the City. He speaks at user groups, code camps, and SQLSaturdays. He has written courses on SQL Server for developers, Power BI, SSRS, SSIS, and SSAS for Wintellect. He has an upcoming course on CosmosDB. He founded the San Diego Tech Immersion Group, a technical book club based in San Diego and is the co-chair of the San Diego Software Architecture Group.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: http://www.linkedin.com/in/tedstathakis
Contact: http://fishheadted.com
Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn't consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.
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.
LinkedIn: https://www.linkedin.com/in/jeffprom
Contact: http://www.jeffprom.com
Jeff Prom is a Data and BI Developer with over 19 years experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Bridgepoint Education as a Business Intelligence Data Architect.
LinkedIn: https://www.linkedin.com/in/brodie-brickey-b074988/
Over eighteen years in Information Technology developing solutions for companies. I specialize in integrating information from disparate systems for legal and financial firms. PMP ITIL certified.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: https://www.linkedin.com/in/nathanielpayumo/
Nathaniel Payumo is a database engineer engaged in numerous platforms including: T-SQL, SSIS, SSRS, and numerous AWS Cloud Services. He has built numerous applications using AWS Serviceless Framework and has developed APIs using Python, Application Front-Ends using JavaScript and ReactJS. He has explored Machine Learning Tools and integrated them within business applications and ETLs.
LinkedIn: http://www.linkedin.com/in/armando-lacerda
Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
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/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
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 SQL Saturdays.
LinkedIn: https://www.linkedin.com/in/jayfalck
I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I’ve spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I’ve used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.
LinkedIn: https://www.linkedin.com/in/tracyboggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQL Saturday – San Diego.
LinkedIn: https://www.linkedin.com/in/richardwaymire/
Richard Waymire is a technical expert on Microsoft SQL Server. He has been involved in numerous Microsoft early adaptor projects and new technologies. Richard has broad ranging experience from the relational data modeling phase through the production implementation of database solutions built with SQL Server, including data loading, monitoring, and performance tuning. Richard has worked on SQL Server for more than 26 years, including 12 years as part of the SQL Server team at Microsoft. In his role with Amazon Web Services, Richard is the Americas specialist for SQL Server, as well as for Amazon Aurora.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
LinkedIn: https://www.linkedin.com/in/sarangiswagatika/
Contact: https://www.jazzintelligence.com/
*** AWS - SA Informatica - MDM Certified, Solutions Architect *** I have had nearly a decade of experience in leading Data Governance, Master Data and Data Quality oriented efforts, strategizing business plan, implementing all phases of SDLC and Agile for clients/projects including Telecommunication, Oil Gas, Sporting goods, Logistics, Consulting, Insurance, Restaurant Education etc. domain. I have extensive experience with developing effective business roadmaps and business models across E-Commerce, B2C, B2B, B2B2C with a major focus in effectively evaluating/and aligning Business Intelligence Analytics Data Warehousing with the appropriate KPI's.
LinkedIn: https://www.linkedin.com/in/ki6bjv
Mr. Embry is the current Database Administrator/Programmer for the Choice Medical group in Apple Valley, Ca. He has previously been the Database Administrator/Programmer at the Snowline Joint Unified School District. Mr Embry has present at several SQL Saturday events in Southern California, he has also presented at the Aeries User Conference and CETPA Annual Conference.
LinkedIn: https://www.linkedin.com/in/ngovkevin/
Kevin Ngo is a Program Manager on the Azure SQL Data Warehouse engineering team with a BS in Computer Science from UC San Diego. He is currently working in areas of the service related to tooling and manageability.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: http://www.linkedin.com/in/lennilobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
LinkedIn: https://www.linkedin.com/in/jeremyilfrye
Contact: https://jeremyfrye.net
Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday's throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.
LinkedIn: http://www.linkedin.com/in/sqlbi
Contact: https://www.sqlbi.com/blog/marco
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.
LinkedIn: http://www.linkedin.com/pub/andy-nakamura/18/12/709/en
Contact: http://andynakamura.com
Andrew Nakamura is a SQL DBA at Keck Medicine of USC. His experience spans enterprise wide level of support using Powershell, DBATools and other custom scripts to maintain 115 servers with over 1600 databases. He has expertise in both Financial and Healthcare worlds and knows the challenges they face. He has presented in all Southern California SQL Saturdays and will continue to push bleeding edge solutions. He enjoys the command line syntax and wish like to play with Core Editions of Windows and SQL 2017. He's added to his current passions of Azure, Automation, High Availability, Family and Faith, Toastmasters, and now, SQL on Linux. Long live the command shell!
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
LinkedIn: https://www.linkedin.com/groups/13514278
Contact: http://www.instagram.com/sqlsatla
What is SQL Saturday? http://www.sqlsaturday.com/773 @SQLSatLA #SQLSatLA PASS SQL Saturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Hundreds of SQL Server and other IT professionals will be in attendance. With 6 simultaneous tracks potentially offering 40+ sessions in anything from database administration to performance tuning as well as business intelligence and professional development conducted by MVP-grade speakers. SQL Saturday is an invaluable learning and networking opportunity for SQL professionals and a great way to spend a Saturday.
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
LinkedIn: https://www.linkedin.com/in/sqlservernerd
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
LinkedIn: https://www.linkedin.com/in/elaena-bakman-473457a/
For the first 15 years of my IT career I worked as a CRM Developer, but have been passionate about SQL since SQL Server 6.4. Five years ago I finally made the switch to the dark side and never looked back. I currently work as a Sr. Database Architect specializing in SSIS, SSRS, RDS, EC2 and enterprise level cloud migration.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQL Saturday and User Groups.
LinkedIn: https://www.linkedin.com/in/sureshdatla/
Worked on the Microsoft stack for 19 years now. Built successful Data Analytics Practices before. Currently focused on Data Platform, Data Analytics, Power BI and ML. I do Dashboard in a day sessions at Irvine MTC once every month. I also, conduct OC power BI user group to build a strong Power BI Community. Worked with SQL Server product since it was version 7 and Power BI since its inception.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
LinkedIn: https://www.linkedin.com/in/peterkral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
LinkedIn: https://www.linkedin.com/in/marsha-pierce-1a020a2
Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.
SQL SERVER DBA/DEVELOPER; ORACLE DEVELOPER/DBA; SAS PROGRAMMER/ADMIN; QLIKVIEW DEVELOPER/DBA; JAVA PROGRAMMER
Contact: http://www.andrewkarcher.com
Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQL Saturdays and Conferences along with supporting my local community as a SQL Saturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.
LinkedIn: https://www.linkedin.com/in/rushabhbmehta
Rushabh is a Principal Architect at SolidQ and the Founder/CEO of Matchbook Services. With over 20 years of experience in the data management, mastering and analytics space, Rushabh has developed a keen understanding of the role of good data management strategies and their impact to an organization.
LinkedIn: http://www.linkedin.com/in/amiemason33
Consultant with a demonstrated history of working with clients across multiple verticals to leverage their data to improve reporting and decision making in their business. Able to quickly assess business requirements and skilled in report design and predictive analytics enabling a direct translation from those requirements to business impact. Broad background includes experience in the public sector, survey design, and grassroots campaign management.
The following is a list of sponsors that helped fund the event.


Employee's Name
First Name
Last Name
Employee's Hire Date
Employee's Title
Employee's Department
Performance Evaluation
Attendence
Very Good
Good
Fair
Poor
Very Poor


Filter rules are used to define the filters that apply to the incoming phone numbers in order to trigger an action. The rule is specified by the name, a short description and the filter patterns that apply to this rule. Editing of the filter patterns is done by a separate activity which can be accessed by clicking the main button on the screen. A filter rule must have a name, and the name must be unique: saving is disabled otherwise. Saving is also disabled whenever there are no changes to save.
Editing a rule allows certain action to be performed, but depending on the context some action will be disallowed (disappear from the action bar) while other will be possible and hence visible. At any moment in time, some hints are given in the bottom purple text view, so keep an eye on it
These are the icons for the editing actions and their meanings:


Class
VerifiedUserEntity
public final class VerifiedUserEntity
User information in Payload of JWT.
APIs that require Payload information to complete processing are automatically expanded by Middleware and relayed to the controller. See AuthenticateThenExpandPayloadMiddleware for details.
Note
SessionPayload is a struct and has an exp that does not require a relay. I thought I should have another class.
Relationships
Nested Types
VerifiedUserEntity.Key
Initializers
init(id:username:token:)
public init( id: Int?, username: String?, token: String?)


See: Description
| Interface | Description |
|---|---|
| Collator<ValueIn,ValueOut> |
This interface can be implemented to define a Collator which is executed after calculation
of the MapReduce algorithm on remote cluster nodes but before returning the final result.
Collator can for example be used to sum up a final value. |
| CombinerFactory<KeyIn,ValueIn,ValueOut> | |
| Context<K,V> |
The Context interface is used for emitting keys and values to the intermediate working space of
the MapReduce algorithm.
|
| Job<KeyIn,ValueIn> |
This interface describes a mapreduce Job that is build by
JobTracker.newJob(KeyValueSource) .It is used to execute mappings and calculations on the different cluster nodes and reduce or collate these mapped values to results. |
| JobCompletableFuture<V> |
This is a special version of ICompletableFuture to return the assigned job
id of the submit operation.
|
| JobPartitionState |
An implementation of this interface contains current information about
the status of an process piece while operation is executing.
|
| JobProcessInformation |
This interface holds basic information about a running map reduce job like
state of the different partitions and the number of currently processed
records.
The number of processed records is not a real time value but updated on regular base (after 1000 processed elements per node). |
| JobTracker |
The JobTracker interface is used to create instances of
Job s depending
on the given data structure / data source. |
| KeyPredicate<Key> |
This interface is used to pre evaluate keys before spreading the MapReduce task to the cluster.
|
| LifecycleMapper<KeyIn,ValueIn,KeyOut,ValueOut> |
The LifecycleMapper interface is a more sophisticated version of
Mapper normally used for complexer
algorithms with a need of initialization and finalization. |
| Mapper<KeyIn,ValueIn,KeyOut,ValueOut> |
The interface Mapper is used to build mappers for the
Job . |
| MappingJob<EntryKey,KeyIn,ValueIn> |
This interface describes a mapping mapreduce Job.
For further information Job . |
| PartitionIdAware |
This interface can be used to mark implementation being aware of the data partition
it is currently working on.
|
| ReducerFactory<KeyIn,ValueIn,ValueOut> |
A ReducerFactory implementation is used to build
Reducer instances per key.An implementation needs to be serializable by Hazelcast since it might be distributed inside the cluster to do parallel calculations of reducing step. |
| ReducingJob<EntryKey,KeyIn,ValueIn> |
This interface describes a reducing mapreduce Job.
For further information Job . |
| ReducingSubmittableJob<EntryKey,KeyIn,ValueIn> |
This interface describes a submittable mapreduce Job.
For further information Job . |
| TrackableJob<V> |
This interface describes a trackable job.
|
| Class | Description |
|---|---|
| Combiner<ValueIn,ValueOut> | |
| KeyValueSource<K,V> | |
| LifecycleMapperAdapter<KeyIn,ValueIn,KeyOut,ValueOut> |
The abstract LifecycleMapperAdapter superclass is used to ease building mappers for the
Job . |
| Reducer<ValueIn,ValueOut> |
The abstract Reducer class is used to build reducers for the
Job .Reducers may be distributed inside of the cluster but there is always only one Reducer per key. |
| Enum | Description |
|---|---|
| JobPartitionState.State |
Definition of the processing states
|
| TopologyChangedStrategy |
This enum class is used to define how a map reduce job behaves
if the job owner recognizes a topology changed event.
When members are leaving the cluster it might happen to loose processed data chunks that were already send to the reducers on the leaving node. In addition to that on any topology change there is a redistribution of the member assigned partitions which means that a map job might have a problem to finish it's currently processed partition. The default behavior is immediately cancelling the running task and throwing an TopologyChangedException but it is possible
to submit the same job configuration again if
JobTracker.getTrackableJob(String)
returns null for the requested job id. |
| Exception | Description |
|---|---|
| RemoteMapReduceException |
This exception class is used to show stacktraces of multiple failed
remote operations at once.
|
| TopologyChangedException |
This exception is thrown when a topology change happens during the
execution of a map reduce job and the
TopologyChangedStrategy
is set to TopologyChangedStrategy.CANCEL_RUNNING_OPERATION . |
This package contains the MapReduce API definition for Hazelcast.
All map reduce operations running in a distributed manner inside the
active Hazelcast cluster. Therefor Mapper
,
Combiner
and Reducer
implementations need to be fully serializable by Hazelcast. Any of the
existing serialization patterns are available for those classes, too.
If custom KeyValueSource
is provided above
statement also applies to this implementation.
For a basic idea how to use this framework see Job
or Mapper
, Combiner
or
Reducer
.
Copyright © 2016 Hazelcast, Inc.. All Rights Reserved.


--- layout: post title: "New Project" date: 2017-04-16 11:35:00 +0000 tags: image: https://s3.amazonaws.com/contrafabulists/2017-02-14-owl.jpg imagecredits: http://bryanmmathers.com author: Audrey Watters ---
We have started work on a new Contrafabulists project: predictions.contrafabulists.com.
We plan to track the predictions made about the future; and we'll see who's right, who's wrong, and who's committed to a certain technological vision of tomorrow.
How many years until self-driving cars? How many years until robots take our jobs? What's the history of these predictions? What can we learn from them?


--- layout: post title: New version of preprint ---
There is a new version of my pre-print "Structure- & Physics- Preserving Reductions of Power Grid Models" available on the Arxiv.


Because we can, and now so can you! Folks pleaded, "Pat, just stop. Please!"
"Nay.", Pat spoke, and the salmon shirt was born. Show your support for wholly gratuitous ventures in savory dessert experiments with this magestic T-shirt!
Because we can, and now so can you! Folks pleaded, "Pat, just stop. Please!"
"Nay.", Pat spoke, and the salmon shirt was born. Show your support for wholly gratuitous ventures in savory dessert experiments with this magestic T-shirt!


Having some experience with Kotlin from my Space Game project and some interest in seeing how various algorithms work because I was taking Algorithms and Data Structures. I wanted to try to make a Kotlin multiplatform project using Kotlin's coroutines. This project ended up being an algorithm visualizer that would run in the browser, by compiling the Kotlin to Javascript, and in the JVM.
By using coroutines and some syntax sugar from Kotlin, I was able to write these algorithms in such a way that they were almost the same code as the normal algorithms. Only multithreaded algorithms, such as the parallel merge sort and parallel quicksort, had large bits that were related to the implementation of the algorithm renderer. The end result, compiled to JavaScript is available below.


Profile
Projects
About Me
Extracurricular
Social Engament
Tastes
Awards
Calculus
Other
Natureza
Test
This is the First photo
This is the Second photo
This is the Third photo
This is the Fourth photo
This is the Fifth photo
×
Hey send me a message :)
Name:*
E-Mail:*
Subject:*
Message
Sugestion
Critics
Help me with a Project/Ideia
Message:*
menu
Lucas Lukasavicus
Profile
Projects
About Me
Extracurricular
Social Engament
Tastes


student
<EMAIL_ADDRESS>npm install -g @angular/cli
ng new "your project"
ng serve
Modules
Components
Services and dependency injection
angular.io
angular24.ru
learn.javascript.ru


Angular jS sample application
Enter first name:
Enter last name:
You are entering: {{student.fullName()}}


Since 1926, the AAMGA has served as the trade association to international wholesale insurance professionals, and as a leader representing the interests of its members before the federal, state and local governmental and regulatory agencies, to elected officials and other industry trade associations in the US, Canada and Europe.
Click here to order your personal copy of the AAMGA's "Proud History - Bright Future: Volume II (1991-2011)" book.
Click here to view the wholesale insurance industry's newest magazine "WIN."
AAMGA Annual Meeting
New Orleans Marriott Hotel
New Orleans, LA
AAMGA Committee Days
Chicago, IL
University West
Scottsdale, Arizona
UFO 22nd Annual Meeting
Samoset Resort On The Ocean
Rockport, ME


Building A News Crawler
May 25, 2016
One of the things that I enjoy doing is text mining. Basically going through huge text corpora like a mad man searching for different patterns. In order to feed this odd habit, I need collections of texts. There are countless public corpora available, but building your own from scratch rewards some kind of an unexplainable joy. It might be one of those tasks which are not too hard to be overwhelming, yet challenging enough to be rewarding. I might be broken. I might need help. But that’s a different story.
I used to do this with Ruby utilizing Nokogiri. But I found out that Python has so much more tools for automating almost everything, so in this post I’m going to describe the steps that I took to build this crawler.  Scream in the comment section if you please. And some of the tools are completely new to me, so forgive me if I mess up some of the steps.
So, let’s get it going. First, we need to identify our source for text. Lately, I enjoy mining news articles. And on top of that, you can almost be certain that the patterns that you uncover are new patterns that no one else has discovered. Cool, we have a place to start.
The best place to get news programmatically might be RSS Feeds. RSS Feeds might not be as hip as they once were, but most news portals still provide them. How to read these feeds?
I found feedparser. This is pretty sweet. So install it on Python.
pip install feedparser
Their documentation is awesome. I got my feedparser up and running in no time. To test out my parser I will be using BorneoPost as a news feed. I played around in IPython to get some familiarity.
import feedparser
parsed = feedparser.parse("http://www.theborneopost.com/feed/")
parsed.entries
Nice. Now I can create a new list of links.
links = [el["link"] for el in parsed.entries]
Now I need to extract the content from each link. Content extraction refers to extracting the main content from the sites. For us humans, this task is trivial. But for computers, the whole site is a HTML document. We could write a program that parses the HTML and extracts the DOM by telling the program where the main text is but this would also mean we would have to write a different program when we want to extract contents on a different site, which may have different formatting. Hence, we need the help of content extractors. They usually utilize some clever machine learning models to select which DOM most probably holds the main content. If you are interested you can read here to get some idea.
I am aware of dragnet, so I tried to install it with pip, but received some error. Then I realized, it does not support Python 3. Then I read one of the blog posts from the developers and found out about other popular content extractors. So I thought to myself, I might as well just try one of the others.
At random, I chose python-readibility. Installed it with:
pip install readability-lxml
Installation worked like a charm. So, I shall be sticking with this one if the results from the content extraction is reasonable and acceptable. Let’s try it out.
from readability.readability import Document
import requests
r = requests.get(links[0])
html = r.text
readable_article = Document(html).summary()
Ok, readable_article, filtered out most of the unwanted elements. But there are still some HTML tags. I don’t want that. I tried feeding readable_article
back to Document().summary()
, but I get the same result.
I remembered using BeautifulSoup with its .text
method to get rid of HTML tags. I think it was from some text mining tutorial I can’t quite recall. Anyways, let’s try that out and see if it works.
from bs4 import BeautifulSoup
cleaned_readable_article = BeautifulSoup(readable_article).text
# 'KUALA LUMPUR: 1Malaysia Development Bhd (1MDB...'
I’ve truncated the output a bit, but in my eyes it works. Now, we have all the tools to start building our corpus. A recap to what we will be doing.
- We need a collection of RSS Feeds
- From the feeds, we get the links and published date of each article
- From the links, we extract the main text
- We shall then save each text in a JSON file
Now all we need is to bring everything together. My example can be accessed here. If you utilize a while loop with a sleep, you can have yourself a nice simple crawler. Collect more news feeds and let your crawler run for some time.  Be aware however, certain sites do not like the fact that you are scraping. Be polite to not DDOS their servers. We all gotta eat.
Hopefully next time I will be able to demonstrate some ways we can augment and explore our text data to uncover some cool patterns.


Feature Testing with Crawljax and JavaScript
User Guide
This file will walk you through installing and using the project. If you're looking for information about the Practical Applications and Future Work, or for the Developer Guide, this is probably not page you want!
The project has 3 components: the Testing Server, the Sample User Story Wiki, and the Sample Tested Application. The Testing Server can be interacted with via a RESTful API, documented in the Developer Guide, and is responsible for running the test scripts on your pages. The Sample User Story Wiki is a simple application written in PHP designed to illustrate the integration of user stories with testing tools: you create user stories for your application, add test scripts, and run the tests on your application. The Sample Tested Application is just a WordPress Blog, and you would ideally use your own untested web application in place of this.
Required Software
There are a number of pieces of software you need to run the project. If you only wish to run the Testing Server and post test scripts to it via other software, then a servlet container should be the only required software. Currently, this software exists as a Proof-of-Concept. This means that, while it should theoretically work with many configurations of the required software packages, it has only been tested with one or two of them. For my development, I used:
Testing Server
- Apache Tomcat v. 7.02(Servlet container)
- Mozilla Firefox v. 3.6 - this is the only version I tested that works with the current version of CrawlJax
Sample User Story Wiki
Sample Tested Application (WordPress Blog)
Please install the required software components for the module you intend on using, and proceed to the next step
Installing from Git
Before you do anything else, check out the source from the GitHub repository using the git clone command.
Testing Server
Copy the CrawlJaxServer.war file into your servlet container's webapps directory (may be something else under a different servlet container). Make sure your server is started; the application should start automatically and respond to calls through the API.
To build from source, import the CrawlJaxServer project into Eclipse for JavaEE. You'll need to set up a server to deploy the project to (via File, New, Other: Server), and then set the project's server to the one you just created.
Sample User Story Wiki
To install the User Story Wiki, simply copy the folder to your htdocs directory where you installed XAMPP. Ensure Apache and MySQL are running. Create a new MySQL database called "wiki" and make sure at least one user has access to it. Update the file "db.php" with your database name/username/password.
Sample Tested Application
To test the same application I used when developing, just grab the latest version of WordPress. In practice though, you should write your own application and then point the User Story Wiki/Testing Server at localhost/application (for example) for testing.
Sample User Story Wiki
We'll walk through the elements of the User Story Wiki (screenshot below)
- Run Tests Button
Press this to run all of your tests on the currently configured Crawljax Test Server (see 3) - Overall Test Progress Bar
Shows the current number of passing assertions over the total number of assertions made. - Configure Button
Allows you to specify the location of the Crawljax server, the location of your application to test, and a script to run before each test script. - User Stories List
Shows a list of the application's specified User Stories, and the currently selected User Story. - New User Story
Adds a new User Story to the list and selects it for editing. - Individual Test Progress Badges
Shows test completion progress on each User Story. A 0 means that no tests have been successfully run yet (as you can see on the sample Untitled User Story I've just created). - User Story Details
Each User Story is composed of a Title, id number, Primary Actor, Goal, Benefit, and a brief comment. See User Stories for more details. - Test Script
The linked test script for the User Story. This is a simple set of JavaScript commands to order around the crawler and test the current page for expected behavior (the last section will detail the Crawljax functions you can call here). - Testing Errors/Assertion Failures
Shows a list of assertions that failed the last time that the tests were run, with a message.
Case Study: Testing a WordPress Blog
Let's walk through testing the login functionality of a WordPress blog
Starting from an empty database, we see the following screen:
Let's start by creating a new User Story for our Log In functionality. Click the Add User Story button, and fill in the fields as shown. Press save when you're finished.
Next, we should make sure the application is configured. Provide the urls of your CrawlJax Server and application to be tested (I put mine in the wp folder, as shown below). We'll leave the Setup Script blank for now.
Now, go back to the User Story we created, and add these lines into the Test Script. All we're asking the Crawler to do here is go to the login page. Make sure you've started your CrawlJax Test Server, and click the "Run All Tests" button at the top.
A dialog like this will show up, indicating that tests are about to be run. If you're running the CrawlJax Test Server locally (which I highly recommend), you'll see Firefox open up and navigate to the login page.
When Firefox closes, you should see that the test progress has been updated: all the tests have run successfully.
Now we need some test logic, and assertion statements. Update the test script a bit:
(eid is a utility function for retrieving elements by id from the document). Fill in the username and password boxes, and click the login button, and assert that the administrator controls are only available (i.e. not null) after we log in.
Oops! looks like something failed. We can see that it's assert-2, and that we didn't obtain proper access. In this case, we need to check our test. The password for the admin user isn't correct:
Now all of the tests pass! We can continue writing tests for the user story, or add and test more user stories. The process is the same from here.
Testing Script Function Library
The external functions available in the Test Script section of the User Stories are divided into two classes:
Crawler Functions
Crawler Functions tell the Crawljax server where to go in your application and which buttons to click.
A block of directions is always followed by a call to Crawler.start("id")
, which tells the crawler
to execute the previous block of directions.
Crawler.go("relative url")
Tells the Crawler to go to a url relative to the application path defined in the configuration (e.g. if my configuration path was localhost/wp, I could provide this with "wp-login.php" and the crawler would go to localhost/wp/wp-login.php)
Crawler.goAbs("absolute url")
Tells the Crawler to go to an absolute url (e.g. calling this with www.google.ca will direct the crawler to open www.google.ca)
Crawler.click(element)
Give a DOM element; CrawlJax will add it to it's list of elements to click. This can be called sequentially with different elements.
Crawler.start("id")
Tells the Crawler to start with any previous instructions that haven't yet been followed. The id must be unique for the test case.
Assertions
Assert.assertTrue("id",value,"error message if failure")
The basic assertion unit. Provide an id unique to the test, the value you expect to be true, and an error message to be posted back if the test fails.
Assert.assertFalse("id",value,"error message if failure")
Asserts that value is false. Posts error otherwise.
Assert.assertNull("id",value,"error message if failure")
Asserts that a value is null (==null). Posts error otherwise.
Assert.assertNotNull("id",value,"error message if failure")
Asserts that a value is not null (!=null). Posts error otherwise.
Assert.assertEquals("id",value1,value2,"error message if failure")
Asserts that value1 equals value2 (value1==value2). Posts error otherwise.
Every other instruction in the Test Script or Setup Script areas is simply vanilla JavaScript. You may also use functions from the JSON library


The History of Israel-Palestine
An interactive story
Public interest in the conflict between Israel and Palestine has recently been revived by renewed violence. News coverage of the conflict today does not provide any context about the roots of this conflict. Most people consider this to be a tussle between two nations, and believe its roots lie in religious ideology or zealotry. Some even conflate it with other kinds of Islamist extemism.
The reality, however, is different and much more complex. Far from a religious conflict, this conflict is a clash of two nationalisms. It is a struggle between two nationalist movements that developed in opposition to each other in the pre-World War 1 era. Both nationalisms were shaped and influenced by variety of events in many different was, over the course of about 50 years.