How do spatial functions handle NULL? I show two ways of validating a spatial object as NULL: the IsNULL method, which returns 0 or NULL, and IsValidDetailed.
SQL SERVER – Validating Spatial Object with IsValidDetailed Function
Invalid spatial objects used to give only a simple error. The IsValidDetailed function tells you whether a shape is valid and, when it is not, the reason why.
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS
Many people have never used Template Browser in SSMS. I give a quick introduction to this useful feature and the ready templates it offers for common tasks.
Finding the Right Answer in SQL Server Documentation
Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.
SQL SERVER – Introduction to Function SIGN
The SIGN function returns 1, -1 or 0 depending on whether a value is positive, negative or zero. A simple example with INT and DECIMAL values.
SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY
A follow up with great comments from David Hall and Kumar Harsh on the usage of $rowguid and $IDENTITY, and the limits of my earlier solution.
SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode
Someone said columnstore indexes run only in batch mode. I stopped to disagree. Here is what I showed about columnstore batch mode vs row mode.










