Johan Bijnens

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 7,498 total)

Reply To: Backup and Ransomware
Anyone who has write auth on the backup file, can manipulate it.
Will it be restorable?
- use checksum as a backup parameter, so SQLServer checks this and prevents a restore of...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 21, 2024 at 7:11 am

#4447880
Reply To: Script to allow Security level to "Check" db_owner for database
btw: if you also want an inventory of all members of db group db_owner in all db, you'll need to provide the account Connect to all db.
```
use...
```
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 20, 2024 at 2:09 pm

#4447661
Reply To: sql access with only local admin

probably.

Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

August 20, 2024 at 10:24 am

#4447561
Reply To: Script to allow Security level to "Check" db_owner for database
To see the actual db owner of a db, you only need a login.
```
CREATE LOGIN [test] WITH PASSWORD=N'123Test...........', DEFAULT_DATABASE=[master];
```
When logged in as that account, the following query...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 20, 2024 at 8:08 am

#4447519
Reply To: Compare query results between two databases
drew.allen wrote:
Johan Bijnens wrote:
Did you try:
```
Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
  ...
```
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 1, 2024 at 6:03 am

#4441586
Reply To: Compare query results between two databases

Glad you already got a solution.
The flaw / bug in my script was that I hard coded "'production' as source,".
If you remove that "source" column from both queries, you'll get...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

July 30, 2024 at 12:17 pm

#4440983
Reply To: Compare query results between two databases
Did you try:
```
Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
    ON...
```
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 30, 2024 at 8:16 am

#4440931
Reply To: Unable to add the database back into AG

Can you post the exact error message?
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

July 22, 2024 at 9:50 am

#4438777
Reply To: Creating an Index with a lot of Columns

Jeff Moden wrote:
emuller1982 wrote:
After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

July 18, 2024 at 7:45 am

#4437815
Reply To: AlwaysON AG

Isn't that the whole "reason to be" for Ag's ?
When the partner instance comes back online and is visible to the primary instance, it will pickup log-processing from primary to...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

July 9, 2024 at 10:29 am

#4434458
Reply To: Strange behavior passing a variable in XML.value

Jep .... that's also part of life 🙂
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

June 13, 2024 at 1:10 pm

#4428228
Reply To: Strange behavior passing a variable in XML.value

I copy-pasted your text and commented all but the ddl and the queries.
Works just file.
Off course, in SSMS you need to keep the consequences of any "GO" line in mind...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

June 13, 2024 at 11:38 am

#4428199
Reply To: large transaction log backups

Talk with your db's consumers if they changed usage / implement new stuff / have faulty processes recently / ...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

June 12, 2024 at 11:48 am

#4427980
Reply To: What does it mean when Query Store Tracked Queries shows the same Plan Id twice?

btw: If you hover over the icon, you’ll get an explanation of it
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

June 11, 2024 at 5:53 am

#4427606
Reply To: Contained Availability Groups - Failover Questions.

explained at: "What is a contained availability group?"
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

June 8, 2024 at 5:33 pm

#4427152

Viewing 15 posts - 211 through 225 (of 7,498 total)