PowerShell helps us to turn the time-intensive process of creating new users into a quick and easy task.

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.

Ok, for SQL server 2000, I need to change the account it runs under. I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at the ...

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

One in five users hit by service failures in the last year, research finds A survey of PostgreSQL users has found that the ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

In particular, many SQL Server users have become accustomed to dealing with what’s not-so-affectionately termed “SQL Server sprawl.” It’s a lot like it sounds—a sprawling environment that results in ...