MSSQLTips Author Profile


Today's Site Sponsor

	SQL Compare quickly and easily compares and synchronizes SQL Server database schemas

Today's Tip Tips By Category Latest Tips Top 10 Tips Suggest a Tip Search By Tip ID

Tools Tutorials Webcasts Whitepapers Blogs Forums Forums - Active Forums - Unanswered RSS Feeds

Join MSSQLTips Authors Contribute Giveaways Feedback User Groups Follow us on Twitter Follow us on LinkedIn

About Us Advertise Copyright Disclaimer Feedback Privacy Statement

Search By Tip ID Search By Category

Author - Atif Shehzad

Atif Shehzad is a passionate DBA currently serving at PRAL. Also he has experience in System Engineering from National Database & Registration Authority of Pakistan. He spends most of his time on SQL Server 2000 and SQL Server 2005. His main areas of interest are SQL Server optimization, security and Reporting Services. Reads blogs and believes in knowledge sharing through blogs and article writing. Writes on his SQL Server blog and for MSSQLTips.com.

Backup and Recovery

Copy Only Backup for SQL Server 2005 and SQL Server 2008 (6/15/2009)
SQL Server Backup History Analysis (10/2/2008)

Compression

Data Compression Using the SQL Server Vardecimal Storage Format (10/28/2008)

Database Administration

Best practices for SQL Server database ALTER table operations (12/17/2009)
Configure Windows Firewall to Work with SQL Server (1/27/2010)
Move SQL Server transaction log files to a different location via T-SQL and SSMS (6/17/2009)
Overview of the SQL Server Browser service (2/19/2010)
Using INSTEAD OF triggers in SQL Server for DML operations (7/29/2009)
Using SQL Server meta data to list tables that make up views (12/3/2008)

Database Design

Getting started with SQL Server database diagrams (8/14/2009)
SQL Server User Defined Data Types, Rules and Defaults (11/17/2008)
Using Computed Columns in SQL Server with Persisted Values (2/6/2009)

DBA Best Practices

Best practices for working with read only databases in SQL Server (1/14/2010)
Generate scripts for SQL Server 2008 object migration (6/1/2009)

Encryption

Options for hiding SQL Server code (9/1/2009)

Functions

Generate a parameter list for all SQL Server stored procedures and functions (1/20/2009)

Indexing

How to create indexes on computed columns in SQL Server (3/6/2009)

Maintenance Plans

Changing passwords for logins used with SQL Server maintenance plans (3/30/2010)
Creating SQL Server password protected backups and cleanup tasks (4/14/2010)

Partitioning

Creating a table with horizontal partitioning in SQL Server (7/17/2009)

Performance Tuning

Analyzing the SQL Server Plan Cache (1/8/2009)
SQL Server Schema Binding and Indexed Views (10/22/2008)
Using schema binding to improve SQL Server UDF performance (2/20/2009)

SQL Server Agent

Analyzing SQL Agent Job and Job Step History in SQL Server (5/15/2009)

SQL Server Management Studio

Auto generate change scripts in SQL Server Management Studio (SSMS) for tables (4/6/2009)
Customizing the Status Bar for each SQL Server SSMS Connection (11/2/2009)
Easier way to read your T-SQL code in SQL Server Management Studio SSMS with word wrap feature (11/10/2008)
Error 'Saving changes is not permitted.' in SQL Server 2008 Management Studio (4/29/2009)
Import and Export Registered SQL Servers To Other Machines (5/24/2010)
Maximizing work space with SQL Server Management Studio by using separate results tabs (9/8/2009)
Registering SQL Server instances for easier management (5/3/2010)

System Stored Procedures

Understanding and dealing with orphaned users in a SQL Server database (9/24/2008)

T-SQL

Benefits and limitations of using synonyms in SQL Server 2005 (9/4/2008)
Dropping multiple SQL Server objects with a single DROP statement (3/19/2009)
When to use SET vs SELECT when assigning values to variables in SQL Server (11/25/2009)

Triggers

Prevent accidental update or delete commands of all rows in a SQL Server table (10/5/2009)

Sponsor Information

Free SQL Server performance monitoring dashboard – Idera SQL check

Realistic test data in just one click with SQL Data Generator.

SQL Server Consultants - What you don't know could be your biggest asset - Guaranteed Results

All SQL Server, all the time! Sign-up for the MSSQLTips newsletter!

Free Whitepaper - Streamline Backup & Recovery with LiteSpeed for SQL Server and LiteSpeed Engine for Oracle

Idera - SQL secure

Idera SQL secure collects and analyzes permissions data from SQL Server and Active Directory as well as the file system and registry to show who has access to what database objects and how that access is granted. SQL secure also monitors changes made to access rights so that unapproved changes can be easily identified and fixed. SQL secure also collects and evaluates key security settings within SQL Server and provides proactive recommendations to improve server security.

Download now!

More SQL Server Tools

SQL Compare

SQL comparison toolset

SQL secure

SQL Backup

SQL defrag manager