SQL Server Archives - Page 260 of 348 - SQL Authority with Pinal Dave

SQL SERVER – Unable to Bring SQL Cluster Resource Online – Online Pending and then Failed

August 14, 2015

SQL High Availability, SQL Server, SQL Server Cluster

Here is the situation which my client explained and I was asked for help about SQL Cluster Resource.

Hi Pinal,
We are having 2 node windows cluster having 3 SQL Server instances clustered running on Windows 2012 R2 on VMware. We have one instance that will start from the services.msc but not from the Failover Cluster Manager when attempting to bring the service online. In reality the services start because during the ‘Online pending’ I am able to connect and query the databases on that instance, although it is in the ‘Online pending’ state.

Do you know what could be the problem?

SQL SERVER – Performance Monitoring for Analysis Services – Notes from the Field #093

August 13, 2015

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SQL Server

[Note from Pinal]: This is a new episode of Notes from the Field series. When we build an application, we build it with zeal and enthusiasm. We believe it will do well for many years but it is not the case always. After a while performance started to go down and everything is not in the best shape. This is the time when we need to monitor performance and take action based on our analysis.

SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol

August 12, 2015

Pinal Dave

SQL

SQL Log, SQL Server

The journey for IT started way back in my college days more than a decade back. It was a booming time and it was exciting to see everyone eyeing the Computer Science stream. Almost every other person in those days always wanted to take this new trend. Riding the waves was one part of excitement, while the other was to be unique in whatever we do. It is easy to get stereotyped with someone and we can never be different from the herd. I always believed in doing the basics right – this blog project that I started more than 8 years was to bring these basic learnings back. I am glad I have been doing this. Let us learn about Write Ahead Logging.

SQL SERVER – Adding File to Database in AlwaysOn Availability Group

August 8, 2015

Pinal Dave

SQL Tips and Tricks

AlwaysOn, SQL Scripts, SQL Server

Writing some typical interview questions have been on my list always. I look for new ways of tricking the person and most importantly, some of the interview questions are designed to make sure the person has strong fundamentals. This blog is one such attempt to understand the basics of the AlwaysOn Availability Group.

SQL SERVER – DevOps for the DBA – Notes from the Field #091

July 30, 2015

Pinal Dave

SQL

Notes from the Field, SQL Server

[Note from Pinal]: This is a 91st episode of Notes from the Field series. Divas is a new buzz word with lots of substance behind it. Not everyone understands what it means and not everyone actually related it to their daily job. Lots of people think that it is alright to not explore and learn about this as after a few days or months it will be meaningless. However, the reality seems very different about DevOps as it is one of the concepts which is just rediscovered. I recently asked my friend Stuart about what it means by DevOps for DBA and he had a informative answer to this question.

SQL SERVER – How to Find If Queries are Running in Parallel?

July 25, 2015

Pinal Dave

SQL Performance

Parallel, SQL CPU, SQL Scripts, SQL Server

Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.

SQL SERVER – Generating Meaningful Test Data with dbForge Data Generator for SQL Server

July 22, 2015

Pinal Dave

SQL

Devart, SQL Server, SQL Server Management Studio

Recently I faced with necessity of generating meaningful SQL data for testing purposes. During my search for a proper application for the task, I found out that Devart, a recognized developer of database solutions, released dbForge Data Generator for SQL Server, a GUI tool for fast generation of meaningful SQL data for development and testing purposes.