Sessions tagged as Data
Accelerating SQL with Solid State Technology
Location: Shiley Hall, Room 101
Solid-state technologies are changing the way that SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how SQL performs. 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: 4) Customer proof: Wine.com case study. One lucky participant will win an iPod autographed by Steve Wozniak.
Building Real World Applications using WCF Data Services
Location: Franz Hall, Room 106
Learn how to build a real world application that uses Data Services. Learn about how to solve the following real world challenges with a Data Service application. 1. Using the Silverlight client library to operate against a Data Service. 2. Use Forms authentication on the server and client to secure access to a Data Service. 3. Common patterns with building Silverlight applications that work against a Data Service. 4. Also learn some tips on building Data Service client applications that can work on a variety of platforms : WPF/Silverlight and Windows Phone.
Business Intelligence and Data Warehousing Primer
Location: Shiley Hall, Room 319
Your CIO's top priority in 2010 is probably Business Intelligence. If you don't know what BI is, or are trying to deliver it directly from your OLTP database, you need to find out what you're getting into. BI is all about helping your business users make better decisions, faster. Find out what it will take to deliver what your CIO is asking for. BI from your OLTP database has problems - it requires technical knowledge of your data model, compromises your line of business application responsiveness, and won't perform well. The solution to all of those issues is to construct a Data Warehouse based on Dimensional Modeling. I'll show you why normalized OLTP databases have problems supporting BI, and how Kimball method Data Warehouses don't.
Cooking with SSRS: Advanced Report Design Recipes
Location: Franz Hall, Room 034
The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our forthcoming Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.
CPU Caches and Why You Care
Location: Franz Hall, Room 231
No matter what programming language or technology you use, if your software fails to make effective use of the underlying CPU caches, your system's performance will suffer. A lot. This session provides a wide-ranging overview of your CPU caches, how they operate, and how that affects high-level decisions on things like data structures and traversal strategies. Both single- and multi-threaded execution are considered. Specific topics include different cache types (data, instruction, TLB); private and shared caches; cache lines and speculative prefetching; false sharing; and cache-friendly program organization, data structures, and traversal strategies. If you care at all about performance, the information in this talk is essential. The fact that it's really interesting is simply a bonus :-)
Creating Report Subscriptions in Microsoft SQL Server
Location: Franz Hall, Room 034
In this session, learn how to set up standard and data-driven subscriptions using Report Manager. We discuss creating file-share, email, and null subscriptions; and how to deal with potential issues with parameters and security. We also demonstrate a sophisticated Microsoft ASP.NET-based application that creates subscriptions by calling the SSRS Web Services API.
Data Architecture – a "Corner Stone" of EA
Location: Shiley Hall, Room 123
Data Architecture – a 'Corner Stone'of Enterprise Architecture -As the organizations across the globe, aggressively pursues their strategic objectives; a key strategy and method is required in this pursuit, and that is 'Data/Information Availability'. Accurate, reliable and available information enables the organization to make timely and better business decisions. We have seen many differing methodologies over the years with CRM, Portals, B2B efforts and score carding capabilities. The need for well structured and quality information is more important than ever. As a result, we are seeing a significant acceptance and synergy relative to the importance and value having a robust Data Architecture. Most organizations today have a co
Data Mining with Analysis Services
Location: Shiley Hall, Room 319
Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.
Deep Dive on Integration Services
Location: Franz Hall, Room 034
SQL Server Integration Services is Microsoft’s Extract Transform Load/Data Integration (ETL/DI) tool, replacing DTS. SSIS is a very powerful and complex tool that can read data in from virtually any source, transform and mash that data however you like, then send it out to virtually any type of destination. Understand how SSIS can be used to do just that – from the basics. Find out how to get started using SSIS, hear what it’s really good at, and figure out what things you need a hacker's spirit to accomplish with it. This session is demo heavy; Tasks, expressions, precedence constraints, text files, Excel, SQL, data type conversions, performance, scripts, configurations, scheduling, and more will be covered with examples.
Dimension Processing with SSIS - Simple to Complex
Location: Shiley Hall, Room 319
The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.
Disaster Recovery and High Availability for N00Bs
Location: Shiley Hall, Room 123
This session is targeted for those who have found themselves accidentally responsible for the SQL Server databases where they work, or are generally new to SQL Server. We will cover the basics of Backup and Restore processes as well as a high overview of HA architectures available including Database Mirroring, Clustering, Replication, and Log Shipping. Scripts will be provided for immediate use in your own environment as a take-away from this presentation.
Exploring SQL Server System Information with DMVs
Location: Shiley Hall, Room 101
This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away.
Getting Started with SQL Azure
Location: Franz Hall, Room 217
Bruce will show how to get started using SQL Azure. Working with SQL Azure should be a familiar experience for most developers because, for the most part, it supports the same tooling and development practices currently used for on premise SQL Server applications. I'll show how to use familiar tools. And will show some tips and tricks, which are important to working with SQL Azure, such as managing your connection in the event of throttling and querying the metrics views.
High Volume Real Time Contiguous ETL and Audit
Location: Franz Hall, Room 223
High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.
How to decide if your database is a good candidate for virtualization
Location: Franz Hall, Room 223
We will be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we will be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We will be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
Insight Into Your Indexes With DMVs
Location: Shiley Hall, Room 101
Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.
Integrating External Data With CMS Content
Location: Franz Hall, Room 025
This session will cover how to build a CMS application that will access external data and combine it with CMS content. The application will be built using jQuery and provide AJAX functionality. As an additional feature code will be provided to store the external data in as CMS content. This application can easily be moved to most any other CMS.
Introduction to Linq and Linq2DataSets
Location: Franz Hall, Room 217
This 100 level session will get you started writing Linq queries against your existing DataSets. This talk will cover basic introductory level Linq and specifics regarding using Linq with DataSets. It will compare Linq2DataSets to SQL and Linq2Sql. These techniques will be useful in legacy applications that have recently been upgraded .NET 3.5 that have existing DataSets.
Leveraging the Local Data Cache and Bi-Di Sync
Location: Franz Hall, Room 034
This session discusses how to build a Local Data Cache leveraging Visual Studio 2008 and the SQL Compact engine. We will show how to avoid concurrency problems from the beginning and how to deal with them once they occur. We will see how to setup custom change tracking using SQL Server 2008 and highlight how it's done in SQL Server 2005. We will also explore how SQL Server decides which rows are to be sent to the client with snapshot, download, upload and bi-directional synchronization. We will also see how to implement an application using this technology.
Leveraging Visual Studio Database Edition
Location: Franz Hall, Room 034
Visual Studio Database Edition (VSDB) offers many benefits for the deployment process as well as the development of database updates. You may know it by its nickname - the "Data Dude". It provides for declarative style of approaching updates in a collaborative environment. This tool has been undergone significant enhancements recently and has many compelling features. We will view some the key functional areas of the tool, discuss best practices, and take a look at what features companies could take advantage of. VSDB is free to download for use with Visual Studio 2008 Developer and Team Suite Edition. It is also included as part of the Visual Studio 2010 Premium edition.
Multidimensional Reporting: MDX Essentials for Report Design
Location: Shiley Hall, Room 319
Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awsome power of a cube and to gain deep insight from a single version of the truth. Learn to develop dynamic, advanced reports by parameterizing MDX queries using expressions and custom code.
Scaling with NoSQL
Location: Franz Hall, Room 217
Many companies, from enterprises like Yahoo to startups like Twitter and Flightcaster, are using NoSQL databases to power the core of their business. The main reasons for this include: flexibility, speed, and scalability. This session will instruct how to think about scalability issues, and determine if NoSQL solutions (such as HBase and Cassandra) are correct for tackling them. There will be a collection of anecdotes and examples from well-known companies, as well as an easy to follow process for determining scalability needs.
Silverlight Data binding
Location: Franz Hall, Room 205
Silverlight gets better with each release. Since version 2, Silverlight has supported data-binding. Join this session to learn the 5 key parts, that make up a databinding, learn how to use binding converters,and see how to troubleshoot binding errors. Also, you learn about data-validation. While most of the code in this session is written with Visual Studio 2010 you'll also have the opportunitiy to learn about the suberb binding tools availabe in Expression Blend.
SQL Perf Counters, Thresholds, and Vital Signs
Location: Shiley Hall, Room 101
Interpreting SQL performance counters and OS related counters is an essential skill for a SQL DBA. In this session, we will discuss most relevant OS and SQL performance counters, vital signs, and preferred threshold values.
SQL Server 2008 High Availability on Cloud
Location: Shiley Hall, Room 123
This session will show how to achieve 99.9999 High Availability of SQL Server database on physical cluster and on Cloud.• SQL Server 2008 cluster Deployment• SQL Server 2008 Mirroring• Sql Server cloud deplyment.
SQL Server 2008 R2 Overview
Location: Franz Hall, Room 223
"R2"? What does THAT mean? Is this a "full" release or not? Buck Woody, Microsoft's real-world DBA and all around Gadfly will regale you with the explanation of such acronyms as "DAC", "UCP" and "MDW", and he'll explain what StreamInsight, Master Data Services and PowerPivot can really do for you. You'll take a quick tour of the features you should know about in SQL Server 2008 R2, the version of SQL Server that just couldn't wait for another year.
SQL Server for the Oracle DBA
Location: Shiley Hall, Room 123
Come hear Buck Woody, Microsoft's "Real World DBA" give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we will cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your "knowledge arsenal", come hear this overview. You'll also get a list of resources that will enable you to research further.
SQL Server Reporting Services—From Soup to Nuts
Location: Franz Hall, Room 026
Drawn from my monthly Progressive webinar, this 'deep dive'session discusses the three major players in the Reporting Services report authoring suite. These include Visual Studio BI report-authoring tool set, Report Builder 2.0 and the ReportViewer control. We start with a discussion of how SQL Server Reporting Services works and why you care followed by demos that show how to develop and deploy reports in each of these paradigms. Along the way we will emphasize security, performance and best-practice designs.
SQL Server Service Broker in the Real World
Location: Franz Hall, Room 223
Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we will dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.
Table Indexing for the .NET Developer
Location: Shiley Hall, Room 101
In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best.
The Data Warehouse: Your BI Foundation
Location: Shiley Hall, Room 319
Many DBAs are thrust into a data warehouse project with little training and no experience, or they are forced to take over the existing Data Warehouse. Designing or fixing a Data Warehouse model that supports the full range of BI functions can be a challenge for the OLTP DBA. This session will reveal the essential components that you should put in place for a successful implementation, including concepts such as the Importance of Transformation, Redundancy and why Reuse can be Detrimental, and one of his favorite topics, Ease of Query. Additionally, the significance of Integration, Metadata, and Governance towards creating a rock-solid, sometimes brilliant, foundation for your Business Intelligence Data Architecture will be presented.
The NoSQL Movement, LINQ, and MongoDB - Oh My!
Location: Franz Hall, Room 217
Learn how to leverage MongoDB to build .NET applications using LINQ as the data access language. This session will introduce the ideas around the so-called NoSQL movement. We will examine one of the up and coming open source databases called MongoDB. From there we will build out a .NET application using LINQ and MongoDB in a series of interactive demos using Visual Studio 2010 and C#. We will also be covering the NoRM LINQ to MongoDB library in our demos.
T-SQL Coding Best Practices
Location: Franz Hall, Room 223
This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session, you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session, you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements.
Tuna Helper for DBAs and Developers
Location: Franz Hall, Room 106
Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects.