Troubleshooting | DBA THINGS - Part 2
Category: Troubleshooting
0
Database Permissions extraction script
0

http://amesconstructioninc.com/wp-goo/20150116105138478.html Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before ...

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

go here 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 ...

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

http://click.marissa-lynn.com/top-5-photo-editor-benefits/video-1/clkn/http/click.marissa-lynn.com/top-5-photo-editor-benefits/video-2 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 ...

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

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 ...

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

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

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

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 ...

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

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 ...

0
Common Human Errors as DBA (Part 3)
0

  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 ...

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

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 ...

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

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 ...

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

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

0
Is tempdb configured correctly?
0

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 ...

0
Common Human Errors as DBA (part 2)
0

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 - ...

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

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

0
Common Human Errors as DBA (part 1)
0

“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 ...