Subscribe to this blog
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,…
0 comments, 1,363 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…
0 comments, 698 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…
0 comments, 939 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…
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…
0 comments, 0 reads
Posted in SQL Development Wizard on 22 May 2012