Viewing 15 posts - 31 through 45 (of 2,051 total)
Sometimes SQL Servers filters very late
and it is possible to have divide by zero on rows that aren't relevant
because they are done before SQL Server decides to filter them out.
May 9, 2025 at 9:53 am
Now it's in a novel/comic format, I might read it
May 2, 2025 at 7:58 am
Currently using Veeam. It has a short I/O freeze when it backups when VSS writer orders SQL to pause for a few seconds.
It makes it easier for the sysadmins in...
April 29, 2025 at 3:19 pm
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
Viewing 15 posts - 31 through 45 (of 2,051 total)