Charley Hanania

Free MDX Training in Zurich

2010-02-12T15:22:00Z

Microsoft Switzerland has a full day Seminar prepared titled: "Introduction to MDX with Chris Webb" its on the 16th of March 2010 at the MS Campus (Richtistrasse 3, 8304 Wallisellen) Details: Registration: 08:30, Seminar start 09:00, End 16:30 If you want to get the most out of your Analysis Services cube it’s essential to know and understand MDX: you need to be able to write queries and calculations. This one-day seminar, aimed at those with little or no previous MDX experience, will teach...(read more)

Breaking into the DBA space

2009-12-01T22:58:00Z

I love helping people, I love to teach and I really love hearing about success stories from people in my past whom I've interacted with, had the chance to help out through eith a course, tutorial or just a few helpful hints to get them started in the SQL space. I've been a lot of places and very recently was awarded MVP for SQL Server, and it looks like this is re-igniting some very old friendships and contacts, which to me is as valuable as if not more that the recent awards. Interestingly...(read more)

Moderating Hour 16 of the 24 Hours of PASS...

2009-09-03T14:46:00Z

Well, it was great, I attended around 12 of the 24 Hours of PASS Virtual event sessions yesterday and the quality of the content, the preparedness of the speakers and overall lack of issues was incredible! Hats off to Rick Heiges , Blythe Morrow , Chuck Heinzelman and PASS management as a whole for getting it together and gluing all of these moving parts into one well oiled and tuned virtual event. They coordinated speakers from the up coming US PASS Summit happening in November as topic presenters...(read more)

SQL Server Saturday - Swiss Style!

2009-09-01T01:57:00Z

There are many SQL Server Saturday type events happening in the US, but this is the first we've attempted to host here. Its been a "handfull" to organise to say the least, but enjoyable nonetheless. Its taking place on the 19th of September 2009 at Digicomp Academy, and all you need do to attend is register on the Event's Website: www.sqlsaturday.ch . We've got 3 tracks, BI, App Development and Database Administration 5 sessions per track and a good balance between English and...(read more)

Register for 24 Hours of Super SQL Server and BI Training!

2009-08-31T17:24:00Z

As more than 2,700 people from over 60 countries around the world get ready for the most value-packed 24 hours of SQL Server and Business Intelligence training available, PASS wanted to thank you for your amazing support and give you some final 24 Hours of PASS instructions and tips. 24 Hours of PASS will start broadcasting its exceptional lineup of 24 back-to-back webcasts to your computer starting at 00:00 GMT (UTC) on Sept. 2. Once registered, links to each session you registered for should appear...(read more)

Powershell Series #1: Setting up Powershell

2009-07-14T15:54:00Z

OK, first things first... I have SQL Server 2008 installed locally (developer edition) on Vista, which I believe installs Powershell for you as a component... I'm using V1.0. The easiest way to see if its installed it to use the "run" command and type powershell... If its not installed, read this article How to Download Windows PowerShell 1.0 . Once that's done, you need to set up your environment. I would encourage you to install Marc's " Tab Completion " Tool for...(read more)

And here starts the Powershell Series...

2009-07-14T14:30:00Z

Most DBA's have a hard time coming to terms with programming languages, and although I've used close to 10 in my history I've always defaulted back to my tried and trusted T-SQL to cater for my data-focussed needs... A while back now though, the hype increased on LINQ for example and now for Powershell, and although I never saw LINQ take off Powershell is another matter in deed... Powershell leverages many components to bring a powerful scripting interface that surpasses the old WMI and...(read more)

SQL Server 2008 Developer Training Kit

2009-06-22T18:45:00Z

The Microsoft Developer and Platform Evangelism Team has put together a training Kit on SQL Server 2008 Covering the following: Date and Time Types Filestream Grouping Sets Reporting Services Row Constructors Spatial Data SQL CLR Table-Valued Parameters T-SQL Merge Statement Within the download is a series of Presentations, Demos and Hands-On Labs that are free and definitely worth the time to look into it. Enjoy!...(read more)

Swiss IT Pro User Group Meeting July 2009 : Virtualization - What's New (VMware / Microsoft)

2009-06-22T03:59:00Z

We've got the information for next month's User Group Meeting, Channelled through SwissITPro this month. Theme: Virtualization - What's New ( VMware / Microsoft ) Language: Deutsch Tuesday / Dienstag - 7 July / Juli 2009 17:45 - 21:00 Uhr (Kleiner Apéro 17:45 - 18:15 Uhr) Where / Wo? Digicomp Academy AG (Zürich) Limmatstrasse 50 CH-8005 Zürich Tel. +41 44 447 21 21 Nutzen Sie die Gelegenheit, Ihren Kollege und die Kern Swiss IT Pro User Group Freiwillige kennenzulernen. Session #1: Hyper...(read more)

Re-post from The Microsoft Learning Community and Evangelism Team Blog - free Microsoft Certification voucher

2009-06-21T21:54:00Z

For those of you who have enlisted or who are still to enlist for my help to get you through the SQL Server exams on SQL Server 2005/2008, look at this poast as it could get you an exam voucher to give you even more motivation to get through all the study and practice! :) from: http://blogs.technet.com/mslcommunity/archive/2009/06/17/this-rss-is-dead-but-the-new-one-could-win-you-a-free-exam.aspx This RSS is dead… but the NEW one could win you a free exam! As the title says… if you are reading this...(read more)

SQL Management Studio Snapshot Add-In

2009-06-21T10:02:00Z

I attended a talk the other day and the speaker was showing SQL Server Potentials and Professionals alike on how easy it was to manage SQL Server from Management Studio. One of the areas emarrasingly was creating Database Snapshots. The presenter looked all over Management Studio for it but couldn't find it... Do you know where it is??? Well look here for it, as its an add in tool written by Sean Price in 2007 :o) http://sqlblogcasts.com/blogs/seanprice/archive/2007/07/15/sql-management-studio...(read more)

Disk Partition Alignment Best Practices Whitepaper for SQL Server

2009-06-19T10:31:00Z

We've been discussing this for so long and warning Sys Admins about making sure our servers are in proper good nic before handing over to us for the SQL install and config. So rather than just talking about it, we can point them to a whitepaper on it... simplifies the list of blog entry links that we generally have to search for and email them ;o) http://msdn.microsoft.com/en-us/library/dd758814.aspx all good :)...(read more)

Backing up Sharepoint Databases for True Point in Time Recovery

2009-06-06T00:32:00Z

I've been working on a whitepaper for Quest (for a while) which focusses on Sharepoint Recoverability from a DBA's perspective. As you proably know Sharepoint uses SQL Server to store its data, and although the data structures and usage within the SQL Server databases isn't what a DBA would call "optimal" its heavy use of tables etc brings things such as Performance Tuning, Capacity Planning and Disaster Recovery into the realms of the DBA as a relatively "complex"...(read more)

Failover Clustering and Virtualization - Update from MS CSS

2009-06-02T12:58:00Z

Virtualisation and Failover Clustering wasn't one of the options you had for SQL Server previously, but Bob Ward has just updated a KB with details on the change of stance and why its now supported :) In reading my blog, you'll know that I'm not the biggest fan of Virtualisation... You'll also know that its not virtualisationper se that is the issue in my view it's how the term has been percievably made into the be all and end all of issues in IT. It is still immature in my eyes...(read more)

New Swiss PASS Chapter Logo

2009-05-28T18:50:00Z

The brief was to create a logo for the Chapter that represented Swissness as well as being part of PASS. Something subtle, yet effective. We had 29 respondants submit 49 entries over the course of 7 days and there were some really good entries in there as well! The winner was awarded $150 USD, so both them and we are happy :o) In the end I chose the image below, and I hope you like it too. To see it context of the website, just go to www.sqlpass.ch Let me know what you think, I'd be very interested...(read more)