:::: MENU ::::

Posts Categorized / Publications of Atif Shehzad on MSSQLTips.com

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

  • Sep 09 / 2009
  • 0
dbDigger, Publications of Atif Shehzad on MSSQLTips.com, SSMS tips and tricks

Maximizing work space with SQL Server Management Studio by using separate results tabs

My article related to Maximizing work space with SQL Server Management Studio by using separate results tabs is published on following address. Due to copy right restrictions i will not publish it here. You may visit it at Maximizing work space with SQL Server Management Studio by using separate results tabs. It would provide you handy methods and tricks to work in maximized view of SQL Server Management Studio (SSMS).

Consult us to explore the Databases. Contact us