Madeira TeamJan 19, 20103 minSQL AzureSQL Azure is a Microsoft solution for relational database cloud computing. It comes as part of the Azure platform. As with the Azure...
Madeira TeamJan 17, 20103 minThings To Know About Analysis Services Server PropertiesIn most sites I’ve been working at, developing Analysis Services solutions, most people were treating the Analysis Services server as a...
Madeira TeamJan 13, 20108 minMoving System Databases in SQL Server 2005/2008This article may be useful when you want to relocate your system databases to another disk on the same server (same instance). There...
Madeira TeamJan 3, 20103 minWindows AzureIn the last 12 months, virtualization and cloud computing have become one of the hottest issues in the hosting world. It started with...
Madeira TeamDec 21, 20091 minStatement-Level Query Statistics ScriptOne of the powerful tools that the DBA can use when tuning queries is the “sys.dm_exec_query_stats” dynamic management view. This view...
Madeira TeamDec 20, 20092 minMaintenance plan exporting problem on named instanceProblem I installed SQL server 2005 Developer edition with a named instance on my computer. I created a database in order to check some...