A guide to the things that you should be doing if you use the CLR, as well as those that you shouldn't. Find out what you need to be aware of, with a cause-and-effect approach.
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
A look at the new SSIS features in SQL Server code-named Denali
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
This session will be an in-depth look at what the MDS business rules are and how they work, including a series of demos and guidance on how the rules are built. SharePoint Workflow will also be covered, as MDS can initiate a SharePoint workflow.
All developers and DBAs make mistakes when programming in SQL Server. Learn to avoid the most common mistakes.
Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
A look into the world of database testing, how to go about it, why do we really need it and how to work well with your peers and managers for greater project success.
We all know how much love DBA's have for Developers and visa versa. You can measure it in milligrams. This fun session discusses the issues we have with one another and presents some solutions to save knives in backs and blood stained carpets.
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
This will show the replication options available in sql server and in which situations each type can be used. I will also show how to set it up and some diagnostic techniques for when it doesnt work
SQL Server spatial features have not yet made it into mainstream usage and many developers still ask "But *why* would I use them?". In this session, I hope to answer that question by replicating the functionality of Google Maps using only SQL Server.
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
Back (hopefully) by popular demand I'll be sharing the secrets to getting started with Powershell in a SQL Server Environment.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
A look at the Microsoft Business Intelligence stack and how other products can enhance a SQL BI project.
Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.
Planning a failover clustering implementation in a single data center is fairly straightforward, but what happens when you want to span data centers? Come and find out how to plan a multi-site failover cluster.
The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases
In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling with PowerPivot.
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
This session will compare and contrast the various SQL Server high availability options and discuss the things you need to do - both SQL Server and non-SQL Server - that you need to do to achieve availability.
SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
Jon Reade examines the performance benefits of SSDs in a SQL Server environment.
Are you uncomfortable with the idea of SQL Server Clustering? Do you currently use it and are scared to go near your Clustered Instances and their physical hosts? Stop worrying and learn the "Dark Art" of SQL Server Cluster administration.
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.
Event Stream Processing opens up a mass of opportunities for reacting to patterns in your data in realtime. This session shows you how.
SQL Injection attacks are one of the most common hacker tricks used on the web. Learn all about SQL Injection attacks in this perennially favorite session.
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore
This presentation will cover all of the new engine and tools features coming our way in the next major version of SQL Server.