join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Swiss PASS Chapter: October 2008 Meeting - Charley Hanania

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Charley Hanania

Swiss PASS Chapter: October 2008 Meeting

Hi All,

As promised I'm posting the 2 presentations from the last meeting:

1. SQL Server 2008 – Business Intelligence, presented by Bernd Schneider (Thanks again for taking the time Bernd!)

New features like improved cube designers, MOLAP enabled write-back capabilities, easy creation and deployment of reports were covered in the session.

2. SQL Server 2008 – Management Studio's New Features, presented by me.

This session delved into some of the top changes that have been brought into SQL Server Management Studio such as:

  • Activity Monitor
  • Object Explorer Details
  • Object Searc
  • Server Facet
  • Multi-Server Queries
  • Intellisens
  • T-SQL Debugge
  • Object Dependency Viewer

 

The presentations are saved as PDF, looking forward to seeing you all again next session (Expected to be 1st Tuesday in December 2008)!

Thanks again to Digicomp our location sponsors, SwissITPro as we're its SQL Server Special Interest Group, and Microsoft of course for their strong partnership and continued support of our activities.

 

Additional Notes:

  • A noteworthy comment from Daniel Steiner was that CU1 is recommended for install prior to installing the Tools. Fortunately My install went pretty smoothly without it :o)
  • Another question that I have not investigated fully yet, but we hinted towards it during Q&A was whether there's a performance hit when using multiserver queries, as it determines what databases are available within each instance in the multi-server set. The gut feel from the demo was that it gathers the data when you establish a multiserver query connection, and so time to open a query would be impacted both by the number of connections and the relative bandwidth performance you're getting to the instances themselves.
  • Save the date: The European PASS Conference for 2008 was a roaring success, and we're in the middle of planning the 2009 Conference! Go to the http://www.european-pass-conference.com/ for details, and email me if you'd like to help with the event's organisation!

Cheers!

Comments

No Comments

About Charley Hanania

Based in Zurich, Charley Hanania works as a Senior Database Specialist at UBS Investment Bank. Prior to this he supported and consulted to numerous organisations in database development, architecture and administration related areas throughout Europe and Australasia. With close to 15 years experience on SQL Server, Charley's focussed on SQL Server since version 4.2 on OS/2.

Communities are Charley's passion, and he became active in database communities in the mid 90's, participating in SQL Server and heterogeneous database user groups in Australia. He continues to lead an active role through various community events, the SwissITPro User Group and the Swiss PASS Chapter.

View Charley Hanania's profile on LinkedIn