Top posts
-
SQL ACID properties
SQL ACID ACID properties When a transaction processing system creates a transaction, it will ensure that the transaction will have certain characteristics. The developers of the components that comprise the transaction are assured that these characteristics...
-
SQL Database in Suspect Mode
SQL Database in Suspect Mode What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA...
-
SQL Server Index Fragmentation In-depth
SQL Server Index Fragmentation In-depth There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down into SQL...
-
Hiding the SQL Server over the network...
Hiding the SQL Server over the network... Hiding the SQL Server over the network... As you can see all of my instances are visible on the network. If I want to hide this information from people on my network, it can be done easily. SQL Server allows us...
-
How do you recover a database which was crashed or corrupted using database backups?
How do you recover a database which was crashed or corrupted using database backups? This is most important questions and is asked almost in every interview. Failing to answer this question may reduce your chances of getting the job. Normally, you will...
-
Can we perform a SQL Server compressed backup?
Can we perform a SQL Server compressed backup? Starting SQL Server 2008, we can perform a compressed backups. All types of backups can be performed with compressed option. Prior to SQL Server 2008, backups may need to be compressed using third party tools...
-
DIFFERENCES BETWEEN 2005 AND 2008 AND 2008 R2 AND 2012.
DIFFERENCES BETWEEN 2005 AND 2008 AND 2008 R2 AND 2012. DIFFERENCES BETWEEN 2005 AND 2008 AND 2008 R2 AND 2012. SQL Server 2005 to 2008 • Transparent Data Encryption. The ability to encrypt an entire database. • Backup compression is available (only in...
-
What is Fragmentation? How to detect fragmentation and how to eliminate it?
What is Fragmentation? How to detect fragmentation and how to eliminate it? Storing data non-contiguously on disk is known as fragmentation. We can classify fragmentation into two types: Internal Fragmentation: When records are stored non-contiguously...
-
Addressing the Performance issues in SQL Server
Ticketing tool improves communications tracking whatever is happening in the environment, reporting that what has happened within the specific duration. A Ticket is an element contained within an issue tracking system which contains information about...
-
Commonly used scripts to troubleshooting...
Cannot connect to SQL Server from a remote machine? How to troubleshoot , when we are unable to connect the SQL Server from other machine?...follow below steps... and identify the issue... 1. Make sure SQL Server is running on the target machine ( verify...
-
New Features in SQL Server 2012:-
w Features in SQL Server 2012:- AlwaysOn Availability Groups – AlwaysON Availability Groups is a revolutionary feature which replaces many other features such Database Mirroring, Logshipping and up to an extent Replication. AlwaysON also known as HADRON,...
-
How to plan a backup strategy in SQL Server
How to plan a backup strategy in SQL Server? There are various types of backup options available in SQL Server and as a DBA we need to plan what backups need to be performed and how frequently those backups need to be performed. The planning for database...
-
How do you recover a database which was crashed or corrupted using database backups?
How do you recover a database which was crashed or corrupted using database backups? This is most important questions and is asked almost in every interview. Failing to answer this question may reduce your chances of getting the job. Normally, you will...
-
Common Backup errors and Troubleshooting steps
Common Backup errors and Troubleshooting step Common Backup errors and Troubleshooting steps:- You can find here some of the frequent or common errors faced which manually performing a database backup or an automated maintenance plan or custom backup...
-
SSRS: Report Server Usage Report
SSRS: Report Server Usage Report While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand the usage pattern of the report that are deployed or to troubleshoot the performance issues.SSRS stores...
-
Approaching Database Server Performance Issues 1
Approaching Database Server Performance Issues When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load the data on a page,could you please check something going wrong with database server?" There might...
-
Approaching Database Server Performance Issue 3
Approaching Database Server Performance Issue In the last post , we have discussed the script to list the sessions which are waiting for resource or currently running. In this post let us see how to list the blocking sessions with required information....
-
Trouble Shooting SQL Server
1. Unable to start SQL Server, what is the reason, how to find issue? A: Check Physical Error Log path : Open Configuration Manager > RC properties of Instance >Advanced check Startup Parameter 2. Log file is corrupted (there is no backups, how u will...
-
Resource Governor
Resource Governor 1. What is Resource governor? A: Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL...
-
Log file is corrupted (there is no backups, how u will get database?
Log file is corrupted (there is no backups, how u will get database? A: SELECT name, state, state_desc FROM sys.databases WHERE name='ABCD' Output for state_desc was RECOVERY_PENDING. I instructed him to set database to the emergency mode. ALTER DATABASE...
-
SQL DBA-INTERVIEW QUESTIONS
SQL DBA-INTERVIEW QUESTIONS INTERVIEW QUESTIONS --------------------------------------------------------------------------------- 1. What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We...
-
Monitoring and Tuning for Performance
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track...
-
SQL Server Integration Services (SSIS)Intervew Q & A.
SSIS 1: What is SSIS? How it is related with SQL Server. SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server....
-
PL/SQL - Module Overloading
Module Overloading Two or more modules can, under certain conditions, have the same name with different parameter lists. Such modules are said to be overloaded. The code in these overloaded programs can be very similar or can be completely different....
-
Unix Interview questions
Unix Interview questions Explain difference between IPC mechanisms? What type of scheduling is used in Unix? What is stty used for? How would you remove a semaphore / shared memory whose owner processes have died? Explain the unix file system? Give examples...