Johan Bijnens

Forum Replies Created

Viewing 15 posts - 391 through 405 (of 7,498 total)

Reply To: SQL Server 2024 or 2025?

I would rather like to know the current version of my Azure Managed Instance, which has been on 12.0.2000.8 for the last 5 years.
I can see the date change e.g...
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 31, 2023 at 6:58 pm

#4249421
Reply To: Audit data

Grant Fritchey wrote:
Damn Johan, great article. I missed that one.
I'm glad you like 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

July 27, 2023 at 2:17 pm

#4246023
Reply To: Audit data

Did you checked my article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
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 27, 2023 at 8:59 am

#4245770
Reply To: Find Version Mismatch
How about ...
```
$VerbosePreference = [system.Management.Automation.ActionPreference]::Continue 
$VerbosePreference = [system.Management.Automation.ActionPreference]::SilentlyContinue

Trap {
    # Handle the error
    $err = $_.Exception
    #Want 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 26, 2023 at 12:51 pm

#4245052
Reply To: Not a question - Just making sure everyone knows.

The question is not "If they'll target you",
the question is "When will they target you"
#KeepDoorShut
#KeepSecurityTight
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 25, 2023 at 10:59 am

#4243994
Reply To: Hash value in a primary key?
- you could also just convert the collation in the calculated column.
```
...
,MyChecksum as (checksum([host_name],[program_name] COLLATE Latin1_General_CS_AS,[DbName] ,[nt_user_name],[login_name],[original_login_name],[is_dac])) persisted
, MyHashBytes HASHBYTES('SHA2_256',concat([host_name],[program_name] COLLATE Latin1_General_CS_AS,[DbName] ,[nt_user_name],[login_name],[original_login_name],[is_dac])) persisted
```
  Make that column persisted...
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 24, 2023 at 11:25 am

#4243092
Reply To: Not a question - Just making sure everyone knows.

Isn't that supposed to never ever happen ?
#Sarcasm
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 24, 2023 at 5:33 am

#4242863
Reply To: Syntax issue while trying to create index on filegroup
```
create index IX_Service_Start_Date ON ivc_cds.CDS_Claim_Header (Service_Start_Date ) 
WITH (FILLFACTOR = 98, SORT_IN_TEMPDB = ON ) ON  [DefFG]
-- remove on  ServiceStartDatePartitionScheme ( Service_Start_Date ) 
```
also have...
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 20, 2023 at 12:37 pm

#4240099
Reply To: Use Alpha characters instead of expanding field

below86 wrote:
The bigger problem I just found out is that this column is part of the key structure on some of our financial tables. So splitting it out makes 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

July 13, 2023 at 5:52 am

#4233867
Reply To: Use Alpha characters instead of expanding field

There are many articles covering "Composite columns" (/ "composite keys") vs individual columns (/ surrogate key ) pro's and cons.
You are now at a junction point handling one of the...
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 12, 2023 at 6:28 am

#4232968
Reply To: Need to read ErrorLog to get the END TIME of last restore?
Did you notice you end up with a negative DurationInSeconds ?
```
--                ...
```
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 6, 2023 at 6:13 am

#4228181
Reply To: Unable to Log when user connects from coding

Please post the "Server Audit" and the "Server Audit Specification" scripts.
There must be some filtering active for it not to report all.

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 5, 2023 at 5:40 am

#4227216
Reply To: Unable to Log when user connects from coding

Did you enable as well the "Server Audit" as well as the "Server Audit Specification" ?
Check filters !!
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 4, 2023 at 1:51 pm

#4226711
Reply To: Has anyone here used PowerShell to query SQL Query Plan XML ?

I just export the plan and its consumption statistics from the plan cache.
1 file with all consumption details, 1 .sqlplan file per plan

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 26, 2023 at 6:34 pm

#4219992
Reply To: delete as head blocker

It is an option, but you may end up being deadlocked most of the time, depending the amount of blocking and lock escallation
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 26, 2023 at 8:36 am

#4219545

Viewing 15 posts - 391 through 405 (of 7,498 total)