join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
April 2009 - Posts - Charley Hanania

MSSQLTips

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

Charley Hanania

April 2009 - Posts

  • Swiss PASS Chapter May Meeting - Eliminating SQL Server Downtime & Designing Effective Aggregations

    Hi all,

    Just a very quick note to mention that we've lined up some great sessions for the May 5th Chapter Meeting to be deliverred by Chris Webb and David Tung (thanks guys!). If you are in the vicinity (ie Switzerland) then definitely put your name down and come along, alternatively you can join us virtually, as we'll be making the sessions available "live" over our MS Live Meeting links (see below):

    We've got some PASS Caps and my attendee bag left over from the Conference and I'll be giving those out to some of those who are there... They actually look pretty good! :)

    Details:

    Date: Tuesday, May 5th 2009
    Time: 17:45 – 21:00 CET (light apéro starts 17:45)
    Session 1: 18:00 – 19:15
    Session 2: 19:30 – 21:00
    Location:

    Digicomp Academy AG
    Limmatstrasse 50,
    CH-8005 Zürich, Switzerland.
    Tel. +41 44 447 21 21.

     

    Session 1:  [18:00 – 19:15]
    Eliminate SQL Server Downtime – Even for maintenance

    No enterprise can afford to be down. Whether private or public, Fortune 100 or startup, the objective is the same: keep the business running, your customers and partners depend on it. This presentation will provide you with an overview of current high availability solutions for SQL Server.
    You'll learn how you can implement active-active databases to protect critical applications from unplanned outages, eliminate the need for scheduled maintenance windows and improve application scalability and performance by better utilizing your existing hardware.

    Topics Covered:

    • Business impact of both planned and unplanned database outages
    • Availability solutions for SQL Server: clustering, mirroring 
    • Disaster recovery – easily solving the geographical disaster recovery problem 
    • Scaling up with a multiple server database Grid
    • Running reports without compromising OLTP 
    • Putting continuous availability into practice

    Presenter:
    David Tung (Solutions Architect, xkoto, Inc)
    David was one of the core developers of xkoto GRIDSCALE during xkoto's founding in 2005. As a solutions architect, he has consulted at many major European and North American customers implementing high availability solutions.

    Livemeeting Link: https://www.livemeeting.com/cc/usergroups/meet/5P5PQB  

     

    Session 2: [19:30 – 21:00]
    Designing Effective Aggregations in Analysis Services 2008

    Building aggregations is one of the most important ways of improving query performance in Analysis Services, but simply running the Aggregation Design Wizard doesn't always result in useful aggregations being built. This session shows the steps you need to go through in order to build aggregations that are actually going to be used by the queries that you're running.Presenter:
    Chris Webb (Crossjoin Consulting)
    Chris Webb is an independent consultant who has been working with the Microsoft Business Intelligence toolset since 1998. His main focus is Analysis Services - complex MDX queries and calculations are his particular interest - although he has much experience with Reporting Services, Integration Services and various other related tools.
    He has worked both as a consultant, including three years with Microsoft Consulting Services, and on internal BI development projects in a wide range of industries including pharmaceuticals, banking, finance, manufacturing, engineering and retail.He is a co-author of the book "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase" along with George Spofford and others, and is an active member of the Microsoft BI community, contributing regularly to newsgroups, online forums and speaking at conferences.

    His weblog can be found here.
    Livemeeting Link: https://www.livemeeting.com/cc/usergroups/meet/4ZJQ3Z 
  • Predictive Analysis Whitepaper

    Predictive analysis is basically being able to leverage current and historical data to help make decisions in the future.

    As a DBA, I of course, LOVE data, and the idea of finding trends and information in hindsight to affect what we can focus effort on or leverage potential opportunities is incredible.

    MS have released a whitepaper describing how to do this easily through tools and applications such as Sharepoint, Excel and SQL Server. A good read for decision makers, fortune tellers and the otherwise curious...

  • Where OCS meets SQL Server

    I was lucky to meet Sasa Juratovic yesterday through Dejan Foro and we all got to speaking about how OCS is another MS Enterprise level application that makes heavy use of SQL Server for storing and managing its application data.

    Through the discussion, we agreed that I could leverage my DBA "skills" and T-SQL knowledge to help fill some wish-list gaps in the product's features (this is generally where cross over communities can help), and I'll be looking into coding a few things initially with T-SQL and Powershell to help with Archiving and CDR reporting. I worked for a Telco in the late 90's in Geneva Switzerland and loved it, so this will be a welcome distraction in the wee hours of the night, while bringing my atrocious Powershell skills up to a better level as well (Despite attending some brilliant sessions from Buck Woody on the subject).

    While I'm at it, let me know if there's other information or functionality you'd like to have gap-fills for, and I'll add them to the list while playing around with OCS back ends :o)