Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
2,391 reads
Andy Robertson
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,173 reads
Blogs
Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
Power BI and a Star Schema
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
A New Git Default Branch
By Steve Jones
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...
Forums
Monitor SQL Server Error Logs with PowerShell
Comments posted to this topic are about the item Monitor SQL Server Error Logs...
Using Dynamic SQL
Comments posted to this topic are about the item Using Dynamic SQL
Ask SSC