All Articles
Performance Tuning Series
Basics of Replication Troubleshooting
Script to Monitor the Running Job Status
Different ways to monitor Log Shipping for SQL Server databases
Steps to Attach a SQL Server database without transaction log file
PathPing-command
Extended Stored Procedure xp_msver
Script to Enable-Disable Database for Replication
Script to Enable/Disable Database for Replication
Steps to change the server name for a SQL Server machine
How to setup and configure the TDE
How to estimate the size of the backup file
Dedicated Administrator Connection
Common cause of the performance issues
Script to find out Heap Table/Table without clustered Index
Steps to restore Database using Database Snapshot
Steps to restore resource database
SQL Dependency Reporting
SQL Server 2008 R2 Unable to Start After Applying CU1
Standardize SQL Server Installations with Configuration Files
Script to get the CPU and Memory Information
Customizing the Status Bar for each SQL Server Instance registered in CMS
Query to check errorlog file location from SSMS
Useful queries while troubleshooting Database Mirroring
Steps to Create a 32-bit DSN on 64-bit machine for SQL Server
How to configure SQL Server to listen on Mutiple Ports
Script to Get Available and Free Disk Space for SQL Server
Difference between temporary table and table variable
Steps to setup a replication in MySQL
T-SQL Script to Check/Create directory
Restoring a SQLServer database that uses Change Data Capture
How to Move Resource Database?
How to kill all sessions that have open connection in a SQL Server Database?
Change Data Capture in SQL Server 2008
SQL Server Central Management Servers System Tables
Bug Fix:The I/O operation has been aborted because of either a thread exit or an application request
Customize SSMS query window for standard comment block and frequently used commands
Bug Fix:Cannot find template file for the new query
DMV to identify database features restricted to specific edition of SQL Server 2008
How to enable Dedicated Administrator Connection Feature in SQL Server 2008?
How to Turn Off SSMS Auto Recovery Feature?
Change Setting for Recently Used Files in SSMS
What is .TUF file in Log Shipping?
how to be SQL DBA?
Script to Monitor the progress of ALTER, Backup, Restore, DBCC, Rollback and TDE commands
How to Check When SQL Server was installed?
Dos Command to Check System Properties and Server Reboot time
Script to Update Statistics
Resolving Could Not Open Connection
Msg 15009, Level 16, State 1, Procedure sp_help, sp_helptext or object_definition()
Reolication Error Message Number and Description
Steps to change default value of SELECT (Top 1000) or EDIT(Top 200) rows in SSMS 2008
How to check the CLR Status and Properties
Steps to clear the server list in SQL Server Management Studio
SQL Server 2011 AKA Denali Step By Step Installation
Policy Based Management in SQL Server 2008
Undocumented Server Property ErrorLogFileName
How to Hide System Objects in Object Explorer?
Step By Step Log-Shipping Configuration for SQL Server
Surface Area Configuration in SQL Server 2008
SQLWB.exe (SQL2k5) and SSMS.exe(SQL2K8)
Steps to Check SQL Server Services Status
DMVs for SQL Server Cluster
Can we restore SQL Server 2008 database to SQL Server 2005?
Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008
Script to find out Orphaned AD/Windows Logins
Script to create Folder/Directory using SSMS
Query to Check the SQL Server Restart time
Troubleshooting CPU bottleneck
Script to Rename Database
Clear/Remove SQL Server Services from Services.msc
How to take database out of emergency mode?
How to take database out of emergency mode?
Script to Calculate DB size
Script to disconnect All active users on database
List of Scripts which make you database hero
Central Management Server
SQL Server Profiler
SQL Server Services
Different ways to secure the SQL Server SA Login
Copying column headers with grid query results in SQL Server Management Studio
Script to get the last update statistics date
List of Standard Report in SQL Server 2005-2008
How can we import/export registered servers?
Steps to rename table name and column name
Logical Join Vs Physical Join
Date Time Functions
Download and Install AdventureWorks Sample Database
How to Create Alias in SQL Server?
Identify Objects Type using sys.SysObjects
Insert data from one table to another table
Display the size of all tables in Sql Server 2005
Linked Server in SQL Server
GO Keyword with Integer Parameter
SSMS T-SQL Batch Separator
Backup Start Date Time and Finish Date Time
How many databases can be mirrored on a single instance of Microsoft SQL Server?
KILL SQL Server 2000 Blocking SPID and Records it details
Steps to insert error log records into temporary table
Stop successfull backup loging messages in SQL Server Error Log?
Transaction Log Backup
How the SQLBrowser Service Works Internally?
Row Versioning in SQL Server 2005
SQL Server 2005 Output Clause
Ranking Function – NTITLE()
Ranking Function – Dense_Rank()
Ranking Function – Rank()
Ranking Function – Row_Number
xp_enumgroups Extended stored procedure
How to read error log using T-SQL?
How to check SQL Server Authentication Mode using T-SQL and SSMS?
Database Level Fixed Roles
SQL Server Level Roles and Description
How can we remove Orphan User Instead of fixing it?
How to fix Orphan User in absense of login
Activity Monitor
How to Open Activity Monitor from SSMS tool?
How to check SQL Server Version Or Build No??
Operating System Error 112
Step by Step DB Mail Configuration
How to enable database mail feature in SQL Server 2005/2008?
Different types of SQL Server Database Access mode
How to get the lists of System Stored Procedures in SQL Server?
Run a Stored Procedure when SQL Server starts
Master..spt_values system table
Unable to change autogrowth properties of SQL Server of log file
LOGINPROPERTY Built-In function
How to get data of SQL Server PerfMon Counters without running Performance Monitor tool?
Make SQL Server DB Read Only/Read-Write Only
MSQL_XP Wait type
Error: The INSERT statement conflicted with the FOREIGN KEY constraint
Script to list out all DMVs and DMFs of SQL Server
How to generate script using SSMS GUI?
How to rename SA account in SQL Server
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
SP to recycle SQL Server and Agent Error Log file
Issues with Using Run As to Start SQL Server Management Studio with a Different Login
Download SQL Server 2011 code name Denali
How to check database ISOLATION Level?
SQL Server Version and Code Name
Find the create and modified date of Database Objects
Peer-to-peer transactional replication and conflict
Peer-to-peer transactional replication and conflict
Unable to start execution of step (reason: The PowerShell subsystem failed to load [see the SQLAGENT.OUT file for details];The job has been suspended). The step failed.
SQL Server Upgrade Startegies
Resource System Database
Dedicated Administrator Connection (DAC)
SQL Server Full Backup Internally
Monitor, Start and Stop services using xp_servicecontrol
Split-Brain/tiebreaker in Cluster
Error: 1101, Severity: 17, State: 2.
How to move data and log file using Alter statement
Shrink SQL Server 2000 Database
Remote Desktop Error – The terminal server has exceeded the maximum number of allowed connections
How to check authentication scheme in SQL 2005/SQL 2008?
how to delete temporary files (*.tmp) and bak files (*.bak)
SQL Server and Protocols
Number of articles and readers
Default Startup Parameters – SQL Server
Trace Flag 3226
Key Points in Disaster Recovery
Script to fix and list out Orphan Users on all the databases on server
RAID Levels
Enabling Filestream to store compress documents
Max Degree of Parallelism and MAXDOP
SQL Server 2008 R2 Editions and Key Features
Download SQL Server 2008 R2 CTP
SQL Server 2008 R2 Airlift and Report Builder 3.0
SQL Server 2008 R2 Airlift Event
Script to Unlock SQL User account
Insert Extended Characters into a SQL Server Table Using OSQL and T-SQL
Database Migration Checklist
SQL Server 2008 Interview Questions
SP_Who Process status
Database Mirroring Vs Log Shipping
Script to find out data and log file size
Script to Take database offline
How to make database read only?
What is Orphan User and Script to fix the Orphan Users
MySQL Replication
FAQs .Net Assembly
DBCC TRACEON / DBCC TRACEOFF/ DBCC TRACESTATUS
Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it.
Index Rebuild vs Index Reorganize. Diffrence between Index Rebuild and Index Reorganize
IHow to check SQL Services status from management studio?
Service Principle Name
Script to Verify the litespeed backup file
Script to list out important properties of database
Script to change the database compatibility level
Login failed for user XYZ The user is not associated with a trusted SQL Server connection.
Unable to install Windows Installer
MSP file
Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server.
Script – Generate DBCC ShrinkFile for each datbase files
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.
DBCC PAGE
Shrink Log File
An error has occurred while establishing a connection to the server
What are the features we can enable using Surface Area Configuration Tool?
SQL Server Security Interview Questions
How to change Min/Max Memory in SQL Server?
SQL Server 2008 Active-Passive/Active-Active Cluster Installation
How to move Cluster Resource/Services to proper node using command prompt?
How to check cluster resources are running on proper node using command prompt?
Login Issue
Shrink the log to as small a size as possible (truncateonly)
SQL Server 2005 Backup Error Messages
Server: Msg 7391, Level 16, State 1, Line 2
Error: 18456, Severity: 14, State: 16
Insert Extended Character using OSQL Utility
Msg 15410, Level 11, State 1
Msg 15063, Level 16, State 1
Troubleshoot Blocking
kernel udopen: operating system error 2 in SQL Server 6.5
How to find database restore history from MSDB?
How to improve communication skills & Support Service
How to improve TempDB performance?
Troubleshoot Suspect Database Issue
DRBD, Heartbeat and MySQL
How to search error from SQL Server error log or SQL Server Agent Log?
Error 18456, Severity 14: Login Failed States
How to Alter a SQL Server Database as Single User Mode and as Multi User Mode
Find the SQL Server Service Startup Time
Execute As in SQL Server 2005
How to recover root password in MySQL?
Oralce Interview Questions – Year 2009 Part – II
Oracle Interview Questions – Year 2009 – Part I
MySQL and Linux commands
How to decide Primary Key column data type in MySQL? Expectation with the Primary Key column
SQL Server Execution Context and Security
SQL Server Interview Questions 2K9 – Part – I
SQL Server 2005 Schema, Schema Properties, Schema T-SQL
Download SQL Sever 2005/SQL Server 2008 Samples
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
How do I install the Service Pack?
December 31, 2008
SQL Server Service Packs and Hotfixes
How do we see the SQL Plan in textual format?
How to enable or disable ‘sa’ login?
SQL Server 2005 Questions and Answers
DBA Roles and Responsibilities
Datbase Snapshot
Factors That Impact Performance
What does database performance means?
SQL Server and Networking
Table Locking enhancement –
SQL Server 2008
Resource Governor in SQL Server 2008
SQL Server 2008 Sparse column
Data Page LSN and Transaction Log LSN
Log Shipping Requirements
Network Troubleshooting Dos Commands
Networking Questions
Networking Interview Questions
Open Systems Interconnection Model
What is the Global.asax file?
“Cannot Generate SSPI Context” error message, more comments for SQL Server
Important Backup Options
How to take backup in Multiple files?
SQL Server Windows Authentication (MIX Mode Authenticatio)
The Basics of Hyper-Threading: What is it?
Networking Terms
Can not open user default database; login failed
Index Covering
How to change SQL Server Instance Name?
Exception Handling using Try-Catch in SQL Server 2005
Replication Agents
Replication in SQL Server 2005
Java Interview Questions
SQL Server 2005 Server-Level Fixed Roles
SQL Server Fixed Database-Level Roles
Oracle Databse Questions and Answers
SQL Server 2005 Interview Questions
Database Certifications
Database Mirroring Operating Modes
SQL Server 2005 Editions
System Databases in SQL Server 2005
GIS DataTypes in SQL Server 2008
XP_cmdshell extended stored procedure (Execute Winows commands)
How to read transaction log data in SQL Server 2000/2005?
Disk Space Alerts using SQL Server 2005
DOS Commands for DBA
SQL Server 2000 Query Analyzer Shortcut
SQL Server 2005 Questions and Answers
FAQs in SQL Server and Oracle
Database Concepts or Database Keywords
.NET INTEGRATION WITH SQL SERVER 2005
Transfer Logins from SQL Server to another SQL Server Instance
Setup Replication MySQL
Data Types in SQL Server
MySQL Optimization Tips
Transactions and Locks in SQL Server
Transactions and Locks in SQL Server
Stored Procedure and System Tables
SQL Server Database Coding Standards
Pros and Cons of MySQL Table Types
MySQL Question and Answers
SQL Server DBA Checklist
How do I reclaim Space from the INNODB (Ibdata) file?
Basic SQL Language based questions
Database Concepts
SQL Server 2008 Features
sir i m consider DBA releted work
thanks
sir i want difference between logshipping,mirrioring,replication in sqlserver dba 2005
gud site
I got the job as a DBA in sql server 2005
i konow basics query retervial,database creation..etc.
but i have to know the database backup.
please suggest the comments help me……..
Hi ,
ur given nice Documents thanks very helpfull for me .
Regards,
Shankarreddy.D
Thanks Shankar
hi sir, can u plz explain the diff b/w master & resource dbs in detail
The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. Also, master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable.
In SQL Server, system objects are no longer stored in the master database; instead, they are stored in the Resource database.The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.
Hi jugal,
is there any check list for performance monitor on sql servers.
-subbarao
Yes. there is I am working on it and will post it on my blog soon.
Hi,
Memory utilization of my system goes high so what is the normal utilization of sql server 2005 and what is the query in sql server 2k5 to find how much memory is utilizing?
Memory utilization depends on the current system load, you can limit the memory use by configuring min/max memory and lock pages in memory.
To find out the memory usage and troubleshooting use DBCC MEMORYSTATUS command.
how to real time work in clustring
Dear Jugal Sir,
I am a DBA working in Bangalore, just completed 1 month today.
Sir, I have 2 questions for you.
1) How is DBA and Datawarehousing related to one another ?
2) Can I change my role from a DBA to datawarehousing in the near future ?
Datawarehousing is OLAP, it has data for analysis and Production DBA is OLTP where the data is live. You can change must you must have knowledge of BI Tools and Analysis service.
Query processing is slow(eg select query)how will u solve that
There could be multiple reasons, start with wait type and troubleshoot as per the wait type.
Hi Jugal Shah
Am new to this forum and to dba too. Am currently working as production support in ms sql server. I am really serious in becoming a dba. Can you please guide me? If possible mail me your advise to aruammca@yahoo.com. Waiting for your kind guidance. Thanks in advance!
Keep reading SQL Blogs, Be member of MSDN/TechNet forums and try to resolve the diffrent issues.
Patch management for development
Hi Jugal, This is very good site for intermidiate/Advanced DBA’s. This is more than good of Penal Dave’s site. Thanks for your entire support for providing the me the deatiled discussion from different topics.
Thanks
Deepak Kumar
deepakdba@in.com