Scotty Tarvan

My feedback

  1. 19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Azure Search » Indexing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback. We need some more information before we can take action on this request.

    Can you share some more context re why you need a decimal (vs. the EDM.double that we support today) or money? Do your fields include signs like $?

    As a workaround, with the recent release of Cognitive Search, you can create a custom skill to transform any field

    Thanks,
    Elad
    Azure Search Product Team

    An error occurred while saving the comment
    Scotty Tarvan commented  · 

    This would save a lot of time when setting up an import from the azure portal and the database has decimal or money fields.

    I doubt that there are many use cases where the decimal type would be used in a filter or sort where the decimal portion is actually used.

    Retrieving and then using decimal values would be a deal breaker as financial applications must have decimals. There could be workarounds using converters or joining back to the original data source but not great solution.

    Scotty Tarvan supported this idea  · 
  2. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Scotty Tarvan shared this idea  · 
  3. 13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Sorry folks, but we are not able to repro this issue (either using SSMS 17.9.1 or SSMS 18 Preview 7).

    Since multiple people out there are reporting this issue, it is obvious that we are missing something that is specific to your environment or configuration.

    Could you help us out and try to describe a little better your subscription/environment/account/permissions?

    For example, does the following mainstream scenario works for you all:
    1) Connect to Azure Portal
    2) Create SQL server+database
    3) Go to SSMS and connect to
    4) Add firewall rule

    If it does, then can you identify what is different between the case where it works and the case where it does not?

    Thanks,
    -Matteo

    An error occurred while saving the comment
    Scotty Tarvan commented  · 

    I get the same error but the strange thing is I have 2 azure subscriptions and it works fine on the one but not the other. When I log in to azure I can add it manually - screenshot attached to show that I only have a few entries. I am the administrator on the azure subscription that fails.

    ===================================

    SQL Server Management Studio 15.0.18142.0
    Microsoft Analysis Services Client Tools 15.0.1389.0
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.18363

    ===================================

    An error occurred while creating a new firewall rule. (ConnectionDlg)

    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.FirewallRuleService.CreateFirewallRule(String serverName, IPAddress startIpAddress, IPAddress endIpAddress, String firewallRuleName)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.FirewallRuleForm.CreateFirewallRule()

    ===================================

    An error occurred while creating a new firewall rule (HTTP Status Code 401)) (ConnectionDlg)

    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.ResourceManagementWrapper.GetSqlServerResources(ServiceSubscription serviceSubscription)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.ResourceManagementWrapper.<>c__DisplayClassa.<GetSqlServerResources>b__9()
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.ResourceManagementWrapper.RunAzureApi[TResult](IAuthenticationCredential azureCredential, String resourceManagementUrl, Func`1 action)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.ResourceManagementWrapper.GetSqlServerResources(IAuthenticationCredential azureCredential, ServiceSubscription serviceSubscription)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.FirewallRuleService.FindAzureResourceForSubscription(String serverName, AzureLoginSession azureLoginSession, String subscriptionId)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.FirewallRuleService.FindAzureResource(IApplicationAuthenticationManager authenticationManager, AzureLoginSession azureLoginSession, String serverName)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.FirewallRule.FirewallRuleService.CreateFirewallRule(String serverName, IPAddress startIpAddress, IPAddress endIpAddress, String firewallRuleName)

  4. 137 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Scotty Tarvan supported this idea  · 
    An error occurred while saving the comment
    Scotty Tarvan commented  · 

    This would be an incredible feature and would close the loop for a modern DWH architecture so that data in the delta lake can easily be extracted to a DataMart/DWH.

  5. 52 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 25

    <=-=Feb 7 2017 7:34PM=-=>

    Yes! I myself a use heavily inline table value functions and that would improve the clarity of their use even more!

    <=-=Mar 5 2017 2:48PM=-=>

    We understand the requirement, and it is good that it gets a lot of votes in very short period. It is in out backlog and we will consider it for some of the next releases; however, currently we cannot confirm when it will be implemented..

    <=-=Dec 22 2017 3:17PM=-=>

    This would be quite incredibly useful. When it was added to C#, it was a “so-what?” thing for me at the time – but now, I don’t know how I ever coded without named parameters. It has saved me countless hours getting things right the first time, and not chasing around dumb problems. I am sure the same would be true if SQL Server supported named parameters in User-Defined Functions.…

    Scotty Tarvan supported this idea  · 

Feedback and Knowledge Base