Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 25
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development & Security

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS & ETL

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Performance

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
SSIS & ETL

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Session Type:
Regular Session

Track:
Development & Security

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Development & Security

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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!
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Development & Security

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS & ETL

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 25
Back to Top