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: Sys.Configuration

    A while ago, I was asked by customer how to tell if an instance parameter is dynamic or rather static (which requires me to restart the instance service). Parameters like fill factor (%) or max degree of parallelism . Does this parameter exist in the short list or do I need the show advance option ?...
  • Blog Post: LOG PARSER.

    Hello everyone, today I'd like to write about the LOG PARSER. First time I have encountered this tool was around 2004 when I had to load a big mass of data (IIS Log) into a database. A month ago I was asked by a customer, how can is it possible to read and load into SQL Server flat files / application...
  • 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...
  • Blog Post: Working with SQLIO and analyzing it’s output

    Introduction While working on a customer request, I faced the question what is the SQLIO? how to operate it and how to analyze its outputs? The customer has read about the tool and was also able to run it but wanted more information on how to do it and how to easily analyze the SQLIO output. ...
  • Blog Post: PERFMON & SQL Server - a small useful tip

    One of the best Performance tools that I use is the PERFMON. PERFMON is a tool that exists out of the box on every windows machine and has lots of counters for almost every application. Perfmon provides current, accurate information on thousands of different attributes of your system. If you open...