Event Location:
Georgia State University - Alpharetta location
3775 Brookside Pkwy
Alpharetta, Georgia
Abstract:
With the release SQL Server Integration Services 2012, Microsoft did a massive overhaul to the deployment platform for SSIS. Gone is the old file based deployment system and MSDB. New to SSIS is the Integration Services Catalog. Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs. In this session we'll look at how the new project based deployment model simplifies your SSIS coding. We'll also take a dive into the catalog, uncovering the wealth of information it can provide.
Speaker(s): Robert Cain,
Abstract:
When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments? If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
Speaker(s): Kerry Tyler,
Abstract:
Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly.  In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like Transaction log and VLF management, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey's consistency checks were taken from 7 days down to 6 hours.
Speaker(s): Argenis Fernandez,
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
Speaker(s): Grant Fritchey,
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:
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:
Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework. Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.
Speaker(s): Richie Rump,
Abstract:
Database development has traditionally been done using SQL Server Management Studio query window as the primary tool, when far more powerful tools are available in your toolset. This is the equivalent of writing a document using Notepad, when MS Word is available on your desktop. This session will take you through some of the basics of using SSDT, show you how to use VS2012 database projects effectively, how to utilize TFS build, test and deploy your code. I've had my share of bumps on the road to deploying these toolsets. At the end of this session you will have a good introduction into how to use the tools and how to avoid some common issues with legacy code you are already have in your environments.
Speaker(s): miguel Cebollero,
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. Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He'll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.
Speaker(s): Chris Skorlinski,
Abstract:
System.Xml.XmlElement
Speaker(s): Rob Volk,
Abstract:
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie (the creator of Biml) will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of *hundreds* of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.
Speaker(s): Scott Currie,
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Speaker(s): Allen White,
Abstract:
With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What's needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who's been building SQL Server clusters since 2000 (the year and the version!). We'll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it's pretty cool!).
Speaker(s): Sven Aelterman,
Abstract:
If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.
Speaker(s): Jon Boulineau,
Abstract:
DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will analyze growth patterns in databases, witness job failures interactively across hundreds of servers, discover elevated permissions in a flash and watch a movie of your infrastructure growing and changing before your eyes.
Speaker(s): Rodney Landrum,
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:
In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
Speaker(s): Damu Venkatesan,
Abstract:
Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.
Speaker(s): David Klee,
Abstract:
The Tabular model is the new kid on the block in Analysis Services 2012. Based on xVelocity, a new highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. Join me in this introductory-level session focusing on how Tabular fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live demo where we'll build a basic Tabular model in visual studio.
Speaker(s): Bill Anton,
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:
The time for predictive analytics to go mainstream has finally come! Business users and BI Pros can use the Microsoft SQL Server and Microsoft Office to unleash predictive analytics and unlock hidden patterns. Join this session to learn how a data scientist can use the Excel Data Mining add-ins to perform predictive analytics with Excel data. I'll provide also the necessary fundamentals for understanding and implementing organizational predictive models with Analysis Services.
Speaker(s): Teo Lachev,
Abstract:
Many SQL Server performance issues can be solved with the information from the DMVs, even if it is collected only after the occurrence. But why was it fine yesterday and a problem today? On modern server systems, problems may be infrequent, but they do still occur. And so we may have neglected to collect data on a routine basis. It is important to collect sufficient information to diagnose and a resolve a problem. Too many third party tools to stop after identifying a problem on the presumption that the DBA’s responsibility ends with passing this information to someone else. I have automated the collection and partial analysis of index usage, query execution statistics and executions plans in my tool ExecStats.
Speaker(s): Joe Chang,
Abstract:
SQL Database is part of the Microsoft Azure platform. The SQL Database component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft data-centers around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations. ***It is assumed that you have familiarity with SQL Server.
Speaker(s): Ryan Duclos,
Abstract:
In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).
Speaker(s): Louis Davidson,
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:
SQL Server Integration Services (SSIS) 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as we can get through! Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and many others. If you haven't seen what has been updated in SSIS 2012, this will be the session to cover the most!
Speaker(s): Steve Wake,
Abstract:
Leveraging the Microsoft BI stack to grab multiple Excel files from SharePoint folders, merge them together, and ultimately bring them into Tableau Desktop for additional analysis. The solution will help with the common problem when different regions of a company are submitting different versions of the same Excel document/report which need to be combined and analyzed as a whole. Rather than downloading and manually merging dozens of documents, this solution will detail the automated process for making this happen.
Speaker(s): Nelson Davis,
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
Speaker(s): Denny Cherry,
Abstract:
Ask The Experts is an open clinic/lounge area, where you can ask questions of our participating Experts and get answers to your most vexing problems. The clinic will be open throughout the day, and we will be awarding prizes for your toughest questions, so bring 'em on!
Speaker(s): Rob Volk,
Abstract:
This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.
Speaker(s): David Dye,
Abstract:
WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.
Speaker(s): Michael French,
Abstract:
Do Availability Groups sound like a perfect fit for your High Availability and Disaster Recovery needs, but there is the initial fear of a new technology? As the primary support of your organization's databases and surrounding technology, you need to have the troubleshooting knowledge for those reactive scenarios when data availability is on the line. Join a Microsoft SQL Server Premier Field Engineer as he dives into his troubleshooting methodology, as well as showing you common pitfalls that he has dealt with out in the wild. Walk out of this session with the tools and confidence to support AlwaysOn Availability Groups.
Speaker(s): Thomas Stringer,
Abstract:
I got promoted to management a couple of years ago, and despite what I previously believed, there were no fluffy pillows and bottles of champagne awaiting me. My team liked me, but they didn't exactly stoop and bow when I entered the room. I've spent the last year relearning everything I thought I knew about management, and what it means to be a manager of a technical team. This session is intended for new managers, especially if you've come from a database (or other technical) background.
Speaker(s): Stuart Ainsworth,
Abstract:
In this session we will look at real world experiences using recursive CTEs. Starting with the basics of putting together CTEs, adding recursion, using more complex queries and then using the queries to calculate n-level of financial balances. Additionally we will look at going from parent-child and child-parent
Speaker(s): Ken Colson,
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:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
Speaker(s): David Dye,
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
Speaker(s): Tamera Clark,
Abstract:
This session will concentrate on features of SSDT as it pertains to creating and updating data structure while incorporating your databases into source control management as well as full application lifecycle management. Discussion will include structure management, seeded data management and deployment. Build integration features will also be part of the talk. Learning objectives 1. Core features of SSDT 2. Source control and artifacts creation 3. Refactoring and build integration
Speaker(s): Sergey Barskiy,
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
Speaker(s): Tim Radney,
Abstract:
As a DBA, my personal least favorite part of the development lifecycle is pushing changes to production. It means adding something unknown (no matter how well tested) to an environment that is considered stable and reliable. Plus there are other things that myself (and I'm sure developers as well) would rather be doing. In READY FOR PROD (caps for emphasis), we will explore how I believe pushing T-SQL script, SSRS reports, and SSIS packages to production should go, and I encourage those in the audience to participate so we can get an idea of how other environments push code as easily or painfully as possible.
Speaker(s): Robert Verell,
Abstract:
There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged. In this presentation, I'll tell you what minimal logging means in conjunction with each of the three different recovery models. In addition, I’ll describe the benefits and dangers of the SIMPLE Recovery Model.
Speaker(s): Kalen Delaney,
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
Speaker(s): Jason Carter,
Abstract:
In this session, we will explore how powerful Excel has become as a Data Visualization tool. Using Analysis Services as a data source, we will create dashboards, report books, and some slick custom reports that you may have never imagined possible in Excel.
Speaker(s): Justin Stephens,
Abstract:
In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.
Speaker(s): Argenis Fernandez,
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
Speaker(s): Pam Shaw,
Abstract:
This lecture (20% slides, 80% demonstrations) takes a close look at the new features of Windows Server 2012 R2 clustering and how it affects your SQL Server availability. In addition, the new availability features of SQL Server 2014 will be reviewed. This session is geared for those new to Windows Server clustering and SQL Server AlwaysOn but will also be beneficial to those with experience looking to learn about the new high availability features in both Windows Server 2012 R2 and SQL Server 2014.
Speaker(s): David Bermingham,
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:
In this presentation I'll explain what the new SQL 2012 AlwaysOn high availability and disaster recovery solution is all about. I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration and the new capabilities it gives us.
Speaker(s): Ryan Adams,
Abstract:
BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.
Speaker(s): Julie Smith,
Abstract:
Think you know SQL Server? Test your knowledge with (and against) our Experts! Quiz Bowl will consist of several 2 person teams, one attendee and one Expert. Teams will compete for a very nice prize. Please visit our Ask The Experts clinic before lunch and ask a challenging question! You can receive one of a limited number of tickets to participate in Quiz Bowl. Please note that Quiz Bowl is being held in Room 223 during the lunch break. Additional prizes may be awarded at the end of the day for ticket holders who were not selected to compete.
Speaker(s): Rob Volk,
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter. In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Speaker(s): Tim Mitchell,
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:
Cubes and Excel go together like peanut butter and jelly. However, some questions cannot be answered by browsing a cube. Multidimensional Expressions, or MDX, unlock the full potential of your multidimensional data. Learning MDX requires a clear understanding of some fundamental concepts. Change your mental model, and advance past the MDX learning curve.
Speaker(s): Lance England,
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:
Multiple index strategies to help improve database performance, Part of the topics covered in this session are: - Noncluster Coverage - Page Split - Heaps - Filtered Indexes - Clustered Indexes
Speaker(s): Kenneth Urena,
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:
In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Mark Tabladillo and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
 Someone tells you that they believe SQL Server is having a performance issue, what now? Their query or stored procedure took a very long time to run. Can you help them? Do you even know where to begin to help them? Most sessions I've attended on performance tuning seem to start in the middle. They take the approach that the audience has some understanding on how or where to start. In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow".
Speaker(s): Ed Watson,
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.
Speaker(s): Kevin Boles,
Abstract:
Excel-erate All The Data! Power Query finishes the Microsoft Self Service (read: inside Excel) BI Stack by providing Extract-Transform-Load capabilities Come and watch Julie and Rob demonstrate this fun and useful new tool.
Speaker(s): Julie Smith,
Abstract:
Power BI for Office 365 delivers a compelling set of Self-Service BI tools and services for the discovery, analysis, and visualization of on-premises and cloud-based data. In this session I will introduce Power BI, with a focus on self-service information management (SSIM) and data stewardship. You'll leave with a solid understanding of the capabilities of the Power BI platform, how it can empower business users and data experts within an organization, and how to get started right away.
Speaker(s): Patrick LeBlanc,
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
Speaker(s): Wendy Pastrick,
Abstract:
GIS data is used everywhere for many reasons. We are all used to digitally navigating maps on our computer or device. How can we use Sql Server and a network (map) to solve some of those same problems without leaving the server’s process? Then, once you have solved a network for one business case, what other problems can you solve with the same algorithm but in a different business domain and using a different network?
Speaker(s): Dan Holmes,
Abstract:
This session porvodes case studied in rewritign bad SQL, with a lot of discussion on what makes sql code "bad"
Speaker(s): Jeffrey Garbus,
Abstract:
Our SQL Server 2012 Always On system with 12 months in production and an 8TB data, you can learn from our experiances, the Good (yes, there are some really cool features), the Bad (not really bad, but features you need to know about) and the Ugly (outagess, causes and resolutions). The session will cover the new SQL Server 2012 Always on functionality and provide hands on examples to features along with a review of how we used SQL Server Always on in a VLDB environment.
Speaker(s): Eric Peterson,
Abstract:
Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta, Mark Tabladillo and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.
Speaker(s): Paul Turley,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/patrickdleblanc
Contact: http://patrickdleblanc.com
Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
Chris Skorlinski has been with Microsoft for 20 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting in Replication and Windows Azure SQL Database. His MSDN blog http://blogs.msdn.com/ReplTalk/ contain Best Practices, How To, and Inside Replication tips for configuring and turning SQL Server Replication while http://blogs.msdn.com/SQLDatabaseTalk/ covers Windows Azure SQL Database topics.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
Justin has over 16 years of experience working with the Microsoft BI Stack. He began is BI career developing ASP/ASP.NET Custom Reports using MDX Queries against Analysis Services cubes. Over the years he has gained his MCITP in Business Intelligence for SQL Server 2008 R2, MCSA for SQL Server 2012, and MCSE in Business Intelligence for SQL Server 2012/2014 certifications. He is currently working as a Senior BI Contractor. When he is not working, you will find him on the Tennis courts.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: https://www.linkedin.com/in/rgverell
Contact: http://sqlcowbell.com/wordpress/
Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User's Group, a volunteer for SQLSaturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.
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/allen-white-sql-server-mvp/5/784/b08/
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
LinkedIn: https://www.linkedin.com/in/sqlmiguel
Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015
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
LinkedIn: http://www.linkedin.com/pub/bill-anton/12/526/4bb
Contact: http://byobi.com/blog/
Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/in/jonboulineau
Contact: http://jonboulineau.me
Jon Boulineau works as a Data Architect and Data Engineer in Nashville, TN.
Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/
Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: http://linkedin.com/in/richierump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
LinkedIn: http://www.linkedin.com/in/ryanjadams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
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.
LinkedIn: http://www.linkedin.com/in/tameraclark/
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
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.
LinkedIn: https://www.linkedin.com/in/michaellfrench
Michael French is a Senior Consultant with Pragmatic Works. He has been working with SQL Servers for 20 years . In his spare time, he supports his community by training adult volunteers with Boy Scouts and serving with his national fraternity.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
Contact: http://clusteringformeremortals.com/
David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.
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.
LinkedIn: https://www.linkedin.com/in/stuartainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He's a former DBA, developer, consultant, and public speaking professor. He's one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday's. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
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/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: http://www.linkedin.com/in/watsoned
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
LinkedIn: https://linkd.in/svena
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
LinkedIn: http://www.linkedin.com/in/b5lurker
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
LinkedIn: https://www.linkedin.com/in/lanceengland
Contact: http://lance-england.com
Lance England is a data professional focused on data, analysis, integration, and automation using SQL Server, Power BI, DAX, SQL Server Analysis Server, BizTalk, PowerShell, C#, and more. He has industry experience in health care, manufacturing, property rental, and non-profit sectors.
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: 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/pshaw1129/
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
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.
Contact: http://jason-carter.net
Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator
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/in/juliesmith0503/
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer--but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
LinkedIn: http://www.linkedin.com/in/dnhlms/
Contact: http://sql.dnhlms.com
Dan Holmes has been developing in Microsoft technologies for 20 years using BASIC, VB, C#, c, and SQL Server from version 7 onwards. He worked as a developer building a warehouse management system as well as custom programming. His current position at RouteMatch software is as the Director of Database Technologies. He has spoken at SQLSaturdays in Atlanta on topics that range from dynamic object creation, GIS solutions and other out-of-the-box ideas. He is a recent graduate of GA Tech with his Masters in Computer Science.
LinkedIn: http://www.linkedin.com/in/tlachev
Contact: http://prologika.com/cs/blogs
Teo Lachev is an internationally-recognized authority on Data Analytics. Through his Atlanta-based company Prologika, a Microsoft Gold Partner in Data Analytics, he helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several bestselling books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Teo has been a Microsoft Most Valued Professional (MVP) Data Platform since 2010.
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
Thomas Stringer is a SQL Server Premier Field Engineer at Microsoft, and specializes in High Availability, Disaster Recovery, performance, administration, development (C/C++ and .NET/C#), scripting (PowerShell), and other aspects of data.
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).
LinkedIn: http://www.linkedin.com/in/argenis
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
LinkedIn: http://www.linkedin.com/in/argenis
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
LinkedIn: http://www.linkedin.com/in/damuvenkatesan/
Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
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.
Contact: https://ken-colson.squarespace.com/blog/
I am the CTO at a Nashville based start-up in the financial industry. I have worked with databases for more than 20 years, often as the database architect, chief query writer and part-time DBA. I have developed data-driven applications in various industries including finance, healthcare and higher-education.
LinkedIn: http://www.linkedin.com/in/juliesmith0503/
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer--but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Contact: http://DotNetSpeak.com
Sergey Barskiy is an architect with Tyler Technologies. He is a Microsoft MVP. He holds the following certifications: MCPD, MCTS, MCSD for .NET, MCAD for .NET, MCDBA, MCP. He has been working with Microsoft technologies for 15 years. He is a frequent speaker at various regional and national conferences, such as VS Live, DevLink, CodeStock, and Atlanta Code Camp as well as local user groups. He is one of the organizers of Atlanta Code Camp and Atlanta Windows Apps users group.
LinkedIn: http://www.linkedin.com/profile/view?id=31625242
Scott Currie is the founder and CEO of Varigence, Inc. Scott has led the development at Varigence of the Business Intelligence Markup Language (Biml) and Mist IDE. Before founding Varigence, Scott worked at Microsoft for seven years on the .NET Framework, Visual Studio, the C++ compiler, various customer connection initiatives, and internal BI/DW projects.
LinkedIn: http://www.linkedin.com/in/arcanecode
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate's SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
LinkedIn: https://www.linkedin.com/in/sqlcr
Contact: http://www.sqlcr.com
Kenneth Ureña is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016. Kenneth has performed the role of Database Developer, Database Architect and Database Administrator, always relying on his disaster recovery and performance tuning skills. He co-leads the Global Spanish Virtual chapter of PASS. PASS LatAm Regional Mentor, he speaks at multiple SQL Server events in both Spanish and English. Kenneth holds multiple SQL server certifications.
LinkedIn: http://www.linkedin.com/in/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Over 30 years of Professional experiance with 25 of those in database design, SQL programming, DB implementation and DB support.
LinkedIn: https://www.linkedin.com/in/kerrytyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Contact: http://thevizioneer.blogspot.com
Nelson Davis recent joined Slalom Consulting, helping the Information Management team leverage Tableau Software and data visualization best practices.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
The following is a list of sponsors that helped fund the event.


Calculates conditional exact tests (Fisher's exact test, Blaker's exact test, or exact McNemar's test) and unconditional exact tests (including score-based tests on differences in proportions, ratios of proportions, and odds ratios, and Boshcloo's test) with appropriate matching confidence intervals, and provides power and sample size calculations. Gives melded confidence intervals for the binomial case. Gives boundary-optimized rejection region test (Gabriel, et al, 2018, <doi:10.1002/sim.7579>), an unconditional exact test for the situation where the controls are all expected to fail.
| Version: | 1.6.3 |
| Depends: | R (≥ 2.10), stats (≥ 3.1.1), exactci, ssanv |
| Suggests: | testthat, Exact |
| Published: | 2018-07-27 |
| Author: | Michael P. Fay, Sally A. Hunsberger, Martha Nason, Erin Gabriel |
| Maintainer: | Michael P. Fay <mfay at niaid.nih.gov> |
| License: | GPL-3 |
| NeedsCompilation: | no |
| Citation: | exact2x2 citation info |
| Materials: | ChangeLog |
| CRAN checks: | exact2x2 results |
| Reference manual: | exact2x2.pdf |
| Vignettes: |
exact2x2: Overview exact2x2: Validation of Unconditional Exact Tests Exact McNemar's Test exact2x2: mid-p adjustment exact2x2: Unconditional Exact Tests |
| Package source: | exact2x2_1.6.3.tar.gz |
| Windows binaries: | r-devel: exact2x2_1.6.3.zip, r-release: exact2x2_1.6.3.zip, r-oldrel: exact2x2_1.6.3.zip |
| OS X binaries: | r-release: exact2x2_1.6.3.tgz, r-oldrel: exact2x2_1.6.3.tgz |
| Old sources: | exact2x2 archive |
| Reverse depends: | asht, pCalibrate |
| Reverse imports: | ggstatsplot |
| Reverse suggests: | jmv |
Please use the canonical form https://CRAN.R-project.org/package=exact2x2 to link to this page.


{{ post.title }}
{{ post.subtitle }}
{% if post.recommended %} Recommended {% endif %} {{ post.category.name }} {{ post.length }} readI like writing about food, my work and (sometimes) my personal life. My views are entirely my own.
{{section.category.name}}
{% for post in section.posts %}{{ post.title }}
{{ post.subtitle }}
{% if post.recommended %} Recommended {% endif %} {{ post.category.name }} {{ post.length }} read


Preparation time
30 mins to 1 hour
Cooking time
10 to 30 mins
Serves
Makes 12
Dietary
Delicate macarons flavoured with blackcurrant and mint.
Preheat the oven 150C/300F/Gas 2. Blend the icing sugar and almonds in a food processor to a fine powder.
Whisk the egg whites, cream of tartar and caster sugar in a stand mixer, gently at first and gradually increasing the speed, add a drop of the food colouring just before the soft peak stage is reached, and continue until the egg whites reach the soft peak stage (the soft peak stage is when the peaks drop slightly when you lift the whisk out of the bowl).
Sift the flour and almond powder into a separate bowl, then fold in a third of the meringue. Continue to add until all the meringue is incorporated and looks smooth and glossy. It should behave like it is flowing ‘magma’ when a spoon drags it to the sides of the bowl. Slacken with a teaspoon or two of lightly whipped egg white if this stage is not reached.
Fill a piping bag with a 2-3mm/1/8in nozzle with the macaroon mixture. Line a baking tray with parchment paper.
Pipe 3cm/1¼in wide circles of mixture onto the parchment, set 3cm/1¼in apart.
Tap the tray underneath two or three times to release trapped air in the macaroons and set aside until they are dry to the touch (at least 15 minutes).
Bake for 13-15 minutes, until the macaroons can be easily lifted off the parchment with a palate knife. Remove from the oven and set the macaroons to cool on a wire rack.
To make the ganache, melt the chocolate in a bowl set over a pan of simmering water, and heat to no more than 45C/113F (use a thermometer to measure this).
Blend the blackcurrants in a food processor and sieve them. Measure out 100g/3½oz of the juice and bring it to the boil in a small pan. Add the peppermint essence and raspberry extract to the juice.
Pour the hot juice over the chocolate and stir rapidly until well combined.
Transfer the ganache to a bowl, cover with cling film and put in the fridge to cool and thicken.
Once cooled a little, transfer the ganache to a piping bag, and pipe a small amount of ganache, from the centre outwards, on one half of the macaroon shells.
Sandwich the macaroon shell with another to form a pair.
Chill the macaroons in the fridge to firm up.


TO
Do for 0.97 Release
MUST (we will hold shipment
for these)
- GUI
needs to have symbol/icon for LED buttons
- Spot will become ____
- Clean will become ____
- Dirt will become ____
- Max will become ____
- Doc (D rotated) will become ____
- CheckRobot (C rotated) will become ____
- top line(None-green-red-orange) Only visible for
400(SCI)
- Bottom line (Dock and Checkrobot) Only visible
for 500 (OI)
- Check in web GUI into TOT & make it work/build
- Update web app interface to include network IP connection &
make web GUI match functionality of roombacomm GUI
- Rename bsquare to something better
- Put ser2net into the tree (subject to licensing)
What is the licensing question here?
- make ant build the tree, make a build & a doc target & an
install target (does what the build script used to do)
- make the dummy's buildit/makeit shell scripts & put them in
the right directory both for source control & for distribution
- restructure TOT to a new directory structure that’s
documented & standard
- Merge changes from JMP097Working to TOT
Docs
- Create readme for svn & eclipse
- fix copyrights
What should the copyrights be? Can someone put
the standard info into this doc?
- make docs into hyperlinked html files
- document how to set up apache to make the web server work
- document how to make ser2net work as a network server on a router
(how to build/run)
- document the new directory structure
HI-WANT (we plan to put these in, but priorities may intercede)
- Make BumpTurn & others commandline programs work over the
network
- Make front bumper press stop the roomba's motors when driving in
controlled mode.
- make javadocs & link into doc system
- Get permission to bundle MyGUI with this package, or document
where it can be found. Bundle it into the zip file
WANT (these are desirable and will be worked on opportunistically)
- First time after poweron, the LEDs flash but don't stay on. Fix
it. (sometime, not necessarily for 0.97)
- Add Motor exerciser panel to RoombacommGui
- Make it so the model of roomba can be discovered (400 vs. 500
family, & maybe sub-models within the family)
- move connection settings in roombacommGUI to its own dialog
- Fill out the the sensor numbers/groups for 5xx models, &
develop masks & figure out the corresponding reply length for the
extra groups, and for querylist (sometime, not necessarily for
0.97)
- Implement failsafe in ser2net or shell script on router
- Make roombasrvr able to serve the serial connection
- Evaluate additional API capabilities that Roombacomm should maybe
support, such as other sensor reading modes (querylist, stream),
scheduling capability or others
- Request permission from iRobot to publish the OI spec in the
release
- Fix net folder under roombacomm root - it won't build
- Fill out the the sensor numbers/groups for 5xx models,
& develop masks & figure out the corresponding reply length for
the extra groups, and for querylist
- First time after poweron, the LEDs flash but don't stay on. Fix
it.
VERIFY (these are thought to be complete but need checking)
- Change the GUI to deal with with smaller screens
We have some users
running it on netbooks. Looking at the specs, seems they may have a
display as low as 1024x600 resolution. This does not leave room for the
task bar. So I think a version that is 480 height would make sense,
allowing for title-bar height etc, but width can be wider than 640 if
you want.
- Maybe move to some command line options for GUI layout
- --GUI=1024x768 or --GUI=640x480
- --GUI=NNNxYYY (support of variable values?)
- Update Power LEDS for 500 series, also make the sliders work the
power leds in realtime. Paul thinks it works - what's broken?
- Update roombacmd - change baud rate to SCI/OI
- fix bug in simpletest on router if no parameters are given.
- Verify that roombacomm doesn't exit if there are no serial ports


{% extends "base.html" %} {% block title %} Best Flights In Django {% endblock title %} {% block content %} Latest Flights {% for flight in flight_list %} {% if flight.has_departed %} {% else %} {% endif %} ₹ {{ flight.price }} {{ flight.origin }} to {{ flight.destination }} Flight Duration: {{ flight.duration }} {% endfor %} {% endblock content %}
Flight Duration: {{ flight.duration }}


Fares may not be listed if your routing involves travel via a stopover point with change of flight number/aircraft. You may consider booking using the Multi-city option. Infants must be below the age of 2 years before the completion of a One Way/Return journey, OR you will need to use the Child option for proceeding further with the booking. You may also choose to contact the local Air India office for the issuance of such tickets.
Would you like to book as a Concessionary Passenger?


The Associates and Analysts will be divided into 4 final ranking meetings for the mid-year 2001 PRC. These meetings are scheduled as follows:
EES Associate & Analyst Final Meeting - June 8
EBS Associate & Analyst Final Meeting - June 19
EWS/Others* Associate & Analyst Final Meeting - June 25
EA Associate & Analyst Final Meeting - July 9
*(EWS/Others includes Associates and Analysts from EWS, EGM, APACHI, CALME, CORP, ECM, EIM, EIP, ENW, ESA, ETS, EOTT, HPL, PGE, EWC, Japan, and EnronCredit).
The Associates and Analysts will be ranked within the following Peer Groups:
Analyst 1 - Analysts with up to one year of service (hired between 3/1/00 and 2/28/01)
Analyst 2 - Analysts with greater than one year of service (hired prior to 3/1/00)
Associate - All Associates hired prior to 3/1/01
Associate and Analyst Ranking Process
Analysts and Associates hired on or after 3/1/01, will receive feedback only, all others will receive both a PRC ranking and feedback.
Each Business Unit Supervisor will be responsible for providing a pre-ranking to the PRC Rep. The PRC Reps have access to the consolidated feedback for each assigned Associate and Analyst. Please be sure that you have met with the assigned PRC Rep prior to the final Associate and Analyst meeting for your business unit. (Your business unit HR department may choose to set up pre-ranking meetings - check with your HR representative). The final ranking for each Analyst an Associate will be determined through a cross calibration in each of the final meetings. In these final meetings, the Analysts and Associates will be represented by a PRC Rep from their Business Unit who should be familiar with their accomplishments.
Associate and Analyst PRC Reps
Please refer to the attached spreadsheet for a list of Associates and Analysts who will be ranked in these meetings and their PRC Reps.
Contact me at extension 35230 if you have any additional questions.
Terry Bosien
HR Manager, Associate and Analyst Program
***********
EDRM Enron Email Data Set has been produced in EML, PST and NSF format by ZL Technologies, Inc. This Data Set is licensed under a Creative Commons Attribution 3.0 United States License <http://creativecommons.org/licenses/by/3.0/us/> . To provide attribution, please cite to "ZL Technologies, Inc. (http://www.zlti.com)."
***********
California


Wizard
A subtitle can go here
-
Orders 847
-
Reviews 223
-
New visits 7930
Create Server
Name & FQDN
To begin, please enter the IP of your server or the fully-qualified name.
Optionally, give this server a label. This will appear in the server nagivation.
Server Group
Where would you like server to go?
Service Selection
Please choose the services you'd like Panopta to monitor. Any service you select will be given a default check frequency of 1 minute.
Monitoring Location
We determined Chicago to be the closest location to monitor If you would like to change this, or you think this is incorrect, please select a different monitoring location.
Notification Schedule
Select the notification schedule to be used for outages.
Agent Setup
The Panopta Agent allows you to monitor local resources (disk usage, cpu usage, etc). If you would like to set that up now, please download and follow the install instructions.
You will be given a server key after you install the Agent on . If you know your server key now, please enter it below.


an old portrait on a new canvas
an old portrait on a new canvas broken thoroughfares and sharply cut steel twist and burn through sedant turns and milky shadows the sun smolders through fleshy clouds cigarettes streak tender embers on the cobblestone the city hushes it rushes and roars and stands still with a passion for pause the wind sears like acid kisses prying at hazel picture frames until i am weeping clarity my eyes seep ash that tumbles down my nose and dis - solves on my palette with a finish of oak and prairie grasses the time passes and i find rapture in crooked corners i check my pulse and it hums like an engine to the rhythm of the city i am a collective i am an exclamation we are fashioned from splintered roots, clay, and a trem - bling wick a vantage point on glowing living rooms and vibrating floors the city harmonizes with the energy of melting ore the steady drum of time beats forward each crude cast of progress and we ride the kinetic waves rippling outward from the hub speaking in metal spokes and soldered phrases a syntax of works and fevered sweat we are drawn to the heat we huddle closer to the core in an instant the world is dark and cold a black swan on a moonless pond slick with midnight dew and we step back out into the prickling street and shuffle towards home our silhouettes are lost among the shingles and the eaves blanketing the city in patchwork malaise it is dawn and clear and the moon lingers to acknowledge salutations smiles and a bid good day we speak in muttered tongues so as not to wake the others we whisper about the sunrise and poke fun at the intrepid skyline when shall we meet again i ask the moon frowns and disappears with a lingering gaze look skyward for a glimpse of a retreating riposte i sit for hours lost in conversation with my memories i become my memories i become the moon and we meet again i have met myself again i have met myself i have met i have i


% include("/template/includes/jquery.html"){} %> <% include("/template/includes/bootstrap.html"){} %>


Websites can have widgets that load relatively slow, which can cause flakyness in the crawling or while testing. With WaitConditions the user can specify that in wich url (or part of the url) Crawljax should wait for certain elements or widgets to become visible.
waitFor(String url, ExpectedCondition...expectedConditions) {
waitFor(String url, int timeout, ExpectedCondition...expectedConditions)
Wait for a list to be loaded on the #contact page.
CrawljaxConfigurationBuilder builder = CrawljaxConfiguration.builderFor(URL); ... builder.waitFor("#contact", new ExpectedVisibleCondition(By.id("contactList")));


{% extends "base_error.html" %} {% block error_title %} Not found {% endblock error_title %} {% block error_content %} Sorry, but we couldn't find the page you were looking for. {% endblock error_content %}


This is the privacy policy for XML Notepad.
This app does not share anything about you or your XML documents with anyone.
This is not a privacy policy for Windows, Windows may keep track of app usage for the purpose of monitoring windows and windows app quality. See Microsoft for more infomration.
If you have any questions about this app please email Chris Lovett.


Picture
Order your Book
Thank you for using chris' book buying service
Book Details
- Cover -
Paper Back
Hard Cover
Delivery Information
- Provience -
Alberta
British Columbia
Manitoba
New Brunswick
Newfoundland and Labrador
Nova Scotia
Ontario
Prince Edward Island
Quebec
Saskatchewan
Northwest Territories
Nunavut
Yukon
Payment Information
Visa
MasterCard
American Express


TennCare members’ information subjected to email breach
NASHVILLE, Tenn. (AP) - Officials say the private information of nearly 44,000 TennCare members may have been stolen during a breach of the email system of a vendor for the state’s Medicaid agency.
The Tennessean reports that Magellan Health Systems says information including members’ names and social security numbers was potentially compromised because a Magellan employee was subjected to a phishing scheme.
Magellan says in a news release that the scheme allowed access to the employee’s email account, which contained members’ information. Magellan is TennCare’s pharmacy benefits manager.
Magellan said a third-party investigation found no evidence the hacker who accessed company emails “actually accessed, viewed or attempted to use” the information, but members’ protected health information still may have potentially been accessed.
A TennCare spokeswoman says 43,847 people may have been affected. Affected members are being notified.
Information from: The Tennessean, http://www.tennessean.com
Sign up for Daily Newsletters
Copyright © 2019 The Washington Times, LLC.
Please read our comment policy before commenting.


TRAIN TIMES
Train Name
Destination
Frequency (min)
Next Arrival
Minutes Away
Train Name:
Destination:
Frequency (mins):
First Train Time:
Add New Train