SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets I recently ran across a poorly covered topic in regards SSRS development using MDX parameters and datasets. After...
2013-02-07
31 reads
HP Announcement: PDW V2 Appliance Features
New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server...
2012-11-16
2,200 reads
HP Announcement: PDW V2 Appliance Features New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server PDW have been announced! Highlights: Lower price point (backup...
2012-11-16
12 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,138 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
22 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,180 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
35 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,822 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
33 reads
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,420 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers