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.