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...
Madeira TeamDec 20, 20092 minBusiness or PleasureWhen I was young and free (and stupid, let’s be honest – we were all quite stupid when we were young and free), I dreamed about living on...
Madeira TeamDec 16, 20095 minRenaming databases and database files in SQL ServerOverview Sometimes there is a need to rename a database. There may be variable causes: Restoring/moving the database from...
Madeira TeamDec 14, 200915 minPartitioning on SQL ServerOverview Partition views have been part of SQL Server since SQL Server 7.0, but the maintenance and benefits they provided were limited....