I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
16 reads
At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics. I thought I’d...
2013-06-19
7,089 reads
At TechEd 2013, I attended many excellent Business Intelligence / Data Platform sessions and thought I’d share an overview of a...
2013-06-11
708 reads
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return...
2013-05-27
7,459 reads
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,260 reads
I recently implemented an MDX expression to count the number of weekdays in a given timeframe. This logic is likely...
2013-03-25
2,731 reads
A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube. For example, users may wish to...
2013-03-11
5,679 reads
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,395 reads
PerformancePoint provides several options to create filters. One of the options available is ‘Named Set’. Within SSAS cubes we can...
2013-03-01 (first published: 2013-02-25)
2,118 reads
PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’. Data sources that...
2013-02-18
1,845 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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