Arshad Ali

Arshad specializes in Database, Data Warehousing and Business Intelligence application design, development and deployment, at enterprise level, with SQL Server, SSIS, SSRS, SSAS, Service Broker, MDS, DQS, SharePoint and PPS. He is a Microsoft Certified IT Professional in Microsoft SQL Server.  He also has experience developing applications in VB/ASP/.NET/ASP.NET/C#, and is a Microsoft Certified Application Developer and Solution Developer for the .NET platform in Web/Windows/Enterprise.  Arshad has Master's degrees in Computer Applications and Business Administration in IT. Disclaimer: Arshad worked for Microsoft and helped people and businesses make better use of technology to realize their full potential. The opinions mentioned in his tips and articles herein are solely his and do not reflect those of his current or previous employers.
  • MSSQLTips Awards: Champion (100+ tips) - 2014
Title Category Date
SQL Server CROSS APPLY and OUTER APPLY Helpful Examples JOIN Tables2026-06-04
SQL Server MERGE to insert, update and delete at the same time TSQL2026-05-29
SQL Server System Functions for Server and Database Properties Functions System2025-05-21
Running a SSIS Package from SQL Server Agent Using a Proxy Account SQL Server Agent2025-01-10
SQL Server Functions for Tables, Views, Indexes, Columns, and more Functions System2024-08-13
Importing and Processing data from XML files into SQL Server tables XML2022-02-24
Understanding SQL Server Physical Joins JOIN Tables2020-07-29
Getting started with Indexes on SQL Server Memory Optimized Tables In Memory OLTP2014-03-18
Getting started with SQL Server 2014 In-Memory OLTP In Memory OLTP2014-02-07
SQL Server In Memory OLTP Durability and Transaction Isolation Level In Memory OLTP2014-01-20
Getting started with the AMR tool for migration to SQL Server In-memory OLTP Tables In Memory OLTP2013-12-31
Overview of Applications, Indexes and Limitations for SQL Server 2014 In-Memory OLTP Tables In Memory OLTP2013-12-30
SQL Server 2014 In-Memory OLTP Architecture and Data Storage In Memory OLTP2013-12-13
SQL Server Backups and Restores Directly with Windows Azure Blob Storage Service Azure Backup and Restore2013-12-06
TSQL Database Backup and Restore using Windows Azure Blob Storage Azure Backup and Restore2013-11-25
Getting started with SQL Data Sync Azure2013-11-12
Understanding SQL Data Sync for SQL Server Azure2013-10-25
Windows Azure SQL Database Backup and Restore strategy Azure Backup and Restore2013-10-16
Backup and Restore with Cloud services (Windows Azure Blob Storage Service) using PowerShell Backup2013-10-11
Backup and Restore SQL Server databases with Azure cloud services and SMO Backup2013-09-23
Creating Power View Reports in Excel 2013 Microsoft Excel Integration2013-08-27
Teach Business Users How To Create Power View Reports With SQL Server Data Sources Microsoft Excel Integration2013-08-05
Power View Reports with SharePoint, Excel and SQL Server Example Microsoft Excel Integration2013-08-02
Comparing Data Warehouse Design Methodologies for Microsoft SQL Server Analysis Services Development2013-06-24
SQL Server Business Intelligence System Architecture – Part 2 Analysis Services Development2013-06-14
Microsoft SQL Server Business Intelligence – What, Why, How – Part 1 Analysis Services Development2013-06-07
SSIS FTP Task for Data Exchange Integration Services Control Flow Transformations2013-02-15
Data tapping during SSIS package execution in SQL Server 2012 Integration Services Configuration Options2013-01-15
Creating SSIS Package Templates for Reusability Integration Services Development2013-01-02
Getting started with the SQL Server 2012 Tabular Model – Part 2 Analysis Services Tutorials2012-12-17
Getting started with Tabular Model in SQL Server 2012 – Part 1 Analysis Services Tutorials2012-11-29
Understanding the SQL Server 2012 BI Semantic Model (BISM) Analysis Services Administration2012-11-19
SQL Server 2012 Column Store Index Example Indexing2012-10-12
Importing Data From Excel Using SSIS – Part 2 Integration Services Excel2012-10-02
Importing Data From Excel Using SSIS – Part 1 Integration Services Excel2012-09-20
Let’s Explore Excel add-in of Master Data Services of SQL Server 2012 – Part 2 Master Data Services2012-08-27
Excel add-in for SQL Server 2012 Master Data Services – Part 1 Master Data Services2012-08-23
SSRS vs. PerformancePoint Services Reporting Services Overview2012-08-10
Getting Started with SQL Server Data Quality Services Using SSIS Data Quality Services2012-06-06
Create knowledge base with SQL Server Data Quality Services – Part 3 Data Quality Services2012-05-24
Getting Started with Data Quality Services of SQL Server 2012 – Part 2 Data Quality Services2012-05-10
SSAS – Best Practices and Performance Optimization – Part 4 of 4 Analysis Services Performance2012-05-04
Getting Started with SQL Server 2012 Data Quality Services – Part 1 Data Quality Services2012-04-23
SSAS – Best Practices and Performance Optimization – Part 3 of 4 Analysis Services Performance2012-03-26
SSAS Best Practices for Performance Optimization – Part 2 of 4 Analysis Services Performance2012-03-08
SSAS – Best Practices and Performance Optimization – Part 1 of 4 Analysis Services Performance2012-02-17
SSIS Interview Questions Data Profiling, Protection Level Business Intelligence Interview Questions2012-02-03
SSIS Interview Questions for Memory Management and Deployment Business Intelligence Interview Questions2012-01-13
SSIS Architecture and Internals Interview Questions Business Intelligence Interview Questions2012-01-02
SSIS Interview Questions on Transactions, Events and Validation Business Intelligence Interview Questions2011-12-12
SSIS Interview Questions for Basic Concepts and Event Logging Business Intelligence Interview Questions2011-12-06
SSIS Interview Questions – Part 1 Business Intelligence Interview Questions2011-11-23
SQL Server 2012 SSIS Enhancements Part 2 of 2 Integration Services Development2011-09-14
SQL Server 2012 SSIS Enhancements Part 1 of 2 Integration Services Development2011-09-01
SSIS Project Deployment Model in SQL Server 2012 (Part 2 of 2) Integration Services Configuration Options2011-08-23
SSIS Project Deployment Model in SQL Server 2012 (Part 1 of 2) Integration Services Configuration Options2011-08-11
SQL Server 2012 THROW statement to raise an exception Error Handling2011-07-14
SQL Server 2012 Server Side Paging Paging2011-07-07
SQL Server 2012 TSQL Debugging enhancements Debugging2011-07-01
Getting started with Code Snippets feature of SQL Server 2012 SQL Server Management Studio2011-06-22
SQL Server Management Studio Keyboard Shortcuts Part 2 SQL Server Management Studio Shortcuts2011-06-09
SQL Server Management Studio keyboard shortcuts (Part 1 of 2) SQL Server Management Studio Shortcuts2011-06-01
SQL Server Service Broker Poison Message Handling Service Broker2011-03-16
Understanding SQL Server Net Libraries SQL Server Configurations2011-03-08
Getting Started with the SQL Azure Database Manager Azure2011-02-03
Creating backups and copies of your SQL Azure databases Azure2011-01-25
Generating SQL Server Test Data with Visual Studio 2010 Testing2010-12-23
SQL Server Unit Testing with Visual Studio 2010 Testing2010-12-16
Getting Started with Extended Events in SQL Server 2008 Extended Events2010-10-29
An Overview of Extended Events in SQL Server 2008 Extended Events2010-10-28
Event Notifications in SQL Server for Tracking Changes Service Broker2010-09-27
SQL Data Comparison with Visual Studio 2010 Comparison Data and Objects2010-08-23
SQL Schema Comparison with Visual Studio 2010 Comparison Data and Objects2010-08-12
SSIS Transfer SQL Server Jobs and Transfer SQL Server Logins Tasks Integration Services Control Flow Transformations2010-08-04
Transfer Database Task and Transfer SQL Server Objects Task in SSIS Integration Services Control Flow Transformations2010-07-19
Using Data Access Application Block DAAB in SQL Server Part 2 of 2 Application Development2010-07-08
Using SQL Server Data Access Application Block (DAAB) Part 1 of 2 Application Development2010-06-30
SSIS Multicast Transformation vs Conditional Split Transformation Integration Services Data Flow Transformations2010-06-28
Writing a Data Access Layer (DAL) for SQL Server Application Development2010-06-07
Understanding Dynamic Management Views and Functions in SQL Server Dynamic Management Views and Functions2010-04-01
SQL Server 2005 and 2008 Ranking Functions DENSE_RANK and NTILE Functions System2010-03-01
SQL Server Ranking Functions Row_Number and Rank Functions System2010-02-17
Understanding Catalog Views in SQL Server 2005 and 2008 Dynamic Management Views and Functions2010-02-03
Different strategies for removing duplicate records in SQL Server Database Administration2010-01-08
Transfer SQL Server database schema objects and data with SMO SQL Server Management Objects SMO2009-12-29
Iterate through SQL Server database objects without cursors Scripts2009-12-21
SQL Azure enhancements with SQL Server 2008 R2 Azure2009-12-10
SSIS Design Best Practices Integration Services Best Practices2009-12-04
SQL Integration Services SSIS Troubleshooting Best Practices Integration Services Best Practices2009-11-20
Moving your database to the cloud with SQL Azure Azure2009-11-05
SSIS Performance Best Practices Integration Services Best Practices2009-10-27
Backup and Restore SQL Server databases programmatically with SMO Backup2009-10-01
SSIS Best Practices Integration Services Best Practices2009-09-18
Generate Scripts for database objects with SMO for SQL Server SQL Server Management Objects SMO2009-09-09
Getting started with SQL Server Management Objects (SMO) SQL Server Management Objects SMO2009-08-28
Using Change Tracking in SQL Server 2008 Change Data Capture2009-08-19
Fixing Index Fragmentation in SQL Server 2005 and SQL Server 2008 Fragmentation and Index Maintenance2009-07-10
SQL Server Filtered Indexes Indexing2009-07-02
Dynamic SQL execution on remote SQL Server using EXEC AT Dynamic SQL2009-05-22
Sending HTML formatted email in SQL Server using the SSIS Script Task Integration Services Development2009-05-18
SSIS Send Email Integration Services Development2009-04-16
Handling workloads on SQL Server 2008 with Resource Governor Resource Governor2009-04-01
Index Fragmentation Report in SQL Server Fragmentation and Index Maintenance2009-03-16
SQL Server TSQL Debugger in SQL Server Management Studio Debugging2009-02-25