Just SQL Auth

Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.

Just SQL Auth

Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.

Let's Talk Ownership (and SQL Jobs)

It seems that the ownership of jobs is something that is often overlooked when articles explain

Grant Execute Permissions to Stored Procedures using DDL Triggers

In your development environment if you have locked down permissions for developers, but still need them to execute stored procedures you will need to grant execute rights each time a new stored procedure is generated. In this tip I will show you a way of doing this automatically each time a new stored procedure is created without granting your developers additional permissions.

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.

Low Hanging Fruit

An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?

Low Hanging Fruit

An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?

Low Hanging Fruit

An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?

Low Hanging Fruit

An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?

Role Membership