SQL Database

  1. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Rename Server SA Account

    I would like to be able to rename Server SA account. Currently, the only way to do this is by server rebuild.

    Thank You!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. write an article about the cost efficiency of using an elastic SQL DB instead of a single SQL DB

    While there is a lot of technical detail about the pricing of various Azure services, it's sometimes difficult to gauge the tangible benefits of each. Specifically with SQL DBs, when does an elastic DB become more cost efficient than a single one when the aim is to still have just one DB? If DTU usage is low during the year because you are in development or otherwise, then does that in turn suggest that under certain loads, elastic is more cost efficient than single?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. No SQL Pricing calculator

    Right now you have exactly nothing in your calculator for estimating the cost of a database server in Azure! Any selection in the SQL options redirects you to the "new" VM calculator which doesn't have any options for SQL Server cost calculations.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Give more power in SQL database

    Give more power for creating tables and viewing the data. Or give the ide for creating the tables in azure in management studio rather than coding the create table structure.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. BCP on Azure Data Science VM

    Hello I am trying to use bcp from a data science VM to upload data into an Azure SQL Database, however I get this output, like if -S was not an option :

    Error: Unknown argument -S
    Usage:
    bcp --list [options] module-list
    bcp --list-short [options] module-list
    bcp --report [options] module-list html-file
    bcp [options] module-list output-path

    Options:
    --boost=path sets the location of the boost tree to path
    --scan treat the module list as a list of (possibly non-boost)
    files to scan for boost dependencies
    --svn only copy files under cvs version control
    --unix-lines make sure that all copied files use Unix…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Create an option to auto-register an Azure SQL database to Azure Data Catalog when a database is created or modified.

    In order to register an asset in Azure Data Catalog, someone has to login to the catalog and then provide information about the database they want to catalog. It would be beneficial if the the registration happened automatically when the database is created and updated when changes occur in the database. So the idea would be to create the link between the catalog and the data store in the data store creation interface. When a DBA creates a database, they can automatically register the asset and those assets appear in the catalog without a catalog administrator having to determine which…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Send email to administrators when Elastic pool is running out of space even when an alert hasn't been configures

    To get notified when an elastic pool is running out of space you have to have set up an alert. When something this critical is happening an email could be sent to the subscription admins even if an alert hasn't been sent out.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Can "Manywho" workflow connect to SQL Azure database ?

    Can "Manywho" workflow connect to SQL Azure database ?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. Perform scale operation before copying to a new tenant ring

    We have hit an issue occasionaly where a 10GB database on S0 has a scale request to S3 takes over 3 hours to complete. This is an operation that is performed daily and normally finishes in less than 15minutes.

    With the database at S0, it is unusable and our customer was unable to use their database for 2 hours (normal level is S3).

    Talking with support, it seems the database was in the process of being moved to a new tenant ring due to the current tenant ring not having enough space to complete the scale up operation.

    It would…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. I think azure sql server should be able to convert a .mdf file to its kind of database or should be able to accommodate it

    I'm working on starting a community banking program and company by August and I'm currently trying out platforms. I found OpenCBS an open source micro finance software, to be very useful but I'm looking to be able to have the database in azure Sql server. I kept getting an error message that the .mdf database creation failed.

    Azure Sql server should be able to convert the database extension or have it in a cup.

    This is very important for me. Thank you Team Microsoft

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 'CREATE SEARCH PROPERTY LIST' is not supported for targeted platform

    Currently I have version of Visual Studio Professional 15.9.4 installed with the latest version of SSDT but as per my stack overflow question can't get my project to build with Target Profile as Azure v12 despite the documentation saying this is supported

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. ReadScale true - Reporting in Azure Portal

    I just enabled ReadScale on our db.

    Now how do I see the performance of those machines?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. On the Azure admin web page, change the positioning of timeout messages

    On the Azure web portal, if an import process into SQL Azure is running long and I have to step away for an extended period of time, the timeout message that appears later completely obscures the most recent success or failure message of an ongoing import, so it is impossible to view the final result message, which can be very annoying.

    The fix is simply to reposition the final timeout message as a floating window centered in the middle of the web page.

    Hopefully this is not a big programming change, so please try to include this in a new…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Choose size of restored database files

    When you restore a database, it creates each files with their original size.
    But sometime you need to extend the file or shrink the files according to the disk space and free space in the original files.
    It would be great to implement a "target size" for each restored file during restoring the database.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Ability to create an Azure SQL backup (.bak) to Blob storage

    Moving a +1TB db to a VM+SqlServer via Import/Export data tier is very slow. Being able to restore an Azure DB from a .bak file should be much quicker. Or the ability to leverage restore from Long Term Backup storage to a VM.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Can you please add the intelisense

    I don't see any intelisense pop-up while querying in SQL server database.
    Is there any setting for it?

    Thanks,
    Gopal

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. bug: The database firewall rules errors when adding an IP address

    This is true both from the portal (new) and deploying a resource manager template

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Enable SQLAzure to "On Premises" database migration via Data Migration Assistant (DMA)

    Since the SQLAzureMW as been made unavailable, our only option for migrating databases is the Data Migration Assistant (DMA).

    DMA does not allow for SQL Azure to On Premises migration only.

    SQLAzureMW was the best way I had found to make local copies of SQL Azure databases. This ability is critical for developers and IT folks.
    Please add this feature to the DMA.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base