THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

Database Edition and You - Some Cool Changes

Greg Low mentioned the new licensing model for Database Edition is his post on the topic a few days ago. What does this mean for you?

Here's my take: Now that Database Edition is included (free as in beer) with Developer Edition, application developers can take advantage of some of the awesome features built into Database Edition. What are some of those awesome features? I'm glad you asked.

  • Unit and Database Tests - you can create database tests (and custom test conditions). Stored Procedure unit tests can be created by right-clicking the procedure and selecting "Create Unit Test".
  • Data Generation - you can populate a test database with gibberish. This is a great test for your database as users will likely store lots of gibberish in your database once the application goes live. Did I type that out loud? Bad me. Seriously, using live data for development and test purposes is at best a bad idea; at worst against the law. Data Generation incorporates foreign key relationships into the matrix, so related data and relationships are also simulated. (This assumes the use of foreign keys in database design...).

There's more, but this should be enough to prompt you to head over to MSDN and download Database Edition.

:{> Andy

Published Tuesday, October 07, 2008 3:15 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Austin Summers said:

To quote Greg's article:

"great product but pity we'll never get to use it because of the licensing"

Nothing has really changed.

Austin

October 8, 2008 11:38 AM
 

andyleonard said:

Hi Austin,

  I agree and disagree. It's a great product but I use it.

:{> Andy

October 8, 2008 10:38 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement