Michel Zehnder

← Customer Feedback for ACE Community Tooling

My feedback

Enable Cost Management Blade for CSP Partners & Customers
- 2018-02-14_13_02_25-list_azure_resources_with_tags.png 73 KB
268 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

62 comments · Cost Management » Data quality + completeness · Flag idea as inappropriate… · Delete… · Admin →

planned · AdminCost Management team (Product Manager, Microsoft Azure) responded

This is definitely coming!

An error occurred while saving the comment

Michel Zehnder commented · August 13, 2019

Any update?

Submitting...
Let's Encrypt Integration for HTTPS certificates

652 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

3 comments · Networking » Application Gateway · Flag idea as inappropriate… · Delete… · Admin →

under review · AdminAzure Networking Team (Product Manager, Microsoft Azure) responded

This is on our long term roadmap.

Michel Zehnder supported this idea · August 06, 2019
Free Certificates

6 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

0 comments · Additional Services · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder shared this idea · July 12, 2019
Provide API to access CDN Supplemental Management Portal

60 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

7 comments · Networking » Content Delivery Network · Flag idea as inappropriate… · Delete… · Admin →

started · Anton Kucer [MSFT] responded

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 · March 19, 2019

An error occurred while saving the comment

Michel Zehnder commented · January 09, 2019

Any progress? We are way past "over the next several months".. we're now at "several years" :D

Submitting...
static website error handling, change 404 to 200

147 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

5 comments · Storage · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · January 28, 2019
Allow SQL databases to exist in a resource group different than the SQL Server

83 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

1 comment · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · January 21, 2019
Redirect to HTTPS

581 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

26 comments · Networking » Content Delivery Network · Flag idea as inappropriate… · Delete… · Admin →

started · AdminAzure Networking Team (Product Manager, Microsoft Azure) responded

This is in progress for Azure CDN from Microsoft.

-Max G [MSFT]

Michel Zehnder supported this idea · January 09, 2019
Fallback to secondary region of RA-GRS storage endpoints

16 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

under review · 0 comments · Networking » Content Delivery Network · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · January 03, 2019
Option to specify a location for the DBCC CHECKDB snapshot

144 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

0 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · December 29, 2018
allow database to reside in different resource group to server

458 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

unplanned · 11 comments · SQL Database · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · March 19, 2019
Increase listener limit for Application Gateway

426 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

24 comments · Networking » Application Gateway · Flag idea as inappropriate… · Delete… · Admin →

started · AdminAzure Networking Team (Product Manager, Microsoft Azure) responded

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. Stay tuned :)

An error occurred while saving the comment

Michel Zehnder commented · December 05, 2018

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-limits

Submitting...

An error occurred while saving the comment

Michel Zehnder commented · December 05, 2018

Please make this happen... this is severly crippling the usefulness of this!

Submitting...

Michel Zehnder supported this idea · December 05, 2018
AzureAD MFA Auth: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Error 18456

2 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

0 comments · SQL Server » Bugs · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder shared this idea · September 28, 2018
Changing app service plan should be improved

5 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

2 comments · Azure portal » Resource management · Flag idea as inappropriate… · Delete… · Admin →
An error occurred while saving the comment

Michel Zehnder commented · September 10, 2018

Please allow the move between resource groups in the portal

Submitting...

Michel Zehnder supported this idea · September 10, 2018
Support IPv6 in Application Gateway front-end public IP

199 votes

Vote

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

You have left! (?) (thinking…)

planned · 3 comments · Networking » Application Gateway · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · August 23, 2018
Ability to upgrade SQL Server Management Studio directly from About menu

51 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

unplanned · 5 comments · SQL Server » Setup + Deployment · Flag idea as inappropriate… · Delete… · Admin →
An error occurred while saving the comment

Michel Zehnder commented · July 07, 2018

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

Submitting...

An error occurred while saving the comment

Michel Zehnder commented · July 04, 2018

@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)

Submitting...

Michel Zehnder supported this idea · July 04, 2018
New SQL version of SQL Server

17 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

under review · 0 comments · SQL Server » Other · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · July 04, 2018
Search box in SSMS Object Explorer

104 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

7 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

unplanned · AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded

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 · July 04, 2018
SQL Server 2017 Minimal Logging Not Behaving As Documented

58 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

under review · 0 comments · SQL Server » Bugs · Flag idea as inappropriate… · Delete… · Admin →

Michel Zehnder supported this idea · July 04, 2018
Unlogged tables

303 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

4 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

under review · AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded

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 logged. The constructs and restrictions for an unlogged table are there as we see in the in-memory offerings of non-durability. It can’t require much more to actually implement such a useful functionality. Another speed increase would occur for working tables. Improved ETL speeds.
<=-=Aug 18 2017 7:25AM=-=>
Unlogged tables could be implemented by truncating them in case of a dirty database startup. That way any kinds of data structure corruptions would be cleared. (Without logging it’s surely very easy to corrupt indexes on power failure.)

This could be done per-index as well. Instead of a truncate (as proposed above) this would disable the index. That would allow for a consistent clustered index or heap with indexes that are considered expendable.
<=-=Sep 20 2017 9:20AM=-=>
Hope this is still being considered. I am a DW architect and this would be really valuable. It would really help even with existing investments where we have etl’s written that dont scale well and one area they dont scale is these large dump and reload scenarios. We constantly have to watch log growth. I would think this would be valuable from an Azure perspective as well. The same operation may only take have the storage resource to achieve and reduce the cycles needed to manage the transaction.

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 · July 04, 2018
Add a built-in table of numbers

178 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

8 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

unplanned · AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded

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 there would be a number of advantages of
having such a table (function) builtin. For more details on the optimization problems, see my
article on Arrays and Lists in SQL Server, http://www.sommarskog.se/arrays-in-sql.html.
<=-=Feb 27 2008 11:40AM=-=>
Where do you stop with the content of the numbers table?

1-100? 1-1000000? What if I need 10billion? What if I need numbers up 2^64?? More?

Seems like an awful waste of space for something that may or may not be used.

As per workaround, use a function. (would be nice if that function was built-in..maybe that’s what they mean by ‘sequence’?)
<=-=Jul 3 2008 6:11AM=-=>
I would say 100000 by default
Another option would be if that 100000 is not good enough for you there would be a built in proc that will generate this table for you, you would have to pass in the start and end value and the proc would generate this table
<=-=Jul 3 2008 8:58AM=-=>
This would be a great asset and I believe it to be worth the storage requirement. 100,000 is a good number to default to and if more numbers are needed; I am sure some sort of system sp that builds the table dynamically. The bottom line is a lot of people are not acclimated with the concept of a numbers table and are missing out of all the performance gains from using one. Having MS built-in numbers table not only exposes the numbers table, but also allows those who do not want to manage an additional table to reap the benefits.
<=-=Jul 7 2008 5:11AM=-=>
Adding a built in table of numbers from 1 to 2 billion would certainly take up a lot of disk space especially if you consider the fact that most people never use one with a count over 8000 and those that do almost never use one over a million.

What I’d rather see is a whole number “sequence generator” where you could identify the StartValue, EndValue, and optional Increment which would default to 1. And, it should be able to order the values in an ascending or descending fashion as if it had a Clustered Primary Key doing so.
<=-=Jul 15 2008 9:59AM=-=>
Why would anything need to be stored on disk? Make the query engine intelligently produce the numbers on demand. It would be an in-memory operation, perhaps not even needing all rows to be materialized, as in the case of splitting a string on a delimiter where the majority of the numbers are discarded.

The optimizer could pay attention to how the numbers are used and do an in-memory loop through the string rather than creating a table, temp or otherwise. The table is uniform and regular, and re-generating it each time in a tight +1 loop is probably faster than building the whole thing. It’s like a kind of native index where you know in advance where everything is because the lookup index is exactly equal to the lookup value.

Look at it this way. What would the query engine have to do to satisfy this query:

SELECT Num FROM Numbers WHERE Num = 123

It wouldn’t have to hit the Numbers table at all: the input IS the result. The answer can be given at parse time. Similarly,

SELECT Num FROM Numbers WHERE Num BETWEEN 1 AND 100000

Again, why hit the table at all? It already knows the desired result, the numbers 1- 100000. It would be far more efficient to just generate the values in memory than go read them somewhere. (give me 1st value: okay, got 1. Give me 2nd value, okay, got 2. …)

Many problems are easily solvable with a numbers table that are difficult or impossible otherwise.
<=-=Aug 5 2008 12:58PM=-=>
Indeed, the table would only be logical, it would not be stored on disk.
<=-=Nov 25 2010 11:53PM=-=>
A little bit off-topic, but could I also get the same thing for dates? It just seems so stupid to create table that has dates so that you can join it with other tables to get one row for each day even if data doesn’t exist for that day.
<=-=Dec 14 2010 2:54PM=-=>
Please read feedback id 347442. Such a built-in function would have (potentially) significant performance impacts, lacking in user defined functions/solutions (mentioned feedback id has examples).
<=-=Jan 1 2011 6:00PM=-=>
Glad to see this suggestion. This functionality would help with many of the perennial problems that come up on news groups and forums.
<=-=Mar 14 2012 4:17PM=-=>
I see Postgres has the “generate_series” function for this need.
<=-=Jun 11 2012 1:19PM=-=>
Neither identity nor sequence will help here. It is hard to believe you even read the question.

+1
<=-=Nov 27 2012 12:04PM=-=>
Having had the “joy” of splitting a multi-XML-document proprietary 3rd-party supplied file of over 3MB, my Numbers table was 12M+ rows, just in case a heavy ordering day bumped the file size…

On SQL2012, using page-level compression, it consumes over 130MB.

If, as current best practices appear to recommend, our SQL Servers are stacked with huge quantities of RAM, 130MB in, say 120GB isn’t going to matter a great deal…

If Microsoft gave us a “standard set” of Numbers that is configurable, but which could be bumped on demand and shrunken automatically to the standard-set-size, memory pressure would be reduced while still delivering high-speed data-access.

My Dates table stretches from 2008 (birth of system) to 2099, comprising 33K rows of 32 columns (at present) and 16MB compressed, with alternate indexes. Again, a triflingly small memory “hog”.

I’m less persuaded that a Microsoft-supplied Dates table is a “need” simply because the slices and representations of dates in short/long/week/month/quarter, etc. are really site-specific (hence my 32 columns!).

+1 for the Numbers table…
<=-=Mar 19 2013 1:14PM=-=>
Please, please, please.
<=-=Nov 24 2014 9:27PM=-=>
Howdy there, Microsoft,

This suggestion is going to be 8 years old in 3 months. It would be wonderful to celebrate that anniversary with a CU for both 2012 and 2014 that contains this wonderful suggested tool. It shouldn’t take you long.

I’ll also suggest that it take two parameters so that folks can start it “0” if they need to (which is more common than you’d think).

Thank you for your time.
<=-=Nov 26 2014 4:42AM=-=>
Personally, I think this relatively simple addition is long overdue. The Tally table has been called the Swiss Army Knife of SQL and I have to agree. It can be used for everything from splitting strings to date generation. An ITVF that’s built into the product would allow for optimization that’s probably beyond what DBAs can do. I’ve been using a table of numbers for years and consider it completely normal, as do many others in the SQL Server community. Please consider the addition of this feature to the product.
<=-=Nov 26 2014 6:31AM=-=>
This would be handy even if it it were no larger than a single record and additional functionality were added to SQL Server such as “Connect BY” and so forth to allow for larger virtual numbers tables could be accessed. Many uses are out there for such a table and if there is any doubt, take a look at the DUAL table in Oracle.
<=-=Dec 1 2014 7:55AM=-=>
This is fairly trivial to develop, but also the issues raised above (integrity) are potentially a problem in app code. Think SQL Injection or some other tampering that wouldn’t be the case in a native numbers table.

While this would be a nice backport, I would argue this is fairly minor work for SQL Server 2014+ (in an SP) and giving us a table with an integer’s worth of numbers, would be very handy. I would suggest that the table be a DMV visible in every database.
<=-=Apr 2 2015 7:56AM=-=>
CREATE FUNCTION [dbo].[fn_Nums](@n AS BIGINT)
RETURNS TABLE
WITH SCHEMABINDING,ENCRYPTION
AS
RETURN
WITH
L0 AS,
L1 AS,
L2 AS,
L3 AS,
L4 AS,
L5 AS,
Nums AS OVER AS n FROM L5)
SELECT n FROM Nums WHERE n <= @n;
GO
<=-=Nov 4 2015 1:00AM=-=>
The easiest trick to generate table of numbers with OPENJSON:

create function
dbo.fn_gen_numbers(count int) returns table return (select cast([key] as int) as number from OPENJSON( '[1' + replicate(',1',count-1)+’]’))

You will need SQL Server 2016 CTP3 or higher for this.
<=-=Mar 5 2016 8:30AM=-=>
This should not be a real table with a fixed number of rows. This should be a generator TVP that can provide any number range, e.g.

select Number from Builtin_Numbers(1, 10000000)

It would be a pity if the built in numbers table would be restricted to some range, e.g. [1, 1M].

We also need such a generator for dates (all dates in a given range).
<=-=Mar 16 2016 12:15AM=-=>
I really love to have a number sequence generator build into SQL Server as it removed a lo

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 · July 04, 2018

← Previous 1 2 3 Next →

Michel Zehnder

My feedback

Enable Cost Management Blade for CSP Partners & Customers

Let's Encrypt Integration for HTTPS certificates

Free Certificates

Provide API to access CDN Supplemental Management Portal

static website error handling, change 404 to 200

Allow SQL databases to exist in a resource group different than the SQL Server

Redirect to HTTPS

Fallback to secondary region of RA-GRS storage endpoints

Option to specify a location for the DBCC CHECKDB snapshot

allow database to reside in different resource group to server

Increase listener limit for Application Gateway

AzureAD MFA Auth: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Error 18456

Changing app service plan should be improved

Support IPv6 in Application Gateway front-end public IP

Ability to upgrade SQL Server Management Studio directly from About menu

New SQL version of SQL Server

Search box in SSMS Object Explorer

SQL Server 2017 Minimal Logging Not Behaving As Documented

Unlogged tables

Add a built-in table of numbers

Feedback and Knowledge Base

Searching…

Give feedback

Microsoft Azure

Your password has been reset