text:
#### Nr: 447
#### [Back to Main list](index.md)
# SQLSaturday #447 - Dallas 2015
Start Time (24h)|Speaker|Track|Title
---|---|---|---
08:30:00|Nancy Hidy Wilson|Enterprise Database Administration  Deployment|[Managing SQL Server in the Enterprise with TLAs](#sessionid-37228)
08:30:00|Argenis Fernandez|Enterprise Database Administration  Deployment|[(Near) Zero-Downtime Upgrades!](#sessionid-37957)
08:30:00|Chris Shaw|Enterprise Database Administration  Deployment|[Tips for SQL Server Performance and Resiliency](#sessionid-39419)
08:30:00|Trayce Jordan|Enterprise Database Administration  Deployment|[Finding root cause for unexplained Availability Group failover](#sessionid-39429)
08:30:00|Ginger Grant|Advanced Analysis Techniques|[Incorporating Azure Machine Learning to SQL Server Environments](#sessionid-39752)
08:30:00|Paul Hargis|Advanced Analysis Techniques|[Spark SQL and Hadoop - When to leverage in-memory SQL](#sessionid-40128)
08:30:00|Patrick Bewley|Application  Database Development|[Develop SQL Server Databases from Visual Studio: SQL Server Data Tools](#sessionid-40150)
08:30:00|Brennan Bice|BI Information Delivery|[PowerBI / DataZen and Microsoft BI Roadmap](#sessionid-40166)
09:45:00|Daniel Janik|Enterprise Database Administration  Deployment|[Translating SANanese to English: How to manipulate your storage admin!](#sessionid-37222)
09:45:00|Dr. Suresh Rajappa|BI Platform Architecture, Development  Administration|[Practical Design Pitfalls in designing Enterprise Data Warehouse](#sessionid-37223)
09:45:00|Scott Shaw|BI Information Delivery|[Big Data and the Data Lake from the Analyst Perspective](#sessionid-37621)
09:45:00|Bryan Smith|Analytics and Visualization|[Predicting Customer Churn with Azure Machine Learning](#sessionid-37750)
09:45:00|Suresh Kandoth|Enterprise Database Administration  Deployment|[Configuring SQL Server for Mission Critical and Scalable Deployments](#sessionid-38458)
09:45:00|Cindy Bean|Enterprise Database Administration  Deployment|[Avoiding the Pitfalls of Database Change Automation](#sessionid-39834)
09:45:00|David Stein|BI Platform Architecture, Development  Administration|[SSIS Performance Tuning with BimlScript](#sessionid-40140)
11:00:00|Steven Rachui|Other|[Configuration Manager and the SQL Broker Service - DRS under the covers](#sessionid-37218)
11:00:00|Mike Diehl|BI Information Delivery|[Cash in on the data dividend: how Power BI can realize the untapped value of your data](#sessionid-37243)
11:00:00|Shawn Weisfeld|Cloud Application Development  Deployment|[Your DB in the cloud?](#sessionid-37290)
11:00:00|Scott Shaw|Strategy and Architecture|[Navigating the Hadoop Stack](#sessionid-37619)
11:00:00|George Govantes|Strategy and Architecture|[So what does it really take to get to four nines](#sessionid-37744)
11:00:00|Randy Knight|Application  Database Development|[But it worked great in Dev!  Perfomance for Devs](#sessionid-39408)
11:00:00|John Harp|Enterprise Database Administration  Deployment|[Third-Party Application Deployment: Dispatches from the Trenches](#sessionid-39778)
11:00:00|Denzil Ribeiro|Enterprise Database Administration  Deployment|[SQL Server 2016  Scale and diagnostics improvements in core database engine](#sessionid-40047)
13:15:00|Daniel Janik|Advanced Analysis Techniques|[Analyze your query plan like a Microsoft Engineer!](#sessionid-37220)
13:15:00|Lance Tidwell|Enterprise Database Administration  Deployment|[SQL Server Agent: The life preserver for the drowning DBA](#sessionid-37225)
13:15:00|Stan Geiger|BI Platform Architecture, Development  Administration|[What is the SSIS Catalog? and Why do I care?](#sessionid-38231)
13:15:00|Jayaprakash Jothiraman|BI Platform Architecture, Development  Administration|[ColumnStore Index: Microsoft SQL Server 2014 and Beyond](#sessionid-39256)
13:15:00|Kalen Delaney|Enterprise Database Administration  Deployment|[Are You Optimistic About Concurrency?](#sessionid-39744)
13:15:00|Patrick O'Keeffe|Enterprise Database Administration  Deployment|[Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance](#sessionid-40110)
13:15:00|Tim Mitchell|BI Information Delivery|[Incremental Load Design Patterns](#sessionid-40144)
14:30:00|Kenneth Fisher|Enterprise Database Administration  Deployment|[SQL Server Security Basics](#sessionid-38064)
14:30:00|Adam Saxton|BI Platform Architecture, Development  Administration|[Everything you Want to know about Power BI Dependency on O365](#sessionid-38733)
14:30:00|Ryan Adams|Enterprise Database Administration  Deployment|[How Active Directory affects SQL Server](#sessionid-39707)
14:30:00|Amy Herold|Enterprise Database Administration  Deployment|[Beginning Automation with Powershell](#sessionid-40154)
14:30:00|Sri Sridharan|Strategy and Architecture|[Modern Data Strategy](#sessionid-40486)
14:30:00|Kal Yella|Application  Database Development|[What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!](#sessionid-41121)
15:45:00|Mike Byrd|Enterprise Database Administration  Deployment|[SS2014 In-Memory Tables:  Formula 1 Performance Unleashed!](#sessionid-37241)
15:45:00|Reinaldo Kibel|Strategy and Architecture|[Is AlwaysOn really as powerful? Tips and Tricks from the field](#sessionid-39075)
15:45:00|Ryan Casey|BI Information Delivery|[The "Data Loading Performance Guide" Presentation](#sessionid-39833)
15:45:00|Ahias Portillo|Application  Database Development|[Fast and Furious: Discovering Windowing Function](#sessionid-40352)
15:45:00|Andre Hass|Enterprise Database Administration  Deployment|[High Availability Solutions with Enhanced SQL Server 2016 Always ON](#sessionid-41123)
15:45:00|mahesh pujari|Other|[SSIS Monitoring Framework](#sessionid-41125)
#
#### SessionID: 37228
# Managing SQL Server in the Enterprise with TLAs
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Nancy Hidy Wilson
## Title: Managing SQL Server in the Enterprise with TLAs
## Abstract:
### Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server features designed to make a DBA’s life easier.  If you aren’t using CMS (Central Management Server), PBM (Policy Based Management), and EPM (Enterprise Policy Management Framework) – come learn what they are and the potential benefits in using them to manage your environment - from SQL 2000 to SQL 2014!
#
#### SessionID: 37957
# (Near) Zero-Downtime Upgrades!
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Argenis Fernandez
## Title: (Near) Zero-Downtime Upgrades!
## Abstract:
### SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure?  You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

* Understand how rolling upgrades are better than in place upgrades
* Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
* Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.
#
#### SessionID: 39419
# Tips for SQL Server Performance and Resiliency
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Chris Shaw
## Title: Tips for SQL Server Performance and Resiliency
## Abstract:
### After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;
We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160;
These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

#
#### SessionID: 39429
# Finding root cause for unexplained Availability Group failover
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Trayce Jordan
## Title: Finding root cause for unexplained Availability Group failover
## Abstract:
### In this session, we will walk you step by step through one or more support cases that demonstrate how we determine root cause analysis of an unexplained failure in an Availability Group.  Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover.   We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.
#
#### SessionID: 39752
# Incorporating Azure Machine Learning to SQL Server Environments
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
## Speaker: Ginger Grant
## Title: Incorporating Azure Machine Learning to SQL Server Environments
## Abstract:
### Azure Machine Learning [ML] is a great tool for gathering more insight with your data, but how do you know if the models you are using are providing the best results? How do you apply modules customized to analyze your data? After this session you will have the answers to these questions, as well as the knowledge necessary to implement machine learning data analysis into your data environment.
Using Azure based SQL Server, attendees will learn rules which can be used to classify the data and the type of analysis desired by Azure ML.  Building upon this information, the best methods for determining which ML models to use will be shown.
This presentation will demo how to extend the flexibility of Azure ML by implementing custom analysis from other sources. Incorporating items created in R and SQL will show the expanded capabilities available outside of the existing ML components.  Lastly we will deploy the Azure ML solution and incorporate the results into our SQL Server Database.

#
#### SessionID: 40128
# Spark SQL and Hadoop - When to leverage in-memory SQL
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
## Speaker: Paul Hargis
## Title: Spark SQL and Hadoop - When to leverage in-memory SQL
## Abstract:
### SQL on Hadoop has many variants. These SQL engines strive to make use of the plethora of data engineers already trained in SQL. A new class of tools, like Apache Spark, aims to increase the speed at which those SQL results can be leveraged by providing an in-memory, distributed framework to hold and process data. This introductory talk will walk through the pros and cons, plus look at a few real-world examples that can be solved more efficiently with the Spark engine.
#
#### SessionID: 40150
# Develop SQL Server Databases from Visual Studio: SQL Server Data Tools
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: Application  Database Development
## Speaker: Patrick Bewley
## Title: Develop SQL Server Databases from Visual Studio: SQL Server Data Tools
## Abstract:
### Did you know you can design and develop databases from within Visual Studio using SQL Server Data Tools? Attend this session to learn robust and repeatable database development methods and take your team to the next level using Visual Studio.  Discover simple ways to manage databases using a tool designed by Microsoft.
#
#### SessionID: 40166
# PowerBI / DataZen and Microsoft BI Roadmap
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 08:30:00 - Track: BI Information Delivery
## Speaker: Brennan Bice
## Title: PowerBI / DataZen and Microsoft BI Roadmap
## Abstract:
### Microsoft has made a significant leap forward with in the business intelligence world with the public release of PowerBI.com and acquisition of DataZen.  Power BI allows customers to create rich visualizes on a cloud platform.  DataZen is an intuitive platform with attractive dashboards and KPIs for desktop and mobile devices.  Come learn about features of both platforms, pros and cons, and Microsoft's BI roadmap.
#
#### SessionID: 37222
# Translating SANanese to English: How to manipulate your storage admin!
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Daniel Janik
## Title: Translating SANanese to English: How to manipulate your storage admin!
## Abstract:
### This technical session covers everything you ever wanted to know about troubleshooting the storage in SQL Server. Have you ever observed high latency, only to be told "It's not the disks" by the storage admin? This empowering session will give you the knowledge you need to dig down to the root cause! This session will cover DMVs, Performance Monitor, XPerf, and more!
#
#### SessionID: 37223
# Practical Design Pitfalls in designing Enterprise Data Warehouse
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development  Administration
## Speaker: Dr. Suresh Rajappa
## Title: Practical Design Pitfalls in designing Enterprise Data Warehouse
## Abstract:
### This session covers practical approaches in avoiding the common design issues in implementing Data Warehouse solutions. This also gives tips to spot the early symptoms  on these issues
#
#### SessionID: 37621
# Big Data and the Data Lake from the Analyst Perspective
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Information Delivery
## Speaker: Scott Shaw
## Title: Big Data and the Data Lake from the Analyst Perspective
## Abstract:
### The concept of a data lake is emerging as a popular way to organize and build the next generation of data systems to master new big data challenges. Organizations are seeking to create data lakes because they manage and use data with increased volume, variety, and unprecedented velocity.  However, how can data professionals and analysts access the data lake for the expected insights at the velocity required by the business?

Come and join me for this practical session which will build on your existing SQL skills to demystify Big Data and the Data Lake for analysts. This session is aimed at people who want to keep pace with the latest Big Data technology by adopting the latest techniques to explore the data lake, building on their existing analytical knowledge.

#
#### SessionID: 37750
# Predicting Customer Churn with Azure Machine Learning
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Analytics and Visualization
## Speaker: Bryan Smith
## Title: Predicting Customer Churn with Azure Machine Learning
## Abstract:
### Using machine learning, we can tap into the patterns that tell us which of our customers are likely to defect to our competitors. This use case is not only applicable to a wide range of businesses but provides a highly accessible starting point for exploring machine learning.
#
#### SessionID: 38458
# Configuring SQL Server for Mission Critical and Scalable Deployments
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Suresh Kandoth
## Title: Configuring SQL Server for Mission Critical and Scalable Deployments
## Abstract:
### SQL Server offers various configuration settings and tuning parameters. As hardware capabilities increase rapidly, choosing the proper configuration settings is extremely important to scale SQL Server for the required application throughput rates. In the last two  years, SQL Server Escalation Team has helped many systems administrators and database administrators scale their SQL Server with several configuration parameters and application patterns. In this session you will hear directly from an experienced member of the Microsoft SQL Server escalation team [Suresh Kandoth], about these specific learnings, configurations and approaches for scaling SQL Server on the largest hardware systems available on the planet.
The goal of this session to help you and guide you to perform successful deployment of SQL Server for your largest SQL Server installations.
#
#### SessionID: 39834
# Avoiding the Pitfalls of Database Change Automation
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Cindy Bean
## Title: Avoiding the Pitfalls of Database Change Automation
## Abstract:
### Automation and Continuous Delivery are at the forefront of software development processes today.  However, databases are being neglected because database code is different, harder to automate, and DBAs just don't seem to trust database automation. This is not surprising when you consider the number of incidents and instances of downtime that were caused by out-of-process updates, code overrides, and other database glitches. In this session, we will explain the options to automate database changes along with the benefits and issues with each option.
#
#### SessionID: 40140
# SSIS Performance Tuning with BimlScript
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 09:45:00 - Track: BI Platform Architecture, Development  Administration
## Speaker: David Stein
## Title: SSIS Performance Tuning with BimlScript
## Abstract:
### You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we'll discuss how to use BimlScript to accomplish the following:
- Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
- Automatically execute each package multiple times and record the results for analysis.
- Determine which package version should be used in production.

The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
#
#### SessionID: 37218
# Configuration Manager and the SQL Broker Service - DRS under the covers
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Other
## Speaker: Steven Rachui
## Title: Configuration Manager and the SQL Broker Service - DRS under the covers
## Abstract:
### When installed in a hierarchy Configuration Manager leverages the SQL Broker service to replicate data between the various sites. Understanding how Configuration Manager leverages SQL Broker and how to troubleshoot when things go wrong is critical to maintain proper hierarchy function. This session will describe how Configuration Manager replication works along with demonstrations that will highlight replication processing. We will also work through troubleshooting techniques that can be used from easiest to more complex.
#
#### SessionID: 37243
# Cash in on the data dividend: how Power BI can realize the untapped value of your data
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: BI Information Delivery
## Speaker: Mike Diehl
## Title: Cash in on the data dividend: how Power BI can realize the untapped value of your data
## Abstract:
### IDC estimates that the economic value gap between companies that are innovative about data analytics and those that maintain a status quo is $1.6 trillion worldwide over the next four years. This presentation will look at the ways that the data dividend can be realized, and provides an overview of Microsoft Power BI (the tools in Excel and the cloud-based services) so you can understand how it can be applied to your organization.

#
#### SessionID: 37290
# Your DB in the cloud?
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Cloud Application Development  Deployment
## Speaker: Shawn Weisfeld
## Title: Your DB in the cloud?
## Abstract:
### Let's face it the cloud is here to stay, and while not every workload will be moving tomorrow an understanding of running database workloads in Azure is a must for every DBA. In this session driven by real world customer conversations we will discuss some of the ramifications of moving your database workload to the cloud. We will look at the PaaS and IaaS offerings available in Azure and discuss the how to choose between them.
#
#### SessionID: 37619
# Navigating the Hadoop Stack
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Strategy and Architecture
## Speaker: Scott Shaw
## Title: Navigating the Hadoop Stack
## Abstract:
### Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.
#
#### SessionID: 37744
# So what does it really take to get to four nines
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Strategy and Architecture
## Speaker: George Govantes
## Title: So what does it really take to get to four nines
## Abstract:
### As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability.  The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success.   While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures?  The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem.
#
#### SessionID: 39408
# But it worked great in Dev!  Perfomance for Devs
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Application  Database Development
## Speaker: Randy Knight
## Title: But it worked great in Dev!  Perfomance for Devs
## Abstract:
### If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production.

#
#### SessionID: 39778
# Third-Party Application Deployment: Dispatches from the Trenches
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration  Deployment
## Speaker: John Harp
## Title: Third-Party Application Deployment: Dispatches from the Trenches
## Abstract:
### Before you install that third-party solution in your SQL Server environment, come to this fireside chat.  John will spin tales from more than a decade of experience in application support to cover some of the more common, and more problematic gotchas you might encounter, as well as their workarounds and solutions. With luck, you'll leave with an improved pre-checklist for deploying purchased products, whether in Development or Production environments.
#
#### SessionID: 40047
# SQL Server 2016  Scale and diagnostics improvements in core database engine
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 11:00:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Denzil Ribeiro
## Title: SQL Server 2016  Scale and diagnostics improvements in core database engine
## Abstract:
### This session will discuss several core performance and scale improvements to the SQL 2016  Database Engine in order to many of  of the most common customer pain points involving tempdb, new CE, partitioning , memory grants among others and will benefit any upgrade to SQL 2016. We will also discuss and demo  new diagnostics improvements for faster troubleshooting and problem mitigation.
#
#### SessionID: 37220
# Analyze your query plan like a Microsoft Engineer!
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Advanced Analysis Techniques
## Speaker: Daniel Janik
## Title: Analyze your query plan like a Microsoft Engineer!
## Abstract:
### This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.
#
#### SessionID: 37225
# SQL Server Agent: The life preserver for the drowning DBA
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Lance Tidwell
## Title: SQL Server Agent: The life preserver for the drowning DBA
## Abstract:
### Automation is a key part to becoming a great DBA.  Without automation a DBA can start to drown in a sea of repeating tasks.  The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water.  In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks.  In addition we will look into how to monitor the jobs and alerts created.  Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.
#
#### SessionID: 38231
# What is the SSIS Catalog? and Why do I care?
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development  Administration
## Speaker: Stan Geiger
## Title: What is the SSIS Catalog? and Why do I care?
## Abstract:
### SQL Server 2012 redefined how SSIS packages are stored and executed.    The advent of the SSISDB catalog gives a central point for working with SSIS projects deployed to the server.   From this catalog we can set project and package parameter, configure environments, and monitor execution.   There is no need to build in package logging because Microsoft had done it for us.  This presentation covers what is in the catalog, how to deploy packages, environment, tips and tricks as well as  monitoring package execution.
#
#### SessionID: 39256
# ColumnStore Index: Microsoft SQL Server 2014 and Beyond
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Platform Architecture, Development  Administration
## Speaker: Jayaprakash Jothiraman
## Title: ColumnStore Index: Microsoft SQL Server 2014 and Beyond
## Abstract:
### Column store technology was first introduced in SQL Server 2012 and has been significantly enhanced for SQL Server 2014 and SQL Server 2016. Column store indexes can not only accelerate data warehouse workloads by an order of magnitude but also reduce storage requirements by an order of magnitude. Column store indexes are a hybrid technology leveraging the best of disk  in-memory capabilities. In this session we cover how to take advantage of column store capabilities in your applications and dive into the internals of how column store works in following areas.
Business Rationale ,
Overview,
Trends in the Data Warehousing Space,
Data Compression,
Query Performance,
Clustered Column Store Index,
Supportability: DMVs, Perfmon, XEvents,
High Availability/Supportability

You will also learn what is available in SQL Server 2012, SQL Server 2014 and SQL Server 2016
#
#### SessionID: 39744
# Are You Optimistic About Concurrency?
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Kalen Delaney
## Title: Are You Optimistic About Concurrency?
## Abstract:
### What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency?

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!

#
#### SessionID: 40110
# Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Patrick O'Keeffe
## Title: Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance
## Abstract:
### We're all told to watch our weight and to exercise more. Join Dell Software experts who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided).

In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won't be only be about how to fix that problem query, but we'll also talk about how to improve overall performance for all your users.

#
#### SessionID: 40144
# Incremental Load Design Patterns
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 13:15:00 - Track: BI Information Delivery
## Speaker: Tim Mitchell
## Title: Incremental Load Design Patterns
## Abstract:
### The volume of data addressed by the typical ETL operation is constantly on the rise.  Not so many years ago, a table with a few million records was considered to be huge.  These days, it's not uncommon to deal with multibillion row tables.  As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.

In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing.  Among the topics of discussion:
--Deciding whether an incremental load is appropriate
--Pick your tool: T-SQL or SSIS?
--Methods for detecting new and changed records
--Common incremental load design patterns
#
#### SessionID: 38064
# SQL Server Security Basics
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Kenneth Fisher
## Title: SQL Server Security Basics
## Abstract:
### In the modern age, data is a company's most valuable resource and, unfortunately, data crimes are common. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and keep it safe.
#
#### SessionID: 38733
# Everything you Want to know about Power BI Dependency on O365
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 14:30:00 - Track: BI Platform Architecture, Development  Administration
## Speaker: Adam Saxton
## Title: Everything you Want to know about Power BI Dependency on O365
## Abstract:
### For most users, you will sign up to use Power BI and never know that Office 365 is the background. For organizations that want to leverage the advanced features of Power BI, you MAY need to perform certain configurations within Office 365. Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service. In this demo heavy session we will dispel the myth that you may not need Office 365 to access the full capabilities Power BI.
  SQL Server has a large surface area and Active Directory can influence a big part of it.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.
#
#### SessionID: 40154
# Beginning Automation with Powershell
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Amy Herold
## Title: Beginning Automation with Powershell
## Abstract:
### This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
#
#### SessionID: 40486
# Modern Data Strategy
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Strategy and Architecture
## Speaker: Sri Sridharan
## Title: Modern Data Strategy
## Abstract:
### Join to this session to look at evolving trends around Data and how you can understand and put a plan for a Data Strategy in your organization.
#
#### SessionID: 41121
# What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 14:30:00 - Track: Application  Database Development
## Speaker: Kal Yella
## Title: What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!
## Abstract:
### Azure SQL Database is great relational database platform in the cloud for developing, deploying, and managing data tier in a wide range of cloud applications. In this session we are going to introduce you to Azure SQL Database and its new incarnation, the V12 release and all its new features that helped minimize the gap between Azure and on-premises database environments.

The topics include new features in Azure V12 database; Elastic Database Pools, Enhanced Disaster Recovery features, Transparent Database Encryption, expanded T-SQL Surface Area to name a few. This session is going to be demo rich and is one session that you don’t want to miss if you are looking to learn more about Azure SQL Databases.

#
#### SessionID: 37241
# SS2014 In-Memory Tables:  Formula 1 Performance Unleashed!
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Mike Byrd
## Title: SS2014 In-Memory Tables:  Formula 1 Performance Unleashed!
## Abstract:
### Query performance is what it is all about.  SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation.  Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc.  This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality.  This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment.
After this session you will
1.	 Understand what in-memory tables are and how to create and maintain them including their limitations
2.	Be able to identify performance gains over equivalent disk back tables
3.	Comprehend the new data monitoring needed for in-memory table

#
#### SessionID: 39075
# Is AlwaysOn really as powerful? Tips and Tricks from the field
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Strategy and Architecture
## Speaker: Reinaldo Kibel
## Title: Is AlwaysOn really as powerful? Tips and Tricks from the field
## Abstract:
### CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and implemented over 100 architectures, see how to architect, design, setup, deploy, tons of gotchas and best practices from real production deployments
With the introduction of AlwaysOn and the deprecation of Database Mirroring, Windows Clustering Services is now more critical than ever. If you have moved away from clustering or implemented database mirroring as an alternative to clustering and found it lacking AlwaysOn is the way forward for you. This talk will demonstrate a complete end-to-end solution using Windows Server Failover Clustering, AlwaysOn, SQL Server 2012 Enterprise edition, and Active Directory.
#
#### SessionID: 39833
# The "Data Loading Performance Guide" Presentation
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: BI Information Delivery
## Speaker: Ryan Casey
## Title: The "Data Loading Performance Guide" Presentation
## Abstract:
### Loading huge amounts of data into SQL Server can be challenging. There are quite a few factors that can help, or hurt your goal for tuned performance. For this reason, bulk loading with large amounts of data requires a strategy.

For that strategy, Microsoft has published a famous whitepaper called “The Data Loading Performance Guide.” The problem is that this guide is long and full of small details that can be confusing and daunting at first glance.

In this session, we will turn this whitepaper into a presentation about creating a strategy to optimize your massive data loading processes by applying the techniques mentioned in the whitepaper, as well as other advanced techniques that have emerged since the whitepaper was published.

We will talk about solutions to achieve High Performance Data Loading, Minimal Logging and Bulk Loading, Indexing Techniques including Columstore, properly leveraging Parallelism and Partitioning, Truncate Partition, PolyBase, Delayed Durability, and more.
#
#### SessionID: 40352
# Fast and Furious: Discovering Windowing Function
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Application  Database Development
## Speaker: Ahias Portillo
## Title: Fast and Furious: Discovering Windowing Function
## Abstract:
### The Windowing Functions are advanced SQL Server commands, existing since 2005, but many database developers forget to use them. In this session we will discuss about how they work, how we should use them and how we can combine them with other development techniques as the use of CTE, procedures, functions, etc.
#
#### SessionID: 41123
# High Availability Solutions with Enhanced SQL Server 2016 Always ON
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration  Deployment
## Speaker: Andre Hass
## Title: High Availability Solutions with Enhanced SQL Server 2016 Always ON
## Abstract:
### SQL Server 2016 Always ON Availability Group delivers even Higher Availability for Mission Critical workloads. If you are interested in learning what is new in SQL Server 2016 Always ON Availability Groups, come to see this session where we will cover Always ON Availability Groups in details and present scenarios how it can be used as a solution for High Availability, Disaster Recovery and offload read-only workloads to secondary replicas using on premises or cloud based servers on a hybrid cloud scenario.
SQL Server 2016 Always ON Availability Group newest features will provide even Higher Available Database Server for Mission critical workloads required by most businesses today.

#
#### SessionID: 41125
# SSIS Monitoring Framework
#### [Back to calendar](#nr-447)
Event Date: 03-10-2015 - Session time: 15:45:00 - Track: Other
## Speaker: mahesh pujari
## Title: SSIS Monitoring Framework
## Abstract:
### Most Organizations use SSIS as the ETL tool of choice for Data movement. These ETL processes can vary from simple to extremely complex processes. Data from these processes can be consumed by a Data warehouse, various other internal systems or for reporting.

Monitoring these ETL processes from a centralized location can be complicated, and many times performance issues only become apparent when the process fails or continues to keep running abnormally.
We shall talk about a framework to proactively monitor SSIS ETL processes for reporting and analysis and to examine performance trends of SSIS packages across servers over time.

This session will discuss the SSIS Monitoring framework and demonstrate a few visualizations to show a performance analysis of ETL processes with minimal effort.

repository: andrekamman/sqlsathistory

repo_name: andrekamman/sqlsathistory


text:
# Thermostat

## Introduction

This is a simple thermostat app built entirely in Javaascript. The purpose of the project was to practice writing Javascript code, interact with the DOM, use AJAX and do some simple CSS styling. The program was built entirely through TDD with Jasmine as the test framework.

## Screenshot
![screenshot](./images/app.png)

## How to use

#### To set up the project

Clone this repo to your computer and then open "index.html" in your web browser.

#### Testing

Testing was completed in Jasmine and all tests are passing. To view the tests, open the file "SpecRunner.html" in your web browser. A screenshot is included below.

![tests](./images/tests.png)

## Program requirements

* Thermostat starts at 20 degrees
* You can increase the temperature with an up function
* You can decrease the temperature with a down function
* The minimum temperature is 10 degrees
* If power saving mode is on, the maximum temperature is 25 degrees
* If power saving mode is off, the maximum temperature is 32 degrees
* Power saving mode is on by default but it can also be turned off
* You can reset the temperature to 20 with a reset function
* You can ask about the thermostat's current energy usage: < 18 is `low-usage`, <= 25 is `medium-usage`, anything else is `high-usage`.

## Credits

CSS developed with Frank McKenna

license: MIT

repository: ArifEbrahim/thermostat

branch_name: refs/heads/main

extension: md

license_type: permissive

repo_name: ArifEbrahim/thermostat


text:
# Building Azure Service Operator v1 from source

## Running the operator locally

> [!NOTE]
> Using this method you can only install resources having the the latest version of a CRD, as there are no conversion webhooks running to convert other versions. This is the reason you need to setup test certificates using the steps below too. Use this method only to try out the operator to get familiar.

1. Clone the repository into the following folder `<GOPATH>/src/github.com/Azure`.

2. Make sure the environment variable `GO111MODULE` is set to `on`.

    ```bash
    export GO111MODULE=on
    ```

3. Make sure all the below environment variables have been set appropriately. The possible values for `AZURE_CLOUD_ENV` are AzurePubliCloud (default if unspecified), AzureChinaCloud, AzureUSGovernmentCloud, AzureGermanCloud.

    ```bash
    export AZURE_TENANT_ID=xxxx
    export AZURE_SUBSCRIPTION_ID=xxxx
    export AZURE_CLIENT_ID=xxxx
    export AZURE_CLIENT_SECRET=xxxx
    export AZURE_CLOUD_ENV=AzurePublicCloud
    ```

4. Install test certificates using `make generate-test-certs`.

5. Install the CRDs defined in the config/crd/bases folder using the command
    `make install`
    You will see output as below.

    ```
    kubectl apply -f config/crd/bases
    customresourcedefinition.apiextensions.k8s.io/eventhubnamespaces.azure.microsoft.com created
    customresourcedefinition.apiextensions.k8s.io/eventhubs.azure.microsoft.com created
    customresourcedefinition.apiextensions.k8s.io/resourcegroups.azure.microsoft.com created
    customresourcedefinition.apiextensions.k8s.io/azuresqldatabases.azure.microsoft.com created
    customresourcedefinition.apiextensions.k8s.io/azuresqlfirewallrules.azure.microsoft.com created
    customresourcedefinition.apiextensions.k8s.io/azuresqlservers.azure.microsoft.com configured
    ```

6. Copy the generated certificates to the correct location by first attempting to run the operator locally using
   ```make run```
   This will cause the operator to run (briefly) and will display an error (as well the correct location to copy generated certificates to). You will see something similar to this in the terminal window indicating that the controller started running and then subsequently failed:

    ```
    go fmt ./...
    go vet ./...
    go run ./main.go

    ...

    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	skip registering a validating webhook, admission.Validator interface is not implemented	{"GVK": "azure.microsoft.com/v1alpha1, Kind=AzureSqlFirewallRule"}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	conversion webhook enabled	{"object": {"metadata":{"creationTimestamp":null},"spec":{"server":""},"status":{}}}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	skip registering a mutating webhook, admission.Defaulter interface is not implemented	{"GVK": "azure.microsoft.com/v1alpha1, Kind=AzureSqlFailoverGroup"}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	skip registering a validating webhook, admission.Validator interface is not implemented	{"GVK": "azure.microsoft.com/v1alpha1, Kind=AzureSqlFailoverGroup"}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	conversion webhook enabled	{"object": {"metadata":{"creationTimestamp":null},"spec":{"location":"","server":"","failoverpolicy":"","failovergraceperiod":0,"secondaryserver":"","secondaryserverresourcegroup":"","databaselist":null},"status":{}}}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	skip registering a mutating webhook, admission.Defaulter interface is not implemented	{"GVK": "azure.microsoft.com/v1alpha1, Kind=BlobContainer"}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	skip registering a validating webhook, admission.Validator interface is not implemented	{"GVK": "azure.microsoft.com/v1alpha1, Kind=BlobContainer"}
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.builder	conversion webhook enabled	{"object": {"metadata":{"creationTimestamp":null},"spec":{"location":""},"status":{}}}
    2020-05-13T17:04:26.587-0700	INFO	setup	starting manager
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.webhook.webhooks	starting webhook server
    2020-05-13T17:04:26.587-0700	INFO	controller-runtime.manager	starting metrics server	{"path": "/metrics"}
    2020-05-13T17:04:26.588-0700	DEBUG	controller-runtime.manager	non-leader-election runnable finished	{"runnable type": "*webhook.Server"}
    2020-05-13T17:04:26.588-0700	INFO	controller-runtime.controller	Starting EventSource	{"controller": "keyvault", "source": "kind source: /, Kind="}
    2020-05-13T17:04:26.588-0700	ERROR	setup	problem running manager	{"error": "open /var/folders/1_/d50yhxgd357cfl0yjdclppfc0000gn/T/k8s-webhook-server/serving-certs/tls.crt: no such file or directory"}
    github.com/go-logr/zapr.(*zapLogger).Error
        /Users/username/Code/go/pkg/mod/github.com/go-logr/zapr@v0.1.0/zapr.go:128
    main.main
        /Users/username/Code/go/src/github.com/WilliamMortlMicrosoft/azure-service-operator/main.go:781
    runtime.main
        /usr/local/Cellar/go/1.14.2_1/libexec/src/runtime/proc.go:203
    exit status 1
    make: *** [run] Error 1`
    ```

    Look for the listed directory given in the *problem running manager* log entry, above that directory is: "/var/folders/1_/d50yhxgd357cfl0yjdclppfc0000gn/T/". Next, run the following command `cp -r /tmp/k8s-webhook-server /var/folders/1_/d50yhxgd357cfl0yjdclppfc0000gn/T/`.

    Please note, copying the generated certificates into the this folder only needs to be done only once (or when the machine is rebooted or the local Kubernetes cluster is cleared). You do not need to do this step every time.

7. Run the operator locally using
   ```make run```
   This will cause the operator to run and "watch" for events on this terminal. You will need to open a new terminal to trigger the creation of a custom resource.

   You will see something like this on the terminal window indicating that the controller is running.

   ```
    go fmt ./...
    go vet ./...
    go run ./main.go
    2019-09-24T12:18:10.419-0600	INFO	controller-runtime.metrics	metrics server is starting to listen	{"addr": ":8080"}

    2019-09-24T12:18:10.419-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "eventhub", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.419-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "resourcegroup", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.419-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "eventhubnamespace", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.420-0600	INFO	controller-runtime.builder	Registering a mutating webhook	{"GVK": "azure.microsoft.com/v1, Kind=EventhubNamespace", "path": "/mutate-azure-microsoft-com-v1-eventhubnamespace"}
    2019-09-24T12:18:10.420-0600	INFO	controller-runtime.builder	Registering a validating webhook	{"GVK": "azure.microsoft.com/v1, Kind=EventhubNamespace", "path": "/validate-azure-microsoft-com-v1-eventhubnamespace"}
    2019-09-24T12:18:10.420-0600	INFO	controller-runtime.builder	Registering a mutating webhook	{"GVK": "azure.microsoft.com/v1, Kind=Eventhub", "path": "/mutate-azure-microsoft-com-v1-eventhub"}
    2019-09-24T12:18:10.424-0600	INFO	controller-runtime.builder	Registering a validating webhook	{"GVK": "azure.microsoft.com/v1, Kind=Eventhub", "path": "/validate-azure-microsoft-com-v1-eventhub"}
    2019-09-24T12:18:10.424-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "azuresqlserver", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.424-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "azuresqldatabase", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.424-0600	INFO	controller-runtime.controller	Starting EventSource	{"controller": "azuresqlfirewallrule", "source": "kind source: /, Kind="}
    2019-09-24T12:18:10.424-0600	INFO	setup	starting manager
    2019-09-24T12:18:10.424-0600	INFO	controller-runtime.manager	starting metrics server	{"path": "/metrics"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "eventhub"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "resourcegroup"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "azuresqldatabase"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "azuresqlfirewallrule"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "eventhubnamespace"}
    2019-09-24T12:18:10.526-0600	INFO	controller-runtime.controller	Starting Controller	{"controller": "azuresqlserver"}
    2019-09-24T12:18:10.527-0600	INFO	controller-runtime.certwatcher	Updated current TLS certiface
    2019-09-24T12:18:10.527-0600	INFO	controller-runtime.certwatcher	Starting certificate watcher
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "azuresqldatabase", "worker count": 1}
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "resourcegroup", "worker count": 1}
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "azuresqlfirewallrule", "worker count": 1}
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "eventhub", "worker count": 1}
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "azuresqlserver", "worker count": 1}
    2019-09-24T12:18:10.626-0600	INFO	controller-runtime.controller	Starting workers	{"controller": "eventhubnamespace", "worker count": 1}
   ```

8. Open a new terminal window. Trigger the creation of a custom resource using  kubectl and the sample YAML file provided.
   For instance, you would use the following command to create a SQL server:

   ```shell
   kubectl apply -f config/samples/azure_v1alpha1_azuresqlserver.yaml
   azuresqlserver.azure.microsoft.com/sqlserver-sample created
   ```

9. You should see logs on the other terminal from the operator when this custom resource is being created.

    ```
    2019-09-24T12:27:12.450-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194427"}, "reason": "Updated", "message": "finalizer azuresqlserver.finalizers.azure.com added"}
    2019-09-24T12:27:12.450-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194427"}, "reason": "Submitting", "message": "starting resource reconciliation"}
    2019-09-24T12:27:17.129-0600	INFO	controllers.AzureSqlServer	mutating secret bundle
    2019-09-24T12:27:17.144-0600	INFO	controllers.AzureSqlServer	waiting for provision to take effect	{"azuresqlserver": "default/sqlserver-sample1"}
    2019-09-24T12:27:17.350-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194437"}, "reason": "Checking", "message": "instance in NotReady state"}
    2019-09-24T12:27:17.359-0600	INFO	controllers.AzureSqlServer	Got ignorable error	{"azuresqlserver": "default/sqlserver-sample1", "type": "ResourceNotFound"}
    2019-09-24T12:27:17.564-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194439"}, "reason": "Checking", "message": "instance in NotReady state"}
    2019-09-24T12:27:17.570-0600	INFO	controllers.AzureSqlServer	Got ignorable error	{"azuresqlserver": "default/sqlserver-sample1", "type": "ResourceNotFound"}
    2019-09-24T12:28:17.805-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194439"}, "reason": "Checking", "message": "instance in Ready state"}
    2019-09-24T12:28:19.010-0600	DEBUG	controller-runtime.controller	Successfully Reconciled	{"controller": "sqlserver", "request": "default/sqlserver-sample1"}
    2019-09-24T12:28:19.010-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194518"}, "reason": "Provisioned", "message": "sqlserver sqlserver-sample1 provisioned "}
    2019-09-24T12:28:19.202-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194518"}, "reason": "Checking", "message": "instance in Ready state"}
    2019-09-24T12:28:20.331-0600	DEBUG	controller-runtime.controller	Successfully Reconciled	{"controller": "azuresqlserver", "request": "default/sqlserver-sample1"}
    2019-09-24T12:28:20.331-0600	DEBUG	controller-runtime.manager.events	Normal	{"object": {"kind":"AzureSqlServer","namespace":"default","name":"sqlserver-sample1","uid":"ed3774af-def8-11e9-90c4-025000000001","apiVersion":"azure.microsoft.com/v1alpha1","resourceVersion":"194518"}, "reason": "Provisioned", "message": "sqlserver sqlserver-sample1 provisioned "}
    ```

10. Once the operator is running locally, in order to view debugging (Prometheus-based) metrics for the Azure operator, open a web browser and navigate to the [Metrics Endpoint](http://<IP_ADDRESS>:8080/metrics).

If you are using the Kubernetes cluster that comes with "Docker Desktop" and would like to view the Prometheus metrics, you can redirect port 8080 to the local machine using the following command:

```
kubectl port-forward deployment/controller-manager 8080
```

Then, open a web browser and navigate to the [Metrics Endpoint](http://<IP_ADDRESS>:8080/metrics).

## Developing using VSCode with Remote - Containers

If you're using VSCode with [Remote - Containers](https://marketplace.visualstudio.com/items?itemName=ms-vscode-remote.remote-containers) extensions installed, you can quickly have your environment set up and ready to go, with everything you need to get started.

1. Clone the repository and open the folder in VS Code. (will refer to the folder as PROJECT_DIR)
2. Create a new file at $PROJECT_DIR/.env with the following variables set for your environment:
```
AZURE_TENANT_ID=
AZURE_SUBSCRIPTION_ID=
AZURE_CLIENT_ID=
AZURE_CLIENT_SECRET=
```

3. Click on the green button in the lower left-hand corner and select "Remote-Containers: Reopen in Container" from the drop-down
4. VSCode will relaunch and start building our development container. This will install all the necessary dependencies required for you to begin developing.
5. Once the container has finished building, you can now start testing your Azure Service Operator within your own local kubernetes environment via the terminal inside VSCode.
6. Install test certificates using `make generate-test-certs`.
7. Install CRDs using `make install`.
8. Run the project using `make run`.
9. In another terminal, use `kubectl apply` with the sample YAML files to create custom resources for testing.
For eg., use  `kubectl apply -f config/samples/azure_v1alpha1_azuresqlserver.yaml` from the terminal to create a SQL server using the operator.
`kubectl describe SqlServer` would show the events that indicate if the resource is created or being created.

## Want to contribute a new operator?

If you are ready to contribute a new operator to the Azure Service Operators project, please follow the step-by-step guide [here](newoperatorguide.md).

## Updating Helm Chart in the repo

If you make changes to the Chart or if you make changes to the CRDs, you will need to update the Helm Chart and check-in the updated chart using the following steps:

1. After you make the changes to the CRDs or the chart, run `make helm-chart-manifests` from the project root.
2. Add all the modified files generated including the .tgz file, to your commit.
3. Include these files in your Pull Request.

## Code Structure

![Overview](../../images/aso-v1-structure.svg)

repository: Azure/azure-service-operator

gha_language: Go

gha_license_id: MIT

repo_name: Azure/azure-service-operator


text:
# carloshb/cache-service
[![Latest Stable Version](https://poser.pugx.org/carloshb/cache-service/v/stable)](https://packagist.org/packages/carloshb/cache-service)
[![Total Downloads](https://poser.pugx.org/carloshb/cache-service/downloads)](https://packagist.org/packages/carloshb/cache-service)
[![Latest Unstable Version](https://poser.pugx.org/carloshb/cache-service/v/unstable)](https://packagist.org/packages/carloshb/cache-service)
[![License](https://poser.pugx.org/carloshb/cache-service/license)](https://packagist.org/packages/carloshb/cache-service)

Simple cache service using SQLite to reduce multiple db queries.
## Basic information
* **default cache time**: 60mins
* **default cache path**: Carloshb\CacheService\Driver
## How to install?
Install using composer
```shell
composer require carloshb/cache-service 0.2.*
```
Or clone in or project.
### How to change default configs?
Add PHP env:
```php
    $_ENV['cache_time'] = 10; // minutes
    $_ENV['cache_path'] = 'yor/storage/path';
```
## Usage
### resolve(string $key, callable $callback [, int $time = 60]) : Cache
The method **resolve()** returns an instance of Cache class and generate or update the key sent with the callback return. First parameter is the key, a string.
Second parameter is the callback, a function returning array with expected results. Third parameter is optional, for set *n* minutes for cache.
```php
    $cache = new \Carloshb\CacheService\Cache();
    $cache->resolve('getInfo', function(){
        return array(
            'name' => 'Carlos Henrique Bernardes',
            'email' =><EMAIL_ADDRESS>        );
    });
```
### getCacheContent() : json
Use after **resolve()** to get a content of cache, the method returns a json.
```php
    $cache = new \Carloshb\CacheService\Cache();
    $content = $cache->resolve('getInfo', function(){
        return array(
            'name' => 'Carlos Henrique Bernardes',
            'email' =><EMAIL_ADDRESS>        );
    })->getCacheContent();
```

### destroy(string $key) : bool
Use this method to force cache destroy using the key name.
```php
    $cache = new \Carloshb\CacheService\Cache();
    $response = $cache->destroy('getInfo');
    var_dump($response); // true or false
```

repository: carloshskp/cache-service

branch_name: refs/heads/master

repo_name: carloshskp/cache-service


text:
# e-ink wifi clock

![Test build](https://github.com/romkey/e-ink-clock/actions/workflows/main.yml/badge.svg)

_This is a work in progress. I'm still testing and updating the hardware, and the software is incomplete. Build at your own risk._

Use a Waveshare epaper (e-ink) display as a digital wifi clock. The clock synchronizes its time with NTP and can show local weather using OpenWeatherMap.

The clock also supports an optional environmental sensor module, which allows it to report the temperature, humidity and air pressure in the space it's in.

It also supports an optional DS3231 I2C real time clock with battery backup module. This allows it to know the time immediately upon booting, even without NTP, and to keep time more accurately than just the ESP32 is capable of.

FInally, it also supports an optional ambient light sensor. This allows the clock to power down the e-ink module in the dark (when it is unreadable), which should extend the lifespan of the module.

# Hardware

Eagle schematics and board are in the `eagle` directory.

_The hardware is still in testing; I cannot make any promises about its suitability for any use or its reliability._

Prices are obviously from the time I made this list. Links to parts are meant to show parts that have identical pinouts to the ones I used in the PC board layout. The specific items may become unavailable over time or the listings might even change to other parts with incompatible pinouts, so *please be careful to make sure you get parts with the correct pinouts* if you want to use the PC board - this is meant to be a guide to the parts and not a specific shopping list.

| Part                               | AliExpress | Amazon | Notes |
|-------------------|--------:|-------:|--|
|Waveshare 4.2" epaper module | [$28.79](https://www.aliexpress.com/item/400x300-4-2inch-E-Ink-display-module-No-backlight-Ultra-low-power-consumption-SPI-interface-Compatible/32826601765.html) | [$38.99](https://www.amazon.com/gp/product/B074NR1SW2) | |
|Wemos LOLIN32 ESP32 | [$5.50](https://www.aliexpress.com/item/ESP-32-ESP32-ESP-WROOM-32-for-WeMos-D1-LOLIN32-V1-0-02-WIFI-Bluetooth-Development/32887251214.html) | [$9.99 + $4.99](https://www.amazon.com/Beaster-LOLIN32-V1-0-0-Bluetooth-Development/dp/B07KFF1GJK) | |
|BME280 breakout | [$2.50](https://www.aliexpress.com/item/High-Accuracy-3In1-BME280-Digital-Sensor-Temperature-Humidity-Barometric-Pressure-Sensor-Module-GY-BME280-I2C-SPI/32817230797.html) | [$11.20](https://www.amazon.com/gp/product/B0775XFW69) | *optional*  lets you read the temperature, hunmidity and pressure where the clock is |
|DS3231 RTC breakout | [$1.04](https://www.aliexpress.com/item/DS3231-AT24C32-IIC-High-Precision-RTC-Module-Clock-Timer-Memory-Module/2037934408.html) | [$6.99](https://www.amazon.com/gp/product/B01IXXACD0) | *optional* keeps more accurate time, works without NTP or wifi |
|photoresistor | []() | []() | *optional* lets the clock power off display in the dark |
|         |$37.83 | $72.16 |

Obviously AliExpress is an economical choice if you can wait a month or more for your parts to arrive.

The printed circuit board uses breakout boards and is easy to assemble. The current version is at https://oshpark.com/shared_projects/apAIFWjg

# Software

The e-ink clock software is built using the Arduino SDK. It builds under [PlatformIO](https://platformio.org/) but with a little rearranging you could also build it with the Arduino IDE.

The application uses the [GxEPD](https://github.com/ZinggJM/GxEPD) library to drive the Waveshare display. GxEPD is a subclass of [Adafruit_GFX](https://github.com/adafruit/Adafruit-GFX-Library), so you can use its API to talk to the display. It also supports fast partial update on some Waveshare displays, which lets you write to the display much faster than a full screen write, without distracting flashing.

## Resources:

- turn an image file into a C language bitmap - [image2cpp](https://javl.github.io/image2cpp/)
- use `fontconvert` from Adafruit GFX Library to convert fonts to Adafruit GFX format

## Configuration

Copy `src/config.h-example` to `src/config.h` and set the constants in the file as you need them:
- `WIFI_SSID1`, `WIFI_PASSWORD1` - your primary WiFi SSID and password
- `WIFI_SSID2`, `WIFI_PASSWORD2` - your backup WiFi SSID and password  - set to the same as primary if you don't have a backup
- `WIFI_SSID3`, `WIFI_PASSWORD3` - your bakup backup WiFi SSID and password  - set to the same as backup if you don't have a backup backup

## License

Permission to use this software is granted under the [MIT License](https://romkey.mit-license.org).

repository: romkey/e-ink-clock

repo_name: romkey/e-ink-clock


text:
# egopanda
CSC-842 Cycle1

## Description
- Course: CSC842 Security Tool Development
- Developer: Dylan Johnson
- Language: C
- Scope: Offensive Security/Penetration Testing

Linux x86-64 based shell/remote administration tool. This project is intended to be used after successful exploitation of a host during a penetration test/offensive security assesment. Kind of a pet project at the moment.

## Capabilities
EGOPANDA is capable of running commands at the same level as the compromised user of a remote host. The shell can attempt to hide itself by deleting the original binary from disk, copying itself to other locations, and renaming the running process to evade detection. There is also functionality for persistence in the form of CRON jobs.

### Functionality
The primary function of this software is to remotely interact with a compromised system.

## Future Work
This is a very basic shell. Future work includes adding additional functionality such as file transfer, privelege escalation, screenshots, audio recording, etc. Building a dedicated administration platform for the operator is also an option.

repository: dylup/egopanda

repo_name: dylup/egopanda


text:
AP Project2 AP Project2

Project Title - TravelPedia

Description :

This project's main aim is help with easy online booking of flights and hotel reservation. The site allows an dummy model to book flight systems and book a hotel room for a number of guests over a certain period of time.

Built With Flask - The web framework used Flask - Dependency Management SqlAlchemy - Database Management

How to Run: The code functions seamlessly when used with flask. Follow these steps to run the website. You will need Visual Studio With Python to run the website seamlessly.

1.Clone the "DB" branch from the github repository named Project2Ap 2.Run Visual Studio 3.Open the Flask Solution from the cloned "Ordering" repository 4.Click on "Web Server" in Visual Studio 5.Runs the webiste on LocalHost//SomePort 6.Website functions as expected.

Final Output The overall website was a final result of various alterations that were made from the original design. After multiple changes in the tools and implementation, the final website was brought together. As envisioned in the beginning, the website had most of all the functionalities that were thought of in the beginning. This included the choice of picking a custom made cake from the numerous options that were provided. Alongside, the User-Login functionality was also successfully implemented. This ensured a secure user database was created and maintained by the website. The website could successfully replicate an order and send out for delivery using the cash on delivery option. In totality , the website performed normally when tested for its optimum results.

Contributers Ayushman Ghosh, Shivangi Mishra, Yash Dixit and Abhishek Awasthi

License This project is licensed under the MIT License

Acknowledgments W3schools Miguelgrinberg


text:
# DRGCN: Dynamic Evolving Initial Residual for Deep Graph Convolutional Networks

```
@inproceedings{drgcn_aaai23,
title = {DRGCN: Dynamic Evolving Initial Residual for Deep Graph Convolutional Networks},
author = {Zhang, Lei and Yan, Xiaodong and He, Jianshan and Li, Ruopeng and Chu, Wei},
booktitle = {Proceedings of the Thirty-Seventh Conference on Association for the Advancement of Artificial Intelligence (AAAI)},
pages = {11254--11261},
year = {2023}
}
```

links
- [aaai](https://ojs.aaai.org/index.php/AAAI/article/view/26332)

gha_language: Jupyter Notebook


text:
---
title: "inputMediaGeoLive"
description: "Live geolocation"
nav_exclude: true
image: https://docs.madelineproto.xyz/favicons/android-chrome-256x256.png
---
# Constructor: inputMediaGeoLive
[Back to constructors index](/API_docs/constructors/index.html)

[Live geolocation](https://core.telegram.org/api/live-location)

### Attributes:

| Name     |    Type       | Required | Description |
|----------|---------------|----------|-------------|
|stopped|[Bool](/API_docs/types/Bool.html) | Optional|Whether sending of the geolocation was stopped|
|geo\_point|[InputGeoPoint](/API_docs/types/InputGeoPoint.html) | Optional|Current geolocation|
|heading|[int](/API_docs/types/int.html) | Optional|For [live locations](https://core.telegram.org/api/live-location), a direction in which the location moves, in degrees; 1-360.|
|period|[int](/API_docs/types/int.html) | Optional|Validity period of the current location|
|proximity\_notification\_radius|[int](/API_docs/types/int.html) | Optional|For [live locations](https://core.telegram.org/api/live-location), a maximum distance to another chat member for proximity alerts, in meters (0-100000)|

### Type: [InputMedia](/API_docs/types/InputMedia.html)

### Example:

```
$inputMediaGeoLive = ['_' => 'inputMediaGeoLive', 'stopped' => Bool, 'geo_point' => InputGeoPoint, 'heading' => int, 'period' => int, 'proximity_notification_radius' => int];
```

repository: danog/MadelineProtoDocs

gha_language: PHP

repo_name: danog/MadelineProtoDocs


text:
![Chainlink Cosmos](docs/imgs/logo.png)

[![GitHub license](https://img.shields.io/github/license/ChainSafe/chainlink-cosmos.svg)](https://github.com/ChainSafe/chainlink-cosmos/blob/master/LICENSE)
[![Medium Badge](https://img.shields.io/badge/chainsafe-systems-black?style=flat&logo=medium&logoColor=white&link=https://medium.com/chainsafe-systems)](https://medium.com/chainsafe-systems)
[![Twitter Badge](https://badgen.net/badge/icon/twitter?icon=twitter&label)](https://twitter.com/chainsafeth)

# Chainlink-Cosmos

**Chainlink** is a decentralized oracle network. To make Chainlink data feeds usable within Cosmos blockchains, [ChainSafe Systems](https://chainsafe.io/) is developing a Cosmos SDK module that supports the basic Chainlink OCR functionality of accepting aggregate signed data from a set of oracles, and storing it in the blockchain state. This data is made available to other modules within the same application.

Any application developer can incorporate this module directly into their application to manage and incentivize data providers & accept data submitted by these participants to the chain.

## Get started

```
$ make install
```

## Launch

```
$ make start
```

## Documentation
[Cosmos ChainLink Module Documentation](./docs/doc.md)

## Learn more
- [Cosmos SDK documentation](https://docs.cosmos.network)
- [Cosmos SDK Tutorials](https://tutorials.cosmos.network)

## License

[MIT](LICENSE) © ChainSafe Systems

repository: salvivona/chainlink-cosmos

repo_name: salvivona/chainlink-cosmos


text:
---
tags: weekly, rustc
---

# T-compiler Meeting Agenda 2021-08-19

[Tracking Issue](https://github.com/rust-lang/rust/issues/54818)

## Announcements

- Steering meeting on <time:2021-08-20T10:00:00-04:00> to discuss how to increase the number of reviewers available to handle the review queue load. ([Zulip topic](https://rust-lang.zulipchat.com/#narrow/stream/131828-t-compiler/topic/Review.20assignments.20steering.20meeting))

## MCPs/FCPs

- New MCPs (take a look, see if you like them!)
  -  "prefer-dynamic=subset" [compiler-team#455](https://github.com/rust-lang/compiler-team/issues/455)
- Old MCPs (not seconded, take a look)
  -  "Add different entry points for x.py" [compiler-team#396](https://github.com/rust-lang/compiler-team/issues/396) (last comments: GH 7m ago, Zulip 12d ago)
  -  "rustdoc is using rustc_ast_pretty, would it be possible to make it somewhat "stable"?" [compiler-team#403](https://github.com/rust-lang/compiler-team/issues/403) (last comments: GH 6m ago, Zulip 50d ago)
  -  "Don't steal the resolver when lowering HIR; instead store an immutable resolver in TyCtxt" [compiler-team#437](https://github.com/rust-lang/compiler-team/issues/437) (last comments: GH 2m ago, Zulip 49d ago)
  -  "CI should exercise (subset of) tests under --stage 1" [compiler-team#439](https://github.com/rust-lang/compiler-team/issues/439) (last comments: GH 49d ago, Zulip none)
  -  "Accept `pc` in place of `unknown` and `unknown` in place of `pc` for `x86_64` and `i?86` targets" [compiler-team#441](https://github.com/rust-lang/compiler-team/issues/441) (last comments: GH 48d ago, Zulip 59d ago)
  -  "Non exhaustive reachable patterns lint" [compiler-team#445](https://github.com/rust-lang/compiler-team/issues/445) (last comments: GH 28d ago, Zulip 20d ago)
  -  "Make `resolve_instance` fallible" [compiler-team#449](https://github.com/rust-lang/compiler-team/issues/449) (last comments: GH 18d ago, Zulip none)
  -  "Add `TyKind::Const` and remove `GenericArgKind::Const`" [compiler-team#453](https://github.com/rust-lang/compiler-team/issues/453) (last comment: GH none, Zulip yesterday)
- Pending FCP requests (check your boxes!)
  -  "Reproducible command line + determinism" [compiler-team#450](https://github.com/rust-lang/compiler-team/issues/450)
  -  "Write text output files to stdout if options like `-o -` or `--emit asm=-` are provided" [compiler-team#431](https://github.com/rust-lang/compiler-team/issues/431)
  -  "Extend `-Cdebuginfo` with new options and named aliases" [rust#83947](https://github.com/rust-lang/rust/pull/83947)
- Things in FCP (make sure you're good with it)
  -  "Make AST->HIR lowering incremental" [compiler-team#452](https://github.com/rust-lang/compiler-team/issues/452)
- Accepted MCPs
  -  "Rename various internal things" [compiler-team#451](https://github.com/rust-lang/compiler-team/issues/451)
- Finalized FCPs (disposition merge)
  - No new finished FCP (disposition merge) this time.

### WG checkins

@*WG-self-profile* by @**mw** @**Wesley Wiser** ([previous checkin](https://hackmd.io/tuLB5d6ETKCZGS3cpzzRiA#WG-checkins))
> @rylev and @**mw** are slowly working towards being able to record non-timestamp data like the sizes of files that the compiler emits -- e.g. object files and incr. comp. on-disk data. @**Wesley Wiser** is doing the reviewing. We should have something to show by the next checkin :)

## Backport nominations

[T-compiler stable](https://github.com/rust-lang/rust/issues?q=is%3Aall+label%3Abeta-nominated+-label%3Abeta-accepted+label%3AT-compiler) / [T-compiler beta](https://github.com/rust-lang/rust/issues?q=is%3Aall+label%3Astable-nominated+-label%3Astable-accepted+label%3AT-compiler)
- :beta: "Always preserve sub-obligations in the projection cache" [rust#85868](https://github.com/rust-lang/rust/pull/85868)
  - @**pnkfelix** self-assigned to find another reviewer
  - feedback from @Jack Huey on it to @Aaron Hill. But Jack also said they would not be comfortable reviewing without at least some support from e.g. @nikomatsakis (perhaps during one of Niko's office times)
- No stable nominations for `T-compiler` this time.

[T-rustdoc stable](https://github.com/rust-lang/rust/issues?q=is%3Aall+label%3Abeta-nominated+-label%3Abeta-accepted+label%3AT-rustdoc) / [T-rustdoc beta](https://github.com/rust-lang/rust/issues?q=is%3Aall+label%3Astable-nominated+-label%3Astable-accepted+label%3AT-rustdoc)
- No backport nominations for `T-rustdoc` this time.

:back: / :shrug: / :hand:

## PRs S-waiting-on-team

[T-compiler](https://github.com/rust-lang/rust/pulls?utf8=%E2%9C%93&q=is%3Aopen+label%3AS-waiting-on-team+label%3AT-compiler)
- "Extend `-Cdebuginfo` with new options and named aliases" [rust#83947](https://github.com/rust-lang/rust/pull/83947)
  - opened by @**Julia Tatz**
  - assigned and reviewed by @**nagisa** and @**Vadim Petrochenkov**
  - discussed [last week](https://rust-lang.zulipchat.com/#narrow/stream/238009-t-compiler.2Fmeetings/topic/.5Bweekly.5D.202021-08-12.20.2354818/near/249241832)
  - [decided to pass this through an FCP](https://rust-lang.zulipchat.com/#narrow/stream/238009-t-compiler.2Fmeetings/topic/.5Bweekly.5D.202021-08-12.20.2354818/near/249242280) but author didn't respond
- "Encode spans relative to the enclosing item" [rust#84373](https://github.com/rust-lang/rust/pull/84373)
  - opened by @**cjgillot**
  - assigned to @**Vadim Petrochenkov**
  - pending wg-incr-comp discussion
- "Remove all json handling from rustc_serialize" [rust#85993](https://github.com/rust-lang/rust/pull/85993)
  - discussed [last week](https://rust-lang.zulipchat.com/#narrow/stream/238009-t-compiler.2Fmeetings/topic/.5Bweekly.5D.202021-08-12.20.2354818/near/249240458), we'd like to have @**Vadim Petrochenkov** and @**cjgillot** in the loop

## Issues of Note

### Short Summary

- [1 T-compiler P-critical issues](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3AT-compiler+label%3AP-critical)
  - [1 of those are unassigned](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3AT-compiler
+label%3AP-critical+no%3Aassignee)
- [83 T-compiler P-high issues](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3AT-compiler+label%3AP-high)
  - [56 of those are unassigned](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3AT-compiler+label%3AP-high+no%3Aassignee)
- [1 P-critical, 2 P-high, 0 P-medium, 0 P-low regression-from-stable-to-beta](https://github.com/rust-lang/rust/labels/regression-from-stable-to-beta)
- [0 P-critical, 1 P-high, 1 P-medium, 2 P-low regression-from-stable-to-nightly](https://github.com/rust-lang/rust/labels/regression-from-stable-to-nightly)
- [1 P-critical, 49 P-high, 81 P-medium, 9 P-low regression-from-stable-to-stable](https://github.com/rust-lang/rust/labels/regression-from-stable-to-stable)

### P-critical

[T-compiler](https://github.com/rust-lang/rust/issues?utf8=%E2%9C%93&q=is%3Aopen+label%3AP-critical+label%3AT-compiler)
- "LLVM crash: Basic Block does not have terminator!" [rust#88043](https://github.com/rust-lang/rust/issues/88043)
  - opened by @**David Tolnay**
  - seems caused by [rust#83417](https://github.com/rust-lang/rust/pull/83417) cc: @**oli**, suggests a quick revert and then look at this again without pressure
  - @**david tolnay** also [points out](https://github.com/rust-lang/rust/issues/88043#issuecomment-900517377) relation with [rust#88043](https://github.com/rust-lang/rust/issues/88043#issuecomment-900517377)

[T-rustdoc](https://github.com/rust-lang/rust/issues?utf8=%E2%9C%93&q=is%3Aopen+label%3AP-critical+label%3AT-rustdoc)
- No `P-critical` issues for `T-rustdoc` this time.

### P-high regressions

[P-high beta regressions](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3Aregression-from-stable-to-beta+label%3AP-high+-label%3AT-infra+-label%3AT-libs+-label%3AT-release+-label%3AT-rustdoc+-label%3AT-core)
- "ICE: unexpected concrete region in borrowck: ReStatic" [rust#87455](https://github.com/rust-lang/rust/issues/87455)
  - regression in crate run for 1.55, manifested in a [couple of issues](https://github.com/rust-lang/rust/issues/87455#issuecomment-897891685)
  - @**pnkfelix** self-assigned to backport [rust#87843](https://github.com/rust-lang/rust/pull/87483)
- "ICE: unexpected concrete region in borrowck: ReEarlyBound(0, 'a)" [rust#83190](https://github.com/rust-lang/rust/issues/83190)
  - assigned same `P-high` as sibling [rust#87455](https://github.com/rust-lang/rust/issues/87455) :point_up_2:

[Unassigned P-high nightly regressions](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3Aregression-from-stable-to-nightly+label%3AP-high+no%3Aassignee+-label%3AT-infra+-label%3AT-release+-label%3AT-rustdoc+-label%3AT-core)
- No unassigned `P-high` nightly regressions this time.

## Performance logs

> [triage logs for 2021-08-17](https://github.com/rust-lang/rustc-perf/blob/master/triage/2021-08-17.md)

A fairly busy week which was to expected given that we've [adjusted our algorithm](https://github.com/rust-lang/rustc-perf/pull/956) for whether we label a change as a regression or not. Most regressions were relatively small, and only one has not yet been addressed in some way.

Triage done by **@rylev**.
Revision range: [6b20506d17f4e5e5bf5bcad7e94add4d754b0ae3..aa8f27bf4d980023a8b245ceb25a490a18041eb2](https://perf.rust-lang.org/?start=6b20506d17f4e5e5bf5bcad7e94add4d754b0ae3&end=aa8f27bf4d980023a8b245ceb25a490a18041eb2&absolute=false&stat=instructions%3Au)
59 comparisons made in total

3 Regressions, 2 Improvements, 2 Mixed; 0 of them in rollups

#### Regressions

encode `generics_of` for fields and ty params [#87815](https://github.com/rust-lang/rust/issues/87815)
- Moderate regression in [instruction counts](https://perf.rust-lang.org/compare.html?start=2d10c2a3302d53e10a4ad3ac581103faaae9eeb6&end=c4c2986c499ee9440b7ae23bf5a62c6168e1ce17&stat=instructions:u) (up to 1.2% on `incr-unchanged` builds of `diesel`)
- While the regressions are fairly small, the largest ones seem to be happening in real-world crates like diesel, serde, and futures.
- The largest regressions seem to be in the `explicit_predicates_of` query which would seem to be directly impacted by this change.
- Left a [comment](https://github.com/rust-lang/rust/pull/87815#issuecomment-900465263) to see how we should address this issue.

Various refactorings of the TAIT infrastructure [#87587](https://github.com/rust-lang/rust/issues/87587)
- Moderate regression in [instruction counts](https://perf.rust-lang.org/compare.html?start=47b41b7788a6f85c749049062f1e4eed497cd894&end=d488de82f30fd1dcb0220d57498638596622394e&stat=instructions:u) (up to 1.5% on `full` builds of `inflate`)
- The issue is [expected](https://github.com/rust-lang/rust/pull/87587#issuecomment-896754235) and is being monitored with a possible solution in the works.

Name the captured upvars for closures/generators in debuginfo [#85020](https://github.com/rust-lang/rust/issues/85020)
- Large regression in [instruction counts](https://perf.rust-lang.org/compare.html?start=c6094fc7b9981d755abeb8c0e866a0f6315b3ec3&end=99efc51dae1dbe9d741707a7ddef84c29e654df5&stat=instructions:u) (up to 4.9% on `incr-patched: println` builds of `webrender-wrench`)
- This is a large regression in one benchmark, but it seems to be in codegen which this change would impact.
- [There is a comment](https://github.com/rust-lang/rust/pull/85020#issuecomment-898823772) justifying this as concerning but worth it given it only impacts one benchmark. I still believe this might be one worth keeping an eye on.

#### Improvements

- Avoid using the `copy_nonoverlapping` wrapper through `mem::replace`. [#87827](https://github.com/rust-lang/rust/issues/87827)
- Run RemoveZsts pass at mir-opt-level=1 [#83417](https://github.com/rust-lang/rust/issues/83417)

#### Mixed

Introduce `hir::ExprKind::Let` - Take 2 [#80357](https://github.com/rust-lang/rust/issues/80357)
- Large improvement in [instruction counts](https://perf.rust-lang.org/compare.html?start=2bd17c1d43bba43412cc2f051323a279d6751e43&end=2a6fb9a4c0e5ca7a81999065943b211c226fe9d8&stat=instructions:u) (up to -2.1% on `incr-patched: println` builds of `webrender`)
- Moderate regression in [instruction counts](https://perf.rust-lang.org/compare.html?start=2bd17c1d43bba43412cc2f051323a279d6751e43&end=2a6fb9a4c0e5ca7a81999065943b211c226fe9d8&stat=instructions:u) (up to 0.7% on `full` builds of `cranelift-codegen`)

BTree: merge the complication introduced by #81486 and #86031 [#87696](https://github.com/rust-lang/rust/issues/87696)
- Small improvement in [instruction counts](https://perf.rust-lang.org/compare.html?start=2a6fb9a4c0e5ca7a81999065943b211c226fe9d8&end=23461b210f1b0a121592a18fc4fb666106006668&stat=instructions:u) (up to -0.6% on `full` builds of `issue-46449`)
- Moderate regression in [instruction counts](https://perf.rust-lang.org/compare.html?start=2a6fb9a4c0e5ca7a81999065943b211c226fe9d8&end=23461b210f1b0a121592a18fc4fb666106006668&stat=instructions:u) (up to 1.7% on `full` builds of `ripgrep`)
- This is mostly a wash in terms of performance (with performance shifting somewhat equally across all the benchmarks), with the largest changes happening in stress tests.

#### Untriaged Pull Requests

- [#87640 Rollup of 9 pull requests](https://github.com/rust-lang/rust/pull/87640)
- [#87587 Various refactorings of the TAIT infrastructure](https://github.com/rust-lang/rust/pull/87587)
- [#87244 Better diagnostics with mismatched types due to implicit static lifetime](https://github.com/rust-lang/rust/pull/87244)
- [#86777 Include terminators in instance size estimate](https://github.com/rust-lang/rust/pull/86777)
- [#86698 Move OnDiskCache to rustc_query_impl.](https://github.com/rust-lang/rust/pull/86698)
- [#86588 Rollup of 8 pull requests](https://github.com/rust-lang/rust/pull/86588)
- [#86034 Change entry point to shield against exploding payloads](https://github.com/rust-lang/rust/pull/86034)
- [#84560 Inline Iterator as IntoIterator.](https://github.com/rust-lang/rust/pull/84560)

## Nominated Issues

[T-compiler](https://github.com/rust-lang/rust/issues?q=is%3Aopen+label%3AI-nominated+label%3AT-compiler)
- "Remove all json handling from rustc_serialize" [rust#85993](https://github.com/rust-lang/rust/pull/85993)
  - discussed in `S-waiting-on-team`
- "Binary size is significant increased from `1.46.0` to `1.51.0`" [rust#86610](https://github.com/rust-lang/rust/issues/86610)
  - Has action item on [HackMD](https://hackmd.io/5BtjuenFTn6M74IDwLOjgw) to add binary size tracking to perf.rlo, needs an owner

[RFC](https://github.com/rust-lang/rfcs/issues?q=is%3Aopen+label%3AI-nominated+label%3AT-compiler)
- "[RFC2603] Extend `<const>` to include `str` and structural constants." [rfcs#3161](https://github.com/rust-lang/rfcs/pull/3161)
  - discussed [last week](https://rust-lang.zulipchat.com/#narrow/stream/238009-t-compiler.2Fmeetings/topic/.5Bweekly.5D.202021-08-12.20.2354818/near/249243501)
  - @**mw** [suggested](https://rust-lang.zulipchat.com/#narrow/stream/238009-t-compiler.2Fmeetings/topic/.5Bweekly.5D.202021-08-12.20.2354818/near/249247119) to merge the current implementation, not the RFC, and gather real-world data
  - still needs discussion or `I-nominated` can be removed?

repository: rust-lang/compiler-team

path: /content/minutes/triage-meeting/T-compiler Meeting Agenda 2021-08-19.md

filename: T-compiler Meeting Agenda 2021-08-19.md

gha_language: HTML

repo_name: rust-lang/compiler-team


text:
# flutterfly

A collection of common widgets, validators, extensions, utilities, as well as some other stuffs that are currently non-existent in Flutter.

## Getting Started

- Add [flutterfly](https://pub.dev/packages/flutterfly) to your flutter package's pubspec.yaml file :

  ```yaml
  dependencies:
    flutterfly: ^<latest_version>
  ```

## Main Considerations

- Only includes the stuffs that don't exist yet, yet essentially important and is broadly re-used across our projects, hence we expect this library to be `open for extension, but closed for modification`
- Brutally **tested**

## Contents

- **Views**

  - Widget Components
    - URL Image with loading progress
    - Timeline

- **Common**

  - Extensions
    - String Extensions
      - Capitalize
      - ToDateTime
      - Digit Only
      - Ellipsis
      - etc.
    - Num Extensions
      - isBetween(min, max)
    - Map Extensions
      - tryCast
      - hasValue(String key)
      - toList
    - DateTime Extensions
      - Calculate Age
  - Validators
    - String Validator
      - Required
      - Min Length
      - Special Characters
      - Email
      - Valid Date
      - Allow Digits Only
      - Disallow any digits
      - No white space
      - Contains
      - etc.
    - Num Validator
      - Required
      - Positive
      - Greater Than
      - Less Than
      - Between
      - etc.
  - Utils
    - Connection Utils
      - Check Internet Connection

## Documentation

# Validators

Please check out the [Unit Tests](https://github.com/wowsomeco/flutterfly/blob/master/test/validators_test.dart) as well as the [Example](https://github.com/wowsomeco/flutterfly/blob/master/example/lib/home_page.dart)

# Extensions

Please check out the [Unit Tests](https://github.com/wowsomeco/flutterfly/blob/master/test/extensions_test.dart)

Pull requests are welcome :)

## License

**MIT**

repository: wowsomeco/flutterfly

repo_name: wowsomeco/flutterfly


text:
# Challenge 02 - Componentization

## To test this application
  Follow this steps:
  - You need to clone this repository by using this command `git clone https://github.com/mlasa/02challenge-ignite-react-.git`
  - Run `yarn` or `npm i` inside of root path of project.
  - Then, run  `yarn dev` and in your browser acces this link `https://localhost:8080`


text:
# WLODZIMIERZ

[![License](https://img.shields.io/badge/License-Apache%202.0-blue.svg)](https://opensource.org/licenses/Apache-2.0)
[![FOSSA Status](https://app.fossa.com/api/projects/git%2Bgithub.com%2Fliannoi%2Fwlodzimierz.svg?type=shield)](https://app.fossa.com/projects/git%2Bgithub.com%2Fliannoi%2Fwlodzimierz?ref=badge_shield)

The goal of the project is to provide a simple, convenient and cross-platform
messenger for providing textual communication between users.

### Principles, paradigms, practices

This project adheres to the best practices from the entire field of business
application development.

Among them:

- Object Oriented Programming (OOP)
- Object Oriented Design (OOD - SOLID, GRASP)
- GOF design patterns as well as architectural patterns (MVC, MVVM, CQRS)
- Domain-Driven Design (DDD)
- Reactive Programming Paradigm
- Principle of "Clean Architecture"
- Test Driven Development (TDD)

### Architecture

The server-side RESTful Web API is written in .NET Core using the MediatR
library to implement the CQRS design pattern.

The clients are:

- Single-page application (SPA) in Angular
- Native mobile application on Kotlin

## Technologies

> To describe the technologies of this project, it was decided to divide them
into two conditional categories. The first category **Client** refers to
technologies that are related to the clients of the project, and the second
category **Server** refers to technologies that are related to the server-side
RESTful Web API.

### Client:

- Angular 11
- Bootstrap 4.5 (ng-bootstrap)
- RxJS 6

---

- Kotlin 1.4
- Android Jetpack (Hilt, Android Architecture Components)
- SQLite
- RxJava (RxKotlin, RxAndroid, RxBinding)

### Server:

- .NET Core 3.1
- ASP.NET Core Identity 3.1
- Microsoft SQL Server 2019
- Docker
- Entity Framework Core 3.1
- MediatR
- AutoMapper
- SignalR
- Swagger

## Classes and characteristics of users

| User class      | Description                                                                                |
|-----------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| **Guest**       | Any non-authenticated user of the application.                                                                                |
| **User**        | Authenticated user an application that is provided with a list of conversations and groups in which he is a member, as well as a list of contacts available for sending messages. |
| **Group Admin** | An authenticated user of the application who is the administrator of a specific group. Initially, the user who created the group is considered its administrator.                 |

## Database diagram

![](https://github.com/liannoi/wlodzimierz/blob/main/database/wlodzimierz-diagram.png)

## License

This repository is licensed under [Apache-2.0](https://github.com/liannoi/wlodzimierz/blob/main/LICENSE).

```
Copyright 2020 Maksym Liannoi

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
```

[![FOSSA Status](https://app.fossa.com/api/projects/git%2Bgithub.com%2Fliannoi%2Fwlodzimierz.svg?type=large)](https://app.fossa.com/projects/git%2Bgithub.com%2Fliannoi%2Fwlodzimierz?ref=badge_large)

repository: fossabot/wlodzimierz

repo_name: fossabot/wlodzimierz


text:
---
layout: default
---

# 1995-11-29 - Re: PGP hooks for Pegasus Mail?

## Header Data

From<EMAIL_ADDRESS>(Anonymous)

To<EMAIL_ADDRESS>Message Hash: ce9b59d0f3b49bb918f0ad35defca1db0e2adff3380dfdf611e2ecf4eef38576

Message ID<EMAIL_ADDRESS>Reply To: _N/A_

UTC Datetime: 1995-11-29 02:47:12 UTC

Raw Date: Wed, 29 Nov 1995 10:47:12 +0800

## Raw message

```
{% raw  %}From<EMAIL_ADDRESS>(Anonymous)
Date: Wed, 29 Nov 1995 10:47:12 +0800
To<EMAIL_ADDRESS>Subject: Re: PGP hooks for Pegasus Mail?
Message-ID<EMAIL_ADDRESS>MIME-Version: 1.0
Content-Type: text/plain

----- wake-up rant ON -----

On 28 Nov 95 at 12:16, Lynne L. Harrison wrote:

> At 09:52 AM 11/28/95 +0000, you wrote:
> >Anyone done anything regarding PGP hooks into Pegasus Mail?
> >I'm running it at home now (SLIPped into my Linux box), and
> >I'd like to find a way to integrate PGP into Pegasus Mail.
> >
> >Thanks in advance for any replies...
>
> Ed -
>
>   I haven't heard of anything re: "PGP hooks into Pegasus
> Mail".  At one time, Eudora and ViaCrypt were discussing it
> but, from what I heard, those discussions fizzled out.

>   The easiest way to *integrate* is to use a front end program.

I find it bizarre that what little is going on in real integration of PGP for e-mail users is not mentioned on cp, perhaps unknown, certainly not of interest to those who should be interested.

What is going on is going on with respect to Pegasus, and what mention of it there is is not on cp but on the Pegasus Mail list.

Apparently cypherpunks *don't* write code, and PMail people *do*.

Do a million registered users and an e-mail program with hooks already originating outside the U.S. penetrate anyone's consciousness?

----- wake-up rant OFF -----

 ------------ http://www.phoenix.net/~tjunker ------------
| Your freedom is on the auction block.  What do you bid? |
 ---------------------------------------------------------
Unofficial Wang VS Information Center

{% endraw %}
```

## Thread

+ Return to [November 1995](/archive/1995/11)

+ Return to<EMAIL_ADDRESS>(Anonymous)](/authors/nobody_at_replay_com_anonymous_)"

+ 1995-11-29 (Wed, 29 Nov 1995 10:47:12 +0800) - Re: PGP hooks for Pegasus Mail? -<EMAIL_ADDRESS>(Anonymous)_