Sessions & Content

Tags
Content Type
Search
Conference
Advanced SQL Server 2008 Troubleshooting
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
Advanced SSRS. Find out what you have been missing
Would you like to see examples of advanced SSRS reports that you do not see every day and which are not very easy to build (if you don’t know how) but are very useful for business users?
Basic BISM
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
Building a SSMS Add-in; The Agony and Ecstasy
We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.
Building Great Models for Crescent
SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.
Creating a Meta Data Driven SSIS Solution with Biml
In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.
Data Quality Services-Making Data Suitable for Business
Data Quality Services is a new product coming in the SQL Server Denali release of Microsoft SQL Server. Come to this session to understand how it can take your data cleansing to the next level.
Data Replication Redefined – best practices for replicating data to SQL Server
This session will provide expert advice & best practices for replicating Oracle (& other) data to SQL Server for data warehousing & BI initiatives. Also, become one of the first to see Attunity’s innovative new software in its historic unveiling!
Database Development with SQL Server Juneau
Juneau is a new developer tool in Denali. Brings VS paradigms to SQL Server like Debug, Refactor and Declarative maintenance. Come to this session and learn what these tools are really about.
Database unit testing with visual studio 2010
This session will cover why you should run database unit tests (and when you should not). It will show how to set them up and run them in visual studio 2010
Deep Dive – HP EDW, Massive Scale, Low Cost
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.
Designing an SSIS Framework
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging.
Fast Track to Spatial Reporting
A 1hr session jam packed with demos on SSRS Spatial reporting
Finding the Limits
In this session, I will take simple SQL statements, the stuff you write every day, and bump up the scale until things start breaking
Gather SQL Server Performance Data with PowerShell
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Gruesome Grotesque and Gory Horrors Stories from the World of IT
This session with SQL Server MVP Kevin Kline will reveal the worst-ever stories he’s experienced in the World of IT, along with some of the most challenging technology issues and harrowing situations.
Handling Advanced Data Warehouse Scenarios in SSIS
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
Hey PowerShell Eventing, can you notify me ?
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?
Implementing Real-Time Data Warehouse
Steps involved in implementing a near-real-time data warehousing solution.
Inside Ola Hallengrens Maintenance Solution
How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.
iPad and Powerpivot-Mobile Business Intelligence in action
The Apple iPad's cutting edge usability, along with PowerPivot’s accessibility, can be combined to enhance productivity for mobile business users. Come to this session, and learn about mobilising BI for the iPad generation of end users.
Keynote - Appliance Roadmap
This keynote will provide deeper insight into the currently available appliances (Business Decision Appliance, Business Data Warehouse, Enterprise Data Warehouse) and solution blocks (Database Consolidation Solution), as well as looking to the future
Knowing the Internals, Who Needs SQL Server Anyway?
Based on my experience in creating OrcaMDF, an open source MDF file parser, I'll go through the primary storage structures, how to parse pages, headers, internal base tables, b-tree structures as well as the supporting IAM, GAM, SGAM and PFS pages.
Let Service Broker Help You Scale Your Application
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
LogParser-quicker than SSIS, easier than BCP
LogParser is a free data application that anyone working with SQL Server should know about, come along and see how you could use it.
Many-to-Many Relationships in DAX
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
Master Data Services in SQL Server Denali
Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.
MDX and DAX-compare and contrast
This talk looks at MDX and DAX, examining their similarities and differences. It won’t turn you into an expert in either but it will help you to decide, given your particular career plans, if either or both are worth learning.
Myths and Monsters of Flash
Steve will explore some of the characteristics of NAND flash, introduce the mechanics and debunk some myths along the way.
Performance tuning from the field
In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.
POSH Clustering
This exciting session will be delivered by PowerShell expert James Boother and Clustering expert Mark Broadbent where we will demonstrate how to use PowerShell to perform SQL Failover Cluster administration and automate simple and complex operations.
PowerPivot and QlikView 101
How to get started with PowerPivot and QlikView. Covering how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard. We’ll walk through the same example on both systems and compare the results.
Preparation for Disaster
Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa
READPAST & Furious: Transactions, Locking and Isolation
In this session we will investigate SQL Server concurrency and reveal some very surprising and thought provoking behaviors.
Real Time and Historical Performance Troubleshooting with SQL Sentry
In this session Aaron Bertrand and Steve Wright of SQL Sentry, will illustrate how SQL Sentry provides unparalleled insight, awareness and control over the true source of performance issues in SQL Server.
RoboDBA
I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)
SQL Azure-Design Concepts
Basic outline of SQL Azure: How SQL Azure fits in with other Azure Storage Options. Main differences between SQL Azure and SQL 2008. Brief new design challenges.
SQL Server Community presents : The A to Z of SQL Nuggets
The leaders from every SQL user group across England, Scotland & Wales have got together and created the definitive dictionary of essential SQL know-how, and crammed all of this into a single fast paced romp through the SQL alphabet.
SQL Server Upgrade: take help from tools and best practiceS
Database or SQL Server instance upgrade will need thorough planning and implementaiton.
SQL tuning from the dot.net perspective
So your customer's dot.net application is ready to ship and it is dog slow. This session focuses on the tools and methology that SQL consultants use to test and improve performance with dot.net applications.
The Art of War-Fast Track Data Warehouse & Fragmentation
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!
The forgotten DBA daily essential checklist
Well, I'm a DBA and one of my duties is to check that all SQL Server stuff are in the right place. It's a routine job, but, probably, the most important duty as DBA because it can help me to predict many important problems.
Through the virtual looking glass – monitoring virtualised SQL
Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.
To Err on the safe side: Denali T-SQL Error handling
We will look into creating a full blown generic error handling routine for T-SQL stored procedures using SQL Server Denali error handling features.
Transaction Log Performance & Troubleshooting-Deep Dive
In this session we will take a deep dive into gaining an understanding of things that can affect transaction log performance and look into methods of prevention and troubleshooting of everyday gremlins.
Trivia Quiz: Test Your SQL Server and IT Knowledge and Win Prizes
Join Quest Software to test your knowledge at our fun lunchtime quiz with SQL Server MVP Kevin Kline, where you’ll test your mettle against a variety of questions ranging from early computing technology to the latest features of SQL Server “Denali”.
T-SQL : Bad Habits to Kick
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
TSQL Performance Recommendations
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
Understanding SQL Server Execution Plans
Do you know SQL Server Execution Plans? Yes! - and can you read/analyze them? No... For the beginner it is not very easy to understand and explain execution plans generated by SQL Server for your queries.
Vertipaq vs OLAP: Change Your Data Modeling Approach
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
<<12>>