Financial firms have sensitive data including credit card numbers, social security numbers, financial history, etc. Based on the sensitivity of the data, it needs to be secured and protected from unauthorized access. With data stored in tables, you have
When preparing for a SQL Server interview there are several topics that could be covered. In this tip we cover some possible interview questions and answers related to SQL Server replication.
Learn about the different ways to capture and identify blocking that is occurring in SQL Server.
Whenever rows or columns are deleted from a table, SQL Server reuses space to accommodate new data. However, this is not the case when a variable length column is deleted. The space used by this type of column is not reclaimed automatically. Variable l
SQL Server backups and restores can take a long time to complete and this article gives you an idea how close these operation are to completion.
For improved security Microsoft recommends the SQL Server Agent service account should not be a member of the local Administrators group. Being a member of the Administrator group, grants the account super-user privileges which therefore may expose you to