SQL Performance ManagementAzure Databricks KKBox Hands-on-Lab with a comparison to SQL Server
I attended a webinar on Microsoft Databricks yesterday. The only link I have is a zoom registration so you’ll have to search. I’m sure they’ll run it again. The hands-on-lab …
Comparing the Performance of Rot13 Implementations
The previous two articles have been devoted to implementations of the Rot13 cipher. This is a character substitution cipher that is used to obscure text strings in the Window registry …
SQL Storage ManagementSQL Server Performace on Solid State Drives (SSD)
Solid State Disks (SSDs) are devices that take advantage of the high speed nature of flash memory chips to provide fast persistent data storage
sp_storage: A proc to manage disk space in SQL Server
sp_storage is a procedure that I wrote to help me manage available disk space on a SQL Server
SQL Coding TechniquesThere’s an EOMONTH function in SQL Server, why no Start-of-Month function?
I responded to a posted question about the EOMONTH() function, which was: if there’s an EOMONTH function, why isn’t there a start of month function.
The reason is that DATEFROMPARTS does …
The reason is that DATEFROMPARTS does …
Using Column Permissions to Protect a Look-up Table.
This article continues where the last one left off. If you’d like and go back and read that one you can find it here.
In that article, an updatable view was …
In that article, an updatable view was …
