As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.
The Pigeonhole Principle: Bridging Mathematics and SQL
The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog
SQL SERVER – Banker’s Rounding
Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.
Trace Flag 3226: Keeping Backup Messages Out of the Error Log
Check trace flag 3226, understand suppressed backup success messages, and use msdb history to monitor backups without log noise.
Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable
Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.
Forecasting the Disk-Full Date From a Daily File Size History
Free space today cannot tell you when the drive fills up. Save daily file sizes and let a short query turn the growth into a date.
SQL SERVER – What is Instance Hiding? How to do it?
In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.