Category: Troubleshooting
Database Permissions extraction script

Database Permissions extraction script

Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before refresh and applied the ...

READ MORE +
0
March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4

March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4

Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look at the ...

READ MORE +
0
SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA

In continuation of our DBA Cheatcode series :-   I started this series on Queries\T-SQL commands that we use in our day to day operations or those queries which should ...

READ MORE +
2
10 Interesting things that ‘CAN NOT’ be done in SQL Server

10 Interesting things that ‘CAN NOT’ be done in SQL Server

I was just thinking about few interesting facts about SQL Server properties which are good to be known for a SQL Server DBA. You can not add data and log files in master and ...

READ MORE +
0
How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

READ MORE +
0
How to create Drop and Recreate Script of all Indexes in a database?

How to create Drop and Recreate Script of all Indexes in a database?

I found this interesting script once so thought of sharing with everyone. Special thanks to the Unknown-Creator of this script.  This script generates the 'create' & 'drop' ...

READ MORE +
0
SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy ...

READ MORE +
0
Common Human Errors as DBA (Part 3)

Common Human Errors as DBA (Part 3)

  In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 Poor naming ...

READ MORE +
0
How to enable remote connection to SQL Instances from single SQL Server Management Studio?

How to enable remote connection to SQL Instances from single SQL Server Management Studio?

Problem : All SQL Server Instances in the Environment are not able to connect from central SQL  Server management Studio. Resolution: Below steps need to be followed to enable ...

READ MORE +
0
SQL DBA Cheatcode Part 1 : Few Important Queries for any DBA

SQL DBA Cheatcode Part 1 : Few Important Queries for any DBA

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy ...

READ MORE +
0
How to get access on SQL Server if you don’t have “sa” password or sysadmin access?

How to get access on SQL Server if you don’t have “sa” password or sysadmin access?

PROBLEM DBAs need to have sysadmin access on SQL Server to support Databases effectively. There may come situations where DBAs neither have sysadmin access nor password. In ...

READ MORE +
0
Is tempdb configured correctly?

Is tempdb configured correctly?

Let’s learn about tempdb and some of the best practices about tempdb. Before doing this, let’s talk about tempdb and its usage. A Tempdb is a system database that is available ...

READ MORE +
0
Common Human Errors as DBA (part 2)

Common Human Errors as DBA (part 2)

You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error - Data or Log file ...

READ MORE +
0
MAXDOP – What is best approach to use it!!!

MAXDOP – What is best approach to use it!!!

The Maximum Degree of Parallelism (MAXDOP) setting will determine the degree to which SQL server will attempt to parallel process transactions which are received from the ...

READ MORE +
0
Common Human Errors as DBA (part 1)

Common Human Errors as DBA (part 1)

“Human Error” is not a new word. Most of the time if there is screwed up done by any one – these golden words are used. For sure, these are the Human Errors and its hard to ...

READ MORE +
0