>Exploring Database Backup Compression in SQL Server 2008

>Database backup size is always an issue in very large databases. Which is why we plan our backup and restore procedures properly to include either differential and filegroup backups. Most of the times, we use backup compression tools like LiteSpeed for SQL Server from Quest or SQL Backup from RedGate. SQL Server 2008 has a […]

>So, you think your secured, patched and updated servers are secure?

>So, we patch our servers, subject them to numerous security scans, implement security best practices and expect them to be secured? That’s ridiculous. I have been trying to convince developers how a functional application can be vulnerable if they do not implement security best practices in writing codes. I come from a developer background as […]

>Encrypting your database backups in SQL Server 2008

>I was asked a question about how you make sure that your SQL Server database backups are secured and I ended up saying, “go get a third-party tool like LiteSpeed for SQL Server from Quest Software.” While it is true that third-party tools can provide additional layer of security on your database backups, budget is […]

Say cheese!

“There are two things people want more than sex and money — recognition and praise.” Mary Kay Ash The public bus system of Seattle, Washington is filled with pictures of their employees – bus mechanics who have won the Vehicle Maintenance Employee of the Year Award who have also won some trade skills competition in […]

>Moving the WSUS database to a new location

>I woke up from a call from our support engineers telling me that a drive has less than 10% free space and needs to be maintained. This drive happens to be hosting my WSUS server together with the database used in the backend. There’s only one thing for me to do: move the database to […]