scotthowe.com - oracle, mssql, and general systems administration blog...

  • my portfolio
  • my code-projects
  • xml sitemap
  • contact
Home

Navigation

  • Recent posts

Primary links

  • My Portfolio
  • My Code-Projects
  • XML Sitemap
  • Contact

Flickr recent photos

Front of MonticelloMonticello Garden1Monticello Garden2Monticello Garden3

User login

  • Create new account
  • Request new password

mssql

Stories having to do with Microsoft SQL Server

Tips for refreshing development mssql server databases

scott — Fri, 07/11/2008 - 14:39

It’s usually a good idea to schedule regular refreshes of a development (dev) sql server from the production(prod) version. Ideally, the prod environment is secured from everyone except an isolated number of systems administrators requiring dev to be kept as close to the live version as possible.

  • database administration
  • mssql
  • Read more

Microsoft's SQL Server Integration Services Intro

scott — Tue, 04/22/2008 - 14:38

DTS's were so... simple, but with a more robust implementation comes complexity. Using Microsoft’s SQL Server Business Intelligence Studio you can create powerful automated packages known as SSIS packages which have taken the place of the DTS. To get started select new project from the File menu and choose Integrated Services project.

  • database administration
  • mssql
  • Read more
Syndicate content

Search

External Links

  • Richardfoote.wordpress.com
  • voug.org
  • xkcd.com

Photo Galleries

  • 08 Spring Flowers
  • Baby Matthew
  • Fall 08 Monticello Trip
  • my portfolio
  • my code-projects
  • xml sitemap
  • contact