Learn tips for administering SQL Server securely.Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...