Viewing 15 posts - 46 through 60 (of 2,062 total)
We have a hybrid approach. I prefer working at the office, but I only have a commute of 15 minutes and my home isn't really setup for remote work.
Many work...
April 23, 2025 at 10:05 am
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
Viewing 15 posts - 46 through 60 (of 2,062 total)