Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed…

If you ever encounter issues when trying to create, add, or edit steps for a SQL Server Agent job in SQL Server Management Studio 2008 R2 don’t worry! The error popup you might get is the following: There is a fix for this issue. You can find it here. The fix applies to the following … Read more…

Upcoming CDNUG Event – Microsoft and Openness / Clustering in SQL Server 2008

Cyprus .NET User Group (CDNUG) brings another event to you, by/for the Community! This month’s event features two sessions: Microsoft and Openness Clustering in SQL Server 2008 The first session, with speaker Andreas Hadjipanayi (Technical Account Manager at the local Microsoft Office in Cyprus) discusses how Microsoft has become more open over time. The major discussion … Read more…

CDNUG Event Review – July 15, 2010 – Windows 7 Development / SQL Server 2008 R2

A great CDNUG event took place on July 15, 2010! As it was the last event before summer holidays, it was a celebratory one of course! After having some sweets and Greek frappé coffee, the event started! Due to the nature of this event, we had two sessions. The first session, dedicated to Windows 7 … Read more…

Building Data Relationships in PowerPivot

This post is a follow-up to the previous post titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word”. In this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, create relationships on the data and perform aggregations that is BI! 🙂 For example, consider the two following … Read more…

Using PowerPivot’s Copy-Paste Support for Importing Data from Word

One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data fast. An example of using the above feature is importing data from Microsoft Word. Let’s say you have a Word document containing the … Read more…

Introduction to SQL Server PowerPivot – MS Momentum 2009 Session Review

On November 26th 2009, Microsoft-Cyprus launched Momentum 2009; a New Efficiency Community Launch event. The event took place in Nicosia, Cyprus, Europe, and had at around 400 attendees. Two tracks were featured: one for Developers, and another one for IT-Pros. I had the pleasure to participate as one of the Cyprus .NET User Group (CDNUG) speakers. … Read more…