Atif Shehzad

Atif Shehzad is a passionate DBA currently serving at Pakistan Revenue Automation Limited (PRAL). His main areas of interest are SQL Server database design, best practices, performance optimization, security/permissions and Reporting Services. He blogs his SQL Server notes on DBDigger. Find him on Twitter and LinkedIn.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2013
Title Category Date
Understanding and dealing with orphaned users in a SQL Server database Security2026-05-29
Analyzing the SQL Server Plan Cache Performance Tuning2025-06-08
Error Saving changes is not permitted in SQL Server Management Studio SQL Server Management Studio2022-09-19
Maximizing work space with SSMS by using separate results tabs SQL Server Management Studio2022-03-25
Parameter List for all SQL Server Stored Procedures and Functions Functions User Defined UDF2022-02-23
SSMS Timeout Expired Error When Making Changes To a Table SQL Server Management Studio2012-05-17
Using Multiple Filegroups for a Database and Changing the Default Filegroup Database Administration2012-04-06
Restoring SQL Server system databases msdb and model Disaster Recovery2011-12-30
Getting creative with Computed Columns in SQL Server TSQL2011-08-29
SQL Server Foreign Key Update and Delete Rules Constraints2011-04-21
Using the Emergency State for a Corrupt SQL Server Database Disaster Recovery2011-03-23
How to setup and manage SQL Server Agent shared job schedules SQL Server Agent2011-01-13
Get script for every action in SQL Server Management Studio SQL Server Management Studio2010-12-06
SQL Server Agent Job Management Scripts SQL Server Agent2010-11-09
Import and Export Registered SQL Servers To Other Machines SQL Server Management Studio Configuration2010-05-24
Registering SQL Server instances for easier management SQL Server Management Studio Configuration2010-05-03
Creating SQL Server password protected backups and cleanup tasks Maintenance2010-04-14
Changing passwords for logins used with SQL Server maintenance plans Maintenance2010-03-30
Overview of the SQL Server Browser service Database Administration2010-02-19
Configure Windows Firewall to Work with SQL Server Security2010-01-27
Best practices for working with read only databases in SQL Server DBA Best Practices2010-01-14
Best practices for SQL Server database ALTER table operations DBA Best Practices2009-12-17
When to use SET vs SELECT for assigning SQL Server Variables TSQL2009-11-25
Customizing the Status Bar for each SQL Server SSMS Connection SQL Server Management Studio2009-11-02
Prevent Update or Delete of All Rows in a SQL Server Table Triggers2009-10-05
Options for hiding SQL Server code Security2009-09-01
Getting started with SQL Server database diagrams Database Design2009-08-14
Using INSTEAD OF triggers in SQL Server for DML operations Triggers2009-07-29
Creating a table with horizontal partitioning in SQL Server Partitioning2009-07-17
Move SQL Server Transaction Log Files to Different Location Database Administration2009-06-17
Copy Only Backup for SQL Server Backup2009-06-15
Generate scripts for SQL Server object migration Upgrades and Migrations2009-06-01
Analyzing SQL Agent Job and Job Step History in SQL Server SQL Server Agent2009-05-15
Auto Generate Change Tables Scripts in SQL Server Management Studio SQL Server Management Studio2009-04-06
Dropping multiple SQL Server objects with a single DROP statement TSQL2009-03-19
How to create indexes on computed columns in SQL Server Indexing2009-03-06
Using schema binding to improve SQL Server UDF performance Performance Tuning2009-02-20
Using Computed Columns in SQL Server with Persisted Values Database Design2009-02-06
Using SQL Server meta data to list tables that make up views Database Administration2008-12-03
SQL Server User Defined Data Types, Rules and Defaults Database Design2008-11-17
Easier way to read your TSQL code in SSMS with word wrap feature SQL Server Management Studio Configuration2008-11-10
Data Compression Using the SQL Server Vardecimal Storage Format Compression2008-10-28
SQL Server Schema Binding and Indexed Views Performance Tuning2008-10-22
SQL Server Backup History Analysis Backup2008-10-02
Benefits and limitations of using synonyms in SQL Server 2005 Synonyms2008-09-04