sqlsathistory

Nr: 299

Back to Main list

SQLSaturday #299 - Columbus 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Chris Bell	Development Security	The Spy Who Loathed Me - An Intro to SQL Security
00:00:00	Colleen Morrow	Administration	SQL Audit - auditing doesn't have to be boring
00:00:00	Craig Purnell	Development Security	Achieving Compliance with SQL Server
00:00:00	Craig Purnell	BI Big Data	From 0 to Hadoop
00:00:00	Kevin Feasel	Performance	Tally 'Em Up
00:00:00	Kevin Feasel	Performance	APPLY Yourself
00:00:00	Janis Griffin	Performance	Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00	Konstantin Melamud	Administration	Transactional Replication-10 steps for successful implementation
00:00:00	Konstantin Melamud	Performance	Performance Tuning - Analyzing Execution Plans
00:00:00	Dustin Prescott	Development Security	Hacking SQL Server - A Peek into the Dark Side
00:00:00	Brian Davis	BI Big Data	Getting Started with Hekaton (In-Memory OLTP)
00:00:00	Brian Davis	SSIS ETL	SSIS Templates Can Make Your Life Easier
00:00:00	Scott Brickey	BI Big Data	Exposing SQL data with SharePoint
00:00:00	Scott Brickey	BI Big Data	Power BI with SQL, Excel and SharePoint
00:00:00	Steve Hood	Performance	Indexing Fundamentals
00:00:00	George Squillace	SSIS ETL	SSIS for the Absolute Beginner
00:00:00	George Squillace	SSIS ETL	All About the SSIS Catalog (SSISDB)
00:00:00	Kevin Boles	Development Security	SQL Injection
00:00:00	Kevin Boles	SSIS ETL	Unit Testing SQL Server
00:00:00	Ryan Brickey	Administration	Policy Based Management: Introduction and Implementation
00:00:00	Adam Belebczuk	Development Security	Introduction to SQL Server Service Broker
00:00:00	Adam Belebczuk	Administration	Introduction to SQL Server 2012 AlwaysOn Availability Groups
00:00:00	Andrew Holowaty	BI Big Data	Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular Model
00:00:00	Allen White	Administration	Manage SQLServer Efficiently w/PowerShell Remoting
00:00:00	Allen White	SSIS ETL	Get Near Realtime ETL with Service Broker

SessionID: 11274

The Spy Who Loathed Me - An Intro to SQL Security

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development Security

Speaker: Chris Bell

Title: The Spy Who Loathed Me - An Intro to SQL Security

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.

SessionID: 11780

SQL Audit - auditing doesn't have to be boring

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Administration

Speaker: Colleen Morrow

Title: SQL Audit - auditing doesn't have to be boring

Abstract:

Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.

SessionID: 11998

Achieving Compliance with SQL Server

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development Security

Speaker: Craig Purnell

Title: Achieving Compliance with SQL Server

Abstract:

There are a plethora of regulatory compliance mandates that affect business today with names like Sarbanes-Oxley, PCI-DSS, and HIPAA. How does a database professional implement these controls in your SQL Server infrastructure? We will review the basics of the GRC (Governance, Risk Management, and Compliance) methodology. You will learn about the tools that you can use to achieve compliance such as TDE, Auditing, and Identity Management. Come to this session and learn how to build a compliant infrastructure that keeps the DBA team, the auditors and the business leaders happy.

SessionID: 11999

From 0 to Hadoop

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI Big Data

Speaker: Craig Purnell

Title: From 0 to Hadoop

Abstract:

Heard about BigData and Hadoop and want to make some sense of it? You will learn about what Hadoop is and what is it not, and how it can help your organization. We will cover Microsoft HDInsight as a cloud solution and Hortonworks HDP 2.0 as an onsite platform for Hadoop implementations. Takeaways include: Why you might want to consider onsite vs hosted, and how to get up to speed as fast as possible on this game changing technology.

SessionID: 14195

Tally 'Em Up

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Performance

Speaker: Kevin Feasel

Title: Tally 'Em Up

Abstract:

Database administrators as a rule hate Row-By-Agonizing-Row (RBAR) solutions due to how poorly they perform in T-SQL. Sometimes, though, it seems as though we need to make do and take that performance hit. This presentation will show you that the humble tally table can eliminate RBAR-dependency across a number of different problem spaces, including splitting text, validating dates, and even reporting on errors. With plenty of examples, you'll get to see exactly how powerful a tally table can be.

SessionID: 14196

APPLY Yourself

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Performance

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 15722

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Performance

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

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.

SessionID: 18554

Transactional Replication-10 steps for successful implementation

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Administration

Speaker: Konstantin Melamud

Title: Transactional Replication-10 steps for successful implementation

Abstract:

What is potentially our biggest problem with transactional replication? You guessed it...it breaks! It may break for a variety of reasons and we as DBA’s probably have experienced them all at one point or another. Our biggest worry? Bringing replication back online whenever a full snapshot reinitialization is not an option due to time or space concerns. But don't you worry; we have a couple of tricks up our sleeves! During this session, we will go over options available to you to re-sync your replication with minimal downtime for your production environments.

SessionID: 18555

Performance Tuning - Analyzing Execution Plans

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Performance

Speaker: Konstantin Melamud

Title: Performance Tuning - Analyzing Execution Plans

Abstract:

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.

In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

SessionID: 22295

Hacking SQL Server - A Peek into the Dark Side

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development Security

Speaker: Dustin Prescott

Title: Hacking SQL Server - A Peek into the Dark Side

Abstract:

The best defense is a good offense. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks.

SessionID: 22641

Getting Started with Hekaton (In-Memory OLTP)

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI Big Data

Speaker: Brian Davis

Title: Getting Started with Hekaton (In-Memory OLTP)

Abstract:

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.

SessionID: 22643

SSIS Templates Can Make Your Life Easier

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SSIS ETL

Speaker: Brian Davis

Title: SSIS Templates Can Make Your Life Easier

Abstract:

How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.

SessionID: 24045

Exposing SQL data with SharePoint

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI Big Data

Speaker: Scott Brickey

Title: Exposing SQL data with SharePoint

Abstract:

You've got your data, but accessing it means using one application among dozens, which can be difficult for once-in-a-while users. Alternatively, you can make the data to SharePoint where it can be easily searched, related, and even (securely) exposed for integration via the SharePoint native OData, REST, and WCF interfaces.

SessionID: 24046

Power BI with SQL, Excel and SharePoint

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI Big Data

Speaker: Scott Brickey

Title: Power BI with SQL, Excel and SharePoint

Abstract:

SQL has always enabled business intelligence through databases and analysis services. But working with them has historically required a development team. Learn how Microsoft's new suite of BI tools for Excel and SharePoint can put the power of business intelligence back into the hands of your power users.

SessionID: 24419

Indexing Fundamentals

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Performance

Speaker: Steve Hood

Title: Indexing Fundamentals

Abstract:

A solid understanding of clustered and nonclustered indexes and a thorough look at their costs and benefits. This will include looking in execution plans to see how indexes are used, going through the buffer cache to see the memory costs and benefits, and a complete look at how they fit into a strategy to improve page life expectancy and server performance.

SessionID: 25082

SSIS for the Absolute Beginner

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SSIS ETL

Speaker: George Squillace

Title: SSIS for the Absolute Beginner

Abstract:

Absolutely an understatement, SSIS is a very powerful construction set for moving and processing data and performing a huge variety of tasks. This session will explore the basics of SSIS development, architecture, and terminology, so that you’ll know Control Flow v. Data Flow, Tasks v. Components, Precedence Constraints v. Data Flow pipeline, to explore the types of problems SSIS can address and be able to develop basic SSIS workflows.

SessionID: 25084

All About the SSIS Catalog (SSISDB)

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SSIS ETL

Speaker: George Squillace

Title: All About the SSIS Catalog (SSISDB)

Abstract:

Wow, deployment of SSIS packages in SQL Server 2012 is radically different, when the new SSIS catalog is used (“Who Moved My Cheese?”). This session examines the “new” SSISDB, its architecture and functionality and compares that to the “old” method of Package Configurations in previous versions of SSIS.

SessionID: 26379

SQL Injection

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development Security

Speaker: Kevin Boles

Title: SQL Injection

Abstract:

Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

SessionID: 26380

Unit Testing SQL Server

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SSIS ETL

Speaker: Kevin Boles

Title: Unit Testing SQL Server

Abstract:

In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

SessionID: 34869

Policy Based Management: Introduction and Implementation

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Administration

Speaker: Ryan Brickey

Title: Policy Based Management: Introduction and Implementation

Abstract:

In this session users will be introduced to the concepts of Policy Based Management. It will include demos for setting up new policies, evaluating policies, and scaling policies across an environment.

SessionID: 8956

Introduction to SQL Server Service Broker

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Development Security

Speaker: Adam Belebczuk

Title: Introduction to SQL Server Service Broker

Abstract:

In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.

SessionID: 8957

Introduction to SQL Server 2012 AlwaysOn Availability Groups

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Administration

Speaker: Adam Belebczuk

Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups

Abstract:

One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

SessionID: 9488

Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular Model

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: BI Big Data

Speaker: Andrew Holowaty

Title: Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular Model

Abstract:

Within the enterprise, the new Excel self-service tools can enable Power Users to define and create analytic requirements by creating new business models in PowerPivot. We will walk through a scenario of creating relationships, hierarchies, KPIs, calculations, and measures as a business person. When completed we will hand it off the model to the governance board for review to see how it fits into the organization BI collateral. Finally, we will put on our IT hats and convert the PowerPivot model into a SSAS Tabular version and give it enterprise strength of partitions and security. We will end the session by selecting a deployment strategy that will meet the needs of new and existing models in the production environment.

SessionID: 9985

Manage SQLServer Efficiently w/PowerShell Remoting

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Administration

Speaker: Allen White

Title: Manage SQLServer Efficiently w/PowerShell Remoting

Abstract:

You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.

SessionID: 9987

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 14-06-2014 - Session time: 00:00:00 - Track: SSIS ETL

Speaker: Allen White

Title: Get Near Realtime ETL with Service Broker

Abstract:

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

This site is open source. Improve this page.