Viewing 15 posts - 16 through 30 (of 8,761 total)
Quick thought, try using VARBINARY(MAX) for the encrypted value.
😎
The encrypted hash is always going to be much larger than the actual input, truncated values may return NULL.
January 16, 2025 at 1:04 pm
Are there any firewall TCP port restrictions?
😎
Another thought, can anyone else access the server remotely?
January 15, 2025 at 5:15 pm
Quick question, have you enabled TCP in the network settings for the server instance?
😎
January 15, 2025 at 3:04 pm
January 13, 2025 at 6:08 pm
And after changing my search terms in Google to "SQL Server get job name from sp_who2 program_name" instead of something more generic, I HAVE FOUND IT!
CONVERT(VARCHAR(34),master.dbo.fn_VarbinToHexStr(sj.Job_ID))
Be careful here, the...
January 13, 2025 at 6:07 pm
Just a quick thought, most but not all of the Trigonometry functions in SQL Server are Float in - Float out, make certain that the input matches the output, otherwise,...
January 13, 2025 at 5:45 pm
My concern is that if my computer is ever stolen then an authorized person may access my SS db because he will have physical access to my drive. I...
January 12, 2025 at 11:08 am
What access do you have to the original server/database?
😎
The first thing would be to get a full backup of the database from the disgruntled employee and then restore it locally,...
January 11, 2025 at 4:16 pm
In the real world, one has to hope for the best, plan for the worst and insure for anything else!
😎
Weather is just one of the many factors, solar storms, volcanic...
January 11, 2025 at 3:00 pm
Without further information, there is no way one can answer your question!
😎
1. Are you using any hard drive encryption?
2. Are you using TDE, transparent data encryption on the server/database level?
3....
January 11, 2025 at 2:08 pm
In MS SQL Server, you'll use the HASHBYTES function and in PostgreSQL, you'll use the sha256 function or any of the other string/binary functions that match the algorithm...
January 11, 2025 at 1:49 pm
The first thought would be to compare a hash of the two, i.e. SHA2_256, those should match.
😎
January 11, 2025 at 11:26 am
I agree with Frederico, it's likely people posting from ChaGPT et al on here, but as I've been experimenting with LLMs and Python, I could whip up a python...
January 7, 2025 at 5:27 pm
As Ed points out, analysing the residual log files does help!
😎
You will find a script for log recovery and analysis in this article
January 6, 2025 at 3:23 pm
Happy New Year everyone!
😎
DBA means different things to different people;
Developer: Devil's Bothering Annoyance
Analyst: Data Botching Aggregation
Further suggestions anyone?
January 1, 2025 at 11:14 am
Viewing 15 posts - 16 through 30 (of 8,761 total)