:::: MENU ::::

Posts Categorized / DBA best practices

  • Jan 14 / 2010
  • 0
DBA best practices, dbDigger, Performance Tunning and Optimization, Publications of Atif Shehzad on MSSQLTips.com

Working with READ ONLY databases in SQL Server

If any of database is not meant to change, then it may be considered as good candidate for READ ONLY database. It is an important concept and requires proper analysis of pros and cos. My article related to Working with READ ONLY databases in SQL Server is published on following address. Due to copy right restrictions i will not publish it here. You may visit it at Working with READ ONLY databases in SQL Server

  • Dec 23 / 2009
  • 0
DBA best practices, dbDigger, Performance Tunning and Optimization, Publications of Atif Shehzad on MSSQLTips.com

Best practices for ALTER table operations in SQL Server

ALTER table operations are very important and may have far reaching effect. Such operations require extensive planning and analysis. My article related to Best practices for ALTER table operations in SQL Server is published on following address. Due to copy right restrictions i will not publish it here. You may visit it at Best practices for ALTER table operations in SQL Server

  • Oct 30 / 2009
  • 0
DBA best practices, dbDigger, SSMS tips and tricks

Customizing SSMS start up opening panes

Both in SQL Server management studio (SSMS) 2005 and 2008 have option to select from objects like object explorer, new query window or activity monitor to be opened automatically when SSMS starts. Following following couple of steps for this start up customization of SSMS

  • Go to ‘options’ in tools menu
  • Click on ‘environment’ in left frame (if not already selected)
  • Open drop down list in front to ‘At startup’
  • Now choose your required objects and click ok

Selective panes at SSMS startup

Now whenever you will open SSMS, the panes or explorer that you choose would be available automatically. If you choose ‘Open empty environment’ then you would get nothing at SSMS start up, but just SSMS frame without any login frame or any thing else.
Note: The options in drop down may differ slightly in SSMS 2005 and 2008.

  • Oct 06 / 2009
  • 0
DBA best practices, DBA Interview questions, dbDigger, Publications of Atif Shehzad on MSSQLTips.com, Triggers

Prevent accidental update or delete commands of all rows in a SQL Server table

My article related to Prevent accidental update or delete commands of all rows in a SQL Server table is published on following address. Due to copy right restrictions i will not publish it here. You may visit it at Prevent accidental update or delete commands of all rows in a SQL Server table. It would provide efficient way to make sure that if you forget to include where clause in update or delete scripts then all rows should not be updated or deleted.

Consult us to explore the Databases. Contact us