Parsing T-SQL using the TransactSql.ScriptDom library (C#)

8:30 am in
Dominic Falso

T-SQL is a very complicated language to parse, so it can be intimidating to get started. We’ll go over basic concepts of what a lexer/parser is and what to expect from it. Then, using the TransactSql.ScriptDom library in the SQL Server SDK, we’ll do some examples to get our feet wet.

Efficient Table Design for “Big Data”

10:00 am in
Alex Grinberg

The importance of proper table design,especially when you dealing with big data, such as billions in rows and hundreds GB in size, cannot be underestimated. Misconception could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session audience will have a sensible walk-through database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTETY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARCE column, and more.

Elastic Scale for Azure SQL Database – Overview

11:30 am in
Bill Emmert

Abstract: Now in Preview, Elastic Scale for Azure DB offers a set of features that make it easier to build and manage a sharded data tier for cloud applications that can grow and shrink database capacity on demand. Delivering on this the key promises of cloud computing used to be challenging in particular for the database tier. Over the last few years, the industry has converged on sharding as a well-established design pattern for cloud applications. Elastic Scale adopts the general sharding pattern and significantly simplifies building and managing sharded applications for Azure SQL DB.

In this session, we are going to explore workloads that are a natural fit for sharding and Azure SQL DB Elastic Scale. Workloads discussed in depth include multi-tenancy as well as telemetry and sensor data processing. We will use capabilities from the Elastic Scale preview to make developing, scaling and managing sharded applications on Azure SQL DB much easier. The capabilities discussed in the session include shard management, data dependent routing, querying across shards and elastic capacity at the data tier in Azure SQL DB.

Objectives: 1. Identify workloads that will benefit from Elastic Scale. 2. Guide you on how to apply sharding to your data tiers.

SQL Server Cryptology – A Primer

1:30 pm in
Sebastian Meine

So, you got told you need to encrypt “the database”. Now what?
Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies.
After attending this session, you will be able to
• explain the difference between symmetric and asymmetric encryption.
• select the right cryptographic technology for your special security requirement.
• identify when to use one-way hashing instead of encryption.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and have basic permission management skills.

SQL Database Snapshots

3:00 pm in
Said Salomon

We will be taking a look at SQL 2005+ enterprise feather of database snapshots and how they work. We will answer question like:
What is Database Snapshot?
Why use Database Snapshot?
How does a Database Snapshot work?
How does a Database Snapshot effect performance?