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.
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 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.