SQLSaturday #235 - New York City 2013
Event Date: 08/17/2013 00:00:00
Event Location:
- Microsoft Offices Midtown Manhattan
- 1290 Avenue of the Americas
- New York City, New York
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Big Data-BI Fusion: Microsoft HDInsight MS BI
Abstract: HDInsight is the name of Microsoft’s distribution of Apache Hadoop, the essential and defining technology of the Big Data world. But why in the world would Microsoft embrace an open source technology, written in Java, and customarily run on clusters of Linux servers? Two words: Business Intelligence. HDInsight (and Hadoop in general) become far more enterprise-friendly when combined with Microsoft BI technologies like PowerPivot, Analysis Services and Power View. And then there’s SQL Server Parallel Data Warehouse, which actually blends the BI and Big Data worlds together in one product. In this session, Microsoft BI expert and ZDNet Big Data blogger Andrew Brust will introduce you to HDInsight and its developer tools, demonstrate relevant BI tools and show how they work together. He’ll also show how developers with relational database skills can make the jump into this exciting and opportunity-filled area.
Speaker(s):
- Andrew Brust
Track and Room: Track 1 - N/A
Title: Advanced T-SQL Development with latest features.
Abstract: In the last three releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking functions (ROW_NUMBER, RANK, DANGERANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker(s):
- Alex Grinberg
Track and Room: Track 2 - N/A
Title: Surviving Your Peak Database Load
Abstract: Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these time frames is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.
Speaker(s):
- Ben DeBow
Track and Room: Track 2 - N/A
Title: How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition
Abstract: Learn how to make your next SQL Server deployment or tech refresh the basis of a consolidated, elastic, self-managed SQL Server utility. This session will help you understand how to build a highly available SQL Server farm to maximize flexibility and agility while avoiding the traps that force you to SQL Server Enterprise Edition.Are you currently dealing with…• Standards that force the most expensive software stack? • High licensing and yearly subscription costs associated with vendor lock-in?• Multiple deployment models that increase project complexity and dependencies while reducing your flexibility and agility? Wouldn’t you like to…• Reduce the cost of both SQL Server licensing and infrastructure?• Have a single operational model that solves all deployment requirements?• Deploy the edition of SQL server that best solves the business problem without being forced to Enterprise Edition?
Speaker(s):
- Carl Berglund
Track and Room: Track 7 - N/A
Title: How to Build a Centralized Database Monitoring Solution – Never Miss a Backup
Abstract: As every DBA knows, the one question you want to be able to answer affirmatively is “Can you recover that data?”
Monitoring is critical, but monitoring methods can be imperfect. Traditional methods are difficult to set up and maintain across your entire environment, resulting in incomplete monitoring and missed alerts, so that it’s difficult to be sure of your answer to that all important question.
This presentation will:
• Show you how to implement a better way to monitor your database environment that is more efficient, easier to maintain, and guarantees that you never miss an alert. • Share the methodology, framework, and key syntax, so that you are certain the databases you are responsible for are always up, always backed up, and never run out of disk/file space.
So that your answer to that all important question is always YES!
Speaker(s):
- John Abrams
Track and Room: Track 7 - N/A
Title: Into the Blue: Extending AlwaysOn Availability Groups
Abstract: For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 2 - N/A
Title: Database Development with SQL Server Data Tools
Abstract: With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and Windows Azure SQL Database. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the new generation of database tools for developers!
Speaker(s):
- Leonard Lobel
Track and Room: Track 5 - N/A
Title: Windows Azure SQL Database Design: Silver Lining and Dark Side
Abstract: Data modelers and designers need to understand the logical, physical, and technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases. In this session, we’ll review the concepts that still work in both and the features that need to be tailored to each target environment.
You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. The session will feature a demonstration of a complete life cycle roundtrip – data model to database and back to data model – and tips and tricks for creating and maintaining WASD database designs. We’ll finish up with 10 tips for designing databases for both WASD and SQL Server.
Speaker(s):
- Karen Lopez
Track and Room: Track 5 - N/A
Title: SQL Server Internals and Architecture
Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:
- What’s different about 32- and 64-bit systems?
- What are the various areas of memory inside of SQL Server?
- How are queries handled behind the scenes?
- What does SQL Server do with procedural code, like functions, procedures, and triggers?
- What happens during checkpoints? Lazywrites?
- How are IOs handled with regards to transaction logs and database?
- What happens when transaction logs and databases grow or shrinks?
Speaker(s):
- Kevin Kline
Track and Room: Track 1 - N/A
Title: HealthySQL
Abstract: Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)
Session Level: Beginner
Robert Pearl
Speaker photo Robert Pearl, President of Pearl Knowledge Solutions, Inc., SQL MVP/SME, solutions-oriented Senior DBA with 12+ years of experience. He’s a SQLCommunity/SQLSaturday evangelist/promoter and maintains his regular b
Speaker(s):
- Robert Pearl
Track and Room: Track 3 - N/A
Title: Using Power View Hadoop to Unlock Hidden Markets
Abstract: A practical way to derive business value from big data is to micro-target customers, but where do you begin? In this session, we examine real data from one of the nation’s largest cable TV providers and combine it with data from the 2010 census and other data sources. Then we walk through a demonstration of how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that you can use to connect more effectively with customers. Co-presented with Joey D’Antoni
Speaker(s):
- Stacia Varga
Track and Room: Track 4 - N/A
Title: Indexing your Data Warehouse
Abstract: One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.
Speaker(s):
- Troy Gallant
Track and Room: Track 3 - N/A
Title: SQL Server 2014 - Staying Ahead of the curve
Abstract: This session will discuss new features and improvements in SQL Server 2014 which is the next release of SQL Server. Topics will include In- Memory database engine, Always-On Improvements, Business Intelligence improvements and Cloud Enhancements.
Speaker(s):
- Ashish Sharma
Track and Room: Track 4 - N/A
Title: Database Health and Performance
Abstract: Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment’s overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker(s):
- David Klee
Track and Room: Track 3 - N/A
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract: In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
Speaker(s):
- Timothy McAliley
Track and Room: Track 8 - N/A
Title: How to audit and prevent unwanted user actions.
Abstract: Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers.
Speaker(s):
- John Miner
Track and Room: Track 8 - N/A
Title: SQL Server Databaseology 201
Abstract: Did you love “Bill Nye, the Science Guy” when you were a kid? Or maybe you were a MacGyver fan? Did you take apart your Mom’s toaster or your Dad’s alarm clock just to see how it ticked? Ever wonder how that database you built or support works behind the scenes? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures. This session will explore some of the deep inner workings of a SQL Server databases. The attendee will walk away with a deeper understanding of how SQL Server databases work which would allow them to build better and faster databases.
Speaker(s):
- John Morehouse
Track and Room: Track 7 - N/A
Title: The 10 Commandments of ETL
Abstract: ETL (Extract, Transform Load) processes are fundamentally important in any data warehouse environment, and there are many different ways in which to develop the components.
In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I’m sure it will work for you too!!
Speaker(s):
- Martin Schoombee
Track and Room: Track 6 - N/A
Title: Patch Management Strategies for SQL Server
Abstract: We all have to deal with applying some sort of update to Windows, SQL Server, and/or hardware. Keeping things up to date is crucial for supportability, not to mention other things like security, performance, and stability. Since patching often involves downtime, you need to be careful not only what you apply to avoid problems, but also find ways to minimize the impact to the business and end users. This session will cover topics such as how to approach patching including what changes you should and should not consume, features that may help you automate or script patching, and developing your own long term patch management strategy.
Speaker(s):
- Allan Hirt
Track and Room: Track 5 - N/A
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract: Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker(s):
- Paul Rizza
Track and Room: Track 6 - N/A
Title: Dealing With Errors in SSIS 2012
Abstract: This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
Speaker(s):
- David Dye
Track and Room: Track 6 - N/A
Title: Biml for Fun and Profit with SSIS
Abstract: Business Intelligence Markup Language is a game-changer. It provides a powerful mechanism to automatically create SSIS packages. The output of a Biml file is the same package you’d create using the UI, but Biml is exponentially faster and easily reusable. Come learn 1) basics of Biml 2) automating SSIS development and 3) creating packages dynamically from metadata.
Speaker(s):
- Samuel Vanga
Track and Room: Track 6 - N/A
Title: SQL Server Storage Engine under the hood
Abstract: How SQL Server performs I/O
How is SQL Server really accessing the data and log files on the disk? What’s done asynchronous and what’s synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what’s different when SQL Server is starting up. Which I/O Subsystems (including SSD) are best for which type of data and what’s the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Speaker(s):
- Thomas Grohser
Track and Room: Track 5 - N/A
Title: Data Flow Architectures in Software Development Life-Cycle
Abstract: The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
Speaker(s):
- Virginia Mushkatbat
Track and Room: Track 7 - N/A
Title: “Indexing” Encrypted Data
Abstract: As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker(s):
- Chris Bell
Track and Room: Track 7 - N/A
Title: SSIS templates, configurations and variables, oh my
Abstract: This session will investigate the benefits of package and logging management framework templates. Then we will move on to adding data connectors to your template packages and building these connectors into package configurations that use a common table to store all your connections and how this will save you time and effort. Then finally we will explore some of the useful things you can do with package configured variables
Speaker(s):
- Daniel Bowlin
Track and Room: Track 6 - N/A
Title: Recovery and Backup for Beginners
Abstract: We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.
In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He’ll also set the record straight around some very common myths around database recovery and backups.
Speaker(s):
- Mike Hillwig
Track and Room: Track 7 - N/A
Title: Indexes: The Basics
Abstract: SQL Server databases have indexes to help applications and reports run with the best performance. But, did you know that too many indexes or the wrong ones can actually hurt performance? Do you know what a clustered index is? What a non-clustered index is? How SQL Server actually uses indexes to help return the correct data? Attend this session to learn the basics about indexes and the answers to your indexing questions.
Speaker(s):
- Kathi Kellenberger
Track and Room: Track 3 - N/A
Title: Alright,WHY is the server REALLY running so slow!
Abstract: SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI’s may be incorporated into the mix.
Speaker(s):
- Steve Simon
Track and Room: Track 1 - N/A
Title: New version: Get-PowerShell | Get-SQLServer
Abstract: New version of the popular PowerShell+SQL Server presentation (presented in over 6 SQLSaturdays User Group events). PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the new PowerShell 3.0 language scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).
Speaker(s):
- SB Chatterjee
Track and Room: Track 8 - N/A
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over FORTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Track 2 - N/A
Title: Database Design: Size DOES Matter
Abstract: Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.
Speaker(s):
- Thomas LaRock
Track and Room: Track 1 - N/A
Title: The Transaction Log and How It Affects HA/DR
Abstract: When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You’ll be surprised to know that the transaction log is the most important part of your database.
Speaker(s):
- Edwin Sarmiento
Track and Room: Track 5 - N/A
Title: Minimally Invasive - Tools to Doctor Up Your Code
Abstract: This code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!
Speaker(s):
- Wayne Sheffield
Track and Room: Track 4 - N/A
Title: Data Career Paths and Decision Making Strategies
Abstract: In recent years Data Careers have expanded beyond the conventional role of a DBA. This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers. The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed. In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions.
Speaker(s):
- Melissa Demsak
Track and Room: Track 4 - N/A
Title: Query Optimization Crash Course
Abstract: Do you have users complaining that applications are running “too slow”? Do your DB traces look like a short story written by monkeys at typewriters? This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We’ll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
Speaker(s):
- Edward Pollack
Track and Room: Track 1 - N/A
Title: Building BI Solutions with Excel 2013
Abstract: If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went “all-in” with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.
Speaker(s):
- Steve Hughes
Track and Room: Track 6 - N/A
Title: Merge Replicaton Internals
Abstract: Merge Replication allows you to replicate data bi-directionally. It is designed for occasionally connected data islands which need to aggreate data centrally, and vice versa. This session covers merge replication internals, conflicts, resolvers including the business logic and stored procedure resolver, dynamic and static filtering and how to handle identity ranges.
Speaker(s):
- Hilary Cotter
Track and Room: Track 8 - N/A
Title: Indexing for performance
Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker(s):
- Jeffrey Garbus
Track and Room: Track 2 - N/A
Title: Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Abstract: This is a lecture and demonstration on how to deploy highly available SQL Server instances in the Amazon EC2 cloud presented by Microsoft Cluster MVP David Bermingham. Starting with preparing the EC2 environment including configuring the VPC, routing and security, Bermingham then continues on and shows you how to configure both AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters for cross availability zone failover.
Speaker(s):
- David Bermingham
Track and Room: Track 3 - N/A
Title: Upgrading to SQL Server 2012 with limited downtime
Abstract: With SQL Server 2012 released and going strong, we’re all wanting the latest and greatest, high performing, SQL Engine sitting on our servers. How we do that is another question. How do you get a weekend of downtime? Do you like convincing the business you need it? I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 with as little downtime as possible - minutes. In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time.
Speaker(s):
- Ted Krueger
Track and Room: Track 5 - N/A
Title: SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Abstract: In this presentation, I’ll compare the new Tabular Model in SSAS 2012 with the more “traditional” multidimensional OLAP in SSAS. I’ll show which of the 2 approaches works better in specific scenarios, and why you’d want to use one method over the other for certain applications. If you are trying to decide which approach to use, or if you are an experienced OLAP developer who wants to know the pros and cons of moving to the Tabular Model, this presenation is for you!
Speaker(s):
- Kevin Goff
Track and Room: Track 1 - N/A
Title: SQL Server 2012 AlwaysOn Availability Groups
Abstract: The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
Speaker(s):
- George Walters
Track and Room: Track 3 - N/A
Title: Virtualizing SQL 2012: Doing It Right
Abstract: A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing SQL Server databases with a heavy emphasis on VMware. Topics include Design, Storage, Processor, Memory Network considerations
Speaker(s):
- Michael Corey
Track and Room: Track 4 - N/A
Title: Automating in the Cloud
Abstract: We’ve heard all the awesome Cloud deployment stories, but DBAs can use the Cloud too! Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common administration problems by utilizing Cloud services in combination with PowerShell automation. In this session, we’ll review the basic Cloud architecture of both Azure and Amazon, as well as some specifics as to the components of the solution.
Speaker(s):
- Matt Velic
Track and Room: Track 4 - N/A
Title: SQL Server Sudoku Solver using Transact-SQL
Abstract: This session will provide an introduction to Transact-SQL using a stored procedure to solve a Sudoku puzzle as an example. Language elements covered will include use of variables, conditional logic, looping, and recursion.
Speaker(s):
- Kevin Feit
Track and Room: Track 8 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Edward Pollack
Twitter: - EdwardPollack
LinkedIn: Edward Pollack
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
David Dye
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
John Morehouse
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday’s as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Kevin Kline
Twitter: - kekline
LinkedIn: Kevin Kline
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
Ashish Sharma
Samuel Vanga
Twitter: - https://twitter.com/SamuelVanga
LinkedIn: Samuel Vanga
Contact: http://SamuelVanga.com
Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.
Martin Schoombee
Twitter: - sqlmartin
LinkedIn: Martin Schoombee
Contact: http://www.martinschoombee.com
Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.
Virginia Mushkatbat
Contact: http://mask-me.net
Virginia Mushkatblat is currently a founder of Hush-Hush, a data masking company. She wrote her first computer program at the age of 14 and has been in technology ever since, progressively rising through the ranks and trying on different hats including database architecture, development, security and operations. She has worked for Startups and Fortune 100 companies in finance, entertainment, e-commerce, internet advertisement, manufacturing, and communications industries and dealt with both heavily transactional and BI applications.She holds B.S. and Masters Degrees in Engineering and in Computer Science, originated a couple of patents, and currently teaches databases and multimedia to graduating seniors in CSUN, her Alma Mater.
Andrew Brust
Twitter: - andrewbrust
Contact: http://www.zdnet.com/blog/big-data
Andrew J. Brust is the Senior Director, Market Strategy and Intelligence at Datameer and writes a blog for ZDNet called quot;Big on Dataquot; (bit.ly/bigondata). Andrew is co-author of quot;Programming Microsoft SQL Server 2012quot; (Microsoft Press); an advisor to the NY Technology Council; serves as Microsoft Regional Director and MVP; is conference co-chair of Visual Studio Live!; and writes Visual Studio Magazine#39;s quot;Redmond Reviewquot; column.
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
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.”
Troy Gallant
Contact: http://www.troygallant.com
Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Hilary Cotter
Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.
Hilary is also an author, or contributor on a number of books on SQL Server.
John Abrams
Contact: http://www.aspect-consulting.com/
John Abrams, COO and Co-Founder of Aspect Consulting, Inc.
John is senior Data Architect/DBA with 20+ years’ experience working with clients and their data. John’s primary focus is on database administration, performance tuning, data warehouse and data load processing design and architecture, as well as application design and architecture.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Daniel Bowlin
Twitter: - @SQLBI_Dan
LinkedIn: Daniel Bowlin
Contact: http://www.danielbowlin.com/
I am a data integration developer at Time Warner Cable. I have been working with SQL Server technologies since the late 90s. About 6 years ago I specialized in the SQL Server BI stack. Lately I have been almost exclusively working in SSIS.
Timothy McAliley
Twitter: - sysframeworks
LinkedIn: Timothy McAliley
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.
Steve Hughes
Twitter: - dataonwheels
LinkedIn: Steve Hughes
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
SB Chatterjee
Contact: http://weblogs.asp.net/sbchatterjee/default.aspx
Architect/Tech-lead in Hartford CT with over 20 years IT experience. Worked at companies like Aetna, IBM, Microsoft, UNICEF, United Technologies and State of Connecticut. Holds graduate degrees in Computer Science, Business Administration and Economics. Awarded the Microsoft MVP Award for SharePoint products 2008 thru 2013. He is active in the SharePoint StackExchange and other forums. Twitter: @sbc111 Acting Director - CT.NET Dev Group (CTDOTNET) CT Dev Startups Group (CTDEVSTARTUP).
Matt Velic
Twitter: - mvelic
LinkedIn: Matt Velic
Contact: http://mattvelic.com
Matt Velic is a database developer for Sanametrix in Washington, DC. When not jet setting between projects at work, you can find him at a board game, a video game, or playing a guitar.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Kevin Feit
Twitter: - @kevinfeit
LinkedIn: Kevin Feit
Kevin Feit is a Solution Principal with Slalom Consulting specializing in data warehousing and ETL development. He has been working with SQL Server since 1990 and is a Microsoft Certified Professional.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
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.
Chris Bell
Twitter: - @cbelldba
LinkedIn: Chris Bell
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.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
Alex Grinberg
LinkedIn: Alex Grinberg
I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com
Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=68
Ted Krueger has been working in development and database administration for over a decade. Ted currently works for a respected consulting company, Magenic Technologies as a valued Database Professional resource. He is a PASS Region Mentor, Friends of Red Gate member, SQL Server MVP and community mentor. Ted blogs and is also one of the founders of LessThanDot Technical Community
Ben DeBow
Contact: http://www.sqlha.com/blog/
Ben DeBow is a MDCBA, MCSE and MCITP focused on SQL Server consolidations, data architecture and performance tuning for organizations both large and small. Ben specializes in solving diverse and complex data and infrastructure challenges for large, global environments. Ben is a longtime member of the SQL community, volunteering the last 8 years as a SQLPass committee member, trainer and SQLPass presenter. Besides his work as a consultant, Ben is a cyclist, avid traveler and photographer.
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
Carl Berglund
Contact: http://www.dh2i.com
Carl Berglund is a senior technical business development leader with over 20 years of experience helping customers implement complex enterprise infrastructures. Prior to DH2i Berglund held senior business development roles at HP and PolyServe, where he was involved in dozens of SQL Server consolidation, virtualization, and optimization projects. As a virtualization evangelist, Carl helps customers reduce spend on overall SQL Server lifecycle costs while reducing risk.
David Bermingham
Twitter: - https://twitter.com/daveberm
LinkedIn: David Bermingham
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
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.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
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.
Melissa Demsak
LinkedIn: Melissa Demsak
Melissa Demsak is passionate about Data, Business and People. She’s currently a Manager of SQL Architecture at large real estate holding company. Melissa was the leader of the NJSQL User Group ‘06-‘12, PASS Summit Program Committee ’07-’10 and a PASS Regional Mentor. She’s currently on the Program Committee for the PASS BA Conference in April and leads the PASS Business Analytics Virtual Chapter.
Michael Corey
Twitter: - Michael_corey
LinkedIn: Michael Corey
Contact: http://michaelcorey.com/
Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael’s a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly
Robert Pearl
Twitter: - @PearlKnows
LinkedIn: Robert Pearl
Contact: http://www.sqlservercentral.com/blogs/pearlknows/
Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
John Miner
Twitter: - JohnMiner3
LinkedIn: John Miner
Contact: http://www.craftydba.com
John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies.
Paul Rizza
Twitter: - @PaulRizzaSQL
LinkedIn: Paul Rizza
Contact: http://blogs.msdn.com/b/paulrizza/
Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
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
George Walters
Twitter: - https://twitter.com/geo_walters
LinkedIn: George Walters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions.
A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases.
Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
Sponsors
The following is a list of sponsors that helped fund the event: