Blog | Madeira Data Solutions

Cursor Types

If you ask any SQL Server DBAs about cursors, they will tell you it’s a big no-no. If you search for T-SQL best practices on the web, in...

Querying XML Using the Edge Table Format

Recently I was asked by one of our customers about querying XML in a relational format. “Sure”, I answered, “you can use OPENXML to...

Job Executions at Point in Time

If you want to monitor job executions, usually the easiest way is to use the Job Activity Monitor or the Job History Viewer in SQL Server...

Can query performance be dependent on the client?

This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent on...

SQL Azure

SQL Azure is a Microsoft solution for relational database cloud computing. It comes as part of the Azure platform. As with the Azure...

Things To Know About Analysis Services Server Properties

In most sites I’ve been working at, developing Analysis Services solutions, most people were treating the Analysis Services server as a...

Moving System Databases in SQL Server 2005/2008

This article may be useful when you want to relocate your system databases to another disk on the same server (same instance). There...

Windows Azure

In the last 12 months, virtualization and cloud computing have become one of the hottest issues in the hosting world. It started with...

Statement-Level Query Statistics Script

One of the powerful tools that the DBA can use when tuning queries is the “sys.dm_exec_query_stats” dynamic management view. This view...

Maintenance plan exporting problem on named instance

Problem I installed SQL server 2005 Developer edition with a named instance on my computer. I created a database in order to check some...

CONTACT US