Making developer edition of SQL Server act/look like Standard Edition


Recently I assisted my colleague answer the question of making SQL Server Developer edition act/look like Standard Edition instead of its default behaviour which is to be the same as Enterprise Edition. Basically the answer to this question is that there is NO switch/setting/configuration to make developer edition act/look like standard edition.

So how does a developer developing applications that are going to ultimately released on standard edition work with developer edition or otherwise? Following are some options:

1) Stay with Developer Edition and understand / manage risk

Largest risk is DE hiding a performance hit when code is migrated to production. SE is single threaded for most operations whereas DE/EE exploits processor capabilities. This is the most problematic to determine impact into production.

DE has a number of capabilities that need to be clearly not used by developers. The list is provided below:

SQL DE/EE versus SQL SE capabilities:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Easiest way to visualise Editions across workloads.

 

Database Engine Analysis Server Reporting Services Integration Services Data Mining

Data compression

· Resource Governor

· Table/Index Partitions

· Indexed Views

· Asynchronous Database Mirroring

· Online Indexing

· Backup Compression

· Database Snapshots

· Oracle Publishing from replication perspective

· SQL Auditing

· Transparent Database Encryption

· Distributed Partition Views

· Change data Capture

· Partitioned cubes

· Account Intelligence

· Linked Measures & Dimensions

· Perspectives

· Semi-additive measures

· Write back Dimensions

· Custom Rollups

· Scale out Reporting services implementation

· Data Driven Subscriptions

· Report Models

· Data Mining Tasks

o Query Transformation

o Mining Model Training Destination Adapter

· Fuzzy Grouping

· Fuzzy Lookup

· Term Extraction

· Dimension Processing

· Partition Processing

· Cross Validation

· Plug-in algorithms

· Sequence Prediction

2) Stay with Developer Edition and leverage Policy Management capabilities

Note: Some of the above capabilities could be controlled by the Policy Management features in SQL Server. These are not done out of the box and would require a DBA to set these up. If I get time, I may provide some examples of this in later posts.

Advantages here is that the DE environment will highlight automatically when the EE capabilities are switched on, however the performance risk still remains.

3) Evaluate cost of MSDN purchase

While I always first advocate a re-look at the value of Enterprise Edition in production the MSDN option is great for all alternatives. Simply put – buying MSDN for every developer all non production environments (like dev, test, UAT, training) to be correctly licensed for all the developers and users (testers and trainees). MSDN Professional subscriptions cover the OS and SQL and this includes all versions of SQL (including SE).

Premium and Ultimate will be appropriate if SharePoint and Exchange etc. need to be covered by MSDN too.

This option is a easy way to know that you are compliant by only needing to focus on Production licenses (once developers are licensed with right MSDN subscription).

Comments (4)

  1. Gisabun says:

    Is it just me or the last column is cut off.

  2. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much
    http://www.lokerjobindo.com lokerius
    http://www.kerjabumn.com somone
    http://www.lokerjobindo.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html I need
    http://www.kerjabumn.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html beberapa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru.html langka sebenaernua
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-nindya-karya.html ada rasa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-cimb-niaga.html sama kita
    http://www.lokerjobindo.com/2015/11/info-kerja-bumn-pt-sarana-multi.html tapi sebenarnya
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-pt-citilink.html tahukan anda
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3-s1-pt-hk-realtindo.html sebutan dari
    http://www.lokerjobindo.com/2015/11/info-kerja-bank-bri-frontliner.html kita adalah
    http://www.lokerjobindo.com/2015/11/info-lowongan-kerja-staf-hubungan.html anugrah yang

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-pertamina-retail.html dapat kita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-bca-syariah.html rahasia itu
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-danamon.html hanya ada
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3.html dalam sebuah cerita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-bni-life-insurance.html tentang kita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-axa-mandiri.html yah begitulah hidup
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-sinamrmas.html hidup itu cuma sekali
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-mandiri-syariah.html tidak ada keduakalinya
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-btn.html maksudnya cuma hidup di dunia
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pt-astra-international.html rahasia semua kediupan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru more release
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN raksa tui
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank end dend
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20S1 nomore

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3 subject

  3. wq says:

    http://www.michaelkorsoutlets-online.us.com/
    http://www.pandora-charms-canada.ca/ and
    http://www.the-north-face.ca/
    http://www.nikeshoesoutlet.org.uk/ it
    http://www.ralphlaurenoutlet.us.com/
    http://www.tiffany-jewelry.in.net/ covers
    http://www.thejoreseproject.com/
    http://www.rolex-watches-canada.ca/ the
    http://www.uggbootsclearance.com.co/ http://www.yoga-pants.ca/ following
    http://www.northfaceoutlet.com.co/
    http://www.truereligionjeans.net.co/ points:
    http://www.nike-air-max.com.au/
    http://www.toms–outlet.com.co/ ManagingMany
    http://www.oakley-outletstore.us.com/
    http://www.ralph-laurenoutlet.co.uk/ of
    http://www.ugg-boots-australia.com.au/
    http://www.guccihandbags.net.co/ you
    http://www.marcjacobs.us.com/ http://www.reebok.com.de/ new
    http://www.uptocoachoutlet.com/
    http://www.cheapoakleysunglasses.ar.com/ SQL
    http://www.louis-vuitton-taschen.com.de/
    http://www.nfl-jersey.us.com/ Server http://www.new-balance.ca/
    http://www.nike-air-force.de/ DBAs
    http://www.ralph-laurenoutlet.ca/
    http://www.true-religion.com.co/ may
    http://www.the-tnfjackets.us.com/ http://www.jimmychoo.net.co/ be
    http://www.adidas.com.se/
    http://www.basketballshoes.com.co/ wondering
    http://www.michael-kors.com.co/
    http://www.longchampoutlet.com.co/ what
    http://www.swarovski-australia.com.au/
    http://www.cheap-baseballbats.net/ are
    http://www.jordanrelease-dates.us.com/
    http://www.outletonline-michaelkors.com/ the
    http://www.newbalance-outlet.org/ http://www.longchamp.com.co/ things
    http://www.ray–ban.ca/
    http://www.hollister.us.org/ to http://www.uhren-shop.com.de/
    http://www.louis-vuittonblackfriday.com/ lookout
    http://www.chanel-bags.com.co/
    http://www.tnfjackets.us.com/ for http://www.nikefree-run.net/
    http://www.ray-ban-sunglasses-outlet.in.net/ to
    http://www.pradahandbags.net.co/
    http://www.poloralphlaurenoutlet.net.co/ effectively
    http://www.barbour-factory.com/ http://www.pradaoutlet.com.co/ maintain
    http://www.michael-kors.com.es/
    http://www.moncler-outlet.us.org/ a
    http://www.ralphlaurenoutlet-online.us.com/
    http://www.burberryoutletonlinesale.in.net/ production
    http://www.weddingdressesuk.org.uk/
    http://www.louisvuitton.jp.net/ SQL
    http://www.bebeclothing.in.net/ http://www.prada.com.de/ Server
    http://www.hilfigeroutlet.in.net/
    http://www.abercrombieand-fitch.ca/ database.
    http://www.celine-bags.org/

  4. Charles BBowles says:

    we want to do it was like turning wave what it felt like tome on the inside with the with the jury I think those were like muscle spasms remember going into now our room and having the screens on top me having barroom i feathers mother-in-law tell me that
    her daughter got my daughter from daycare that she was okay ohm and them starting to do the procedures in the with.

    http://herbsforbrain.com/