Sessions

Tony Rogerson

There are three major features in SQL Server that are usually under used or not used optimally; these are - a) Derived Tables, b) Common Table Expressions and c) The CASE expression. In this session I look at the in's and out's of each feature from basics right through to advanced techniques and considerations.

Satya Shyam K Jayanty

Database Tuning Advisor (DTA) - MOT your database. Using DTA tool all the existing tuning sessions available to review makes it easy to: clone sessions based on existing ones, edit existing tuning recommendations. How to perform this tuning exercise at regular intervals to monitor the physical design of your databases. A tour with "what-if" analysis to keep up the performance.

Satya Shyam K Jayanty

What’s new in SQL 2008 Management Studio – to provide an in-depth preview of new performance monitoring tools? This is to enable: 1. Understand the architecture of how SQL Server 2008 collects performance and diagnostic data and presents the information in Microsoft SQL Server Management Studio. 2. Develop a plan for enabling performance data collection and analyzing the results for troubleshooting and diagnostics. 3. Learn how to create your own collection sets and manage the performance data collection warehouse database.

Satya Shyam K Jayanty

SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This presentation involves my experience with a demo & discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.

Satya Shyam K Jayanty

I see SSIS tool has a lot of potential and with recent deployment of these services in various production environments. Still the users are not fully accustomed to use the SSIS and there is a need for development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as must and should but these are tried and tested methods and if nothing else should serve as a basis for you developing your own SSIS best practices.

Satya Shyam K Jayanty

SQL Server has evolved into a major RDBMS provider since the release of 2000 version. Now the 2005 provides various features and industry trend is taking a lot of importance for SQL Server. So all these years what DBA responsibilities are getting intelligent and need to keep up with constant learning and training. So where you need to begin your journey? So what it will take to get real world experience, how far you can learn and how best you can implement within your environment. I will also cover the enhancements from SQL 2005 to 2008 that every DBA is interested to manage their environment with available technologies.

Satya Shyam K Jayanty

Installation requirements can vary widely, depending on your application needs. The different editions of SQL Server 2005 accommodate the unique performance, runtime, and price requirements of organizations and individuals. Which of the various SQL Server 2005 components you install will also depend on your organization or individual needs. The following sections help you understand how to make the best choice among the editions and components available in SQL Server 2005. There is lot of confusion and uncertainty to choose which edition will provide and that fits to the organizational needs in an Enterprise environment. This session covers the edition features and provides idea about which one to choose for effective usage.

Sutha Thiru

What is MDM and How does it help BI? What is Microsoft vision on MDM? Overview of the new Microsoft MDM offering. Demo of the product (Providing CTP is out by then)

Richard Fennell

Microsoft Visual Studio Team Edition for Database Professionals for the first time makes the database developer a first class citizen in the Microsoft development family. In this session I will cover the complete development life cycle using this tool, addressing issues such as schema management, source control, testing, data generation and deployment.

Charley Hanania

Didn't anyone tell you?!? Mainstream Support for SQL Server 2000 ends on the 8th of April 2008! So upgrading to SQL Server 2005 is the right move in most cases (unless 2008 is an easier option for you) but it doesn't come without its share of concerns. This session focuses on the upgrade of SQL Server databases from SQL Server 2000 to SQL Server 2005, the general approach and traps that may be easily overlooked. We'll even look at the upgrade path to SQL Server 2008 from SQL Server 2000 and SQL Server 2005.

Charley Hanania

Many organisations spend a lot of time locking down access to server rooms and servers only to find that the way that the applications have been developed are insecure. Remember, your data is only as secure as the weakest entry point, physical or abstract! In the last couple of versions of SQL Server, Microsoft focussed increasingly on providing a wide range of security features to assist in development of secure applications, so accessing your data in application in a secure way has never been easier! In this session you'll find out about how to design systems to be secure by default, focussing on key security concepts in SQL Server 2000 and 2005, with a view into the improvements that SQL Server 2008 will bring as well.

Dr András Belokosztolszki

This session is focused on transient data in SQL Server. We will look at questions like: What is stored in tempdb? Is tempdb a performance bottleneck? What are the differences between temporary tables and table variables? What is stored in the transaction log file and how can its size be kept under control?

Dr András Belokosztolszki

Databases, like applications, evolve. However, unlike applications, databases can be modified directly. This is like modifying an application via a hex editor. In this session Andras will contrast the two most common database development styles: working on a live database directly vs. working with creation SQL scripts. He will show some of his own techniques and chosen tools to display how to avoid some change related problems, to manage database changes and to set up source control for databases.

Colin Angus Mackay

It is reckoned that 80-90% of data has a spatial component to it. But what do we do with it now? At best, we constrain it to postcodes. Well, that would be great if we were delivering letters, but the majority of us aren’t. In this session we look at Spatial Queries in SQL Server to see how it works and what can be done with it.

Hue Holleran

Scripting is essential for many tasks: eg. automating tasks and streamlining installs and performing changes on remote databases. Solid scripting is essential in larger organisations - all changes are deployed to production in this way. Improving your scripting not only makes you more productive but can also make a difference to your pay packet - giving you access to these larger and more formal environments! On the surface, scripting is not the most exciting of concepts BUT the world has changed significantly since isql grew up and became SQLCMD and many uses that we could only once dream of are now made possible with SQLCMD. If you've not used SQLCMD yet - be prepared for a surprise - I can guarantee you that once you leave this session you'll have the "by default, open new queries in SQLCMD mode" option permanently checked! This session will be useful to you even if you can only "string together a handful of SQL queries" - as that's all scripting is at the simplest level! This session goes well beyond the concepts and shows tried-and-trusted techniques used every day by the session's presenter.

Christian Bolton

Think about what happens when you issue a query to update a row: *The optimizer creat