Encrypting Passwords Using EncryptByPassPhrase
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is part of a storing passwords blog series where we will examine …
Storing Passwords In A SQL Server Database
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is the first of a series of posts where we will …
Index Basics: Nonclustered Indexes, Part 1
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …
Index Basics: Clustered Indexes
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …
Why you should not prefix your stored procedures with “sp_”
One nasty habit that seems to persist throughout the ages with developers (I even did it myself) is the tendency to put “sp_” at the beginning of stored procedure names …
NOLOCK may not be doing what you think it does
When working with developers, I’ve noticed that some have a tendency to put WITH (NOLOCK) on every table in a SELECT query. When I inquire about this, the typical response I …