Forum Replies Created

Viewing 15 posts - 121 through 135 (of 9,244 total)

  • Reply To: SQL Backups Continuing After Migrating SQL Server Off Azure

    dup post

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: SQL Backups Continuing After Migrating SQL Server Off Azure

    amartin 92042 wrote:

    Ross Tyler wrote:

    We're a hosting company but the end-user/customer has a DBA who manages these servers so I'll get him to query the sys.credentials catalog for any backup to URL...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Azure SQL how to grant ALTER DATABASE permission

    Yes it was clear from the description that this was azure sqldb rather MI, server securables are not available in SQLdb but supported under MI.

    With sqldb they are managed at...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Azure SQL how to grant ALTER DATABASE permission

    Coriolan wrote:

    I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter with GRANT ALTER TO <myusermanagedidentity> successfully at the application database level with the intent to give...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Always on Availability groups cluster question

    Server 1-4 will all have one instance each or multiple instances?

    Think about your design carefully and document it, create a POC environment if you need (and recommended).

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Are the posted questions getting worse?

    Robert Sterbal wrote:

    Is there a public list of bugs? A public change log?

    wishful thinking I would say

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Always on Availability groups cluster question

    Jeffrey Williams wrote:

    You will be increasing your costs since each node in the new cluster will need to be fully licensed

    nodes in a WSFC with AGs follow the same rules...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Always on Availability groups cluster question

    GreatPancake wrote:

    Thanks for the reply. Maybe I unnecessarily complicated the question. I wanted to ask if i have a group of servers: server1, server2, server3 and server4, where server1 and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Always on Availability groups cluster question

    FCIs can be replicas in an AG but can’t convert to stand alone.

    The maximum number of nodes for a WSFC is 64 so you could deploy one WSFC with 40...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: AWS RDS for SQL Server - Backup to/Restore from s3 - Multiple Account Scenario

    I’m a little confused, the topic title states RDS backup and rsstore but you’re citing EC2 Β backup to url, the 2 are configured differently.

    Also, have you tried what AWS support...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Extend Event with sqlserver.login

    I just used a SQL acct for demo purposes, you would need to filter the event trace or have the headache of searching through it, you may have a group...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Extend Event with sqlserver.login

    using the login event from the session category and capturing the relevant global fileds i was able to connect via a sql acct and pull data and see the connections...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: ghost backups processed 0 pages

    can you supply a little more detail on the database and where it's situated, you mention azure

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr

    restore the filelist from the backup and report the files found

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • Reply To: Multiple processes accessing the same table. some to write others to read / Lock

    river1 wrote:

    Dears,

    Hope this message finds you well

    We have a log table which is used at same time by some processed to read and others to write. This is causing deadlock

    What...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 121 through 135 (of 9,244 total)