All Articles - SQL Authority with Pinal Dave

SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073

March 26, 2015

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about indexes and its impact. We often believe that indexes will improve the performance of the query, but it is not true always. There are cases when indexes can reduce the performance as well. Read…

SQL SERVER – Knowing Nested Transactions Behavior with SQL Server

March 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Transactions

SQL Server is an interesting database system that baffles me every single day that I get to learn something new. This blog has been my way to share these learnings. Every time I write something new, my blog readers have been kind enough in pushing me with interesting comments that…

SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

March 24, 2015

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Log, SQL Scripts, SQL Server

Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them to find location of ERRORLOG file generated by SQL Server. Most DBA’s are intelligent and know some of these, but this is my try to share my learning about ERRORLOG location.

SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases

March 23, 2015

Pinal Dave

SQL Backup and Restore

Last week I wrote about SQL SERVER – Marking Filegroup as ReadOnly with SQL Server and it got me interested into few key questions. One of the questions someone asked was, how will backups behave? Are there anything I need to know about ReadOnly Filegroups? Will these databases when restored take…

Interview Question of the Week #012 – Steps to Restore Bak File to Database

March 22, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Here is the question, I was asked the other day at the conference. Question: If I have a .bak file and I want to restore it database what are the various steps involved in it. Assume that I do not know much about that backup file. Answer: I love this question,…

SQL SERVER – Trivia – Days in a Year

March 21, 2015

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL DateTime

Every time I wrote a blog, I tend to get back to most of them via the search. Most of you ask me questions and I do few simple search back to make sure I am able to address them. Yesterday as I was searching for an interesting question, Now…

SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed

March 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Every day I get many emails and blog comment with at least one new problem every day. Recently, one of my blog readers sent an email asking assistance. She already had two node Windows Cluster. Let us call them Node1 and Node2. SQL Server Clustered instance, was successfully installed on…

SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072

March 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 72th episode of Notes from the Field series. Master Data Services is one of the most important but very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI…

SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1

March 18, 2015

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server

We are so used to taking backups and it can sometimes give us new experiences. One of the common messages I see are around taking backups on a share. If you have found this blog while searching for error message then you may want to look at below blogs as well if you are NOT dealing with mapped drive.

SQL SERVER – Marking Filegroup as ReadOnly with SQL Server

March 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and they wanted to know how this can be done. This blog post is in continuation to…