I've got a SQL server that I'm reviewing that uses mixed mode authentication. I have an entry in the syslogins table that lists a user with a NULL password, this user is an NTUser that does have ...

Now, enter your SQL Server's name and choose the authentication type that you want to use. If necessary, enter the credentials to be used for SQL Server authentication.

I need to build a new box to go in our DMZ to run SQL 2008 R2. SQL will have a processor license. The Windows build will be covered by our DataCenter license. So long as SQL authentication is used ...

Instead of using SQL Server Management Studio to bridge the gap, as used in Azure SQL Database, Microsoft's free SQL Server Data Tools (which can be downloaded here) will be used instead. The improved ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

SQL authentication only-for obvious reasons, integrated security cannot be implemented, but this may be an issue for your security model. Unsupported features compared to SQL Server 2008 include: SQL ...