Tag Archives: SQL

Creating a Database Backup and Restoring it in Code

Posted on March 27, 2012 by Tom Becker

When running regression tests many times you have to rely on very specific bits of data to be present in your database for the correct results to come out reliably.  This can typically be handled by a few simple inserts and deletes to massage the data that you need.  Other times there is just too much data to handle in that way.  So you need to just start from scratch and re-create your database.  
Read more...

Posted in .Net, ASP.NET, SQL | Tagged , , | Leave a comment

Automate your test data with Red Gate SQL Data Generator

Posted on November 29, 2011 by Everett Comstock

Just about every developer out there has encountered a scenario where they need to load test the application they are creating, but simply cannot come up with enough load to make it happen. I’m not going to go down the rabbit hole that is load testing an application in this post, but I do want to talk about one component of load testing, which is working with a lot of data. I seem to always run into the situation where I’m developing an application for a client, and when it comes time to test the application in a real world scenario and need real world data, the only viable solution is to back up data from a production server and massage it to “fit” into my applications database. Bad idea. Yes, there are times when this is unavoidable, but in general, do you really want to make multiple copies of sensitive data? Also, in most cases I cannot just copy and paste the data into my database. In the past I’ve created a number of data migration utilities, data population scripts, and used a number of tools just to populate my application with data that I can use to test it. All of this takes time, and effort.  
Read more...

Posted in SQL | Tagged , , | Leave a comment

Join the TCSC Team!

Posted on June 1, 2011 by Minh Ngo

Our company is growing! We have a lot of new faces walking through TCSC this week, but we’re still looking for new hires! Send resumes to careers@tcsc.com if you have what it takes to join our team, or know anyone who is looking to advance their career with TCSC!  
Read more...

Posted in .Net, Administration, Configuration, Development, Entity Framework, Linq to SharePoint, Linq to SQL, MVC, PowerShell, SharePoint Designer, WCF | Tagged , , , , , , , , , , , | Leave a comment