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.
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.
Making the Most of Historical Data: Preventing Future SQL Server Issues
The key to predicting future troubles often lies in the past – specifically, historical data. We’ll explore the importance of historical data.
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.
SQL SERVER – Troubleshooting Common CSV Import Issues
Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.
SQL SERVER – Stored Procedures to Check for Pythagorean Triples
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.