How It Works: How is SQL Server Error 833, 15 Sec I/O Detected

Moved from: bobsql.com
 
I was approached to revisit the details of how Error Message 833 is detected and reported.
 

SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in data… Continue reading How It Works: How is SQL Server Error 833, 15 Sec I/O Detected

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

Moved from: bobsql.com
 
Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hard… Continue reading How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

Lesson Learned #186: Firewall protection using Private Endpoint

 
Today, I worked on an interesting service that our customer has implemented a Private Endpoint for Azure SQL Database and they want that only some subnets of the VNET might be able to connect, they asked how to do it. 
 
Well, the firs… Continue reading Lesson Learned #186: Firewall protection using Private Endpoint

New! Normalization is now built-in Microsoft Sentinel

Normalization is at the core of every SIEM, and Microsoft Sentinel is no exception. The Advanced Security Information Model (ASIM) is Microsoft Sentinel’s normalization engine. Until now, you had to deploy ASIM from Microsoft Sentinel’s GitHub. Startin… Continue reading New! Normalization is now built-in Microsoft Sentinel