Event Location:
ECPI
800 Moorefield Park Drive
Richmond, Virginia
Abstract:
SQL Server 2008 brought us the ability to do Row and Page level compression in our databases but even today many people are not taking full advantage of these wonderful features. The most common bottle neck today is physical I/O and SQL Server compression can help with that in most cases. If you are not sure how these features work or how to apply them in your environment this session is for you. We will discuss in detail how the compression schemes work at both the row and page levels along with which data types may or may not be able to participate. We will see from various demos what else affects the compression ratio and just how extensive it can be under the right conditions. Nothing comes for free though so we will also cover the pros and cons along with why, when and most importantly how to use it effectively.
Speaker(s): Andrew Kelly,
Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.
Speaker(s): Ayman El-Ghazali,
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Speaker(s): Jason Brimhall,
Abstract:
Don’t miss this educational session that will help put an end to your application outages. See how to ensure peak SQL Server performance and keep your applications up and running. Learn how to simplify your work with in-depth monitoring and diagnostics. Experience easy tips to: * Set up comprehensive data collections within seconds * Create a series of threshold-based alerts automatically and tie them to email notifications * View the historical state of the instance when an issue occurred * Monitor the entire application stack to identify bottlenecks * Diagnose the source of CPU or I/O problems immediately * Integrate Spotlight on SQL Server data with SSRS * Monitor additional connections, such as SSAS, VMware, SQL Azure, and any Windows OS
Speaker(s): David Orlandi,
Abstract:
Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.
Speaker(s): Jason Brimhall,
Abstract:
Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response-time analysis. Real-life case studies are used to demonstrate the techniques. Much of what you’ll learn falls beyond OEM, so this is a “must-see” for those who rely on Performance Packs.
Speaker(s): Carlos L Chacon,
Abstract:
We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload? Have you ever completed an upgrade and wondered if you were truly getting better performance? Do we know if the new 3rd Party application upgrade will make performance better or worse? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use Distributed Replay, XEvents and ClearTrace to answer these questions and even give you a little insight into how you can document these changes to help you get that next raise.
Speaker(s): John Sterrett,
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
Speaker(s): Wayne Sheffield,
Abstract:
Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around "impossible in SSRS" visualizations and construct them live in SSRS!
Speaker(s): Jason Thomas,
Abstract:
Loading a data warehouse can be fraught with data quality issues, data type mismatches, and failed loads. To combat these issues and load your data quickly can be a challenge. This session will explain step-by-step how to implement an ETL rollback framework to remove any data that was loaded incorrectly. Based on a real-world implementation, this framework can either automatically or manually load the corrected data, making your life easier.
Speaker(s): Jessica Moss,
Abstract:
Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.
Speaker(s): Melissa Coates,
Abstract:
Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we'll look at the concepts surrounding partitioning and how we can apply them. We'll reinforce what we cover with some cool demo's showing some really neat tricks.
Speaker(s): Brandon Leach,
Abstract:
From log shipping to Always On Availability Groups, SQL Server has a lot of options for keeping your systems up and your data safe. In this session we will look at the various HA/DR options available in SQL Server and discuss the pros, cons, tips and tricks to each of them. Be sure to bring your questions because we won’t leave until the last question is answered.
Speaker(s): Mike Sullivan,
Abstract:
We will navigate through the internal differences between Clustered and non-Clustered indexes. Will take a look how indexes are built, what page splits are and how SQL Server uses indexes to retrieve a data. In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code. That is Intermediate session for everybody who already knows about indexes, but doesn't really know how they work.
Speaker(s): Slava Murygin,
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
Speaker(s): Brandon Leach,
Abstract:
When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
Speaker(s): Carlos L Chacon,
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I'll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure.
Speaker(s): Chris Skorlinski,
Abstract:
Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
Speaker(s): Mark Hudson,
Abstract:
Learn how to navigate the SQL Server Community. There are a lot of great resources out there - Most of them Free. Learn what is available and how you can get the most of the community. We will them explore THREE cool features in SQL Server 2014 - Clustered Column-Store Index, Buffer Pool Extension, and In-Memory OLTP Database Technology (aka Hekaton).
Speaker(s): Rick Heiges,
Abstract:
In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database. We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.
Speaker(s): Timothy McAliley,
Abstract:
Together we'll explore SQL Server "check engine lights", those little indications that SQL Server needs your attention. Ignore these and you could be stuck alongside the road with a broken engine.
Speaker(s): Chris Skorlinski,
Abstract:
This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.
Speaker(s): John Sterrett,
Abstract:
For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.
Speaker(s): Doug Purnell,
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker(s): Brian Davis,
Abstract:
It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker(s): Tim Radney,
Abstract:
Experience with a platform gives us patterns: common techniques which we can use to solve a number of recurring problems. They also give us anti-patterns: common techniques we often use to solve a number of recurring problems incorrectly. This session will cover a number of anti-patterns related to writing T-SQL code. We will cover each anti-pattern in detail, explaining the problem, why you might reach for the anti-pattern, and better alternatives which won't leave you hurting for performance.
Speaker(s): Kevin Feasel,
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!
Speaker(s): Andy Leonard,
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:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
Speaker(s): Andy Leonard,
Abstract:
As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three.
Speaker(s): Geoff Johnson,
Abstract:
Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.
Speaker(s): Rick Heiges,
Abstract:
In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
Speaker(s): Rafael Salas,
Abstract:
Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..
Speaker(s): Louis Davidson,
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/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002.
LinkedIn: https://www.linkedin.com/in/carloslchacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
LinkedIn: https://www.linkedin.com/pub/slava-murygin/9/b95/858
Contact: http://slavasql.blogspot.com/
Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.
Mike Sullivan has been working with SQL Server since Version 4.21 (running on NT 3.1). In his current role as a Senior Premier Field Engineer for Microsoft, he is responsible for improving the customers experience by providing enterprise class solutions for SQL Server. Mike lives in central Virginia and when he’s not tinkering with technology, he enjoys camping, cycling, and sailing with his wife and two daughters.
LinkedIn: http://www.linkedin.com/in/aymansqldba
Contact: http://www.thesqlpro.com
Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.
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.
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
LinkedIn: https://www.linkedin.com/in/sqlservernerd
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
LinkedIn: http://www.linkedin.com/pub/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002.
LinkedIn: https://www.linkedin.com/in/jasontomthomas
Contact: http://www.SqlJason.com
Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).
Contact: http://www.dell.com
David Orlandi brings over 13 years of experience in software consulting to his position as Systems Consultant at Dell Software. Dave is responsible for supporting the sales division by communicating and demonstrating the value of the Performance Monitoring suite of solutions. Prior to Dell, Dave held similar positions at Embarcadero Technologies, Toshiba, and Thomson. Dave graduated from the Whitman School of Management at Syracuse University with a bachelor’s degree in Marketing.
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
LinkedIn: http://www.linkedin.com/in/AndyLeonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of "The Biml Book and SQL Server Integration Services Design Patterns" and author of "Managing Geeks - A Journey of Leading by Doing", "Data Integration Lifecycle Management with SSIS", "Building Custom Tasks for SSIS", and the "Stairway to Integration Services". Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: http://www.linkedin.com/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/louisdavidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).
LinkedIn: https://www.linkedin.com/in/sqlservernerd
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
LinkedIn: http://linkedin.com/in/tradney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Contact: http://www.rafael-salas.com
Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.
LinkedIn: https://www.linkedin.com/in/briandavis78
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
LinkedIn: http://www.linkedin.com/in/AndyLeonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of "The Biml Book and SQL Server Integration Services Design Patterns" and author of "Managing Geeks - A Journey of Leading by Doing", "Data Integration Lifecycle Management with SSIS", "Building Custom Tasks for SSIS", and the "Stairway to Integration Services". Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.
LinkedIn: http://www.linkedin.com/in/melissacoatesprofile
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa's website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
Contact: http://selectstatements.blogspot.com
Geoff is the BI Developer for Custom Data Systems, Inc., a software company offering data management for CPA associations and similar non-profit groups. He has been working with SQL Server for over fifteen years, with a focus on BI and SSRS for 6+ years. Since January of 2016 he has been designed and implemented a data warehouse solution for CDS, Inc. He is an active member of the Richmond SQL Server User Group and counts it a privilege to share what he has learned the hard way with others so they don't have to. He also occasionally blogs about his lessons learned.
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: https://www.linkedin.com/in/carloslchacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
LinkedIn: https://www.linkedin.com/in/dougpurnell/en
Contact: http://sqlnikon.wordpress.com
Doug Purnell is a DBA at Elon University and is a co-leader for the Triad SQL BI PASS User Group. In his spare time you can find Doug taking photos and cooking up some BBQ on his cooker.
The following is a list of sponsors that helped fund the event.


--- layout: post title: Got my iPhone magnets! date: 2010-03-16 03:43:38.000000000 -07:00 type: post published: true status: publish categories: [] tags: [] meta: {} author: ---
Sent via iPidgeon


| Site/Civil Design | Roadway Design | Maintenance of Traffic (MOT) | Traffic Signal Design | Signing and Pavement Markings Design |
| Highway Lighting Design | Utilities | Bridge/Construction Inspections | Project Management | Independent Quality Services |
Site/Civil Design
We can perform the following Site design services to suit your project needs:
Roadway Design
We can perform the following Roadway design services to suit your project needs:
Maintenance of Traffic (MOT)
We can perform the following MOT design services to suit your project needs:
Traffic Signal Design
We can perform the following Traffic Signal design services to suit your project needs:
Signing and Pavement Markings Design
We can perform the following Signing and Pavement Markings design services to suit your project needs:
Highway Lighting
We can perform the following Highway Lighting design services to suit your project needs:
Utilities
We can perform the following utility services to suit your project needs:
Bridge/Construction Inspections
We can perform the following inspection services to suit your project needs:
Project Management
We can perform the following project management services to suit your project needs:
Independent Quality Services
We can perform the following Independent Quality Services to suit your project needs:


I created the scripts contained on this github page in order to parse the output of a particular simulation program. This program outputs a lot of data and the python and bash scripts parse the information and pull out the data I wished to look at. I really loved working on this becuase it was cool to see the bash scripts work in tandem with the python scripts.


The Main Page
Latest news ›
How to set up a birthday fundraiser on Facebook
Rachel Kaser · 15 minutes agoThis free font was designed to make it easier for devs to read code
Mix · 6 hours agoHow India's homegrown GPS will work with phones
Ivan Mehta · 7 hours agoSatoshi Nakaboto: 'Elon Musk says Bitcoin is good for illegal payments — and that's about it'
Satoshi Nakaboto · 7 hours agoAlleged BTC-e boss will be extradited to France over cryptocurrency fraud
Yessi Bello Perez · 15 minutes agoGet ready for the emergence of AI-as-a-Service
Ji Li · 8 hours agoThe UK now has 30,000 EV charging connectors — but there's a long way to go
Matthew Beedham · 8 hours agoHow to be a digital disrupter at your company — without getting fired
Nate Berent-Spillson · 10 hours agoLogiNext
£39M
SERIES B
SERIES B
LogiNext snags $39m from Tiger Global, Steadview Capital on DealStreetAsia
Autenti
£4.5M
SERIES A
SERIES A
Intelerad
Undisclosed amount
PRIVATE EQUITY
Hg
PRIVATE EQUITY
Hg invests in Intelerad Medical Systems on PrivateEquityWire
ConnectDER
£7M
SERIES B
SERIES B
ConnectDER Draws Investment From Avista in Latest Funding Round on Greentech Media
Blog Topics
Apps ›
How to add people to Twitter lists without notifying them
- Your beginner's guide to Honey, the anti-Amazon shopping extension
- Uber test allows California drivers to set their own fares
- Don't update Twitter for Android — it crashes (but you can fix it)
- WhatsApp finally gets dark mode on Android — here's how to enable it
- YouTube TV just debuted on the PS4, replacing Vue
Gear ›
MOST POPULAR
Samsung's Galaxy Z Flip may use bendable 'ultra-thin glass' instead of plastic
Napier Lopez · 21 hours agoGoogle is testing how to make ads sneakier in search results
- Samsung's Galaxy Z Flip may use bendable 'ultra-thin glass' instead of plastic
- Fujifilm's new X-T200 camera uses gyro sensors to shoot steady 4K video
- The latest Huawei P40 Pro color leak makes me want a Viennetta
- The FBI is cracking iPhone 11s without Apple's help, so why does it need a backdoor?
- The new Motorola Razr arrives February 6 in all its folding glory
Tech ›
MOST POPULAR
Ride-hailing apps are failing sexual assault survivors — UrSafe aims to change that
Cara Curtis · 7 hours agoScientist says aliens in UFOs might be Earthlings from the future
- Ride-hailing apps are failing sexual assault survivors — UrSafe aims to change that
- Scientists have cracked the formula for a perfect cup of coffee
- How to add Apple Pay to your Watch ahead of your next gym visit
- A beginner's guide to the AI apocalypse: Wall-E syndrome
- 100 seconds to midnight: Why we're closer to Doomsday than ever
Creative ›
MOST POPULAR
Leaked trailer offers a new look at Godfall, the first game announced for PS5
Mix · 3 days agoInstagram's decision to hide photoshopped images is a disservice to art
- How to design better buttons
- Giphy debuts Arcade, a platform for making and playing 'microgames'
- Microsoft's new font for devs is very aesthetically pleasing (and free)
- How to build a production and recording studio that fits in a backpack
- Watch: Disney's new anti-vibration tech maps CGI movements onto actual robots
Podium ›
How to be a digital disrupter at your company — without getting fired
- Conway's Law and DevSecOps: How communication affects security
- Why your business should focus on understanding speech over voice recognition
- Facebook and Zuckerberg keep getting 'freedom of expression' wrong
- WeWork can be salvaged — but its turnaround plan isn't enough
- Freelancers can solve the corporate innovation conundrum
Insights ›
MOST POPULAR
Report: Japan is working on its own digital currency in retaliation to China's
Matthew Needham · 7 hours agoThe Dutch Department of Defense now has its own CS:GO team ' and they got pwned
- Satoshi Nakaboto: 'Elon Musk says Bitcoin is good for illegal payments — and that's about it'
- Alleged BTC-e boss will be extradited to France over cryptocurrency fraud
- The UK now has 30,000 EV charging connectors — but there's a long way to go
- PornHub content creators can now cash out in Tether
- Scientists invent a faster and cheaper way to repurpose EV batteries
Launch ›
MOST POPULAR
PSA: Amazon Fresh grocery deliveries are now free for US Prime members
Abhimanyu Ghoshal · 12 weeks agoAlexis Ohanian and Serj Tankian team up to help build a social network for Armenia
- Google Assistant gets its own phone number in India
- Pam and Angela from The Office are re-watching the show for their new podcast
- Bethesda wants you to test its game streaming tech with DOOM on iOS this year
- Mozilla rolls out new automated crypto-jacking filtering in Firefox
- Google announces Stadia, its cross-platform game streaming service
Distract ›
MOST POPULAR
This free font was designed to make it easier for devs to read code
Mix · 9 hours agoModern Warfare Season One's been extended, should I purchase the Battle Pass now?
- Radiohead launches digital 'public library' of the band's archive
- This genius combined every macOS 10 wallpaper into a psychedelic masterpiece
- If a Japanese billionaire farted in front of you, what would you say?
- Hide the Pain Harold is the meme of the decade (according to Imgur)
- You'll need 19 years and $139,346 to download everything on The Pirate Bay


We believe in offering the offering the very best quality of products possible. If you are unhappy with your purchase you may return unused items for a refund or exchange.
Please contact our customer service team for returns at<EMAIL_ADDRESS>Products must be returned within 90 days from the date of purchase
In order to purchase a product from our website you must have a registered PayPal account or enter your payment information on PayPal's website when you check out.
We do not accept any other forms of payment.
We use Paypal in order to ensure that your personal information is secure and encrypted. Therefore, your data is safe from any prying eyes.
You may shop and add items to your cart. Adding items to your cart will direct you to PayPal's website where you may checkout. Once you're ready to checkout you can either log in to PayPal, or continue as a guest and submit your required payment details.
You may contact us by phone or email immediately and our team can change the shipping address so long as the package has not left the facility. If the package has left the facility and you wish to change the address while it is in transit we can update the address, but a $15.00 service fee will be issued to do so. This is because shipping companies issue a fee when the address is altered.


the and {background will with for hepatitis margin The {border-style px;} #ffffff;} antiviral combined virus chronic ETV data treatment px; serum {font-family CHB analysis bias font-size risk Chinese double; efficacy patients which This antigen are bias), border-color border-width effect evaluate from have reducing review solid; systematic there {font-style {font-weight CHB. China HBV HBV-DNA Hepatitis Types assessed bold courier; drug drugs effects em; evidence has heterogeneity liver may oxymatrine performed protocol pt;} resistance safety should side surface


Booksamillion.com has created this statement to demonstrate our firm commitment to our customers' privacy. This document discloses our practices for gathering and disseminating information through our web site at www.booksamillion.com.
Information That We Collect
When you sign up for a Booksamillion.com account or service operated by Booksamillion.com, we store all information that you provide to us. Our site uses an order form for customers to request information, products, and services. We collect visitors' contact information (such as an email address) and financial information (such as account or credit card numbers). Contact information from the order form is used to send orders and information about our company to our customers. The contact information is also used to communicate with customers when necessary. Users may choose not to receive future mailings (see the CHOICE/OPT-OUT section below). The financial information that we collect is used to bill the user for products and services.
Your IP address and browser information are stored in a "cookie" file to help identify you and your shopping cart. A cookie is a small data file that web sites write to your hard drive. A cookie cannot read data off your hard drive nor read other cookie files. You can refuse cookies by turning this option off in your browser. You do not need to have cookies turned on to purchase items from Booksamillion.com. However, cookies are needed if you wish to store items in your shopping cart between visits to the site.
We run contests on our site in which we ask visitors for contact information (such as an email address). We may use this contact data to send users information about our company. Users may opt-out of receiving future mailings (see the CHOICE/OPT-OUT section below).
Any email or written correspondence that you send us may be stored. Data from any monetary transaction taking place via Booksamillion.com may be stored.
Uses of Collected Information
Booksamillion.com uses collected information to enhance your experience online, authenticate you when you sign in, send notifications, fulfill your requests for services, contact you, customize the advertising or content that you see, and provide anonymous reporting for internal and external clients.
Information Sharing
Booksamillion.com does not share personal information with other individuals , organizations, or companies outside of Booksamillion.com, unless we have your consent or unless:
In addition, for our book clubs, online forums, customer ratings and reviews, certain personal profile information is shared with forum moderators. When you join clubs or forums, your email address and the specific information requested by particular communities will be shared with the moderators of those communities.
Data Integrity
Booksamillion.com processes personal information only for the purposes for which it was collected and in accordance with our Privacy Policy. We review our data collection, storage, and process practices to ensure that we only collect, store, and process the information needed to provide our services. We depend on our users to update or correct their own personal information.
Security and Confidentiality
Booksamillion.com restricts access to personal information to Booksamillion.com employees, moderators, contractors and agents who need to access the information in order to operate, sustain, improve or repair our services. These individuals are bound to confidentiality agreements and may be subject to discipline, including termination and criminal prosecution, if they fail to meet these obligations.
This site has security measures in place to protect the loss, misuse and alteration of the information under our control. Booksamillion.com processes orders with a SSL Secure Commerce Server which utilizes military grade encryption to protect your information. All credit card information is encoded with strong encryption before storage. Booksamillion.com does not release your credit card information or mailing address to any outside organizations without your prior electronic consent.
Choice/Opt Out
Customers may unsubscribe from a Booksamillion.com email list at any time by simply following the instructions included at the bottom of any Books-A-Million email message.
Contacting Booksamillion.com
If you wish to modify information previously provided, remove information from our database to avoid receiving future communications, or inquire about this privacy statement, the practices of this site, or your dealings with this site, contact us through one of these options:


{% extends "newbase.html" %} {% block title %}EasyDMP: Privacy Policy{% endblock %} {% block content %}
In order for this website to function, it is necessary to collect some data on users and usage.
We strive to collect as little as possible about our users, but some data is necessary for things to work.
EasyDMP uses email addresses as user names. EasyDMP stores these with itself, together with a timestamp marking the first login, and a timestamp for the newest login.
These addresses are stored on first log in, and comes from the login facility. Therefore, we only support login mechanisms that supply us with an email address. This also means that if a user needs to change their email address, they need to do it at whatever facility they use to log in, for instance Feide or B2ACCESS, and then contact us.
The email address is visible to other logged in users. It is used to contact other users, invite other users to work on a plan, or for the support team at Sigma to get in contact with specific users if a problem occurs. There currently exists no easily used list of all email addresses in order to easily contact every user at once as of yet, as there haven't been any use for it. If the need should occur, details of the lists will be added to this page.
In order to have a valid export to RDA DMP Common Standard, a machine-readable DMP standard, it is necessary to collect your full name (first + last in that order).
As with email addresses, we can to some degree get this from the login mechanisms. When the login mechanism does not support this, there will be an extra form on login that will ask for your full name.
Since collecting full names was not part of the original design, if we do not already have the full name of a specific user, it will be added during next login.
The web server collects access logs. These contain users' ip-addresses and date of access. Log entries older than 30 days are deleted and there are no backups. There are also error logs, these are also deleted after 30 days, with no backups.
At the moment, UNINETT Sigma2 is both data processor and data controller for the data about logged in users (above), as far as we understand the terms.
This policy is in line with EUDAT's Privacy Policy, see that for the legalese.
Last updated: 2020-03-25
{% endblock %}


index
|
up
|
prev
|
next
NotNode Class
Definition at line
245
of
Expression.hpp
Constructors
NotNode
(
const
Span
& span_)
NotNode
(
const
Span
& span_,
Node
* subject_)
Member Functions
void
Accept
(
Visitor
& visitor)
override
Node
*
Clone
(
CloneContext
& cloneContext)
const override
std::string
ToString
()
const override
Constructor Details
NotNode Constructor
cmajor::ast::NotNode::NotNode(
const
Span
& span_)
Definition at line
546
of
Expression.cpp
:
546
:
UnaryNode
(
NodeType
::
notNode
,
span_
)
547
{
548
}
Declaration at line
248
of
Expression.hpp
NotNode Constructor
cmajor::ast::NotNode::NotNode(
const
Span
& span_,
Node
* subject_)
Definition at line
550
of
Expression.cpp
:
550
:
UnaryNode
(
NodeType
::
notNode
,
span_
,
subject_
)
551
{
552
}
Declaration at line
249
of
Expression.hpp
Member Function Details
Accept Member Function
void
cmajor::ast::NotNode::Accept(
Visitor
& visitor)
override
Definition at line
559
of
Expression.cpp
:
560
{
561
visitor
.
Visit
(
*
this
)
;
562
}
Declaration at line
251
of
Expression.hpp
Base class overridden functions:
cmajor::ast::Node::Accept
Calls:
cmajor::ast::Visitor::Visit
Clone Member Function
Node
* cmajor::ast::NotNode::Clone(
CloneContext
& cloneContext)
const override
Definition at line
554
of
Expression.cpp
:
555
{
556
return
new
NotNode
(
GetSpan
(
)
,
Subject
(
)
->
Clone
(
cloneContext
)
)
;
557
}
Declaration at line
250
of
Expression.hpp
Base class overridden functions:
cmajor::ast::Node::Clone
Calls:
cmajor::ast::NotNode::Clone
Called by:
cmajor::ast::NotNode::Clone
ToString Member Function
std::string cmajor::ast::NotNode::ToString()
const override
Definition at line
564
of
Expression.cpp
:
565
{
566
return
"!"
+
Subject
(
)
->
ToString
(
)
;
567
}
Declaration at line
252
of
Expression.hpp
Base class overridden functions:
cmajor::ast::Node::ToString
Calls:
cmajor::ast::NotNode::ToString
Called by:
cmajor::ast::NotNode::ToString
index
|
up
|
prev
|
next


Please note: JavaScript (scripting) must be enabled for this site to work as intended.
Store Search
Store Information
LCBO Store # 444 :
KENNEDY & SHEPPARD (AGINCOURT MALL)
2356 KENNEDY ROAD
AGINCOURT MALL
TORONTO-SCARBOROUGH,
M1T 3H1
Telephone:<PHONE_NUMBER>
Fax:<PHONE_NUMBER>
LCBO Store # 444 :
KENNEDY & SHEPPARD (AGINCOURT MALL)
2356 KENNEDY ROAD, AGINCOURT MALL,
TORONTO-SCARBOROUGH,
M1T 3H1
Telephone:<PHONE_NUMBER>
HOURS OF OPERATION
Sunday:
12:00 PM - 5:00 PM
Monday:
10:00 AM - 10:00 PM
Tuesday:
10:00 AM - 10:00 PM
Wednesday:
10:00 AM - 10:00 PM
Thursday:
10:00 AM - 10:00 PM
Friday:
10:00 AM - 10:00 PM
Saturday:
10:00 AM - 10:00 PM
This store has the following features:
parking
transit access
wheelchair accessibility
bilingual services
product consultant
a tasting bar
a beer cold room
special occasion permits
a VINTAGES corner
About LCBO
|
Accessibility
|
Social Responsibility
|
Careers
|
VINTAGES
|
Contact Us
|
Site Map
|
Store Search
© 2000/2012 LCBO
|
Privacy Policy
|
Terms & Conditions
|
Franšais
TRADE RESOURCES


My Prosperity To Do List
Add
Learn Programming
Pay Off Debt
Max Out Benefits
Reduce Living Expenses
Invest In My Business
Invest in My Health


British Airways owner IAG cuts growth forecast
by Jessica ClarkBritish Airways’ owner International Consolidated Airlines Group (IAG) cut its growth forecast for the next few years due to an expected slump in passenger capacity growth.
The company said average earnings per share growth would be 10 per cent in the three years from 2020 to 2022, compared to a previous estimate of 12 per cent.
Read more: Pilot strikes hit IAG profits
Growth in available seat kilometres (ASK), a measure of an aeroplane’s carrying capacity available to generate revenues, is expected to be 3.4 per cent, almost halving from a previous forecast of six per cent.
IAG said there was no change to its operating profit margin forecast of between 12 and 15 per cent.
Shares in the company dipped around three per cent to 527.2p following the announcement this morning before recovering to 543.6p
Meanwhile, the company announced that traffic in October was up 4.8 per cent compared to the same month last year, while capacity increased 2.7 per cent.
IAG, which also owns Aer Lingus and Iberia, carried 10.4m passengers in October compared to 10m a year ago. Load factor increased to 85 per cent from 83.3 per cent.
Read more: IAG issues profit warning after British Airways pilot strikes
British Airway’s passenger numbers increased 1.1 per cent to 4.17m last month.
The airline owner announced it will stop reporting monthly traffic and capacity statistics, opting instead to publish quarterly data going forward.
Main image credit: Getty


{% extends 'base.html' %} {% block body %} CONTACT US HOME Get In Touch Contact us Fullname Email Phone Number Subject Message Submit Keep touch with us Mousl/iraq Phone Number +964 773 1476 198<EMAIL_ADDRESS>{% endblock body %}


| table1 {tidyr} | R Documentation |
Data sets that demonstrate multiple ways to layout the same tabular data.
table1 table2 table3 table4a table4b table5
An object of class tbl_df
(inherits from tbl
, data.frame
) with 6 rows and 4 columns.
table1
, table2
, table3
, table4a
, table4b
,
and table5
all display the number of TB cases documented by the World
Health Organization in Afghanistan, Brazil, and China between 1999 and 2000.
The data contains values associated with four variables (country, year,
cases, and population), but each table organizes the values in a different
layout.
The data is a subset of the data contained in the World Health Organization Global Tuberculosis Report
http://www.who.int/tb/country/data/download/en/


raise TargetDefinitionException(target, msg)
def _execute(self, targets):
self._runner.execute(targets)
self._coverage.report(
targets, tests_and_targets.keys(), self.execute_java_for_targets, tests_failed_exception=exception)
try:
self._run_tests(tests_and_targets)
_do_report(exception=None)
except TaskError as e:
_do_report(exception=e)
raise


We enhance tables!
- morph sticky initiatives
- enable sexy supply-chains
- incubate real-time solutions
- unleash 24/365 applications
- disintermediate value-added solutions
- orchestrate integrated e-business
- implement frictionless e-markets
- target magnetic methodologies
- transition real-time methodologies
- implement bleeding-edge initiatives
- leverage seamless web services


{{ template "chrome/head_includes.html" . }}
{{ template "chrome/sidebar.html" . }}
{{ template "chrome/masthead.html" . }}
There is no web page at this address
You have been redirected to
the home page
.
{{ template "chrome/footer.html" }}


To get a complete idea of how to use the bot, go to the Docs tab. Or you can type @BGSBot help and get help on the commands in Discord itself.
@BGSBot help