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".

Terminate a SSIS package after specific time interval.



 

There are several ways you can execute scheduled SSIS package/job they are:
 

A)     SQL Server Agent Job.
B)       Windows Schedule Task.
C)      Third party program, like SQL Sentry
 

Nirav's Diary has example on using…

Read more

1 comments, 1,126 reads

Posted in SQL Development Wizard on 25 June 2013

Run DBCC CHECKDB on a regular basis

Problem
 
One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption in the database. You can run the command as part of a Transact-SQL script or it can be a part of a Database Maintenance Plan or possibly, even…

Read more

0 comments, 3,887 reads

Posted in SQL Development Wizard on 10 April 2013

SQL Server Policy Based Management Alerts


SQL Server Policy Based Management Alerts


Problem


Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not all policies support "on change prevent mode" and the rest are only logged in the event log. The error number that is recorded depends on which evaluation mode…

Read more

0 comments, 1,492 reads

Posted in SQL Development Wizard on 4 December 2012

Running a document database on Sql Server


Running a document database on Sql Server.

Since Microsoft is slow to come out with a product of their own to support the growing need for document databases (Yes,I know there are other good products on the market like RavenDB, CouchDB,  MongoDB from other venders). I want to show how…

Read more

1 comments, 6,085 reads

Posted in SQL Development Wizard on 26 September 2012

Unwanted dependency between different parts of the code


Small systems tend to grow with new functionality and new access points. When the system grows, the need for data (might even be the same or very similar) and data access requirements grows at a similar rate and becomes more and more complex. A single component might no longer be…

Read more

0 comments, 543 reads

Posted in SQL Development Wizard on 16 August 2012

JSON and the NoSQL “advantage” over SQL Server

First what is JSON?

JSON: JavaScript Object Notation.

JSON is syntax for storing and exchanging text information, similar to XML.

JSON is smaller than XML, and faster and easier to parse.

JSON is built on two structures:

 • A collection of name/value pairs. In…

Read more

2 comments, 10,691 reads

Posted in SQL Development Wizard on 14 June 2012

Don’t Pass Null


I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each developer and DBA should follow be few does; the key is to help to keep your code clean and maintainable.


Most of the book is written in a Java/C# perspective,…

Read more

0 comments, 555 reads

Posted in SQL Development Wizard on 8 June 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,854 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,445 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,788 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