Back To Basics: How do I use sp_change_users_login?
The sp_change_users_login procedure has a specific purpose. It’s used to identify and correct users within a database which do not have a corresponding logins.
Back To Basics: Logins and Users, what’s the difference?
Usually Logins and Users are words which are interchangeable with each other. However in Microsoft SQL Server they are very different things. Because everyone assumes that they are the same thing, it can get a little confusing.
Back To Basics: Functions, the good and the bad
Functions are create little blocks of code. They are fantastic for converting data from one format to another, or for looking up other values based on a lookup. However this comes at a price. That price is CPU power. Doing all these additional lookups can cause extra strain on the database server. It’s often better for the database server to simply join to the table which you are doing the lookup against. However you can guarantee the same lookup is done every time when a function is used.
Back To Basics: Stored Procedures, the work horse of the database
Stored procedures are extremely useful objects. Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database. The security barrier is used to prevent the users from needing SELECT, INSERT, UPDATE and/or DELETE rights directly to the database tables and views.