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.
SQL SERVER – Making Recursive Parent-Child Queries Efficient
One puzzle is finding out how many employees each manager is responsible for in a company. Let us Make Recursive Parent-Child Queries Efficient.
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.
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.
MySQL – Identifying Unused Indexes in Databases
Unused indexes slow down writes and waste space. Identifying unused indexes in your MySQL database is easy with INFORMATION_SCHEMA. Here is how.
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.