Event Location:
Rochester Institute of Technology
1 Lomb Memorial Drive
Rochester, New York
Abstract:
Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you! We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery. If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.
Speaker(s): Adam Belebczuk,
Abstract:
Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now? The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
Speaker(s): David Klee,
Abstract:
It's estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards. In this session, Chris will introduce you to the world of BIML and how it can change your world. We'll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won't want to miss this session!
Speaker(s): Chris Schmidt,
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data? You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries? Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would. *Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
Speaker(s): Chris Bell,
Abstract:
Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker(s): Janis Griffin,
Abstract:
Abstract: You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice. This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up. Topics are focused on data storage structures, security, and integrity. After this presentation, will be ready to meet that clients need. Coverage: 1 - Files File Groups 2 - Logins Users 3 - Security using schemas 4 - Database roles for access. 5 - Table design via SSMS or TSQL. 6 - Default, Check, and NULL constraints 7 - Handling table relationships (PK vs FK). 8 - To index or not to index? 9 - Testing database integrity using DML.
Speaker(s): John Miner,
Abstract:
Abstract: Are you tired of installing, configuring and patching Microsoft SQL Server? Microsoft Azure SQL database maybe a way to move some of your infrastructure to the cloud. Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments. The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions. Coverage: 1 - The Azure Portal 2 - Identifying your database server 3 - Adding IP Rules for clients 4 - Capturing a connection string 5 - Using SSMS and/or SQLCMD for development 6 - Creating a database from TSQL 7 - Executing CRUD statements 8 - Migrating old database using wizard 9 - What SQL Azure database still lacks.
Speaker(s): John Miner,
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. Session Goals: • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. • Learn how to configure a working replication topology • Learn how to how to monitor transactional replication performance
Speaker(s): Kendal Van Dyke,
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies. Session Goals: • Learn how to baseline performance metrics by gleaning information from the distribution database • Show how to tune replication agent performance with agent profiles • Demonstrate advanced troubleshooting techniques to apply when problems occur
Speaker(s): Kendal Van Dyke,
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.
Speaker(s): William E Pearson III,
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s): William E Pearson III,
Abstract:
SQL Server 2014 will have a number of new features to help with specific situations in OLTP and OLAP queries. In-Memory tables and queries, SSD Buffer Pool, Columnstore Indexing, and AlwaysOn Improvements will be covered
Speaker(s): George Walters,
Abstract:
In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
Speaker(s): Brian Benzel,
Abstract:
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s): Kathi Kellenberger,
Abstract:
You just restarted SQL Server, but some of your databases aren't coming online. Maybe you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session we'll cover the various states that a database can be in, how they get into those states, and learn the proper techniques to bring your data safely back online.
Speaker(s): David Maxwell,
Abstract:
People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals. This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.
Speaker(s): David Klee,
Abstract:
You may understand what a data warehouse is, but what is big data? And why should I care about it? How will it help me? I’ll talk about the things to look at to understand if you have big data, and cover those buzz words you may have heard but don’t know what they mean (data scientist, Hadoop, Internet of Things, data lake, modern data warehouse). I’ll also give examples of how big data is making companies make better business decisions.
Speaker(s): James Serra,
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing.
Speaker(s): Janis Griffin,
Abstract:
Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s): David Maxwell,
Abstract:
So you got a handle on what Big Data is and how you can use it to find business value in your data. Now you need an understanding of the Microsoft products that can be used to create a Big Data solution. Microsoft has many pieces of the puzzle and in this presentation I will show how they fit together. How does Microsoft enhance and add value to Big Data? From collecting data, transforming it, storing it, to visualizing it, I will show you Microsoft’s solutions for every step of the way.
Speaker(s): James Serra,
Abstract:
In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases. Unfortunately, that's an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, extended events, and even SQL Audit.
Speaker(s): Colleen Morrow,
Abstract:
Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.
Speaker(s): Kathi Kellenberger,
Abstract:
One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
Speaker(s): Adam Belebczuk,
Abstract:
In 2014, CareerBliss.com and Forbes Magazine ranked Database Administrator as the #1 happiest job. But what exactly does a DBA do? How does someone become a DBA? And why are they so darned happy? In this session we'll explore the different types of DBA, their roles and responsibilities, and the career path for database professionals. Whether you're just starting your career and trying to find your footing, or you're a seasoned veteran wondering where to go from here, this session will show you the possibilities.
Speaker(s): Colleen Morrow,
Abstract:
Do you have users complaining that applications are running "too slow"?  This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
Speaker(s): Edward Pollack,
Abstract:
SQL Server 2014 is all about in-memory. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: columnar storage, in-memory tables and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.
Speaker(s): Markus Ehrenmueller-Jensen,
Abstract:
Join Thomas in an almost Powerpoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate it into multiple database projects with a few mouse clicks. He will also share Tips and Tricks for using Visual Studio more effective.
Speaker(s): Thomas Grohser,
Abstract:
Imagine a world in that end-user can collect data from your data warehouse, from operational databases, flat files, excel files and even external data sources like a web page or a data market. Imagine that those users can cleanse the data by themselves, manage calculations, and refresh the data through a tool they are already familiar with. Imagine that they also can build nice and crisp interactive reports (tables, charts maps) by just a few mouse clicks or by natural language.
Speaker(s): Markus Ehrenmueller-Jensen,
Abstract:
How SQL Server performs I/O How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Speaker(s): Thomas Grohser,
Abstract:
Dynamic Management Views are a beautiful gift from Microsoft. With them you can gather immense amounts of information about your SQL environment, optimize performance issues, and solve problems you didn't even know you had! We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
Speaker(s): Edward Pollack,
Abstract:
Integration services is a powerful tool for visualizing and handling most of your SQL Server ETL needs. But Business Intelligence Development Studio (BIDS) can be a confusing tool the first time that you start the application. There's a LOT going on, and for the first time developer, it's not very clear how to get started. This session will help get you on your feet developing SSIS packages. We will look at some common scenarios and live demo creating your first SSIS packages to copy data from one server to another, extract data to a flat file, and learn how to solve some common errors. Feel free to bring your questions on getting started with BIDS.
Speaker(s): Matt Nelson,
Abstract:
In this session, we will do a short introduction to the In-Memory OLTP feature before diving straight into the use cases where the new lockless/latchless concurrency control and native compilation really shines. Demos will cover PAGELATCH contention, use of In-Memory for ETL and In-Memory tables as 'shock absorbers' for high throughput environments. For each case we will do a comparison of "Classic" vrs In-Memory, what gains can the audience expect and what patterns will yield the biggest benefits.
Speaker(s): Warner Chaves,
Abstract:
Need HA and DR? Tired of Mirroring or Log Shipping restrictions? Reporting queries slowing down your production system? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.
Speaker(s): George Walters,
Abstract:
You've been hearing about Windows PowerShell, but you're wondering if it's something you should be working with. Or maybe you’re just looking for a way to make those boring, repetetive chores take care of themselves. In this introductory session, we'll talk about what PowerShell is, how to use it, and where it’s going. Whether you're a junior DBA or seasoned veteran, you'll find ways that PowerShell can make your life easier.
Speaker(s): Andy Levy,
Abstract:
Have you ever scratched your head trying to figure out what is causing performance issues in your SQL Server databases? In this session, we will look at uncovering your SQL Server’s performance issues by learning about wait statistics. We will look at SQL Server wait statistics and how we can troubleshoot performance problems using this methodology – from finding the root cause to resolving the issues.
Speaker(s): Edwin M Sarmiento,
Abstract:
As part of Microsoft's aggressive cloud strategy, the SQL Database as a service has been getting new releases and new features at a rapid pace. The biggest change so far has been the introduction of three service tiers: Basic, Standard and Premium. Gone is the pay for database size system and it has been replaced by a system where we also pay for the performance characteristics and recovery features of our database. Come learn the differences between the tiers, measuring performance and how to optimize the use of your cloud SQL power.
Speaker(s): Warner Chaves,
Abstract:
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker(s): Kevin Feasel,
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
Speaker(s): Chris Bell,
Abstract:
Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
Speaker(s): Kevin Feasel,
Abstract:
Do you think you can handle Failover Clustering and Availability Groups? Think again. Your job description as a SQL Server DBA has just changed. In this demo-centric session, you’ll see how networking aspects such as Active Directory and DNS play very important roles when implementing a SQL Server high availability and disaster recovery (HA/DR) solution. You will want to be confident enough to have a conversation with your Domain Administrator to make sure your SQL Server databases meet their recovery objectives and service level agreements.
Speaker(s): Edwin M Sarmiento,
Abstract:
Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
Speaker(s): Steve Hood,
Abstract:
After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with *today's* date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.
Speaker(s): Matt Nelson,
Abstract:
Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.
Speaker(s): Mike Hays,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/pub/matt-slocum/5/251/709
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable...I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting. I also love space, technology Japanese culture.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
LinkedIn: https://www.linkedin.com/company/1319388
Contact: http://us.sios.com/blog/
SIOS Technology Corp. makes software products that protect data and applications from downtime, while eliminating complexity, and reducing labor costs. SIOS products make clusters in both SAN and #SANLess environments easy to use and easy to own. By removing the configuration limitations of traditional clusters, SIOS products give enterprise data managers the freedom to run applications in the environment that best meets their needs -- physical, virtual, cloud or any combination thereof.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: https://www.linkedin.com/in/georgewalters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions. A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases. Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
LinkedIn: https://www.linkedin.com/in/davidmmaxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
LinkedIn: http://www.linkedin.com/in/stevehoodsql
Contact: http://simplesqlserver.com
I#39;m a DBA who has gone through most of my career with few people to learn and unsure of where to find great help until I found a real mentor. When I started at a company with a great, knowledgeable manager and learned to find others speaking about SQL Server online my skills boomed. This is especially true in my most passionate area, SQL Server performance. Knowing that my knowledge came from others, I now have a second passion of sharing my knowledge with others.
LinkedIn: https://www.linkedin.com/in/davidmmaxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
LinkedIn: https://www.linkedin.com/in/kimberly-stjacques
Contact: http://dbobserver.com
Kim StJacques is passionate about SQL Server and Community. She has worked in IT for 20+ years and 15 of those years working with SQL Server. Kim's experience as a DBA spans multiple database platforms, however, SQL Server is her passion. Kim is also an avid volunteer in the SQL Server community! She has served as a SQLSaturday organizer/volunteer/speaker, PASS Summit Program Committee, PASS Summit Ambassador, and PASS Summit buddy for first timers. As a recent empty nester, Kim has developed a thirst for learning new things such as Ansible and Docker, however, she still finds time for a few Overwatch matches and a splash of Netflix.
LinkedIn: http://www.linkedin.com/pub/matt-slocum/5/251/709
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable...I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting. I also love space, technology Japanese culture.
Contact: http://www.craftydba.com
John has twenty-five years of data processing and project management experience. His expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance of systems. He is currently a Senior Consultant at Atrion Networking Corporation providing customers with Database and Business Intelligence solutions. When he is not busy at PASS events, he spends time with his wife and daughter enjoying outdoor activities.
LinkedIn: https://www.linkedin.com/in/thomasgrohser/
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
LinkedIn: http://www.linkedin.com/pub/matt-slocum/5/251/709
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable...I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting. I also love space, technology Japanese culture.
LinkedIn: https://www.linkedin.com/in/mattpgh
Contact: http://wwww.nelsonsweb.net
Matt Nelson is a Database Administrator and Business Intelligence developer for RDX (Remote DBA Experts) in Pittsburgh, PA. With over 10 years of experience, He works with more than 200 clients on general database administration needs and BI projects. Matt is also the Chapter Leader of the Pittsburgh SQL Server Users Group, and an organizer of Pittsburgh SQLSaturday. He occasionally blogs at www.nelsonsweb.net and http://www.rdx.com/Blog/
LinkedIn: http://ca.linkedin.com/in/warnerchaves/
Contact: http://sqlturbo.com
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.
LinkedIn: http://www.linkedin.com/pub/matt-slocum/5/251/709
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable...I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting. I also love space, technology Japanese culture.
LinkedIn: https://www.linkedin.com/in/minerjohn/
Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/
John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions. He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems. He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX. Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.
LinkedIn: https://www.linkedin.com/in/thomasgrohser/
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
LinkedIn: http://www.linkedin.com/pub/matt-slocum/5/251/709
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable...I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting. I also love space, technology Japanese culture.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: https://www.linkedin.com/in/georgewalters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions. A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases. Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
LinkedIn: https://www.linkedin.com/in/mattpgh
Contact: http://wwww.nelsonsweb.net
Matt Nelson is a Database Administrator and Business Intelligence developer for RDX (Remote DBA Experts) in Pittsburgh, PA. With over 10 years of experience, He works with more than 200 clients on general database administration needs and BI projects. Matt is also the Chapter Leader of the Pittsburgh SQL Server Users Group, and an organizer of Pittsburgh SQLSaturday. He occasionally blogs at www.nelsonsweb.net and http://www.rdx.com/Blog/
LinkedIn: http://ca.linkedin.com/in/warnerchaves/
Contact: http://sqlturbo.com
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.
LinkedIn: https://www.linkedin.com/profile/view?id=81593638
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.
LinkedIn: http://www.linkedin.com/in/JamesSerra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
LinkedIn: https://www.linkedin.com/in/markus-ehrenmueller/
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
LinkedIn: http://ca.linkedin.com/in/edwinmsarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.
LinkedIn: http://www.linkedin.com/in/JamesSerra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
LinkedIn: https://www.linkedin.com/in/markus-ehrenmueller/
Contact: http://www.savorydata.com
Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.
LinkedIn: http://ca.linkedin.com/in/edwinmsarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
LinkedIn: http://linkedin.com/in/alevyinroc
Contact: https://flxsql.com
Andy is a database administrator, PowerShell fan, former developer, Open Source contributor, SQLSaturday organizer and user group leader. He’s worn a number of IT hats since 1999 before landing in database administration, including web server administration and development, systems integration, and database development. When he isn’t picking queries apart and wrangling an unruly herd of databases, he can be found helping out with his son’s Boy Scout troop, making BBQ ribs for his daughter, or planning the next family vacation with his wife.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
LinkedIn: https://www.linkedin.com/in/mike-hays-21097419
Contact: http://www.thesqlreport.com/
Mike has been working with Microsoft SQL Server for the last twenty years. Currently working as a Database Administrator for a diversified energy company, he has also worked in the retail, manufacturing, banking sectors. He holds a Master’s degree in Computer Information Science from Cleveland State University.
LinkedIn: http://www.linkedin.com/in/itacb
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Brian is Regional Sales Director responsible for driving sales and onboarding new customers in PA, NJ, NY, DE, MD, and DC for Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold ISV Partner providing solutions built on MDS. Brian was formerly with Microsoft Corporation as a Senior Account Manager for 7 years.
LinkedIn: https://www.linkedin.com/in/christophermschmidt
Contact: http://intelligentsql.wordpress.com/
Chris Schmidt is a data architect with Centric Consulting and has experience designing business intelligence solutions for a wide variety of companies in multiple industries. He is very passionate about the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS.
LinkedIn: http://www.linkedin.com/pub/colleen-morrow/2a/95a/651/
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
LinkedIn: http://www.linkedin.com/pub/colleen-morrow/2a/95a/651/
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
LinkedIn: https://www.linkedin.com/profile/view?id=81593638
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
LinkedIn: http://www.linkedin.com/in/itacb
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
The following is a list of sponsors that helped fund the event.
Rochester Institute of Technology


Wolofal
Wolofal - Arabic script QWERTY keyboard designed for the Wolof language of Senegal.
© 2022 SIM


I am an individual with a hard work ethic , a well rounded skillset and a wide range of enterprising skills. I have previously worked in the IT industry and would like to prosper and pursue within the industry I have a high amount of passion for. I have always had a passion for technology and since the age of 14 I have taught myself several programming languages through looking at online material and reading books and have developed simple programs that I have used to test my programming and coding skills.
I have also worked with 3d visual graphics and have created 3d models and short basic test animations within Autodesk Maya and 3ds max. I was inspired by Architecture of buildings and designed and rendered my own concepts within multiple 3d design programs. I then used these 3d models along with my coding and programming skills to develop short demo games within the Unreal development kit (UDK). This then inspired me to look into the app development market and particulary the gaming app market. In which I had researched and constructed analytical data in order to inspire ideas for future apps , websites and software.
I have an even logical and creative balance and therefore I can easily imagine and envision a project or task aswell as using the logical and practical thinking on order to achieve the vision or task at hand. I have taken a particular liking to business within the tech industry over the years and would like to build my own company from the ground up. I always aim for something out of my comfort zone as it pushes me to succeed more knowing it is a challenge and therefore I give even more dedication and comittment to the project or task that I am working on.
Overall I believe that whatever you're doing that you love isn't really
work , it's just fun and something that brings you joy and fulfilment.


These notes are intended for speakers
Accommodations
Department of Statistics will arrange your lodging. Please send an email to Ms. Allison Stone at<EMAIL_ADDRESS>with your desired dates of reservation and Rita will book you a hotel room in Palo Alto.
Instruction for reimbursement
Please make sure you review reimbursement policies before you arrange your trip. To be reimbursed, you should submit receipts to Ms. Nicole Cobb at<EMAIL_ADDRESS>We recommend that you also inform STATS285 team by carbon copying our email<EMAIL_ADDRESS>while submitting your reimbursement request.
Reimbursement policies
To make sure that you will receive the maximum allowable reimbursement for your travel expenses, please review the following policies before you make arrangements. Any questions or concerns regarding these policies should be directed to Ms. Nicole Cobb at<EMAIL_ADDRESS>- Airfare
Travelers can be reimbursed for coach/ economy air travel, with the exception that international travelers on flights of 8 hours or more can be reimbursed for business class. It must be the lowest available airfare that meets the traveler’s choices determined by the following criteria:- The route between origin and destination is the most direct and frequently traveled (i.e., no circuitous routing).
- May be a nonstop flight if requested by the traveler.
- Does not require stays beyond the traveler’s requested dates of travel.
If you choose to fly a higher class of service than economy (or business class for international flights over 8 hours), you need to save proof of the lowest economy fare or lowest business class fare for international flights over 8 hours for the same route (screenshot of lowest available fares AT THE TIME of BOOKING). Stanford will reimburse the documented comparison economy fare or comparison business class fare for international flights over 8 hours, and the traveler will be responsible for the balance.
If a portion of your travel is personal, and you then will fly a different route, you need to save proof of lowest airfare for the direct route (screenshot of lowest available fares at time of booking). Stanford will then reimburse the lower of the actual airfare for the route flown or the documented lowest available fare for the direct route.
- Meals
Stanford pays for reasonably priced and necessary meals during travel. Itemized receipts are required for meal reimbursement. Alcohol is not reimbursable.


{% include 'bs3/dashboard/panels/recent_clients_panel.html' %}
{% include 'bs3/dashboard/panels/testing_services_panel.html' %}
{% include 'bs3/dashboard/panels/expired_services_panel.html' %}
{% include 'bs3/dashboard/panels/birthdays_panel.html' %}
{% include 'bs3/dashboard/panels/calls_panel.html' %}
{% include 'bs3/dashboard/panels/maintenance_panel.html' %}
{% include 'bs3/dashboard/panels/spy_panel.html' %}


Hello friend! Me think you no accept cookie policy yet.
Me think you should check box.


Dominican Spaghetti
- ⏲ Prep time: 10 min
- 🍳 Cook time: 25 min
- 🍽 Servings: 4
Ingredients
- 1 box Spaghetti
- 1 Onion minced
- 1 Green Pepper minced
- 2 Garlic cloves minced
- 1 tbsp Chicken Bouillon Cube or Adobo
- 1 tbsp sazón
- 1 tbsp Tomato Paste
- 1 cup Tomato Sauce
- 1 tbsp Butter
- ¼ cup Evaporated Milk
- 2 tbsp Green Olives
- 1 tsp Sugar
- 1 cup Starchy Pasta Water
Directions
- Boil spaghetti.
- In a separate pan, Sauté onions, peppers, and garlic until soft.
- Add seasonings and black pepper to taste. Mix until well combined.
- Add tomato paste, sauce, and the pasta water. Mix and let it come to a simmer. Simmer for 5 minutes.
- Add evaporated milk, butter, sugar, and olives.
- Taste for seasoning and heat to desired temperature.
- Add spaghetti and toss into the sauce.
Contribution
Recipe tags:
pasta
supper
dominican
cheesefare


Here is an example of the most basic usage of the socket module. It connects to a port and prints out the response.
script.py
#!/user/bin/env python
# Importing the socket module
import socket
# We use the socker() method of the module socket and store it in the variable s.
s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
# Here we use the connect method of the socket we created.
s.connect(("<IP_ADDRESS>", 22))
# Here we save what the socket reviewed in the variable answer.
answer = s.recv(1024)
print answer
# Send stuff. REMEMBER THE \r\n
s.send("this is my message\r\n")
print s.recv(1024)
# Here we close the socket.
s.close


Plot of the Statistical Parameters of orientation data:
The settings of the menus 'Confidence', 'Projection', 'Symbols'‚
and 'Colours' are saved in Fabric7.ini. The settings can be changed in
this form.
The menu 'Diagram' contains options to save
the plot (within the rectangular frame) as a bitmap, and options to
combine the drawn plot with a plot produced with another Fabric7
program. The options 'plot with a printer', 'plot into a HPGL file', and 'plot into a DXF file' produce a vector plot.
These options open a panel (on the right side) in which the plot
parameters can be set. These parameters are saved in Fabric7.ini. Further options concern the 'colour of the periphery', the 'colour of the diagram', the 'colour of the frame', and the 'colour of the background'.
The option ‚Printer' prints the plot as a
bitmap
The following parameters are calculated and presented graphically:
For the calculation of the probability parameters a probability interval (Confidence) must be set.
The data list and the table of statistical parameters can be printed with the menu 'print list'.
The statistics of orientation data is presented in Wallbrecher (1986).


A seat is a group of keyboards, pointer and touch devices.
More...
A seat is a group of keyboards, pointer and touch devices.
This object is published as a global during start up, or when such a device is hot plugged. A seat typically has a pointer and maintains a keyboard focus and a pointer focus.
◆ WL_SEAT_CAPABILITIES_SINCE_VERSION
| #define WL_SEAT_CAPABILITIES_SINCE_VERSION 1 |
◆ WL_SEAT_GET_KEYBOARD_SINCE_VERSION
| #define WL_SEAT_GET_KEYBOARD_SINCE_VERSION 1 |
◆ WL_SEAT_GET_POINTER_SINCE_VERSION
| #define WL_SEAT_GET_POINTER_SINCE_VERSION 1 |
◆ WL_SEAT_GET_TOUCH_SINCE_VERSION
| #define WL_SEAT_GET_TOUCH_SINCE_VERSION 1 |
◆ WL_SEAT_NAME_SINCE_VERSION
| #define WL_SEAT_NAME_SINCE_VERSION 2 |
◆ WL_SEAT_RELEASE_SINCE_VERSION
| #define WL_SEAT_RELEASE_SINCE_VERSION 5 |
◆ wl_seat_capability
seat capability bitmask
This is a bitmask of capabilities this seat has; if a member is set, then it is present on the seat.
| Enumerator |
|---|
| WL_SEAT_CAPABILITY_POINTER | the seat has pointer devices
|
| WL_SEAT_CAPABILITY_KEYBOARD | the seat has one or more keyboards
|
| WL_SEAT_CAPABILITY_TOUCH | the seat has touch devices
|
◆ wl_seat_send_capabilities()
| static void wl_seat_send_capabilities |
( |
struct wl_resource * |
resource_, |
|
|
uint32_t |
capabilities |
|
) |
| |
|
inlinestatic |
Sends an capabilities event to the client owning the resource.
- Parameters
-
| resource_ | The client's resource |
| capabilities | capabilities of the seat |
◆ wl_seat_send_name()
| static void wl_seat_send_name |
( |
struct wl_resource * |
resource_, |
|
|
const char * |
name |
|
) |
| |
|
inlinestatic |
Sends an name event to the client owning the resource.
- Parameters
-
| resource_ | The client's resource |
| name | seat identifier |


JQUERY NUMBER ANIMATION
jQuery counter to count up to a target number
SomeText GoesHere
SomeText GoesHere
SomeText GoesHere
SomeText GoesHere


I’ve been run in to this kind of problem recently: one day I found out a solution written in python multi-thread approach take more running time than single thread. This is really confusing. I decided to dive into that…and some interesting stuff were found out.
Note that my computer is multi-core processor cpu. i7 2.3Ghz QuardCore CPU, 16G DDR3 Memory. With SSD Hard Drive.
Essentially every thing starts from this little piece of code recursively solving a permutation problem
1 2 3 4 5 6 7 8 9 10 11 12 13 |
|
Below are how it was wroted in single thread, multi-thread and multi-process. Along with the running time.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
|
Also, I simply increased the task from 10 digit array to 12 digit array, this takes roughly 1 min for the node to solve the problem. so the new result is this: single thread: 50 sec; multi-thread: 72 sec. I also tried implement it using multi-process. surprisingly multi-process cut the time in half. so the basically result is:
single thread RUNTIME T multi-thread RUNTIME T multi-process RUNTIME T/2
This does not explain why there is no improvement from single thread to multi-threads. therefore I took a snapshot of CPU workload.
Note that even single thread it actually involves all my cpu cores. I’m now suspecting maybe CPython interpreter/optimizer or Intel CPU instruction set is pretty smart to handle even single thread solution to force it run on multiple CPUs.


ETRACS 2x Leveraged ETN Snapshot: October 2019
by Stanford ChemistSummary
- SMHD is the highest yielding 2x ETN, followed by MORL/MRRL and MLPQ.
- 3-month LIBOR continues to fall, relieving pressure on 2x ETN expense ratios.
- HOML has the best 1-year total return.
Note: This article was initially released to members on October 23, 2019.
The ETRACS 2x Leveraged ETN Snapshot presents the latest updates on the news, yields, performance and other data for the ETRACS 2x ETNs, an extremely popular suite of high-yielding vehicles for income investors. This consolidated report is designed to help members evaluate at a glance which of the ETNs may deserve a place in their portfolios. Data are taken from the close of October 22, 2019. Previous articles on the Snapshot can be searched using the keyword "ciletn".
Fund additions, closures, or notable adjustments
None.
The funds
| Fund | Ticker | Inception | Assets / m | Volume / k | Yield | BER | Adjusted TER | 1x fund |
| Equity | ||||||||
| Monthly Pay 2xLeveraged S&P Dividend ETN | (SDYL) | 5/2012 | 16.3 | 1.7 | 5.36% | 0.70% | 1.35% | (SDY) |
| Monthly Pay 2xLeveraged Dow Jones Select Dividend Index ETN | (DVYL) | 5/2012 | 36.0 | 3.7 | 7.58% | 0.75% | 1.38% | (DVY) |
| Monthly Pay 2xLeveraged US High Dividend Low Volatility ETN | (HDLV) | 9/2014 | 19.2 | 4.9 | 10.36% | 1.45% | 1.73% | |
| Monthly Pay 2xLeveraged US Small Cap High Dividend ETN | (SMHD) | 3/2015 | 39.0 | 46.9 | 22.71% | 1.65% | 1.83% | |
| Monthly Pay 2xLeveraged US Small Cap High Dividend ETN Series B | (SMHB) | 11/2018 | 46.5 | 36.7 | - | 1.65% | 1.83% | |
| Monthly Reset 2xLeveraged ISE Exclusively Homebuilders ETN | (HOML) | 3/2015 | 3.3 | 1.3 | 0.00% | 1.65% | 1.83% | |
| Alternative equity | ||||||||
| Monthly Pay 2xLeveraged Wells Fargo MLP Ex-Energy ETN | (LMLP) | 6/2014 | 25.7 | 7.9 | 12.11% | 1.45% | 1.73% | |
| Monthly Pay 2xLeveraged MSCI US REIT Index ETN | (LRET) | 5/2015 | 4.2 | 2.1 | 7.04% | 1.65% | 1.83% | (VNQ) |
| Monthly Pay 2xLeveraged Mortgage REIT ETN | (MORL) | 10/2012 | 392.7 | 263.9 | 21.90% | 0.80% | 1.40% | (MORT) |
| Monthly Pay 2xLeveraged Mortgage REIT ETN Series B | (MRRL) | 10/2015 | 194.7 | 220.5 | 21.90% | 0.80% | 1.40% | (MORT) |
| 2xMonthly Leveraged Alerian MLP Infrastructure Index ETN Series B | (MLPQ) | 2/2016 | 61.7 | 32.9 | 17.83% | 1.65% | 1.83% | (MLPI) (AMLP) |
| 2xMonthly Leveraged S&P MLP Index ETN Series B | (MLPZ) | 2/2016 | 21.7 | 1.6 | 17.64% | 1.95% | 1.98% | (IMLP) |
| 2xLeveraged Long Wells Fargo Business Development Company Index ETN | (BDCL) | 5/2011 | 18.2 | 78.0 | 15.51% | 0.85% | 1.43% | (BDCS) |
| 2xLeveraged Long Wells Fargo Business Development Company Index ETN Series B | (LBDC) | 10/2015 | 5.6 | 0.8 | 15.51% | 0.85% | 1.43% | (BDCS) |
| Balanced | ||||||||
| Monthly Pay 2xLeveraged Closed-End Fund ETN | (CEFL) | 12/2013 | 235.1 | 89.7 | 17.10% | 0.90% | 1.45% | (YYY) |
| Monthly Pay 2xLeveraged Diversified High Income ETN | (DVHL) | 11/2013 | 20.3 | 7.7 | 14.31% | 1.25% | 1.63% | |
| Fixed income | ||||||||
| ETRACS 2xMonthly Pay Leveraged Preferred Stock ETN | (PFFL) | 9/2018 | 29.4 | 16.8 | 9.82% | 1.25% | 1.63% | (PFF) |
Note: BER = baseline expense ratio (excluding 3-month LIBOR, but including financing spread), TER = total expense ratio (including 3-month LIBOR and financing spread). Adjusted TER = TER/2 (to account for the 200% leverage and to enable comparison with 1x funds).
Assets and volume
The chart below shows the assets under management and the average volume for all of the 2x ETNs. We can see that MORL is still the largest of the 2x ETNs, followed by CEFL. This month, MRRL has jumped into 3rd place by AUM, overtaking BDCL which was the 3rd-largest fund for a very long time. Interestingly, the two most active ETNs are MORL and MRRL - meaning that MRRL is traded more frequently than CEFL despite being smaller than CEFL.
(Source: Stanford Chemist, Morningstar)
Note that several of the ETNs are thinly traded. For those illiquid ETNs, it is recommended to use limit orders to ensure that the transaction is executed at an acceptable price. Moreover, it is highly recommended to check the indicative price of an ETN, available on the UBS ETRACS website (e.g. here for CEFL), before buying or selling the low-volume ETNs. This is because financial websites or brokers often quote the last-traded price, which can deviate significantly from the NAV (technically, "indicative value" for the ETNs) for the thinly traded ETNs.
Yields
One of the major attractions of the 2x leveraged ETNs is their often mouth-wateringly high yields. The yields (trailing 12 months) of the funds are displayed graphically below, arranged in order of smallest to largest. Note that HOMX is a total return fund, and hence pays zero distributions. SMHD has the highest yield of 22.7%, followed by MORL/MRRL at 21.9% and MLPQ at 17.8%. All of the ETNs pay monthly except for BDCL/LBDC, MLPQ and MLPZ which pay quarterly (and except for HOMX which pays no distributions at all). The newly launched SMHB is expected to have a similar yield as SMHD as they track the same index.
(Source: Stanford Chemist, Morningstar)
This month, PFFL's ttm yield is being reported for the first time, as the fund is now 1 year old. The ttm yield is 9.82%. For reference, the unleveraged PFF has a ttm yield of 5.54%.
Note that MORL may exhibit a slightly lower yield than MRRL even though both ETNs track the same index, due to the suspension of sales of new notes of MORL which may allow MORL to trade at a premium (see "What To Do About MORL?" for more information). The same applies to the SMHD and SHMB, with SMHD possibly experiencing a lower yield for the same reason (see "What To Do About SMHD?" for more information). Moreover, Morningstar is appearing to report the NAV yield of the funds rather than their market yields, which is why MORL and MRRL are showing the same yield in the chart above.
Important note: SMHD's listed ttm yield may not be an accurate reflection of its forward yield. See "Is SMHD's 22% Yield Sustainable?" for further information.
Dividend growth rates (updated for 2019!)
Investors might be interested in whether or not the 2x ETNs have been able to grow their distributions. The following chart shows the 1-year DGR, 3-year and 5-year DGR for the 2x ETNs, where available. Note that these are calendar year DGRs and therefore only show data where full years are available. Hence,
- 1-year DGR represents the distribution increase from 2017 to 2018
- 3-year DGR represents the distribution increase from 2015 to 2018
- 5-year DGR represents the distribution increase from 2013 to 2018
With another year (2018) under our belt, four more 2x ETNs that were incepted during 2016 now have two full calendar years (2017 and 2018) of distribution history: MLPQ, MLPZ, allowing the calculation of calendar 1-year DGR ratios. Similarly, calendar 3-year DGRs are now available for the ETNs incepted in 2014 since they have now four full calendar years of distribution history available (2015, 2016, 2017, 2018): HDLV, LMLP. Finally, calendar 5-year DGRs are now available for the ETNs incepted in 2012 since they have now six full calendar years of distribution history available (2013-2018 inclusive): DVYL, MORL, SDYL.
We can see from the data below that 3 out of 14 leveraged ETNs have managed to increase their distributions from 2017 to 2018. SDYL showed the largest 1-year DGR increase (+19%), followed by LMLP (+14%) and DVYL (+3%). The ETNs with the largest 1-year DGR decreases were MLPZ (-37%), MLPQ (-24%), and BDCL/LBDC (-20%).
In terms of calendar 3-year DGR, 3 out of 8 leveraged ETNs for which we have data available managed to increase their distributions from 2015 to 2018. Here, DVYL and SDYL have the highest 3-year DGRs of +16%, while BDCL, CEFL and LMLP have the lowest 3-year DGRs of -11%.
For calendar 5-year DGR, DVYL and SDYL managed to boost their distributions by an average of 16% per year, however, MORL's dividend rate decreased by -10% per year over the last 5 years.
(Source: Stanford Chemist, Morningstar)
It should be remembered that the distributions of the 2x ETNs are not only affected by the yield of the underlying holdings, but also changes in price of the ETNs. This is because the ETNs are 2x leveraged. Hence, increases in the price of the ETNs will boost their distributions, and vice versa. See this Lance Brofman article for a detailed explanation.
Expense ratios
Regarding the expense ratios, UBS engages in the (rather dubious, in my opinion) practice of hiding their financing spread within their pricing supplement, which makes their headline management fee (known as "tracking rate") look lower. For example, SDYL has an annual tracking rate of 0.30%, a figure that is displayed prominently on the fund's website, but you have to dig into the pricing supplement to see that you are being charged an additional 0.40% in financing spread. This means that the total financing rate will be 0.40% + 3-month LIBOR (currently 2.00%). Adding all three fees together gives a total expense ratio [TER] of 0.30% (tracking rate) + 0.40% (financing spread) + 2.00% (3-month LIBOR) = 2.70%.
However, remember that these ETNs are 2x leveraged. Thus, I devised an "adjusted TER" that takes into account both the current LIBOR rate, and the leverage of the fund, which can be achieved by simply dividing the total expense ratio (including LIBOR) by 2. I believe that this value is more useful when one is trying to compare the expense ratio of the 2x ETNs versus unleveraged funds. In fact, with some of the adjusted TERs being lower than the expense ratios for unleveraged 1x funds, it might be able to juice your portfolio by up to nearly 1% a year by synthetically replicating a 1x position (as described in Build Your Own Leveraged ETF (ETRACS Edition)).
The following chart shows the baseline expense ratio (excluding LIBOR) and the adjusted TER of the funds, arranged from lowest to highest. MLPZ has the highest expense ratio (excluding LIBOR) of 1.95%, and its adjusted TER comes out to 1.95%. SDYL has the lowest expense ratio (excluding LIBOR) of 0.70%, and its adjusted TER comes out to 1.35%.
(Source: Stanford Chemist, Morningstar)
The 3-month LIBOR has fallen another 13 bps decline this month, marking a 10th straight month of declines. This will benefit the 2x ETNs in terms of providing lower interest expense ratios.
Data by YCharts
Position within 52-week trading range
I also calculated the position of the stock price of each 2x ETN as a function of their 52-week trading range which is a metric I have found to be quite useful when making buy or sell decisions. As a value investor, I am more inclined to buy a stock when its price is close to its 52-week low. Conversely, I am reluctant to buy stocks when their prices are close to their 52-week highs (of course, momentum investors will disagree).
In the below chart, 0% on the x-axis indicates the midpoint of the 52-week trading range. The -50% position indicates the 52-week low while +50% indicates the 52-week high. Note that some of these values may be unreliable due to the low liquidity of some of the ETNs.
Over the last month, the MLP-focused MLPZ and MLPQ have fallen to near the bottom of trading range. Meanwhile, the broader stock funds, SDYL and DVYL, as well the REIT-focused LRET, are trading near the upper end of their 52-week trading range.
Performance
The following chart shows the recent performance of the suite of 2x ETNs, in terms of total return [TR]. 1-year, 3-year and 5-year TR values are given were available, with time periods longer than 1 year being annualized. The figures on the chart show the 1-year total return percentages.
(Source: Stanford Chemist, Morningstar)
We can see from the chart above that there is a large variation between the 1-year TR performances of the 2x ETNs. HOML (+134%) has by far the best 1-year returns among the 2x ETNs, while MLPZ (-29%) is the worst. Note that these are price performances, not NAV performances. Where ETNs have the ability to trade at premiums (SMHD, MORL) due to the suspension of sales of new notes, the price performance can differ substantially from the NAV performance.
At member request, we now also present the cumulative total return figures for the 2x ETNs over 1, 3 and 5-year time frames. Members requested this data as it shows the actual amount that an investor would received over the entire time frame, had they been fully invested from the start of the period. Due to the fact cumulative nature of the data, we present the charts for the various time frames separately to be able to more clearly see the difference in returns between the 2x ETNs.
1-year:
3-year:
5-year:
This month, HDLV has turned 5 years old! The fund is showing a 74% cumulative TR since inception, which is not too shabby although significantly less than the broader DVYL and SDYL over the same time periods.
Reminder about Series B ETNs
In October 2015, UBS launched six new "Series B" ETNs, four of which were 2x leveraged (MLPQ, MLPZ, MRRL, LBDC). The main difference between the original "Series A" ETNs and the Series B ETNs is that the former are co-guaranteed by both UBS AG and UBS Switzerland AG, whereas the newer the latter are guaranteed by UBS AG only. In theory, this should make the Series B ETNs less valuable than the Series A, since the former are solely guaranteed by UBS AG. However, it is hard to imagine a scenario where UBS AG goes under and its subsidiary, UBS Switzerland AG (and by extension the Series A notes) remains unscathed.
In the same announcement, UBS also stated that they do not intend to issue any new notes in any of its existing Series A ETNs. While this could in theory make those ETNs "broken products", a few simple guidelines could help prevent investors from going astray. First, this "does not affect the terms of the outstanding Series A ETRACS ETNs... including the right of noteholders to require UBS AG to redeem their notes on the terms", meaning that if the ETNs were to deviate significantly below their NAV, large players could buy the notes on the open market and have UBS redeem them (the minimum number of shares for redemption is 50,000) at their NAV. This arbitrage potential should act as a driving force to push the price of the ETN back up towards its NAV.
Secondly, just because UBS has suspended issuance of new notes of the Series A ETNs doesn't mean that they will all start automatically trading at premiums. This is because UBS still has a reservoir of "Previously Issued But Unsold Notes Available for UBS Securities LLC to Sell" for each ETN, allowing supply to match demand until the reservoir becomes fully exhausted. So far, the only two ETNs to have suspended both issuance and sales of notes are MORL and SMHD, and so these funds have the greatest ability to trade above their indicative values.
On the other hand, if the notes were to deviate significantly above their NAV (say >10%), then... what are you waiting for? Sell the notes right now on the open market and buy them back later when the price falls back to its NAV. This also serves to remind that one should always check the indicative value of the ETNs on the UBS ETRACS website before buying any fund.
Reminder on leverage
An interesting feature of the ETRACS 2x leveraged ETNs is that their leverage resets monthly rather than daily, which is the norm for most leveraged funds in the market. It is well known that decay or slippage in leveraged funds will occur when the underlying index is volatile with no net change over a period of time. By resetting monthly rather than daily, the decay of the ETRACS ETNs might be somewhat mitigated.
Seeking Alpha author Dane Van Domelen has conducted both theoretical and empirical research into the performance of leveraged funds. His research showed that in most cases, the decay is not as serious as is often initially thought to be. My own research on the live performance of the 2x ETNs showed that monthly resetting has generally helped rather than hurt performance.
Moreover, the 2x ETNs charge a finance cost (3-month LIBOR plus a variable financing spread) to maintain their 2x leverage. Due to prevailing low interest rates, the finance charge is currently relatively low, but this could change when/if interest rates rise in the future. Still, the financing rates charged to these ETNs are still much lower than what the majority of retail investors would be able to access from their brokers. This means that from an expense ratio point of view, it would usually be better to buy the leveraged fund than to try and replicate it yourself with a margin loan from your broker.
Finally, remember that leverage will act to boost the distributions of the ETNs when its share price is going up, and reduce distributions when its share price is going down, even if the payout levels of the underlying holdings remain unchanged, in order for the funds to maintain their 2x leverage.
Reminder on ETN structure
It should be noted that investors in the 2x ETNs are subject to credit risk from the fund sponsor, in this case UBS. If UBS were to go bankrupt, the ETNs will likely become worthless. Professor Lance Brofman has argued that the risk of ETN investors losing money due to UBS going bankrupt is, barring an overnight collapse, minimal because the notes can always be redeemed (the minimum number of shares for redemption is 50,000) at NAV.
Moreover, since ETNs are debt instruments, their distributions are considered as coupon payments rather than as dividends. Distributions from ETNs are therefore treated as interest tax-wise and subjected to the ordinary income tax rate.
Profitable CEF and ETF income and arbitrage ideas
At the CEF/ETF Income Laboratory, we manage market-beating closed-end fund (CEF) and exchange-traded fund (ETF) portfolios targeting safe and reliable ~8% yields to make income investing easy for you. Check out what our members have to say about our service.
To see all that our exclusive membership has to offer, sign up for a free trial and 20% offer by clicking on the button below!
Disclosure: I am/we are long THE PREMIUM PORTFOLIOS. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it (other than from Seeking Alpha). I have no business relationship with any company whose stock is mentioned in this article.


drawOval( 100-50, 300-50, 2*50, 2*50 )
Of course the method would work if you did the arithmetic and put the results in the method call, but why bother?
To draw a rectangle,
use the drawRect()
method of the Graphics object.
This method looks like:
drawRect(int x, int y, int width, int height)
It draws the outline of a rectangle using the current pen color. The left and right edges of the rectangle are at x and x + width respectively. The top and bottom edges of the rectangle are at y and y + heigth respectively.
Of course, if you want a square you would use this method also. Here is an applet that surrounds the entire drawing area with a rectangle, then puts another rectangle in the center.
import java.applet.Applet; import java.awt.*; // assume that the drawing area is 150 by 150 public class SquareAndRectangle extends Applet { final int areaSide = 150 ; final int width = 100, height = 50; public void paint ( Graphics gr ) { setBackground( Color.green ); gr.setColor( Color.blue ); // outline the drawing area gr.drawRect( 0, 0, areaSide-1, areaSide-1 ); // draw interiour rectange. gr.drawRect( areaSide/2 - width/2 , areaSide/2 - height/2, width, height ); } }
Here is what it draws on your screen:
When drawing the outer square, one was subtracted from its width and height so that the edges would be inside the drawing area.


Computer science and HCI
CSC318: Design of Interactive Computational Media
University of Toronto
2014-2017
Introduction
CSC318 is the first of two HCI courses offered at the Department of Computer Science. It is meant to be a survey of interaction design from user requirements gathering through functional prototyping. The course is based on the User-Centred Design methodology. Over several iterations, I have expanded it to include elements of cognition and emotion, visual design, typography, and the Jobs-to-be-done framework as an alternative to UCD deliverables such as personas and user stories. The course roughly follows a single cycle of design from ascertaining user needs through interpreting research, ideating, prototyping, and evaluating solutions.
Topics
- Definitions: User-centred design, user experience, interface design, interaction design
- Understanding humans: memory, emotion, motivation, cognition, information scents, stages of action
- Requirements gathering: literature reviews, questionnaires, interviews, observation, contextual inquiry, participatory design
- Research interpretation: personas, scenarios, user requirements, job stories, experience maps
- Conceptual models: affordances, signifiers, constraints, mappings, instructions, metaphors, idioms
- Ideation and prototyping: sketches, storyboards, paper prototypes, wireframes, mockups
- Visual design: layout, balance, negative space, colour, colour deficiency, typography, font pairing
- Evaluation: heuristic evaluation, lost-our-lease usability testing
Group Project
Students complete a semester-long project in groups of 5. The project mirrors the stages of the UCD process.
- Problem domain selection
- Literature review
- Research instrument drafts
- Revised research instruments
- Research results
- Brainstorming
- Initial prototype
- Usability testing
- Project pitch presentation
- Final write-up
Assignments
Students complete three individual assignments:
- New technology: solve a problem using a new technology's capabilities, e.g., Google's Project Soli
- Heuristic evaluation: evaluate the department's web submission portal
- Visual design: skin a wireframe with appropriate fonts, colours and visuals.
More info:
CSC108
Introduction to Computer Programming
University of Toronto
Spring 2011
Introduction
CSC108 is the first programming course in the Computer Science program, and it teaches programming fundamentals using Python. I taught CSC108 in 2011 alongside CS lecturer Paul Gries as a traditional lecture-based class.
In 2014 I was one of 5 teaching assistants hired to help transition the offering to a flipped classroom. I created 14 instructional videos and recorded voiceovers for them. The flipped classroom model is now implemented in the teaching of CSC108 in online and in-person sections alike.
Topics:
- Data types and variables
- Functions, return statements, parameters and arguments
- Boolean logic, conditionals and loops
- Modules, docstrings and __main__
- Scope, namespaces and memory
- Strings, tuples, lists, and dictionaries
- Object-oriented programming fundamentals
- Sorting algorithms and introduction to time complexity
More info:
CSC148
Introduction to Computer Science
University of Toronto
2012-2014
Introduction
CSC148 expands on the fundamentals taught in CSC108 and begins to abstract away the particulars of Python in favour of abstract data types and algorithms.
Topics:
- Objects, classes, inheritance, and self
- Test-driven development and unittests
- Queues and stacks
- Exceptions
- Recursion and iteration
- Call stack and memory model
- Lists vs linked lists
- Trees and tree traversals
- Binary search and binary search trees
- Priority queues, heaps, and heapify
- Sorting algorithms: bubble, insertion, selection, quicksort, mergesort, heapsort, timsort
- Time complexity
More info:
Back to Teaching


Clay
Material Investigation
Click on a layer name below to show/hide
Layer is shown
Layer is hidden
Bentonite
Producer
Past Producer
Prospect
Occurrene
Kaolin
Producer
Past Producer
Prospect
Occurrene