text:
---
layout: "post"
title: "SQLSaturday #615 - Baltimore 2017"
prettydate: "6 May 2017"
---
# SQLSaturday #615 - Baltimore 2017

**Event Date**: 05/06/2017 00:00:00

**Event Location**:
- Loyola University
- 8890 McGaw Road
- Columbia, Maryland

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

Sessions

Speakers

Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

-----------------------------------------------------------------------------------

# Sessions
This is a list of sessions from the event, based on the schedule in the XML files.

-----------------------------------------------------------------------------------

## Title: Public Preview of SQL Server on Linux

**Abstract**:
Abstract:

There was a lot of excitement at the Connect() developer conference in November 2016.  Two major announcements were made at the conference.

First, visual studio code now runs on Windows, Linux and Mac.  Second, SQL Server v.Next is coming to Linux.  This means a developer can

develop code against SQL Server in a Window less environment.  If you are really passionate about Linux, join the hundreds downloading and

testing this preview release.

Coverage:

1 - Core code deployed for multiple environments.

2 - Installs on Red Hat and Ubuntu flavors of linux.

3 - Generate ssh key.

4 - Deploy standard Red Hat image.

5 - Install core engine and tools on linux.

6 - Connect to engine via sqlcmd.

7 - Open firewall for external access.

8 - Create database on Linux via SSMS in windows.

9 - Load data into table via bcp.

10 - Supports docker (container) images.

11 - Current limitations.

12 - Future road map.

**Speaker(s):**
- John Miner

*Track and Room*: Application  Database Development - Design - Room 330

-----------------------------------------------------------------------------------

## Title: Database Project Makes Deployment Consistent

**Abstract**:
The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.

  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

*Track and Room*: Professional Development - Pro - Room 304

-----------------------------------------------------------------------------------

## Title: Digging Deeper: BI Methodologies and Best Practices

**Abstract**:
In this session attendees will learn how to make decisions around which technologies to use when delivering BI solutions including some exciting new BI features in SQL 2016.  We will explore the starting point of the project with data sources, step through the ETL decision making process and on to picking the medium for best delivery of content, while learning some best practices along the way.

**Speaker(s):**
- Chris Seferlis

*Track and Room*: BI Platform Architecture, Development  Administration - BI 3 - Room 359

-----------------------------------------------------------------------------------

## Title: The Business Intelligence Side of SQL Server

**Abstract**:
This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

**Speaker(s):**
- Sayed Saeed

*Track and Room*: BI Platform Architecture, Development  Administration - BI 1 - Room 363

-----------------------------------------------------------------------------------

## Title: Microsoft and Big Data - An Overview of the Power Tools and more!

**Abstract**:
Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.  Along the way, we will introduce Microsoft Azure and show how the Azure Cloud can help developer's get access to resources quickly and easily.

**Speaker(s):**
- David Patrick

*Track and Room*: BI Information Delivery - BI 1 - Room 363

-----------------------------------------------------------------------------------

## Title: Crash Course on Better SQL Development

**Abstract**:
SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

**Speaker(s):**
- Vladimir Oselsky

*Track and Room*: Application  Database Development - Dev - Room 360

-----------------------------------------------------------------------------------

## Title: Tune Like a Guru!

**Abstract**:
In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work.  As a long-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools.  We will cover many topics, including:

- Server, virtualization and database configuration
- Optimization processes
- Statistics
- Indexing
- Understanding query plans
- Improving design
- Improving code
- Profiler use and analysis
- Temp object usage
- Waits and IO stall analysis
- ORM Badness

We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools, etc. I have collected in my almost 45,000 man hours of working with SQL Server.  I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!

**Speaker(s):**
- Kevin Boles

*Track and Room*: Other - SQL Internals - Room 260

-----------------------------------------------------------------------------------

## Title: Statistics  Cardinality – How They Work to Find Data Efficiently

**Abstract**:
Are your statistics up to date?
Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that?
In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

**Speaker(s):**
- Chris Bell

*Track and Room*: Application  Database Development - Dev - Room 360

-----------------------------------------------------------------------------------

## Title: Disaster Documents: The role of documentation in disaster recovery

**Abstract**:
I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001.  Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery.  In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself.  We will discuss the documents we had and how they were used in our recovery.  We will also discuss what documents we didn't have, and how they could have made the process better.

**Speaker(s):**
- Ray Kim

*Track and Room*: Strategy and Architecture - Design - Room 330

-----------------------------------------------------------------------------------

## Title: Efficient table design

**Abstract**:
The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.

**Speaker(s):**
- Alex Grinberg

*Track and Room*: Strategy and Architecture - Design - Room 330

-----------------------------------------------------------------------------------

## Title: Power BI:  From the Desktop to the Enterprise

**Abstract**:
Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly, blog posts are flying across twitter.  How can you keep up?  In this full day session I will explain and demonstrate how to implement a full enterprise Power BI solution.  This will include preparing your organizations network for Power BI, deciding if you need to build an SSAS Semantic Model or will the Power BI desktop work as an alternative.  In addition, there will be a few hand-on labs that will help each attendee get started working with both the Power BI Desktop and the Power BI Service.  Bring your laptop, grab a cup of coffee and get ready to learn.  See the high-level agenda below:

Preparing Your Organization for Power BI,
To Data Warehouse or Not,
Introduction to the Power BI Desktop,
Introduction to the Power BI Service,
Connecting to and Refreshing Data,
Power BI meets Cortana,
Near real-time Dashboards

**Speaker(s):**
- Patrick LeBlanc

*Track and Room*: BI Information Delivery - BI - Room 259

-----------------------------------------------------------------------------------

## Title: Drinking From the Firehose: a Guide to Keeping Up with Technology

**Abstract**:
Keeping up with technology can feel like a treadmill; you keep running but never get anywhere. We'll take a look at ways to keep up with technology without pulling your hair out. We'll balance cost versus benefit for the different types of learning. We will also talk about learning goals.

**Speaker(s):**
- Eugene Meidinger

*Track and Room*: Professional Development - Pro - Room 304

-----------------------------------------------------------------------------------

## Title: Azure Analysis Services - An introduction

**Abstract**:
We will take a look at an introduction and overview of Azure Analysis Services - Microsoft 's cloud-based analytical engine and Platform as a Service (PaaS) offering. We will discuss Azure Analysis Services features and capabilities, use cases, provisioning and deployment, managing and monitoring, tools, and report creation. Although Azure Analysis Service is in Public Preview at the time of this session submission, we will incorporate the latest publicly  available information.

**Speaker(s):**
- Timothy McAliley

*Track and Room*: Cloud Application Development  Deployment - BI 3 - Room 359

-----------------------------------------------------------------------------------

## Title: Big Data 101

**Abstract**:
If you are new kid in the world of Big Data? Let's look at some of the topics of Big Data.
We will learn about foundations of big data and social physics, What is the importance of data quality and data privacy. We will have a quick look at personal sensors and human behavior
This module will explore the various sources of data, how to leverage personal sensors to predict behavior, and introduce you to the key features of 'Funf'

We will explore the basics of data dynamics and data interrogation, and the importance of interdisciplinary research and testing on yourself, to assist in analyzing a data set.

What are the fundamentals and structure of peer networks?
We will also talk about HDInsight and take a look at Microsoft's items in play.

**Speaker(s):**
- Paresh Motiwala

*Track and Room*: BI Platform Architecture, Development  Administration - BI 3 - Room 359

-----------------------------------------------------------------------------------

## Title: Excel with DAX

**Abstract**:
DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it).  PowerBI also uses DAX for all the formula expressions.  We'll cover the basics of DAX, and go over some time intelligence functions.

**Speaker(s):**
- Azhagappan Arunachalam

*Track and Room*: Application  Database Development - BI 1 - Room 363

-----------------------------------------------------------------------------------

## Title: The ABC's of Server Baselines

**Abstract**:
The numbers on the monitor go up and then they go down.  Which numbers are the most important?  How do I know if the change I made is helping my environment?  This sessions reviews some of the important areas to understand before you start making changes to your environment and how to measure them.

**Speaker(s):**
- Carlos L Chacon

*Track and Room*: Enterprise Database Administration  Deployment - Design - Room 330

-----------------------------------------------------------------------------------

## Title: Using Powershell to Document SQL Server

**Abstract**:
Most DBAs 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 exported because they 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 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, Server Triggers and much more

**Speaker(s):**
- George Walkey

*Track and Room*: Enterprise Database Administration  Deployment - DBA - Room 362

-----------------------------------------------------------------------------------

## Title: "Full Text indexing!" or..."What is that service I never turn on?"

**Abstract**:
If you've ever wondered what that other service is in your configuration manager then this is the class for you.  Full text indexing allows you to write queries to scan large text fields without having to do a complete table scan every time.

We'll talk about installing, setting up, maintaining, and using full text indexes to their fullest!

**Speaker(s):**
- Eric Blinn

*Track and Room*: Enterprise Database Administration  Deployment - BI 2 - Room 361

-----------------------------------------------------------------------------------

## Title: The Ins and Outs of SQL Indexes

**Abstract**:
This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive.  Lots of valuable information will be provided in a short amount of time.

**Speaker(s):**
- Mindy Curnutt

*Track and Room*: Application  Database Development - Dev - Room 360

-----------------------------------------------------------------------------------

## Title: New Features in SSIS 2016

**Abstract**:
This session will present detailed examples of the newest features added or enhanced in SSIS 2016.
Including but not limited to:
    True template based package design
    Incremental package deployment
    Non-Admin logging access
    Error Handling by Column name (prior versions only gave that cryptic lineage ID number)
    SSISDB AlwaysOn Availability Group support
    and many more...

The session will include a limited number of slides followed but demo examples of each new feature which will also be provided for download so attendees while have access to them for reference after the event.

**Speaker(s):**
- Paul Rizza

*Track and Room*: BI Platform Architecture, Development  Administration - BI 2 - Room 361

-----------------------------------------------------------------------------------

## Title: SQL Server Defaults SUCK!!

**Abstract**:
If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-)  There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally.  This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

**Speaker(s):**
- Kevin Boles

*Track and Room*: Enterprise Database Administration  Deployment - SQL Guru - Room 210

-----------------------------------------------------------------------------------

## Title: Introduction to SQL Server Microsoft Mobile Reporting

**Abstract**:
This is a must attend session for every data professional.  Join me as I provide an overview of Microsoft Mobile Reporting, Microsofts newly acquired on-premises mobile BI solution.  Mobile Reporting 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 Mobile Reporting, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.

**Speaker(s):**
- Patrick LeBlanc

*Track and Room*: BI Information Delivery - SQL Guru - Room 210

-----------------------------------------------------------------------------------

## Title: Monitoring Availability Groups

**Abstract**:
So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups.  We will discuss what metrics to look at, what they mean, and what you need to alert on.  You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.  This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.

**Speaker(s):**
- Tracy Boggiano

*Track and Room*: Enterprise Database Administration  Deployment - DBA - Room 362

-----------------------------------------------------------------------------------

## Title: User Group

**Abstract**:
We will be talking about our local BBIG (Baltimore Business Intelligence) User Group. Where and When we meet. What we are talking about and what topics you want to hear.

**Speaker(s):**
- Ravi Kumar

*Track and Room*: Professional Development - Design - Room 330

-----------------------------------------------------------------------------------

## Title: Tech Writing for Techies: A Primer

**Abstract**:
Documentation is one of the most critical, yet most blatantly ignored and disrespected tasks when it comes to technology.  Businesses and technical professionals ignore documentation at their own risk.  This session discusses what tech writing and documentation is about and why it's critical for business.  It also explores possible reasons for why it's ignored, how documentation can be improved, and how "non-writers" can contribute to the process.

**Speaker(s):**
- Ray Kim

*Track and Room*: Professional Development - Pro - Room 304

-----------------------------------------------------------------------------------

## Title: SQL Server 2016: Data Masking and Encryption

**Abstract**:
Learn about data masking and encryption, the pros and cons of each, as well as when to use which.

**Speaker(s):**
- Sean Werick

*Track and Room*: Application  Database Development - Dev - Room 360

-----------------------------------------------------------------------------------

## Title: Why candidates fail the job interview in the first minute

**Abstract**:
In the last two decades Thomas always had more open positions than I could fill, not because of lack of applicants, I must have interviewed close to 300 people for DBA, database developer, data architect, data modeling and other data related positions. Come to this highly interactive session to learn why 99% of the candidates failed the simplest questions and disqualified them self.

Thomas will share what he misses in resumes and how to respond to questions better.

**Speaker(s):**
- Thomas Grohser

*Track and Room*: Professional Development - Pro - Room 304

-----------------------------------------------------------------------------------

## Title: SSAS 2016 Tabular - Diving into the new features

**Abstract**:
Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

**Speaker(s):**
- Brian Beswick

*Track and Room*: BI Platform Architecture, Development  Administration - BI 2 - Room 361

-----------------------------------------------------------------------------------

## Title: # vs @ - it's not about Social Media it's about temporary tables and data

**Abstract**:
In this session Thomas will explore and explain the different options that exist in SQL Server to temporary store data and show you when to use which and why not the others. This will cover #, ##, @,  Non-Durable Memory Optimized and regular user tables.  He will also present alternatives like common table expressions.

**Speaker(s):**
- Thomas Grohser

*Track and Room*: Application  Database Development - SQL Guru - Room 210

-----------------------------------------------------------------------------------

## Title: On the Doorsteps - Women in Technology

**Abstract**:
Women make up over half of the workforce, and yet there are still discrepancies in pay and in the number of women in certain industries. Technology is one of the industries where women are drastically underrepresented. What factors in industry and society have contributed to these outcomes?

In this session, we will discuss the effects of trends in industry such as college graduation of women in technology fields, and women currently in tech or in positions of leadership. And, even important to us, how the contributions of women in PASS affect our community. This will be an open discussion with input from the audience encouraged.

**Speaker(s):**
- Michelle Haarhues

*Track and Room*: Professional Development - Pro - Room 304

-----------------------------------------------------------------------------------

## Title: SSIS Incremental Loading:  The Tortoise and The Hare

**Abstract**:
Extracting, transforming and loading data has become a major component to satisfying business requirements and needs.  Depending on the size of the data you are working with, the way you design your SSIS packages can have an impact on performance and run times.  In this session, we will cover a variety of incremental design approaches centered around large data sets using SSIS.  We will look at the pros and cons of each ETL strategy and generate specific use cases to decide which strategy yields optimal results.

**Speaker(s):**
- Jeremy Frye

*Track and Room*: BI Platform Architecture, Development  Administration - BI 3 - Room 359

-----------------------------------------------------------------------------------

## Title: Interrogating your data sources with Biml

**Abstract**:
You've decided to start using Biml to make your integration services packages. Congratulations!

Now, you're looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases?  In this session, I'll share some of the techniques I've used to deal with these second-class sources. I'll be walking you through C# code.  Don't worry, I'm not a real programmer, so the code isn't the most complex, but it does solve the need.

**Speaker(s):**
- Shannon Lowder

*Track and Room*: BI Platform Architecture, Development  Administration - BI 2 - Room 361

-----------------------------------------------------------------------------------

## Title: Data Visualization:  How to truly tell a great story!

**Abstract**:
We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…

**Speaker(s):**
- Jonathan Stewart

*Track and Room*: BI Information Delivery - BI 1 - Room 363

-----------------------------------------------------------------------------------

## Title: Deeper Into Azure Machine Learning

**Abstract**:
Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.

**Speaker(s):**
- Mark Hudson

*Track and Room*: Advanced Analysis Techniques - BI 3 - Room 359

-----------------------------------------------------------------------------------

## Title: An (Advanced) Introduction to Power BI

**Abstract**:
When people talk about Power BI, it can be all sizzle and no steak. Instead, we are going to take a slightly deeper dive into the inner workings of PowerBI. We will cover the different components of the Power BI ecosystem: PowerQuery, DAX, Power BI visuals, Data gateways, and the Power BI service. Instead of just showing off pretty graphs, we will focus on a more fundamental understanding of these tools.

**Speaker(s):**
- Eugene Meidinger

*Track and Room*: BI Platform Architecture, Development  Administration - BI 1 - Room 363

-----------------------------------------------------------------------------------

## Title: Introduction to Azure Streaming Analytics

**Abstract**:
This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

**Speaker(s):**
- Warren Sifre

*Track and Room*: Cloud Application Development  Deployment - BI 2 - Room 361

-----------------------------------------------------------------------------------

## Title: APPLY Yourself

**Abstract**:
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

**Speaker(s):**
- Kevin Feasel

*Track and Room*: Application  Database Development - Dev - Room 360

-----------------------------------------------------------------------------------

## Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

**Shannon Lowder**

Twitter:  - [@shannonlowder](https://www.twitter.com/@shannonlowder)

LinkedIn: [Shannon Lowder](http://linkedin.com/in/slowder)

Contact: [http://shannonlowder.com](http://shannonlowder.com)

For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly.  As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development.  Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml.  After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions.  Today, he is a Biml Hero candidate and is awaiting the final approval for the award.

**Jonathan Stewart**

Twitter:  - [sqllocks](https://www.twitter.com/sqllocks)

LinkedIn: [Jonathan Stewart](https://www.linkedin.com/in/sqllocks/)

Contact: [https://sqllocks.net/](https://sqllocks.net/)

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

**Warren Sifre**

Twitter:  - [WAS_SQL](https://www.twitter.com/WAS_SQL)

LinkedIn: [Warren Sifre](http://www.linkedin.com/in/wsifre)

Contact: [http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com](http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com)

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL.  Currently he is a Principal Consultant and Technology Leader with Moser Consulting.  He is responsible for BI Solution Architecture and the mentorship of team members.  He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone.  He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

**Mark Hudson**

Twitter:  - [HMarkHudson](https://www.twitter.com/HMarkHudson)

Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis.  He has developed data solutions using numerous platform tools including multiple SQL Server versions.  He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).

**John Miner**

Twitter:  - [https://twitter.com/JohnMiner3](https://www.twitter.com/https://twitter.com/JohnMiner3)

LinkedIn: [John Miner](https://www.linkedin.com/in/minerjohn/)

Contact: [https://www.mssqltips.com/sqlserverauthor/154/john-miner/](https://www.mssqltips.com/sqlserverauthor/154/john-miner/)

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island.  Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

**Jeremy Frye**

Twitter:  - [SQLBInstein](https://www.twitter.com/SQLBInstein)

LinkedIn: [Jeremy Frye](https://www.linkedin.com/in/jeremyilfrye)

Contact: [https://jeremyfrye.net](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.

**Thomas Grohser**

LinkedIn: [Thomas Grohser](https://www.linkedin.com/in/thomasgrohser/)

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

**Azhagappan Arunachalam**

Az Arunachalam has been working with SQL server since v4.21/SQLNT.  He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect.  He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.

**Paresh Motiwala**

Twitter:  - [pareshmotiwala](https://www.twitter.com/pareshmotiwala)

LinkedIn: [Paresh Motiwala](http://www.linkedin.com/in/pareshmotiwala)

Contact: [https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2](https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2)

Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies.  He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).

He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian.
He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com

**Patrick LeBlanc**

Twitter:  - [patrickdba](https://www.twitter.com/patrickdba)

LinkedIn: [Patrick LeBlanc](https://www.linkedin.com/in/patrickdleblanc)

Contact: [http://patrickdleblanc.com](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.

**Eric Blinn**

Twitter:  - [@SQL2TheSequel](https://www.twitter.com/@SQL2TheSequel)

LinkedIn: [Eric Blinn](https://www.linkedin.com/in/ericblinn)

Contact: [https://ericblinn.com/](https://ericblinn.com/)

Eric has been a SQL Server DBA in the legal, software, transportation, and insurance industries for over 10 years.  Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.

Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.

He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User's Group.

**Tracy Boggiano**

Twitter:  - [TracyBoggiano](https://www.twitter.com/TracyBoggiano)

LinkedIn: [Tracy Boggiano](https://www.linkedin.com/in/tracyboggiano)

Contact: [http://databasesuperhero.com](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.

**Alex Grinberg**

LinkedIn: [Alex Grinberg](https://www.linkedin.com/in/alex-grinberg-36773a6/)

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book "XML and JSON Recipes for SQL Server", also wrote number of articles for Simple-Talk and SQLServerCentral.com

**Thomas Norman**

Twitter:  - [ArmorDba](https://www.twitter.com/ArmorDba)

LinkedIn: [Thomas Norman](http://www.linkedin.com/in/armordba)

Contact: [https://armordba.com/](https://armordba.com/)

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

**Kevin Feasel**

Twitter:  - [feaselkl](https://www.twitter.com/feaselkl)

LinkedIn: [Kevin Feasel](https://www.linkedin.com/pub/kevin-feasel/7/716/504)

Contact: [http://www.catallaxyservices.com](http://www.catallaxyservices.com)

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

**Thomas Grohser**

LinkedIn: [Thomas Grohser](https://www.linkedin.com/in/thomasgrohser/)

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

**Mindy Curnutt**

Twitter:  - [@sqlgirl](https://www.twitter.com/@sqlgirl)

LinkedIn: [Mindy Curnutt](https://www.linkedin.com/in/mindycurnutt)

Contact: [http://www.mindycurnutt.com](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 SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

**Chris Bell**

Twitter:  - [@cbelldba](https://www.twitter.com/@cbelldba)

LinkedIn: [Chris Bell](http://www.linkedin.com/pub/christopher-bell/19/a08/93/)

Contact: [https://www.wateroxconsulting.com/](https://www.wateroxconsulting.com/)

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.

**Mindy Curnutt**

Twitter:  - [@sqlgirl](https://www.twitter.com/@sqlgirl)

LinkedIn: [Mindy Curnutt](https://www.linkedin.com/in/mindycurnutt)

Contact: [http://www.mindycurnutt.com](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 SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

**Kevin Boles**

Twitter:  - [@TheSQLGuru](https://www.twitter.com/@TheSQLGuru)

LinkedIn: [Kevin Boles](http://www.linkedin.com/in/thesqlguru)

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

**Patrick LeBlanc**

Twitter:  - [patrickdba](https://www.twitter.com/patrickdba)

LinkedIn: [Patrick LeBlanc](https://www.linkedin.com/in/patrickdleblanc)

Contact: [http://patrickdleblanc.com](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.

**David Patrick**

Twitter:  - [DavidEPatrick](https://www.twitter.com/DavidEPatrick)

LinkedIn: [David Patrick](http://www.linkedin.com/in/davidepatrick)

Contact: [http://www.madsharepoint.com](http://www.madsharepoint.com)

Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.

**Vladimir Oselsky**

Twitter:  - [@VladyOselsky](https://www.twitter.com/@VladyOselsky)

LinkedIn: [Vladimir Oselsky](https://www.linkedin.com/in/voselsky)

Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby.  IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming

**Ravi Kumar**

Twitter:  - [@sqlravi](https://www.twitter.com/@sqlravi)

I have over 12 years of experience working with SQL Server and Business Intelligence Technology.  My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory.  As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.

**Sean Werick**

LinkedIn: [Sean Werick](https://www.linkedin.com/in/seanwerick)

Contact: [http://www.seanwerick.com](http://www.seanwerick.com)

I have been in the data industry for 15 years, specializing in Microsoft business intelligence for the last decade. I have architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care and retail. I am extremely passionate about data and the endless possibilities for companies utilizing it in the best ways. I enjoy data science and business intelligence because the possibilities and magnitudes of impact are immeasurable.

**Brian Carrig**

Twitter:  - [@briancarrig](https://www.twitter.com/@briancarrig)

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.

**Carlos L Chacon**

Twitter:  - [@CarlosLChacon](https://www.twitter.com/@CarlosLChacon)

LinkedIn: [Carlos L Chacon](https://www.linkedin.com/in/carloslchacon)

Contact: [http://sqldatapartners.com/blog](http://sqldatapartners.com/blog)

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast.  While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader.  He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven).  He and his family live in Richmond, Virginia.

**Paul Rizza**

Twitter:  - [@PaulRizzaSQL ](https://www.twitter.com/@PaulRizzaSQL )

LinkedIn: [Paul Rizza](http://www.linkedin.com/in/prizza/)

Contact: [http://blogs.msdn.com/b/paulrizza/](http://blogs.msdn.com/b/paulrizza/)

Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning.  Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.

**Kevin Boles**

Twitter:  - [@TheSQLGuru](https://www.twitter.com/@TheSQLGuru)

LinkedIn: [Kevin Boles](http://www.linkedin.com/in/thesqlguru)

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

**Ray Kim**

Twitter:  - [PianoRayK](https://www.twitter.com/PianoRayK)

LinkedIn: [Ray Kim](https://www.linkedin.com/in/pianorayk)

Contact: [https://pianorayk.wordpress.com/](https://pianorayk.wordpress.com/)

Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.

A musician in his spare time, Ray plays four different instruments. He also enjoys going to ball games and doing CrossFit, and is a two-time SQLServerCentral.com fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.

**Sayed Saeed**

LinkedIn: [Sayed Saeed](?https://www.linkedin.com/in/sayed-saeed-68079a18?)

Contact: [http://www.plusconsulting.com/blog/](http://www.plusconsulting.com/blog/)

Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.

**Eugene Meidinger**

Twitter:  - [@sqlgene](https://www.twitter.com/@sqlgene)

Contact: [http://www.sqlgene.com](http://www.sqlgene.com)

Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.

**Timothy McAliley**

Twitter:  - [sysframeworks](https://www.twitter.com/sysframeworks)

LinkedIn: [Timothy McAliley](http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/)

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area.  Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer  and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

**Shannon Lowder**

Twitter:  - [@shannonlowder](https://www.twitter.com/@shannonlowder)

LinkedIn: [Shannon Lowder](http://linkedin.com/in/slowder)

Contact: [http://shannonlowder.com](http://shannonlowder.com)

For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly.  As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development.  Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml.  After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions.  Today, he is a Biml Hero candidate and is awaiting the final approval for the award.

**Brian Beswick**

LinkedIn: [Brian Beswick](https://www.linkedin.com/in/briantbeswick)

Contact: [http://brianbeswick.com/](http://brianbeswick.com/)

Brian is a Managing Consultant at Allegient. He has many years of experience in database architecture and development across multiple versions of SQL Server. He’s an accomplished Database Architect with a specialty in Business Intelligence. He’s particularly strong at understanding and designing solutions for complex requirements.

**Slava Murygin**

Twitter:  - [SlavaSQL](https://www.twitter.com/SlavaSQL)

LinkedIn: [Slava Murygin](https://www.linkedin.com/pub/slava-murygin/9/b95/858)

Contact: [http://slavasql.blogspot.com/](http://slavasql.blogspot.com/)

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a  contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses,  cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

**George Walkey**

Twitter:  - [sqlbytehd](https://www.twitter.com/sqlbytehd)

Contact: [http://insyncva.com](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

**Eugene Meidinger**

Twitter:  - [@sqlgene](https://www.twitter.com/@sqlgene)

Contact: [http://www.sqlgene.com](http://www.sqlgene.com)

Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.

**Paul Rizza**

Twitter:  - [@PaulRizzaSQL ](https://www.twitter.com/@PaulRizzaSQL )

LinkedIn: [Paul Rizza](http://www.linkedin.com/in/prizza/)

Contact: [http://blogs.msdn.com/b/paulrizza/](http://blogs.msdn.com/b/paulrizza/)

Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning.  Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.

**Karlyn LeBlanc**

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.

**Chris Seferlis**

Twitter:  - [bizdataviz](https://www.twitter.com/bizdataviz)

LinkedIn: [Chris Seferlis](http://www.linkedin.com/in/cseferlis)

Contact: [http://blog.bizdataviz.com](http://blog.bizdataviz.com)

Chris Seferlis is a Sr Cloud Solution Architect at Microsoft. He has 20+ years’ experience working in IT and solving technical challenges from a business perspective. Chris is a former CIO with an MBA from UMass, bringing a mix of business acumen and practical technology solutions, primarily focusing on Data and AI within the Microsoft Data Platform, including MCSA and MCT designations.

**Alex Grinberg**

LinkedIn: [Alex Grinberg](https://www.linkedin.com/in/alex-grinberg-36773a6/)

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book "XML and JSON Recipes for SQL Server", also wrote number of articles for Simple-Talk and SQLServerCentral.com

**Michelle Haarhues**

Twitter:  - [@mhaarhues](https://www.twitter.com/@mhaarhues)

Contact: [https://witsociety.wordpress.com/](https://witsociety.wordpress.com/)

Michelle is a database administrator and has been working with SQL Server for over 15 years.  She started as a SQL Server developer and is currently a Database Administrator for Denver Health.  In many of her positions over the years, she was the lone SQL DBA\Developer so she loves talking about SQL Server to anyone who will listen.

**Kevin Boles**

Twitter:  - [@TheSQLGuru](https://www.twitter.com/@TheSQLGuru)

LinkedIn: [Kevin Boles](http://www.linkedin.com/in/thesqlguru)

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

**Ray Kim**

Twitter:  - [PianoRayK](https://www.twitter.com/PianoRayK)

LinkedIn: [Ray Kim](https://www.linkedin.com/in/pianorayk)

Contact: [https://pianorayk.wordpress.com/](https://pianorayk.wordpress.com/)

Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.

A musician in his spare time, Ray plays four different instruments. He also enjoys going to ball games and doing CrossFit, and is a two-time SQLServerCentral.com fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.

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

- [Moser Consulting](http://moserit.com)

- [DELL EMC](https://www.dellemc.com/en-us/index.htm)

- [Microsoft Corporation (GAP)](http://www.microsoft.com/en-us/server-cloud/products/sql-server/)

- [Realistic Computing Inc.](http://www.realistic-computing.com/)

- [Allegient](http://www.allegient.com)

- [Idera](http://www.idera.com/Content/Home.aspx)

- [SentryOne](https://www.sentryone.com/)

- [Applied Information Sciences](http://workatais.com/)

- [COZYROC](http://bit.ly/cozyrocssis)

- [Redgate Software (GAP)](http://rd.gt/2j7SNf9)

- [Vision Technology Services](http://www.bgstaffing.com/executive-recruitment/it-project-management/)

- [SQL Data Partners LLC](http://www.sqldatapartners.com/podcast)

- [Goldberg Finnegan](https://www.goldbergfinnegan.com/)

[Back to the SQLSaturday Event List](/past)

[Back to the home page](/index)

repository: red-gate/sql-saturday-website

repo_name: red-gate/sql-saturday-website


text:
---
layout: post
title:      "Using Fetch in JS"
date:       2020-10-09 22:06:34 -0400
permalink:  using_fetch_in_js
---

## Overview
In this blog post I will go over how to use the Fetch API. Let’s start off by giving an overview of what the Fetch API does.

The Fetch API is used when your web application needs to make network requests to a backend or a remote server, much like an XMLHttpRequest. Fetch API is a newer JavaScript API that is supported by most modern day browsers, and is a much simpler and easier to use than XMLHttpRequests. One of the main differences between these two is that the Fetch API utilizes something called promises.

## Promises
Promises are defined as objects that represent the completion or failure of an asynchronous call we do using the Fetch API. A promise has three distinct traits. The first state is **Pending**. When a promise is Pending it will transition to either **Fulfilled** or **Rejected**. If the promise becomes Fulfilled the promise will contain the data that we retrieved, and if it is rejected that means the asynchronous call has failed. Now we got promises out of the way let's look at how we actually use the Fetch API.

## fetch() Method
The fetch() is used to make asynchronous calls to a server. This method takes in one mandatory argument and one optional argument. The mandatory argument is the url that you are requesting from. When you only use the url, the fetch() method will act as a "GET" request. You can check out the HTTP methods [here](https://www.restapitutorial.com/lessons/httpmethods.html#:~:text=The%20primary%20or%20most%2Dcommonly,but%20are%20utilized%20less%20frequently) for an overview. The fetch() method will then return a promise in one of the states we explained earlier. If the promise is Fulfilled the promise returns a Response object in which we can use the .then() function to proceed with the response of the asynchronous call. If the promise is Rejected we can use the .catch() function to handle the Error object. So a basic function would look something like this

```
fetch(url)
.then(response => {
//do something with the response
}
.cach(error =>{
//error handling
}
```

## The Response Object
When we make a fetch request to a server, and it is Fulfilled, we get a Response object. This Response object has a bunch more data than what you are requesting. To get the data that you need you need to use a method called .json(). This method takes the response, reads and parses it and returns another promise. The returned promise has the data that we are looking for. The key to this is that it returns a promise. So we will use another .then function to do what we want with the data. Now the JavaScript code will look like:

```
fetch(url)
.then(response => {
return response.json()
}
.then(data => {
//do what we want with the data
}
.catch(error => {
//error handling
}
```

We have successfully used the fetch() method to "GET" data from a server! Just a note, we use .then() methods because we are making asynchronous calls. This means that whenever we get a promise we will immediately do whatever the .then() method calls. This allows the rest of the program to function normally while we are requesting and parsing the data from the promises. Once we get the promise we “then” continue working on what we were doing with it.

## Optional Argument
As I mentioned before there is an optional argument that the fetch() method takes. This optional argument is an object with certain keys. The below snippet is taken from [here](https://github.github.io/fetch/).

**Options**

method (String) - HTTP request method. Default: "GET"

body (String, body types) - HTTP request body

headers (Object, Headers) - Default: {}

credentials (String) - Authentication credentials mode. Default: "omit"

"omit" - don't include authentication credentials (e.g. cookies) in the request

"same-origin" - include credentials in requests to the same site

"include" - include credentials in requests to all sites

Notice that when we make a fetch request without the optional argument we are really doing a “GET” request because the optional method is “GET” by default.

If we wanted to do a “POST” request (uploading JSON data) our fetch() method will look something like this:
```
fetch(url, {
method: 'POST',
headers: { 'Content-Type': 'application/json', },
body: JSON.stringify(data), }
)
```

"data" in the above example is the data you are uploading to the server. We use JSON.stringify() so that it converts data into JSON. The fetch will still return a response in one of the three states. If it is Fullfilled, the promise will return the data that was submitted. A full "POST" request to a server will look something like:

```
fetch(url, {
method: 'POST',
headers: { 'Content-Type': 'application/json', },
body: JSON.stringify(data), }
)
.then(response=>{
return response.json()
}
.then(data => {
//do something with the data
}
.catch(error => {
//do something with error
}
```

And there you have it! This is how you use the Fetch API in a Javascript application. I hope this was helpful!

branch_name: refs/heads/master

extension: markdown

license_type: permissive


text:
metrics_tools
=============

These are various python scripts to pull Google analytics or YouTube details for a particular path, tag, or user. These use the APIs from Google Analytics and YouTube Analytics to create PDF or CSV files.

## requirements

#### CSV scripts
In addition to the standard Python libraries, these scripts require two libraries from Google APIs:
sudo pip install google-api-python-client
sudo pip install gdata

#### pdf scripts
In order to use the PDF creation functionality, there are further requirements.

For Python dependencies, you must install (``` pip install ``` in a virtual environment, ```sudo pip install ``` otherwise):

- matplotlib
- numpy
- apiclient
- oauth2client
- httplib2
- requests
- BeautifulSoup4

You also need a Google account with read access to the Google Analytics profile you are interested in.

##openmichigan-metrics-pdf

###use

In order to use the PDF functionality, in the ``` openmichian-metrics-pdf ``` folder, you need to fill in the files ``` client_secrets_blank.json ``` and ``` infofile_blank.py ``` with the appropriate information, and save them respectively as ``` client_secrets.json ``` and ``` infofile.py ```. These each provide necessary, but private to account holder(s), specific information.

In ``` client_secrets.json ```, you must fill in this structure:

```
{
  "installed": {
    "client_id": "[longstringofcharacters].apps.googleusercontent.com",
    "client_secret": "stringoflettersandnumbers",
    "redirect_uris": ["urn:ietf:wg:oauth:2.0:oob","http://localhost"],
    "auth_uri": "https://accounts.google.com/o/oauth2/auth",
    "token_uri": "https://accounts.google.com/o/oauth2/token"
  }
}
```

You can find your ``` client_id ``` and your ``` client_secret ``` for your Google account, and learn more about what this means, by going to [this page](https://developers.google.com/api-client-library/python/guide/aaa_client_secrets).

In ``` infofile.py ```, you need to fill in

```
profileid = ""
pgpath = ""
```

with relevant information. The ``` profileid ``` string should contain the Google Analytics profile id that you're interested in, which you can find at [this page](https://developers.google.com/analytics/resources/concepts/gaConceptsAccounts#accountID). The ``` pgpath ``` string variable should contain a path to a course or resource you are interested in, if you are using this for Open.Michigan's OERBit instance. (This is specifically configured to work with an instance of the [OERbit platform](https://github.com/openmichigan/OERbit), as of August 2014.) For example, this could be

```pgpath = pgpath = "/education/si/si508/fall2008" ```

##results

To run, ``` cd ``` to the ``` openmichigan-metrics-pdf ``` folder. Make sure you have filled in information and installed dependencies as specified above. Then run ```python create_pdf_plots.py ```.

In the process, a few other files will be created: ``` incomplete summary ```, and ``tf_ ``` 1, 2, and 3. Do not worry about these -- you can delete them or ignore them, but they will be overwritten each time you run this process.

In addition, a .PDF file will be saved and created each time you run it with a name such as ``` si_si508_fall2008_YYYY-MM-DD.pdf ```, with the date on which you ran this set of scripts. These will be different every time, and there are your results.

##csv scripts

###script: youtube-data-by-channelowner

The Python script youtube-data-by-channeluser.py requires one argument: channel owner name,
e.g. ``` python youtube-data-by-channelowner.py openmichigan ```

This script does not require login credentials or an API key because it uses v1 of the YouTube Analytics API. (N.B. The most recent version of the YouTube API is v3, which requires an API key. Likes and dislikes can only be retrieved by v3.)

The result is a CSV (spreadsheet) file with a row for each video with the following variables:
Ranking by popularity, Video ID, Video Title, Date Published, Category, URL, Duration in seconds, Total Views, Rating on 5.0 scale (Historical), Number of Raters (Historical), Number of Comments, Description, Content of All Comments

license: MIT

extension: md


text:
# Contributing

Thank you in showing interest in contributing to Tony! We greatly value every contribution from

* fixing a syntax error, improving style or adding a paragraph;
* adding to the documentation;
* reporting a bug; to
* proposing a change to the language spec.

## Code of Conduct

This project and everyone participating in it is governed by the [Code of Conduct](CODE_OF_CONDUCT.md). By participating, you are expected to uphold this code.

## Contributing ideas and reporting bugs

We use GitHub issues as a ticket system. You should open an issue if

* you want to [report a bug](https://github.com/tony-lang/spec/issues/new?assignees=&labels=bug&template=bug_report.md&title=);
* you want to [open a proposal](https://github.com/tony-lang/spec/issues/new?assignees=&labels=discussion%2C+proposal&template=proposal.md&title=); or
* you want to [make changes to the documentation](https://github.com/tony-lang/spec/issues/new?assignees=&labels=documentation&template=documentation.md&title=) (that go beyond fixing a syntax error here or adding a paragraph there).

You should **not** open an issue if

* you have a question. If you have a question use [Stack Overflow](https://stackoverflow.com) instead or send an email to the project team at<EMAIL_ADDRESS>* you want to fix a syntax error or otherwise adjust a sentence in the documentation. You may immediately propose your changes in a pull request.

When you open an issue we urge you to use the provided templates.

**Note of caution**: Please only report a bug in this repository if it is a bug of the language specification itself. If instead, an implementation of this specification has a bug, open an issue in the corresponding repository.

## Proposals

The Tony programming language is improved and changed through a rigorous process.

### Opening a proposal

Every proposal starts with an idea. If you have an idea please consider sharing it with everyone by opening a proposal in this repository.

A finished proposal should consist of the following:

1. a brief description of the motivation behind the change
1. a description of the syntactic changes
1. a description of the semantics of the changed syntax
1. a description of possible implementations of the updated spec

When you first open a proposal you do not have to tick all of these boxes. It is encouraged to start with a proposal as small and concise as possible to incorporate feedback as soon as possible.

Only proposals that satisfy all of the above will be accepted.

### Accepting a proposal

After a proposal is accepted (i.e. merged into `main`), that does not mean the proposal is now part of the language spec. Now the actual work of implementation begins.

First, the proposed changes have to be implemented in a pull request in this repository.

Whenever a new version of the spec is released all proposals accepted up to this point are locked. This means that implementors of the spec can now depend on the changes to the spec.

There are two phases to the release-process:

* pre-releases

  Every accepted proposal will first be released in a pre-release. This is when the core componenents of Tony (such as the parser and the compiler) will implement the proposal. At this stage proposals may not be changed anymore. Proposals my be disregarded, however, in case its its implementation turns out to be harder and less worthwhile than originally anticipated.

* releases

  Once all accepted proposals of a pre-release are implemented by the core components of Tony, the proposals that were not disregarded are incorporated into the specification of Tony.

repository: tony-lang/spec

branch_name: refs/heads/main

gha_license_id: MIT

repo_name: tony-lang/spec


text:
# deep-hash

deep-hash calculates nested hashes.

## Installation

```shell
$ npm install deep-hash
```

## Quick start

First you need to add a reference to deep-hash to your application:

```javascript
const deepHash = require('deep-hash');
```

Then call `deepHash` and provide a value you want to hash. Beside the primitive data types also objects and arrays are supported:

```javascript
const hash = deepHash({
  name: 'the native web',
  founded: 2012
});

// => {
//      name: '55a1f59420da66b2c4c87b565660054cff7c2aad5ebe5f56e04ae0f2a20f00a9',
//      founded: '4b9a7f50c0bb198c6f5414c5a8459f5d216d34ab521ea94c060ea35cac66f900'
//    }
```

*Please note that deep-hash uses SHA256 as hash algorithm.*

Optionally, you may specify a secret to "salt" the hashes:

```javascript
const hash = deepHash({
  name: 'the native web',
  founded: 2012
}, 'secret');
```

## Running the build

To build this module use [roboter](https://www.npmjs.com/package/roboter).

```shell
$ npx roboter
```

## License

The MIT License (MIT)
Copyright (c) 2018 the native web.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

 IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

repository: thenativeweb/deep-hash

gha_language: JavaScript

repo_name: thenativeweb/deep-hash


text:
# Cassandra Exporter

| Status                   |              |
|--------------------------|--------------|
| Stability                | [alpha]      |
| Supported pipeline types | logs, traces |
| Distributions            | [contrib]    |

## Configuration options

The following settings can be optionally configured:

- `dsn` The Cassandra server DSN (Data Source Name), for example `<IP_ADDRESS>`.
  reference: [https://pkg.go.dev/github.com/gocql/gocql](https://pkg.go.dev/github.com/gocql/gocql)
- `keyspace` (default = otel): The keyspace name.
- `trace_table` (default = otel_spans): The table name for traces.
- `replication` (default = class: SimpleStrategy, replication_factor: 1) The strategy of
  replication. https://cassandra.apache.org/doc/4.1/cassandra/architecture/dynamo.html#replication-strategy
- `compression` (default = LZ4Compressor) https://cassandra.apache.org/doc/latest/cassandra/operating/compression.html

## Example

```yaml
exporters:
  cassandra:
    dsn: <IP_ADDRESS>
    keyspace: "otel"
    trace_table: "otel_spans"
    replication:
      class: "SimpleStrategy"
      replication_factor: 1
    compression:
      algorithm: "ZstdCompressor"
```

gha_language: Go


text:
# bash-ftw
An opinionated collection of **BASH** scripts, aliases, customizations, defaults, and bootstraps **F**or **T**he **W**in!

## Jump Right In, Install!

1. `git clone https://github.com/jontsai/bash-ftw`
2. `cd bash-ftw; make install`
3. Profit

## Why I Made This

*The life of a developer.*

*Hopping from one terminal to the next VM over SSH.*
*IT upgrades laptops for your whole department and you lose your precious customizations.*
*Ubuntu here, Mac (FreeBSD) there, RedHat over there, Debian over yonder, Amazon Linux over there, ...*

*Years of muscle memory... What?! Do. You. Mean. `-bash: ll: command not found`?*
*Handicapped, crippled*

`ssh me@somehost`
`me@somehost's password:`

*Why. Isn't. It. Recognizing. My. Public. Key.*

`ssh -v me@somehost`
`...`

*No more of this.*

## What's In the Box

* ~~TBD~~ It's good. I use it, and you should use it to. No time to write this `README` section.

## Frequently Asked Questions

See [`FAQ.md`](https://github.com/jontsai/bash-ftw/blob/master/FAQ.md).

## Contributing

Pull requests are welcome! If you would like to contribute to this project, please fork this repository, create a branch, and submit a pull request.

All meaningful code contributions will be recognized in [`CONTRIBUTORS.md`](https://github.com/jontsai/bash-ftw/blob/master/CONTRIBUTORS.md).

## License

MIT, see [`LICENSE.md`](https://github.com/jontsai/bash-ftw/blob/master/LICENSE.md).

repository: jontsai/bash-ftw

gha_language: Shell

repo_name: jontsai/bash-ftw


text:
# Docker Config Controller for Kubernetes

[![Build Status](https://travis-ci.org/krijohs/dcc.svg?branch=master)](https://travis-ci.org/krijohs/dcc)
[![codecov](https://codecov.io/gh/krijohs/dcc/branch/master/graph/badge.svg)](https://codecov.io/gh/krijohs/dcc)

This is a controller for Kubernetes which creates a Docker config secret in namespaces which later can be used for authentication when using private Docker repositories.
The secret will be created in all namespaces except excluded ones, and the controller will listen on namespace state changes and automatically create the secret on a newly added namespace.

## Usage

The application can be deployed using the Helm chart located in 'deployments/charts/dockerconfig-controller', use the values.yaml file to add configuration for your private Docker registries.

The config key in values.yaml file is required and should have the following structure.
```yaml
kubeconf: "" # empty when run inside kubernetes
registries:
  - name: privateregistry
    exclude:
      - kube-public
      - kube-system
    config: |
      {
        "auths": {
          "private.docker.reg": {
            "auth": "xxx"
          }
        },
        "HttpHeaders": {
          "User-Agent": "Docker-Client/19.03.1-ce (linux)"
        }
      }
```

repository: krijohs/dcc

repo_name: krijohs/dcc


text:
# Design Documentation

## Design files and links

The major bulk of the design mock ups, brand identity and design system are located in this [Adobe XD file](https://drive.google.com/file/d/1v3VVVtEic4KNNPOb4WWnJkdKd-t_WIRF/view?usp=sharing) [Adobe web link](https://xd.adobe.com/view/8e9576cb-18da-4d9f-58b8-7d00d753377f-f8a4/) (Updated 13.06.2020)

Further design work was done on the blog via [Figma](https://www.figma.com/file/eqiXamWjAerrBr4ajtLf5Z/foss-responders?node-id=26%3A132)

The design work was done in collaboration by [Eriol Fox](https://github.com/Erioldoesdesign), [Jay Sethi](https://github.com/jaysethi), [Richard Littauer](https://github.com/RichardLitt), [Alyssa Wright]() and [Nuritzi Sanchez]() and [Alison Yu](https://github.com/alisonjudy)

## Design process

Foss responders did not follow any strict methodlogy or process when creating design work and typically 'design briefs' were encompassed in issues.

Those with design skills did however, make sure to include a wider array of voices, thoughts and opinions across the group and did their best to facilitate an open discussion about visual and design choices.
Several design artifacts were also made using accessible to non-designers tools like [google slides for social media graphics](https://docs.google.com/presentation/d/1Tx6_4f36vRmwn0mD_RJoYMRt7swv9yzuM7XUH_wEXNM/edit?usp=sharing)

gha_language: HTML


text:
---
redirect_from:
  - /LevelConverter
---

# Level Converter

Most of our gadgets have serial ports that work at 1V8 or 3V3
single-ended; our serial concentrator expects true RS422 or RS232, at
±12 to ±25V. So we need to provide a level converter/driver to convert
between the low level single-ended signals on the boards, and the
high-level differential voltages for transmission to the serial
concentrator.

We used the suggested circuit in the
[Manufacturer's Datasheet](http://datasheets.maximintegrated.com/en/ds/MAX218.pdf), laid out on a piece of perfboard.

This picture shows one wired to convert a single channel; because most
of our gadgets need only a three-wire interface, you can convert two
channels with one chip. The converter is powered from the gadget:
provide 1V8 or 3V3 depending on the signalling level.

repository: bennoleslie/docs

gha_license_id: NOASSERTION

repo_name: bennoleslie/docs


text:
# favouriteThings

## This page includes 3 anime that my most favourite

### Preparetion
1. Node.js
2. MAMP/WAMP

### mannul guide
1. Clone and download the source.
2. Open your MAMP(for Windows WAMP), and import databases from folder ***database***, keep the server running.
3. Open with Visual Studio Code, type code *npm start* in the ternimal.(node.js required)
4. Open your browser, type address *localhost:3000* to open the page(for windows and linux maybe need to change the port)

### Techinal description
1. the banner data is draging from databases outside.
2. click more info to access further information(can not  display the div during the testing, but still can have response in console to show the accessed data)
3. Responsive design for mobile and desktop version.
4. There are totally 2 sql files link to the page, and can be access in folder ***database***
5. editing css with ruby sass.

### Personal desscription
1. the icon of the website is the logo for my final protfolio.

#### *Reference*
1. https://img.moegirl.org/common/4/42/K-on_Poster.jpg
2. https://img.moegirl.org/common/f/f0/Attack_on_Titan_Season_3_KV5.jpg
3. https://upload.wikimedia.org/wikipedia/en/4/4a/Evangelion_3.0%2B1.0%2C_Teaser_Image.png
4. Prof Trevor's functional code. https://github.com/Trevor-FanshaweC/Week7_Demo.git

#### *Lisence*
MIT Lisence - see the LISENCE for detail

#### *Contribution*
1. Need all of preparetion
2. Ruby need for SASS
3. push in new branch

repository: MyronCC/favouriteThings

repo_name: MyronCC/favouriteThings


text:
# mocha puppeteer example
[![Build Status](https://travis-ci.org/StephenDavidson/mocha-puppeteer-example.svg?branch=master)](https://travis-ci.org/StephenDavidson/mocha-puppeteer-example)

Browser tests using [puppeteer](https://github.com/GoogleChrome/puppeteer) with mocha

## setup

`yarn`

## running the tests

`yarn test`

repository: StephenDavidson/mocha-puppeteer-example

repo_name: StephenDavidson/mocha-puppeteer-example


text:
# docker-stafwag-unbound

```Dockerfile``` to run unbound inside a docker container.
The unbound daemon will run as the unbound user. The uid/gid is mapped to
5000153.

## Installation

### clone the git repo

```
$ git clone https://github.com/stafwag/docker-stafwag-unbound.git
$ cd docker-stafwag-unbound
```

### Configuration

#### Port

The default DNS port is set to ```5353``` this port is mapped with the docker command to the default port 53 (see below).
If you want to use another port, you can edit ```etc/unbound/unbound.conf.d/interface.conf```.

#### ```scripts/create_zone_config.sh``` helper script

The ```create_zone_config.sh``` helper script, can we help you to the ```zones.conf``` configuration file.
It's executed during the container build and creates the zones.conf from the datafiles in ```etc/unbound/zones```.

If you want to use a docker volume or configmaps/persistent volumes on Kubernetes. You can use this script to
generate the ```zones.conf``` a zones data directory.

```create_zone_config.sh``` has following arguments:

* **-f** Default: /etc/unbound/unbound.conf.d/zones.conf
  The zones.conf file to create
* **-d** Default: /etc/unbound/zones/
  The zones data source files
* **-p** Default: the realpath of zone files
* **-s** Skip chown/chmod

#### Use unbound as an authoritative DNS server

To use unbound as an authoritative authoritive DNS server - a DNS server that hosts DNS zones - add your zones file ```etc/unbound/zones/```.

During the creation of the image ```scripts/create_zone_config.sh``` is executed to create the zones configuration file.

Alternatively, you can also use a docker volume to mount ```/etc/unbound/zones/``` to your zone files. And a volume mount for the ```zones.conf```
configuration file.

You can use subdirectories. The zone file needs to have ```$ORIGIN``` set to our zone origin.

#### Use DNS-over-TLS

The default configuration uses [quad9](https://www.quad9.net/) to forward the DNS queries over TLS.
If you want to use another vendor or you want to use the root DNS servers director you can remove this file.

### Build the image

```
$ docker build -t stafwag/unbound .
```

To use a different BASE_IMAGE, you can use the --build-arg BASE_IMAGE=your_base_image.

```
$ docker build --build-arg BASE_IMAGE=stafwag/debian:bullseye -t stafwag/unbound .
```

## Run

### Recursive DNS server with DNS-over-TLS

Run

```
$ docker run -d --rm --name myunbound -p <IP_ADDRESS>:53:5353 -p <IP_ADDRESS>:53:5353/udp stafwag/unbound
```

Test

```
$ dig @<IP_ADDRESS> www.wagemakers.be
```

### Authoritative dns server.

If you want to use unbound as an authoritative dns server you can use the steps below.

#### Create a directory with your zone files:

```
[staf@vicky ~]$ mkdir -p ~/docker/volumes/unbound/zones/stafnet
[staf@vicky ~]$
```

```
[staf@vicky stafnet]$ cd ~/docker/volumes/unbound/zones/stafnet
[staf@vicky ~]$
```

#### Create the zone files

##### Zone files

stafnet.zone:

```
$TTL  86400 ; 24 hours
$ORIGIN stafnet.local.
@  1D  IN  SOA @  root (
<PHONE_NUMBER>1 ; serial
            3H ; refresh
            15 ; retry
            1w ; expire
            3h ; minimum
           )
@  1D  IN  NS @

stafmail IN A <IP_ADDRESS>
```

stafnet-rev.zone:

```
$TTL    86400 ;
$ORIGIN 10.10.10.IN-ADDR.ARPA.
@       IN      SOA     stafnet.local. root.localhost.  (
<PHONE_NUMBER>1; Serial
                        3h      ; Refresh
                        15      ; Retry
                        1w      ; Expire
                        3h )    ; Minimum
        IN      NS      localhost.
10      IN      PTR     stafmail.
```

Make sure that the volume directoy and zone files have the correct permissions.

```
$ sudo chmod 750 ~/docker/volumes/unbound/zones/stafnet/
$ sudo chmod 640 ~/docker/volumes/unbound/zones/stafnet/*
$ sudo chown -R root:5000153 ~/docker/volumes/unbound/
```

Create the zones.conf configuration file.

```
[staf@vicky stafnet]$ cd ~/github/stafwag/docker-stafwag-unbound/
[staf@vicky docker-stafwag-unbound]$
```

The script will execute a ```chown``` and ```chmod``` on the generated ```zones.conf``` file and is excute with sudo for this reason.

```
[staf@vicky docker-stafwag-unbound]$ sudo scripts/create_zone_config.sh -f ~/docker/volumes/unbound/zones.conf -d ~/docker/volumes/unbound/zones/stafnet -p /etc/unbound/zones
Processing: /home/staf/docker/volumes/unbound/zones/stafnet/stafnet.zone
origin=stafnet.local
Processing: /home/staf/docker/volumes/unbound/zones/stafnet/stafnet-rev.zone
origin=1.168.192.IN-ADDR.ARPA
[staf@vicky docker-stafwag-unbound]$
```

Verify the generated ```zones.conf```

```
[staf@vicky docker-stafwag-unbound]$ sudo cat ~/docker/volumes/unbound/zones.conf
auth-zone:
  name: stafnet.local
  zonefile: /etc/unbound/zones/stafnet.zone

auth-zone:
  name: 1.168.192.IN-ADDR.ARPA
  zonefile: /etc/unbound/zones/stafnet-rev.zone

[staf@vicky docker-stafwag-unbound]$
```

#### run the container

```
$ docker run --rm --name myunbound -v ~/docker/volumes/unbound/zones/stafnet:/etc//unbound/zones/ -v ~/docker/volumes/unbound/zones.conf:/etc/unbound/unbound.conf.d/zones.conf -p <IP_ADDRESS>:53:5353 -p <IP_ADDRESS>:53:5353/udp stafwag/unbound
```

#### Test

```
[staf@vicky ~]$ dig @<IP_ADDRESS> soa stafnet.local

; <<>> DiG 9.16.1 <<>> @<IP_ADDRESS> soa stafnet.local
; (1 server found)
;; global options: +cmd
;; Got answer:
;; WARNING: .local is reserved for Multicast DNS
;; You are currently testing what happens when an mDNS query is leaked to DNS
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 37184
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;stafnet.local.

;; Query time: 0 msec
;; SERVER: <IP_ADDRESS>#53(<IP_ADDRESS>)
;; WHEN: Tue Oct 19 19:51:47 CEST 2021
;; MSG SIZE  rcvd: 75

[staf@vicky ~]$
```

***Have fun***

repository: stafwag/docker-stafwag-unbound

repo_name: stafwag/docker-stafwag-unbound


text:
# PyMerge

Python implementation of Merge Sort

## About

This is just intended as a personal reminder of how this algorithm works, and isn't intended to be hyperoptimized for
production or anything.

## License

Released under the Apache 2.0 license

repository: DasAllFolks/PyMerge

repo_name: DasAllFolks/PyMerge


text:
---
path: '/materials/urql'
type: 'GitHub'
img: './screenshot.png'
material:
  title: 'urql'
  url: 'https://github.com/FormidableLabs/urql'
  github_url: 'https://github.com/FormidableLabs/urql'
  subscribers_count: '51'
  stargazers_count: '1808'
  tags: ['formidable','graphql','graphql-client','react','react-component','reactjs']
  subtitle: 'A highly customizable and versatile GraphQL client for React'
  clone_url: 'https://github.com/FormidableLabs/urql.git'
  ssh_url: 'git@github.com:FormidableLabs/urql.git'
  pushed_at: '2019-02-14T21:23:54Z'
  updated_at: '2019-02-14T18:42:35Z'
  author:
    name: 'FormidableLabs'
    avatar: 'https://avatars3.githubusercontent.com/u/5078602?v=4'
    github_url: 'https://github.com/FormidableLabs'
  latestRelease:
    tag_name: null
    name: null
    url: null
    created_at: null
---
# urql

    A highly customisable and versatile GraphQL client for React

`urql` is mainly a GraphQL client, but also exposes a set of React components.
It's built to be highly customisable and versatile, so you can take it from building
your first GraphQL or playing around with complex GraphQL experiments, all the
way to building a highly sophisticated GraphQL data management library.

While GraphQL is an elegant protocol that constrains and informs the data that is returned
from APIs, this library exists because existing solutions are a bit heavy on the API side
of things. Instead of replacing sane data management that should be easy,
`urql` strives to make them as simple as possible.

## Quick Start Guide

First, install `urql`:

```sh
yarn add urql
# or
npm intall --save urql
```

Then try to create a client and wrap your app with a `<Provider>`:

```js
import { Provider, createClient } from 'urql';

const client = createClient({
  url: 'http://localhost:1234/graphql'
});

// ...
<Provider value={client}>
  <YourApp />
</Provider>;
```

This allows you to use the `<Connect>` component, for instance,
to query your GraphQL API:

```js
import { Connect, createQuery } from 'urql';

// ...

<Connect query={createQuery(`{ todos { id } }`)}>
  {({ fetching, data }) => (
    fetching ? <Loading /> : <List data={data.todos} />
  )}
</Connect>
```

You can also send mutations, which can be passed into the same `<Connect>`
component:

```js
import { Connect, createMutation } from 'urql';

// ...

<Connect mutations={{
  addTodo: createMutation(`mutation { addTodo(text: 'Example') { id } }`)
}}>
  {({ mutations }) => (
    /* mutations.addTodo() sends the mutation and returns a promise */
  )}
</Connect>
```

[Learn more about urql's 'Usage' in the docs](./TODO.md)


text:
---
layout:     post
title:      DS Question Collection-General
subtitle:   ~~
date:       2018-11-20
author:    Chester
header-img: img/failure.jpg
catalog: true
tags:
    - Job
---
## Terminology Explanation
#### Logstic Regression

#### Explain Difference and Box plot

#### Explain sparsity

#### Explain expectation-maximization (EM)

#### Explain SVM

#### Explain-SVM Soft Margin

#### Explain-SVM Dual problem

#### Explain Naive Bayes

#### Explain SGD

#### Explain PassiveAggressiveClassifier

#### Metrics for classification problem
## DS Concept
#### What is bias-vaiance tradoff?
W
## Regression

#### Explain boosting

#### Explain xgboost

#### Clustering

#### Explain SVM 1-class

#### Explain Metrics for clustering

## Classification
#### List the metrics for cluster:

 - Binary problem
 - Multiple class
	 - Micro/Macro F1, Presion Recall
	 - Confusion matrix

## Statistic

#### Explain Bayes

#### Explain Hyposis test

#### Explain P-Test

#### Explain Confifdence Interval

#### Explain Probabilty & Likiihood

## BIG DATA

#### What's CAP theory
#### What's difference between Cassandra and Mongodb ?
####  If you have tera bytes data, How you do it for implement?
[Training a NER in large data set](https://nlpforhackers.io/training-ner-large-dataset/)
## Special Case

#### Very unbalanced data for classification problem
I've been asking this question for at least 3 companies(Stich Fix, Grid Dynamic, Amazon Alexa)
- balanced accuracy
- Turn the problem into abnormal detection
-
#### Dimen
## Deep Learning
#### Why we need the max pool in CNN?

## Imblanced training data?
[How to handle Imbalanced Classification Problems in machine learning?](https://www.analyticsvidhya.com/blog/2017/03/imbalanced-classification-problem/)
 1. Over sampling /Down sampling /Mixtur / SMOTE
 2.  Ensamble algorithm=> bagging/boosting
 3.  Weighting change.

<!--stackedit_data:
eyJoaXN0b3J5IjpbMTE1MzQyNjk2MCwxNjkxMzUwNDIxXX0=
-->


text:
# township-accounts

Node.js library for managing user accounts.

[![npm][npm-image]][npm-url]
[![travis][travis-image]][travis-url]
[![standard][standard-image]][standard-url]
[![conduct][conduct]][conduct-url]

[npm-image]: https://img.shields.io/npm/v/township-accounts.svg?style=flat-square
[npm-url]: https://www.npmjs.com/package/township-accounts
[travis-image]: https://img.shields.io/travis/township/township-accounts.svg?style=flat-square
[travis-url]: https://travis-ci.org/township/township-accounts
[standard-image]: https://img.shields.io/badge/code%20style-standard-brightgreen.svg?style=flat-square
[standard-url]: http://npm.im/standard
[conduct]: https://img.shields.io/badge/code%20of%20conduct-contributor%20covenant-green.svg?style=flat-square
[conduct-url]: CONDUCT.md

## About

township-accounts is a high-level module based on [township-auth](https://github.com/township/township-auth), which manages authentication credentials, [township-access](https://github.com/township/township-access), which manages authorization via access scopes, and [township-token](https://github.com/township/township-token), which manages JWT tokens.

## Install

```sh
npm install --save township-accounts
```

## Usage

### Create the `accounts` object by calling the `townshipAccounts` constructor:

```js
var townshipAccounts = require('township-accounts')
var level = require('level')
var db = level('db')

var accounts = townshipAccounts(db, {
  secret: 'not very secret'
})
```

### Create an account with the `register` method:

```js
var creds = {
  email<EMAIL_ADDRESS>  password: 'weee'
}

accounts.register(creds, function (err, account) {
  console.log(err, account)
})
```

### Log in with the `login` method:

```js
var creds = {
  email<EMAIL_ADDRESS>  password: 'weee'
}

accounts.login(creds, function (err, account) {
  console.log(err, account)
})
```

### Log out with the `logout` method:

```js
accounts.logout(accountKey, function (err, account) {
  console.log(err, account)
})
```

See more in the [API documentation](docs/api.md)

## Documentation
- [Getting started](docs/getting-started.md)
- [API](docs/api.md)
- [Tests](tests/)

### Examples
- [Basic example](examples/basic.js)

## Contributing

Contributions are welcome! Please read the [contributing guidelines](CONTRIBUTING.md) first.

## Conduct

It is important that this project contributes to a friendly, safe, and welcoming environment for all. Read this project's [code of conduct](CONDUCT.md)

## Changelog

Read about the changes to this project in [CHANGELOG.md](CHANGELOG.md). The format is based on [Keep a Changelog](http://keepachangelog.com/) and this project adheres to [Semantic Versioning](http://semver.org/).

## Contact

- **issues** – Please open issues in the [issues queue](https://github.com/township/township-accounts/issues)
- **twitter** – Have a question? [@sethdvincent](https://twitter.com/sethdvincent)
- **email** – Need in-depth support via paid contract? Send an email to<EMAIL_ADDRESS>
## License

[ISC](LICENSE.md)

license: ISC

repository: township/township-accounts

repo_name: township/township-accounts