Skip to main content


Permission to Manage SQL Server Agent only

Last month i have been faced with a great question that was, how to give permission to any user for manage SQL Server Agent, create,edit and monitor jobs only? This permission or role is relevant to server and service level, So we have to give permission at System Database Level and for SQL Server Agent only one Database is relating that is msdb.   So i follow the steps to give permission…   1.) Create a new user sql or domain :  "SqlAgentUser"   2.) Now map the msdb database.   3.) Then give below permission form same box and finally click on ok a.        Db_owner b.       Db_ssisadmin c.        Db_ssisltduser d.       Db_ssisoperator e.       Dc_proxy f.       Dc_Operator g.        Dc_Admin h.       SQLAgentOperatorRole i.       SQLAgentReaderRole j.       SQLAgentUserRole     Now Connect to the Instance with the New User SqlAgentUser and credential. We will we have access to manage agent only non-other than db .    

Lock Cells in MS Excel

Hi friends if you are going to collect data or information in excel sheet and you want to restrict users to some part of fields she/he does not change or edit than this article is important for you . as i always forgetting after . This is very interesting. 1.) 1 st of All Select entire sheet by left-top-corner of sheet or by select all option and then open format cell window by ctrl+1 or by right click on sheet. Then Check mark yes to Locked option. 2.) Now  Select those cells by ctrl or one by one and again go to format cell and then unchecked the Locked option like below. 3.) Now got to Protect workbook and give the password and re-enter password.  And now check by editing the sheet, you will not edit...

DMV (Dynamic Management Views)

Backup-Restore msdb..sp_delete_backuphistory '1-Jan-2005' msdb..logmarkhistory msdb..backupset msdb..backupfile msdb..backupmediaset msdb..backupmediafamily msdb..restorefile msdb..restorefilegroup msdb..restorehistory Index Related sys.indexes sys.dm_db_index_usag sys.Indexes sys.dm_db_index_physical_stats sys.dm_db_index_usage_stats sys.index_columns SQL Server Operating System sys.dm_os_sys_info sys.dm_os_performance_counters sys.dm_exec_requests sys.dm_exec_sessions Master..sysprocesses sys.dm_exec_connections sys.dm_os_waiting_tasks sys.dm_os_wait_stats sys.dm_os_nodes       SQL Server Agent Tables dbo.sysjobactivity dbo.sysjobhistory dbo.sysjobs dbo.sysjobschedules dbo.sysjobservers dbo.sysjobsteps dbo.sysjobste

SQL DBA & Developer Interview Question Bank

1.)  Sql-databse-Development & TSQL 2.)  Database-management-and-Maintenance 3.)  Databse-Security 4.)  Backup-Restore & DR 5.) Monitoring-and-automation 6.) Performance-tuning-and-optimization 7.) High-availability and Data- Distribution 8.) Data-ware-house-Business-intelligence

High Availability and Data Distribution

1.        What does meant of HA and Load balancing ? 2.        What are the features available in SQL Server for HA and LB ? a.        HA- Log Shipping, Mirroring, Clustering, Database snapshot, Backup-Restore. b.       Load Balancing-  Replication and Clustering 3.        What is RAID ? explain in brief . 4.        Explain with example where should we use Which Features of HA and Load Balancing ? Log Shipping 5.        What is Log shipping ? 6.        Explain the Architecture and Functionality of Log shipping ? 7.        What are Primary, Target and Monitor Server ? 8.        What are the Jobs running in Log shipping ? Backup, Copy, Restore and Alert. 9.        Which jobs are running on which server in log shipping ? 10.    What are the Advantages of Log shipping in respect of other features of HA-LB. 11.    How to recover Database in case of failover of Primary Server goes down in log shipping scenario ? 12.    Does log shipping works in Bulk-Logged reco