Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

lsjames

lsjames lsjames

Niner since 2012

  • Azure SQL Database Elastic Scale

    This looks promising -- moreso than Federations did.  I do have a couple questions.

    Looking through the documentation, I might easily be missing it but I don't see anything relating to schema changes.  How does that work?  E.g. we use SSDT to manage our schemas and generate update scripts.  In non-production environments we even publish directly from SSDT.  Would we have to manually get a script and execute it against each shardlet?  Ideally the whole set could be managed as one entity, with schema changes applied across the board.

    Similar concerns exist for reference data, or any shared tables.  When that data changes, do we have to synchronize it across all shardlets?  A far better solution would be to allow queries to span databases.  This would both enable more complex fan-out scenarios (see Jeff's post above), but also would allow queries to join sharded tables to reference tables, with the reference tables being stored in a common, shared database.

  • Edge Show 33 Windows Final Code Available

    I managed to get an ISO downloaded but I don't think it's the Pro version.  It's not entirely clear.  I'm thinking it's not, since for volume licencing they list it separately.  In any case I can't get any product keys.

  • Demo: A First Look at SQL Server Data Tools

    This stuff looks great.  I am really enjoying the new capabilities, but wondering if there is a way to upgrade a data tier application (i.e. change an existing database's schema) without modifying any users or their permissions.  Essentially I would like to be able to to use a .dacpac to encapsulate all aspects of a database's schema WITHOUT messing around with stuff like users.  The scenario is developing a dacpac in a test environment, and then wanting to use it to upgrade say a production database, which obviously would have different security than in test.

    I did find a bunch of advanced settings under the project settings' Debug tab, but those don't seem to affect the actual compare process when upgrading the data tier application from within SQL Management Studio -- it still insists on dropping existing users in that database, which is obviously not ok.

    Any thoughts?