Michel Zehnder
My feedback
-
3 votesMichel Zehnder
shared this idea
·
-
51 votes
Work has started on both moving capabilities that are only available in the CDN Supplemental Portal (e.g. rules engine) into the Azure Portal and also providing API’s to support all of these features. This work will be done in multiple phases over the next several months.
Michel Zehnder
supported this idea
·
-
405 votesMichel Zehnder
commented
Seriously? There is currently no way to do this?
Michel Zehnder
supported this idea
·
-
55 votesMichel Zehnder
supported this idea
·
-
76 votesMichel Zehnder
supported this idea
·
-
383 votesMichel Zehnder
supported this idea
·
-
6 votesMichel Zehnder
supported this idea
·
-
104 votesMichel Zehnder
supported this idea
·
-
300 votesMichel Zehnder
supported this idea
·
-
360 votes
We have raised the limit to 100 recently. We are regularly reviewing the limits and will continue to look for opportunities to raise the limits even further. If you have scenarios requiring limits higher than what is supported, please add your scenario details here (if you are comfortable with that) or raise an issue with Azure support and we will get back to you.
Michel Zehnder
commented
Apparently the limit is 40 now. Would still like to have more:
https://docs.microsoft.com/en-us/azure/azure-subscription-service-limits#application-gateway-limitsMichel Zehnder
commented
Please make this happen... this is severly crippling the usefulness of this!
Michel Zehnder
supported this idea
·
-
1 voteMichel Zehnder
shared this idea
·
-
3 votesMichel Zehnder
commented
Please allow the move between resource groups in the portal
Michel Zehnder
supported this idea
·
-
143 votesMichel Zehnder
supported this idea
·
-
3 votes
Upvotes: 20
<=-=Jun 27 2017 11:59AM=-=>One item after testing the new compression features of SQL Standard is that the “single core” limit of creating indexes is further maxed out at 100% usage for the single core (of which 31 are idle) when compression is utilized. Adding compression to an already limited “maxdop 1” in creating indexes causes compression to be less useful since there is no room in the single core to process the overhead.
<=-=Jun 29 2017 3:50PM=-=>I certainly support an increase in cores, and not only the increase but removing any price difference from maybe 8 to 32 cores. Today’s chips come with a lot of cores, but they actually add value only in limited circumstances. Linear pricing by core count does not recognize this and disincentivizes customers from upgrading hardware – or software. SQL Server ends up looking doggie because it is underprovisioned, especially for…
Michel Zehnder
supported this idea
·
-
43 votes
We have a “Check for updates link” in the Tools menu today, and SSMS prompts you to upgrade when it detects a new version unless you have turned off auto-check for updates. We have no plans to further automate these updates. We are pushing more updates through WSUS for enterprise installations.
Michel Zehnder
commented
SSMS is HUGE and has a strong dependency on visual studio components. It's not as easy as you think. They are working on a new cross-platform SQL Management experience called SQL Operations Studio. Over time I guess this will take over from SSMS and replace it. https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017
Michel Zehnder
commented
@Mark Freeman: There is. Tools -> Check for Updates...
You need to be using the "new" SSMS that is not bundled with SQL Server (i.e. this one: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017)Michel Zehnder
supported this idea
·
-
17 votesMichel Zehnder
supported this idea
·
-
86 votes
Object Explorer doesn’t populate the entire tree in memory, unlike visual studio’s solution explorer. It wouldn’t know if database “MyDatabase” existed until you expanded the Databases node.
There are third party plugins that provide this type of functionality, I believe, by downloading a bunch of data in the background and exposing a search.Michel Zehnder
supported this idea
·
-
47 votesMichel Zehnder
supported this idea
·
-
189 votes
Upvotes: 127
<=-=Jun 23 2015 8:37AM=-=>I’m the first to post a useful comment. This must make me special.
Seriously though, this would be an excellent solution to having to create a new “scratchdb” to hold my interim ETL data. This would be a major plus in simplifying design of a high performance app.
<=-=Jul 3 2015 5:04AM=-=>In 2014, memory optimized tables, and delayed durability can be used help mitigate these Issues. However neither of this are always completely viable solutions. Brent’s proposed solution is likely the simplest way to achieve this with the least amount of unwanted impact. It is important to note that other platforms implement similar functionality as well. Notably Oracle.
<=-=Nov 29 2016 3:58PM=-=>There are so many good things about this suggestion. I am amazed that SQL does not have the capability to turn off logging for certain tables that you define as no…
Michel Zehnder
supported this idea
·
-
121 votes
Upvotes: 278
<=-=Feb 1 2008 7:18PM=-=>Thanks for the valuable suggestion.
This seems more like adding the sequence support which we’re seriously considering for the next major release.
Meanwhile, would using identity column help?
<=-=Feb 2 2008 2:11AM=-=>It does not seem that you understood the request. This definitely has nothing to do with
IDENTITY. I am less versed about sequences, but I don’t think they will cut it either. If you think
it does, maybe you could provide an example? Take this problem: For the Orders table in
Northwind, write a query that lists the number of orders for all days in 1997. The result set should
include all 365 days, and list zero for days without a number.This is a typical problem where you need a table of of numbers (or dates). While it’s easy to
create such a table, I argue in this request that…Michel Zehnder
supported this idea
·
Any progress? We are way past "over the next several months".. we're now at "several years" :D