Viewing 15 posts - 166 through 180 (of 9,244 total)
I don’t see any reason to be concerned about 3NF reqs here it’s a simple metadata table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 12:16 pm
What groups are provisioned on the servers with rdp access too?
that is do you see the same AD group in windows admins as you see as syssdmin in the sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 8:37 am
Does anybody know of any drawbacks with this approach?
can’t think of any immediately, the table is small and lightweight.
only the obvious which is the inability to truncate the parent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 8:26 am
It makes sense for azure sqldb, AGs are more targeted at groups of databases rather than single dbs, ok azure sqldb are pinned to a virtual instance for database connectivity...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 9:12 pm
The best alternative I can think of is a separate table instead of an IsDefault column. This other table has one row with one column, FK to the PK...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 8:58 pm
And that's why there are central management servers and Powershell...
agreed, the deployment of a central management server provides this list centrally for all users, adding warehousing capability and harvesting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 8:17 pm
If you declare an explicit tran then it is your responsibility to either commit or rollback
Cleaning up uncommitted explicit trans by auto committing them is not something you want
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 5:14 pm
This link should help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 3:04 pm
Situation: Prod instance can successfully backup to the designated s3 bucket FOR FULL BACKUPS. DIFF backups fail with "internal error".
full backups are fine but diffs fail, is that correct?
Also...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2024 at 2:36 pm
as already stated, its bit surprisng that the database engine thought a transaction large enough to warrant a 30 hour rollback was the least busy transaction. Was this transaction actually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2024 at 9:51 pm
Glad it helped, mirroring can be paused at the group level and database level.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2024 at 7:23 pm
error number would be helpful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2024 at 11:05 am
Ok so check the logs you should be seeing error in the restore likely with an OS error number
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 8:36 pm
Recreated this by creating a test SP, queue and service (owned by user test)
Try to drop user and get same message box, this will identify the service name and owning...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 6:45 pm
.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 4:28 pm
Viewing 15 posts - 166 through 180 (of 9,244 total)