The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

Ever tried to learn SQL, the query language that lets you poke at the innards of databases? Most tutorials start by having you create your own database, fill it with nonsense, and then run queries ...

I've been doing a little google foo and coming up a bit short. I need a whitepaper that details what the SQL max memory should be set at in relation to the total amount of RAM on the server. I thought ...

I have the option to set the SQL services to run with different user accounts, basically Domain User Account or a Local System account.<BR><BR>Now as I understand it a Domain User Account is often ...

Last time, we discussed the different backup types available in SQL Server. Now, let's take a quick look at some best practices when it comes to configuring those backups. Although there is no one set ...

This column is available in a weekly newsletter called IT Best Practices. Click here to subscribe. SQL injection attacks have been around for more than 10 years. Database security experts know they ...