Anthony Genovese

My feedback

  1. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 95

    <=-=Jun 23 2008 10:59AM=-=>

    Hi Jaimie,

    Agreed! More generally, wherever TSQL expects, say, and integer value, it should accept a literal, a variable, or the result of a function whose return type is integer. It just makes the language more regular (“orthogonal”) and easier to learn/use.

    That said, it’s too late for this feature in the Katmai release, but I’ll add it to our TODO list.

    [In passing, I’m reading your request to mean what I said above. ie, you still want to pass a value to a procedure – not a pointer-to-function – higher-order-functions. Right?]

    Thanks,

    Jim

    <=-=Jun 23 2008 11:17AM=-=>

    Jim,
    You got it! I just want to pass in a value without writing 2 lines of code!

    Thanks for the great reply. As a SQL MVP I’m first to criticise the SQL team when their responses to feedback are not up to scratch. Yours is…

    Anthony Genovese supported this idea  · 
  2. 104 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    We are exploring product improvement opportunities in an area of combined relational and non-relational data querying including integration with data lakes and data virtualization from Azure SQL database/Managed Instance to data stored in various formats.
    We are seeking for the customers interested in these new functionalities to participate in the survey below and help us improve our customer experience and product functionalities in Azure SQL DB/MI. If that’s you we are looking for, please fill out this survey: https://aka.ms/sqldbmi-datalake-integration.

    An error occurred while saving the comment
    Anthony Genovese commented  · 

    Connect to SQL Server first, then Azure SQL and other PASS, then other Azure things like data lake

    Anthony Genovese supported this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  4. 9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  5. 64 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  6 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anthony Genovese commented  · 

    This right here. We really need this supported or there is no path for us to go to production here.
    >>>>Switching instances, disaster recovery, migration scenarios would be a lot easier to handle.

    Anthony Genovese supported this idea  · 
  6. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  7. 18 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    We are exploring product improvement opportunities in the area of hybrid link between SQL Server (on-premises and VM) and Managed Instance which will enable near real-time data replication. This will not be a stretch DB, but a replication technology based on distributed availability groups (AG). If this might interest you, we invite you to provide your feedback to the engineering team through this online form: https://aka.ms/mipg-chimera-survey

    Anthony Genovese supported this idea  · 
  8. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all and thank you for your feedback. While this will not directly address backup and restore from MI to back on-premises SQL (this is also being considered and some updates might follow), we are considering a replication technology which might help support this scenario. We are exploring product improvement opportunities in the area of hybrid link using distributed availability groups (AG) replication technology between SQL Server and MI. This will enable near real time data replication between SQL Server and MI. We are also considering failover scenarios both ways. If this might interest you, we invite you to provide your feedback to the engineering team through this online survey: https://aka.ms/mipg-chimera-survey. Thank you.

    Anthony Genovese supported this idea  · 
    An error occurred while saving the comment
    Anthony Genovese commented  · 

    Ultimately, I need a way to snapshot and move data. It needs to be as easy and as quick as a backup and restore is right now.
    The DDL layer is simple. Schema compare & dac pacs get you where you need to go. But storing and moving that data seems to be the hard part. What I want is something packaged all together that easy to use and automate. And quick.

  9. 17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  10. 37 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  11. 38 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  12. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    LTR (Long Term Retention) backup for Managed Instance is being worked on and should be expected in a preview in calendar year 2020. Updates will follow when the feature becomes available.

    Anthony Genovese supported this idea  · 
  13. 326 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 249

    <=-=Oct 4 2016 2:15PM=-=>

    This is similar to my feedback located here: https://connect.microsoft.com/SQLServer/feedback/details/2769130/sql-2016-temporal-tables-with-triggers. The solution I suggest is similar to this, and could be used in many different cases developing using SQL server.

    <=-=Jan 10 2017 9:43AM=-=>

    I would love this too. The issue is that many/most applications don’t use Windows Auth in the connection to SQL Server (connection pooling issues, etc), so SQL can’t get the User information

    <=-=Jan 10 2017 9:51AM=-=>

    @Sanford

    Just to clarify, I am not asking for an “automatically store user name” feature. I’m asking for “automatically store whatever I want, based on whatever expression I provide.” So the fact that the user name may or may not be available is not really relevant.

    That said, there are plenty of workarounds for various situations. I imagine that if you’re using a shared connection, you can get some notion of “user” some other…

    Anthony Genovese supported this idea  · 
  14. 33 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  15. 62 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →

    This is a difficult one to handle technically. However the main theme is cost savings. Are there other cost-saving options (other than pausing) that could address this concern? For example, smaller vCore Managed Instances etc.? On the other hand, implementing pausable Managed Instance can also mean that resuming them will take several hours each time. Is this a concern? Thank you.

    An error occurred while saving the comment
    Anthony Genovese commented  · 

    Smaller vCore MI sizes would fit our needs. Just like everyone else. Dev/QA envs. I don't mind it on overnight. I mind 8vcore as the minimum

    Anthony Genovese supported this idea  · 
  16. 112 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 →
    Anthony Genovese supported this idea  · 
  17. 89 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  18. 149 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  8 comments  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  19. 97 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Genovese supported this idea  · 
  20. 84 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 47

    <=-=Jun 26 2017 1:02AM=-=>

    I have had the exact same issue, intermittently whenever I open script tasks all my code seems to have vanished and all the “ReadOnlyVaraiables” and “ReadWriteVariables” have also disappeared. It happens for c# and VB script tasks. This is is extremely frustrating and is impossible to develop a project when code randomly keeps disappearing. I’m wondering if this is a bug with Visual Studio 14.0.23107.0 D14REL. Can anyone at Microsoft shed some light on this please?

    <=-=Jun 29 2017 10:45PM=-=>

    Got the same problem. Seems like the Script Task is cleared when the project/Visual Studio i closed/shut down.

    <=-=Jul 18 2017 5:38PM=-=>

    Same problem for me, too. Once the original code in Script Task was still present after reloading the solution. But after that they are gone, along with ReadOnly/ReadWriteVariables and ConnectionManagers. I’m using SSDT 14.0.61705.170 (which just came out) with VS 14.0.25431.01 update…

    Anthony Genovese supported this idea  · 
← Previous 1

Feedback and Knowledge Base