DBA THINGS

Tag: sql server

  • SQL DBA Cheatcode : SQL Server properties

    SQL DBA Cheatcode : SQL Server properties

    In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. It has been checked in various SQL versions like SQL 2005, 2008, 2008 R2 and 2012. SELECT SERVERPROPERTY(‘BuildClrVersion’) AS [BuildClrVersion] , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) AS ComputerNamePhysicalNetBIOS , SERVERPROPERTY(‘ServerName’)…

  • How to check SQL Server connection without SSMS?

    How to check SQL Server connection without SSMS?

    There are times when you need to verify SQL Server Connectivity from a machine there is no SQL Server Management Studio or any tool available. Not to worry, there are many ways to do this but the question is how easily can this be done? This question is often asked in DBA Interviews as well, “How to verify…

  • 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 permissions back on it after restore but still all permissions were not applied correctly and user is reporting access related issues. I checked and found that the…

  • March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation

    March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation

    I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So here comes the First blog of this series based on SQL Server installation topic. I hope it…

  • 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 for any SQL DBA(Junior or senior) out there. In this series, I’ll try to share as many queries as I have or I…

  • 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 scheduler. As a general rule of thumb, OLTP environments with high transaction volume and repetitive queries should normally have a MAXDOP value of 1, as any benefit gained from…

  • Database Engine Instances (SQL Server): A Quick Refresher

    Database Engine Instances (SQL Server): A Quick Refresher

    SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each running SQL Server instance you must see one sqlservr.exe in task manager. Like in screenshot. An instance can manage six system databases. An instance can manage one or more…

  • Issues – PayPal integration

    I am facing some issues with PayPal integration with WordPress. Cosider that this function isnt working as of now and avoid using it.