Jumping from SSIS 2008 to SSIS 2012
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I...
2012-11-01
2,494 reads
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I...
2012-11-01
2,494 reads
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,661 reads
PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...
2012-10-25
2,888 reads
I have come across a number of tips while using MDS. These are tips not big enough for their own...
2012-10-23
9,196 reads
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
5,998 reads
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement...
2012-10-18
1,190 reads
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
743 reads
There are four different way to interact with Master Data Services (MDS) to do things such as create a model, load...
2012-10-11
3,134 reads
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,252 reads
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,408 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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