SQL Server 2008 R2

SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)

In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment and the installation fails reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the…

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…

Security Changes in SQL Server 2008

SQL Server 2008, among other introduced significant security changes that enhance the database administrators applying an even stricter security policy on the SQL Server instances. Besides the changes in the Windows local groups that are created during the SQL Server setup process, the changes in surface control tools where now…

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…