The Young DBA

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

We can use following code. Sub Button64_Click() ActiveWorkbook.RefreshAll End Sub

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

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

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

1.        What are the different ways and methods of performance tuning and optimization ? a.        Indexing b.       Achieving c.        Load Balancing d.       Query Refactoring e.       System/Resource Level Optimization (CPU,Memory,IO Configuration) 2.        What is Index ? 3.        What is Heap ? 4.        What is B-Tree/Balance Tree ? 5.        What are the kinds of Indexes ? – Clustered and Non-Clustered 6.        What are differences between Clustered and Non-Clustered Indexes ? 7.        What is execution plan / query execution plan ? 8.        What is Estimated and Actual Execution Plan ? 9.        How do you plan about Indexes in your database ? 10.    What is difference between Table scan and Index Scan ? 11.    What is Composite Index ? 12.    What is Filtered Index ? 13.    What is Fill Factor ? 14.    What is Page Split Problem in Sql Server ? 15.    What is Fragmentation , Explain ? 16.    What is difference between Index Reo