Browse by Tags

Related Posts
  • Blog Post: Using the proper login account for the correct SQL Service

    I was often asked this question: I'm installing my SQL Server. What should I use as the service account? There are a few options (Local Account, Service Network, domain User) What is the best and suitable account for the service? I will try to answer that on this blog post. It is very important for...
  • Blog Post: Keep track of the DML changes:

    Last week, one of my customers asked me how to track DML code. He had a scenario in which he needed to update a table and keep the old data. In the past, developers and DBAs have used custom code to track changes, stored procedures, triggers and CDC. Starting with version 2005, SQL Server supports...
  • Blog Post: The scenario of a missing SA password:

    You are the senior DBA of your organization, responsible for all the databases that hold the critical info. In order to secure the environment and the databases, you performed the next recommended steps: 1) Remove all built-in admin account from SQL Server logins. 2) Remove all users from SYSADMIN...