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?
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?
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
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.
This session will drill into some of the details on the shipping HP BDA and BDW appliances and how they can work well together to deliver a comprehensive BI and DW solution for customers using the Microsoft Application Platform.
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.
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.
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 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.
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!
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.
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
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.
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.
Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. This session will short-cut you past years of hard-won experience straight to the essentials of IO tuning for SQL Server.
A 1hr session jam packed with demos on SSRS Spatial reporting
In this session, I will take simple SQL statements, the stuff you write every day, and bump up the scale until things start breaking
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.
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.
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.
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 ?
Steps involved in implementing a near-real-time data warehousing 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.
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.
Mat will introduce how NAND flash can be introduced into a system, either as cache or persistent storage whilst discussing the pros and cons of each.