Atif Shehzad

Atif Shehzad is a passionate SQL Server DBA, technical reviewer and article author.

 
Atif Shehzad is a passionate DBA currently serving at Pakistan Revenue Automation Limited (PRAL). He is also the technical reviewer of Learning SQL Server 2008 Reporting Services. 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 Google Plus, Twitter and LinkedIn.
2013 Awards   

CategoryTitle
BackupCopy Only Backup for SQL Server
BackupSQL Server Backup History Analysis
CompressionData Compression Using the SQL Server Vardecimal Storage Format
ConstraintsSQL Server Foreign Key Update and Delete Rules
Database AdministrationMove SQL Server transaction log files to a different location via TSQL and SSMS
Database AdministrationOverview of the SQL Server Browser service
Database AdministrationUsing Multiple Filegroups for a Database and Changing the Default Filegroup
Database AdministrationUsing SQL Server meta data to list tables that make up views
Database DesignGetting started with SQL Server database diagrams
Database DesignSQL Server User Defined Data Types, Rules and Defaults
Database DesignUsing Computed Columns in SQL Server with Persisted Values
DBA Best PracticesBest practices for SQL Server database ALTER table operations
DBA Best PracticesBest practices for working with read only databases in SQL Server
Disaster RecoveryRestoring SQL Server system databases msdb and model
Disaster RecoveryUsing the Emergency State for a Corrupt SQL Server Database
Functions User Defined UDFGenerate a parameter list for all SQL Server stored procedures and functions
IndexingHow to create indexes on computed columns in SQL Server
MaintenanceChanging passwords for logins used with SQL Server maintenance plans
MaintenanceCreating SQL Server password protected backups and cleanup tasks
PartitioningCreating a table with horizontal partitioning in SQL Server
Performance TuningAnalyzing the SQL Server Plan Cache
Performance TuningSQL Server Schema Binding and Indexed Views
Performance TuningUsing schema binding to improve SQL Server UDF performance
SecurityConfigure Windows Firewall to Work with SQL Server
SecurityOptions for hiding SQL Server code
SecurityUnderstanding and dealing with orphaned users in a SQL Server database
SQL Server AgentAnalyzing SQL Agent Job and Job Step History in SQL Server
SQL Server AgentHow to setup and manage SQL Server Agent shared job schedules
SQL Server AgentSQL Server Agent Job Management Scripts
SQL Server Management StudioAuto Generate Change Scripts in SSMS for Tables
SQL Server Management StudioCustomizing the Status Bar for each SQL Server SSMS Connection
SQL Server Management StudioGet script for every action in SQL Server Management Studio
SQL Server Management StudioMaximizing work space with SSMS by using separate results tabs
SQL Server Management StudioSaving changes is not permitted in SQL Server Management Studio error
SQL Server Management StudioSSMS Timeout Expired Error When Making Changes To a Table
SQL Server Management Studio ConfigurationEasier way to read your TSQL code in SSMS with word wrap feature
SQL Server Management Studio ConfigurationImport and Export Registered SQL Servers To Other Machines
SQL Server Management Studio ConfigurationRegistering SQL Server instances for easier management
SynonymsBenefits and limitations of using synonyms in SQL Server 2005
TriggersPrevent accidental update or delete commands of all rows in a SQL Server table
TriggersUsing INSTEAD OF triggers in SQL Server for DML operations
TSQLDropping multiple SQL Server objects with a single DROP statement
TSQLGetting creative with Computed Columns in SQL Server
TSQLWhen to use SET vs SELECT when assigning values to variables in SQL Server
Upgrades and MigrationsGenerate scripts for SQL Server object migration
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (12)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (74)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (71)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (70)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (9)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (321)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (133)
Power PlatformPower BI Charts (46)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)