Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Development Wizard

My name is Peter Skoglund. I have twenty+ years experience in IT and I have work with SQL Server since version SQL Server 7.0. I work as a development DBA and spend all my days with development and database administration. My quote is "The first step to improvement is to have the gut to question".

Archives: May 2012

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)


When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get carried away about the problems/possibilities about:



· How to get nightly restores from Production.

· How to solve the storage issues.

· How fast does the environment need to be,…

Read more

0 comments, 1,877 reads

Posted in SQL Development Wizard on 31 May 2012

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)


How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)


One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is a simple task of backup and restore or using a data…

Read more

0 comments, 1,466 reads

Posted in SQL Development Wizard on 31 May 2012

A new neat feature in SQL Server 2012 is THROW


In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors within their T-SQL code. Prior to that the developers had to use the @@ERROR in-built system function to check for errors and they had to check for error conditions after…

Read more

0 comments, 1,818 reads

Posted in SQL Development Wizard on 31 May 2012

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?


One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is a simple task of backup and restore or using a data synchronization tool like the data compare in visual studio. BUT with a new version of an application on its…

Read more

0 comments, 0 reads

Posted in SQL Development Wizard on 23 May 2012

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.



When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get carried away about the problems/possibilities about:

  • How to get nightly restores from Production.
  • How to solve the storage issues.
  • How fast does the environment need to be, large/cheap SATA drives…

Read more

0 comments, 0 reads

Posted in SQL Development Wizard on 22 May 2012