Pinal Dave - SQL Server Performance Tuning Expert

NuoDB – Achieving Performance Through Scale-Out – Elastic Scalability

August 17, 2017

Pinal Dave

SQL

NuoDB

The other day, I received an email asking – What does elastic scalability mean?

SQL Server – Configuration Manager Console Running Very Slow and Time Out

August 16, 2017

Pinal Dave

SQL Performance

Database Compatible Level, SQL Server

SQL Server Performance Tuning is my hobby, passion and a job. During my recent consulting engagement for Comprehensive Database Performance Health Check, I had to face a very interesting situation which I had never faced before. I personally take any consulting gig where SQL Server is running slow, it does not matter if it is Configuration Manager Console, Dynamics, NAV, SharePoint or any other application which runs SQL Server as a database.

SQL SERVER – Database Files Initial Size Changing Automatically

August 15, 2017

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server

One of my clients reported an interesting issue and I was needed to wear detective cap to solve it. The mystery, for which they hired me was as below for Database Files Initial Size Changing Automatically.

SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started

August 14, 2017

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, SQL Server Agent

Many companies do hardening of servers to make sure they are protected from any known vulnerabilities. It is important to test all the application in test server before doing hardening. Let us learn about how to fix Eventlog Service not starting.

How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135

August 13, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Show Results of sp_spaceused in a Single Result?

Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.