Tag Archives: Stored Procedures

SQL: Increase performance by fully qualifying procedure names

There is a “best practice” when programming in T-SQL that consists in fully qualifying any object referenced in your code. And this article explains one of the reasons why this is recommended. In short: if you don’t write “dbo.my_proc” when … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment

SQL Server security: Managing logins using stored procedures.

If you are a concerned DBA, you know that the rule of “least privilege” must be followed at all times. Even if something is not perfect right now, this is the direction to go and every step in that direction … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment