Viewing 15 posts - 61 through 75 (of 2,076 total)
We began switching to c# scripts in SSIS to parse the excel and output the required columns
April 11, 2025 at 9:06 am
As SSIS get a litte love lately, thinking of moving to c#, powershell. We don't have very complicated workloads and excel is being read by a c# script inside SSIS
April 4, 2025 at 12:56 pm
Thanks for sharing
April 4, 2025 at 10:00 am
A little late for the preview of the SQL 2025 feature list:
https://www.brentozar.com/archive/2025/04/whats-new-in-sql-server-2025-2/
April 3, 2025 at 9:56 am
It will, all the new students basically grow up with GenAI,
March 31, 2025 at 9:56 am
That were AI may come in handy to manage the complexity
March 28, 2025 at 11:29 am
Thanks for mentioning the new interesting commands.
According to https://learn.microsoft.com/en-us/sql/t-sql/functions/jaro-winkler-distance-transact-sql?view=azuresqldb-current it's still in preview
March 28, 2025 at 11:26 am
Times flies, thanks for the reminder. Didn't switch yet to 2022
March 26, 2025 at 9:06 am
Had to create a custom role on the resourcegroup https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql&tabs=azure-powershell
March 18, 2025 at 3:16 pm
Instant file initialization in sql 2022? https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-ver16
However the latency points to hardware ( perhaps an ssd buffer got full, your sql server got migrated to slower storage due inactivity ...)
March 14, 2025 at 11:07 am
Probably switch to PostGres or start developing again
March 14, 2025 at 10:55 am
Using some crude tracking with SP_DATABASE_TABLE_SIZE. Lately switched to extended events database file changes to identify the culprit or using query story to find the queries just before that happened
March 11, 2025 at 10:00 am
The newer os requires you to use administrative privileges (UAC). Run explorer as administrator
cmd (run as administrator)
explorer (this will be started as administrator)
explore
March 4, 2025 at 11:16 am
4 TB SQL backup may take a long time
Have you looked at backup snapshot technologies? Like Veeam / SAN ...
February 27, 2025 at 11:04 am
Nvidia drivers are under the weather, having an expensive video card to see black screens every so often. Not feeling the burn yet
February 21, 2025 at 5:17 pm
Viewing 15 posts - 61 through 75 (of 2,076 total)