When it comes to assigning value to different components in today’s IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

Looking to run SQL 2000 as a platform for an ERP app on a new box. Dual P4, 2GB RAM, up to 6 SCSI drives in any of a variety of RAID configurations.<BR><BR>The research I've done and the ERP vendor ...

Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your storage properly to keep SQL Server workloads running smoothly. Microsoft ...

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots Like so much of IT, database security requirements largely ...

Maximize your SQL Server performance – right now! Optimizing SQL Server performance is challenging work. And while you can find a lot of info on general performance problems, there hasn’t been much ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...