sqlsathistory

Nr: 177

SQLSaturday #177 - Silicon Valley 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Dan Bulos	Track 2 - Mercury	So Many BI Tools, So Little Time
00:00:00	Carlos Bossy	Track 1 - Galileo	Big Data for the SQL Server DBA
00:00:00	Chris Shaw	Track 5 - Computer Training Room	What is the Best Disaster Recovery Solution?
00:00:00	Denise McInerney	Track 1 - Galileo	WIT - Encouraging Enabling Women in Technology
00:00:00	Denise McInerney	Track 3 - Jupiter	Stop Bad Data in its OLTP Tracks
00:00:00	Eddie Wuerch	Track 6 - ECR	TempDB Performance Troubleshooting and Optimizing
00:00:00	Grant Fritchey	Track 4 - Saturn	Query Tuning in the Clouds
00:00:00	Janis Griffin	Track 4 - Saturn	Don't Panic, DBAs! Databases on VMware made easy.
00:00:00	Jason Horner	Track 3 - Jupiter	Dimensional Modeling: Beyond the Basics
00:00:00	Julie Koesmarno	Track 2 - Mercury	Analytic Cartography: Master geospatial reporting
00:00:00	Joe Sack	Track 6 - ECR	Troubleshooting Query Plan Quality Issues
00:00:00	Joseph Verftido	Track 3 - Jupiter	Matching and Survivorship
00:00:00	Joy Mundy	Track 1 - Galileo	Dimensional Modeling and OLAP
00:00:00	Kevin Kline	Track 1 - Galileo	Top 10 Admininistrator Mistakes on SQL Server
00:00:00	Lakshmi Randall	Track 3 - Jupiter	Analytics on Azure
00:00:00	Mark Ginnebaugh	Track 7 - 2036	Nimble Storage Vendor Presentation
00:00:00	Mark Ginnebaugh	Track 6 - ECR	Introductions and Keynote
00:00:00	Mark Ginnebaugh	Track 4 - Saturn	NetApp Vendor Session
00:00:00	Mark Ginnebaugh	Track 5 - Computer Training Room	Nimble Storage Vendor Session
00:00:00	Mark Ginnebaugh	Track 6 - ECR	EMC Vendor Session
00:00:00	Mark Ginnebaugh	Track 5 - Computer Training Room	Parallel Data Warehouse 2.0
00:00:00	Mark Gschwind	Track 2 - Mercury	Master Data and Data Quality in SQL Server 2012
00:00:00	Mickey Stuewe	Track 7 - 2036	Tablix - The Rubik Cube of Reporting Services
00:00:00	Mitchell Bottel	Track 5 - Computer Training Room	Get TurnedOn with AlwaysOn
00:00:00	Denny Cherry	Track 1 - Galileo	SQL Server Table Partitioning from the Ground Up
00:00:00	Pat Sinthusan	Track 7 - 2036	SQL Server 2012 over NAS Storage
00:00:00	Phil Hummel	Track 5 - Computer Training Room	SQL Server, HyperV, Virtual SAN Switches
00:00:00	Randy Knight	Track 6 - ECR	Understanding Transaction Isolation Levels
00:00:00	Rob Kerr	Track 2 - Mercury	Designing a SQL 2012 BI Architecture
00:00:00	Scott Klein	Track 4 - Saturn	SQL Azure- What is it and why do you need it?
00:00:00	Kevin Boles	Track 6 - ECR	Windowing Functions: THE Reason to Upgrade to 2012
00:00:00	Wenming Ye	Track 1 - Galileo	Hadoop on WindowsAzure in Action
00:00:00	Mark Tabladillo	Track 3 - Jupiter	Secrets of Enterprise Data Mining
00:00:00	Aaron Nelson	Track 4 - Saturn	PowerShell for Data Professionals
00:00:00	Allan Hirt	Track 5 - Computer Training Room	Demystifying Clustering for the DBA
00:00:00	Ami Levin	Track 6 - ECR	Where Are My (Primary) Keys?
00:00:00	Angel Abundez	Track 2 - Mercury	Business Intelligence with SharePoint 2013
00:00:00	Argenis Fernandez	Track 4 - Saturn	Lean and Mean: Running SQL on Windows Server Core

SessionID: 11102

So Many BI Tools, So Little Time

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 2 - Mercury

Speaker: Dan Bulos

Title: So Many BI Tools, So Little Time

Abstract:

Microsoft has a broad range of tools that can be used to create a BI application: Power View, Reporting Services, and Excel (Pivot Tables Power View) on the presentation side and SQL, Analysis Services (MOLAP Tabular), PowerPivot, and Excel models on the data side. Which ones should you use when? Should an application mix and match or should an application focus on a limited set of tools? While the technologies in each class have similarities (Power View, Reporting Services, and Pivot Tables all have bar charts), they are fundamentally different and should be used in different circumstances. Compare the tools and learn nuances of each of them by seeing them in the context of real world examples. See how choosing different tool str

SessionID: 11305

Big Data for the SQL Server DBA

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Carlos Bossy

Title: Big Data for the SQL Server DBA

Abstract:

If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about? This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment. It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system.

SessionID: 11493

What is the Best Disaster Recovery Solution?

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Chris Shaw

Title: What is the Best Disaster Recovery Solution?

Abstract:

It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.

SessionID: 13086

WIT - Encouraging Enabling Women in Technology

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Denise McInerney

Title: WIT - Encouraging Enabling Women in Technology

Abstract:

Women make up only about 25% of the computing workforce. The number of women majoring in Computer Science in the U.S. has declined significantly over the past 25 years. Yet today technology companies can't find enough talented engineers and the demand is only going to increase. Come hear from a people who are actively working to encourage and enable more girls and women to pursue technology careers. Our panel will include Kimberly Bryant, Founder Black Girls CODE, Ayna Agarwal and Ellora Israni, co-founders of She++ at Stanford and more.

SessionID: 13087

Stop Bad Data in its OLTP Tracks

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 3 - Jupiter

Speaker: Denise McInerney

Title: Stop Bad Data in its OLTP Tracks

Abstract:

Incorrect, inaccurate and misleading data can get into a database in a variety of ways. It causes bugs, impacts customers and hurts business. This session will explain how DBAs and developers can proactively ensure the data coming into a transactional system is clean and correct. The topics covered will include table design, the pitfalls of NULL, “garbage in”, transactions, change management, and coding standards.

The presentation will draw on the speaker's years of personal experience managing busy e-commerce databases supporting multi-million dollar businesses. The speaker will use real-life examples and demos to illustrate the many ways that OLTP data quality can be compromised.

SessionID: 14066

TempDB Performance Troubleshooting and Optimizing

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Eddie Wuerch

Title: TempDB Performance Troubleshooting and Optimizing

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

SessionID: 14763

Query Tuning in the Clouds

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Grant Fritchey

Title: Query Tuning in the Clouds

Abstract:

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.

SessionID: 15668

Don't Panic, DBAs! Databases on VMware made easy.

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Janis Griffin

Title: Don't Panic, DBAs! Databases on VMware made easy.

Abstract:

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.

SessionID: 15846

Dimensional Modeling: Beyond the Basics

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 3 - Jupiter

Speaker: Jason Horner

Title: Dimensional Modeling: Beyond the Basics

Abstract:

In this session, we will dive deeper into the art of dimensional modeling.

We will identify the different types of fact tables and dimension tables and discuss how and when to use each type. We will also review approaches to creating rich hierarchies that simplify complex reporting. This session will be very interactive--bring your toughest dimensional modeling quandaries!

SessionID: 16903

Analytic Cartography: Master geospatial reporting

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 2 - Mercury

Speaker: Julie Koesmarno

Title: Analytic Cartography: Master geospatial reporting

Abstract:

One of the hottest trends in analytics right now is geospatial reporting. Long gone are the days of viewing region based data in a grid. Now it is possible to provide users with additional insight on the regional performance of business.

In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we'll show how easy it is to build interactive maps using Power View.

SessionID: 17122

Troubleshooting Query Plan Quality Issues

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Joe Sack

Title: Troubleshooting Query Plan Quality Issues

Abstract:

When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.

SessionID: 17482

Matching and Survivorship

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 3 - Jupiter

Speaker: Joseph Verftido

Title: Matching and Survivorship

Abstract:

The spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship.

SessionID: 17543

Dimensional Modeling and OLAP

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Joy Mundy

Title: Dimensional Modeling and OLAP

Abstract:

SessionID: 18189

Top 10 Admininistrator Mistakes on SQL Server

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Kevin Kline

Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract:

SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

SessionID: 18940

Analytics on Azure

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 3 - Jupiter

Speaker: Lakshmi Randall

Title: Analytics on Azure

Abstract:

Speaker Lakshmi Randall will walk us through analytics on Azure.

SessionID: 19588

Nimble Storage Vendor Presentation

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 7 - 2036

Speaker: Mark Ginnebaugh

Title: Nimble Storage Vendor Presentation

Abstract:

Details Coming Soon

SessionID: 19589

Introductions and Keynote

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Mark Ginnebaugh

Title: Introductions and Keynote

Abstract:

Greetings from Mark Ginnebaugh and Keynote with Ross Mistry

SessionID: 19590

NetApp Vendor Session

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Mark Ginnebaugh

Title: NetApp Vendor Session

Abstract:

SessionID: 19591

Nimble Storage Vendor Session

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Mark Ginnebaugh

Title: Nimble Storage Vendor Session

Abstract:

Details coming soon!

SessionID: 19592

EMC Vendor Session

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Mark Ginnebaugh

Title: EMC Vendor Session

Abstract:

Details coming soon!

SessionID: 19593

Parallel Data Warehouse 2.0

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Mark Ginnebaugh

Title: Parallel Data Warehouse 2.0

Abstract:

Come learn about the latest features in the just-released PDW 2.0!

SessionID: 20135

Master Data and Data Quality in SQL Server 2012

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 2 - Mercury

Speaker: Mark Gschwind

Title: Master Data and Data Quality in SQL Server 2012

Abstract:

A recent survey by Information Week found that data quality is the greatest barrier to BI adoption in enterprises. MDS addresses this challenge with modeling, validation, alerting and security capabilities. In this presentation, you will learn how to use MDS to model your data to ensure correctness, update it with changes from your ERP, and alert users to data conditions that require attention. Next you will learn the capabilities of DQS and see how it addresses data standardization, completeness and uniqueness challenges. You will then see how to use them together to enable Enterprise Information Management. BI professionals will come away with knowledge on how to use tools that address the greatest risk to success for BI projects - d

SessionID: 20391

Tablix - The Rubik Cube of Reporting Services

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 7 - 2036

Speaker: Mickey Stuewe

Title: Tablix - The Rubik Cube of Reporting Services

Abstract:

Did you know that the Table, Matrix, and List controls are all based on the highly flexible Tablix Data Region Grid? So really, they are all one control that can be morphed into each other.

Learn how to get the most out of the Tablix controls in this demo-heavy session. We'll go through how to best layout data using multiple Tablix controls. We’ll use parameters to change the layout of the data in these controls to minimize the number of reports that need to be maintained. We’ll create a columnar report that grows vertically as well as horizontally, and we’ll find out about other exciting uses of this highly flexible control.

SessionID: 20833

Get TurnedOn with AlwaysOn

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Mitchell Bottel

Title: Get TurnedOn with AlwaysOn

Abstract:

Once upon a time, there were 2 SQL Solutions named High Availability and Disaster Recovery. They had a love hate relationship and could never find a common ground. That is, until SQL Server 2012 brought them together in a love story built for the ages. When the dust settled, a beautiful new feature was born. It was called AlwaysON and brought with it new technologies like availability groups, read-only mirrors and listeners. It was a perfect blend of both HA and DR all wrapped up in one bundle of joy.

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. Come see and learn some of the new features associated with it, how they work and why this new feature of SQL Server 2012 is so wonderfu

SessionID: 21040

SQL Server Table Partitioning from the Ground Up

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Denny Cherry

Title: SQL Server Table Partitioning from the Ground Up

Abstract:

In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users.

Using these techniques we will be able to improve query performance and reduce downtime when loading and pruning data.

SessionID: 21741

SQL Server 2012 over NAS Storage

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 7 - 2036

Speaker: Pat Sinthusan

Title: SQL Server 2012 over NAS Storage

Abstract:

Microsoft SQL Server is one of the most commonly virtualized applications environments. With the release of SQL Server 2012, Microsoft introduces full support for SMB. Now you can install SQL Server 2012 with both system and user databases on SMB file shares. This allows you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and shrink. This session will demonstrate how to install and run SQL Server over SMB and VMware NFS on NetApp storage as well as best practices, caveats, and performance of SQL Server database over NAS storage.

SessionID: 22110

SQL Server, HyperV, Virtual SAN Switches

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Phil Hummel

Title: SQL Server, HyperV, Virtual SAN Switches

Abstract:

SQL Server, HyperV, Virtual SAN Switches - Virtual Reality! Details coming soon...

SessionID: 22500

Understanding Transaction Isolation Levels

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Randy Knight

Title: Understanding Transaction Isolation Levels

Abstract:

SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

SessionID: 23081

Designing a SQL 2012 BI Architecture

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 2 - Mercury

Speaker: Rob Kerr

Title: Designing a SQL 2012 BI Architecture

Abstract:

SessionID: 24155

SQL Azure- What is it and why do you need it?

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Scott Klein

Title: SQL Azure- What is it and why do you need it?

Abstract:

This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about.

SessionID: 26229

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 27837

Hadoop on WindowsAzure in Action

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 1 - Galileo

Speaker: Wenming Ye

Title: Hadoop on WindowsAzure in Action

Abstract:

Web 2.0 companies have been fully taking advantage of Hadoop based open source tools to tackle Big Data needs. Microsoft now offers the best of both worlds with its own Hadoop solution on Windows Azure with full compatibility and additional rich toolsets. This session is a "getting-started" tutorial on developing Big Data applications on Windows Azure. We cover application scenarios, Hadoop on Azure, tools, and applied data analytics. More importantly, we show you how to put everything together with a couple of sample applications.

SessionID: 34738

Secrets of Enterprise Data Mining

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 3 - Jupiter

Speaker: Mark Tabladillo

Title: Secrets of Enterprise Data Mining

Abstract:

If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2012 tools including SSMS, SSIS, and SSDT.

SessionID: 8858

PowerShell for Data Professionals

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 9237

Demystifying Clustering for the DBA

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 5 - Computer Training Room

Speaker: Allan Hirt

Title: Demystifying Clustering for the DBA

Abstract:

The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest.

SessionID: 9371

Where Are My (Primary) Keys?

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 6 - ECR

Speaker: Ami Levin

Title: Where Are My (Primary) Keys?

Abstract:

In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.

SessionID: 9652

Business Intelligence with SharePoint 2013

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 2 - Mercury

Speaker: Angel Abundez

Title: Business Intelligence with SharePoint 2013

Abstract:

Details to follow shortly

SessionID: 9778

Lean and Mean: Running SQL on Windows Server Core

Back to calendar

Event Date: 23-02-2013 - Session time: 00:00:00 - Track: Track 4 - Saturn

Speaker: Argenis Fernandez

Title: Lean and Mean: Running SQL on Windows Server Core

Abstract:

Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management of SQL Server on Windows Server Core, along with lots of tips and tricks.

This site is open source. Improve this page.