(John Desch) In 2007, Carl Rabeler and Eric Jacobsen wrote a fairly detailed white paper entitled Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.

(Richard Douglas) Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.

(Tim Radney) Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the availability of SQL Server databases. Questions that always come up when discussing availability of the data is “Recovery Time Objective – RTO” and “Recovery Point Objective – R

(Chris Yates) This week I am back at it with my SQLCoOp friends in sharing something new that we’ve learned since our last post. You ready? Great, pull up a chair and let’s see where this takes us shall we?

(Thomas LaRock) Back in March there was an announcement that data compression was available for Microsoft Azure SQL Database (MASD). This was met with much rejoicing. You can read more about the announcement here.

(Marcin Policht) In our recent posts published on this forum, we have been discussing characteristics of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform.

(Chris Webb) One area where I see people have a lot of problems when they’re learning MDX is when they are working with dates. SQL has a lot of great functionality for working with dates while MDX, to be honest, does not – therefore people tie themselves in knots writing complex MDX expressions (whi

(Pinal Dave) In Repair a SQL Server database using a transaction log explorer, I showed how to use ApexSQL Log, a SQL Server transaction log viewer, to recover a SQL Server database after a disaster. In this blog, I’ll show you how to use another SQL Server disaster recovery tool from ApexSQL in a s

(Hannes DuPreez) A month or so ago, I wrote a few articles introducing you to the world of databases and VB. If you have followed them, you have seen that it is not particularly difficult to use databases properly from VB. Today’s article is no exception. Today I will talk about using stored procedu

(Gilbert Quevauvilliers) Below are the steps that we have integrated into SSAS using SSIS so that we can then drop our old SSAS Partitions using SSIS and XMLA.