Why does my SSIS package run slower in BIDS than DTEXEC?
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have...
2011-11-09
1,083 reads
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have...
2011-11-09
1,083 reads
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft...
2011-11-07
3,473 reads
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,108 reads
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,116 reads
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the...
2011-10-31
2,270 reads
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,519 reads
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
853 reads
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,234 reads
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,027 reads
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,773 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