Profile

Cover photo
Aamir Shahzad
Attended Dawood College of Engineering and Technology
Lives in Charlotte, NC 28215
548 followers|11,551,101 views
AboutPostsPhotosYouTube

Stream

Aamir Shahzad

Shared publicly  - 
 
How to check if table exists in all databases in SQL Server- SQL Server Scripts
Scenario: You are working as SQL Server DBA / Developer. You have many databases on SQL Server Instance and you would like to check in which databases table exists or does not exists. Declare @TableName VARCHAR (128) --Provide the Table Name that you would ...
3
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to create SSRS Report Dynamically with Dynamic Schema, Dynamic Table Name and Dynamic Columns Part 59.1
Scenario: Few months back, I created a post/video "How to Create SSRS Report When Number of Columns Can change Anytime in Source Object" . In this post we are going to create another dynamic reports in which we will be able to 1) Choose the Schema form our ...
Scenario: Few months back, I created a post/video "How to Create SSRS Report When Number of Columns Can change Anytime in Source Object". In this post we are going to create another dynamic reports in which we will be able to...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to download file from SharePoint by using SSIS Package - SSIS Tutorial / SSIS Interview questions
Scenario: You are working as SSIS Developer and you need to download the file from SharePoint on daily basis, if the file exists in the folder you want to overwrite with new file. The file name that you need to download from the SharePoint stays the same. S...
Scenario: You are working as SSIS Developer and you need to download the file from SharePoint on daily basis, if the file exists in the folder you want to overwrite with new file. The file name that you need to download from ...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to see Created Date for Files and Folders in Windows Explorer
When we often Windows Explorer we see different properties and one of them we see for file and folder is Modified Date. Sometime we need to know when the file or folder was created and we would like to see Created Date. To add that Right Click right next to...
When we often Windows Explorer we see different properties and one of them we see for file and folder is Modified Date. Sometime we need to know when the file or folder was created and we would like to see Created Date. To ...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
Project / Work Support
Looking for some support who can help with difficult task/s and be there when you need them, TechBrothers have got your back! OR Have small or big project that needs to be finished by professionals on time, we are here to help. We provide following services...
Looking for some support who can help with difficult task/s and be there when you need them, TechBrothers have got your back! OR Have small or big project that needs to be finished by professionals on time, we are here to hel...
1
Laura Ashburn's profile photoAamir Shahzad's profile photoBhavesh Patel's profile photo
3 comments
 
I am interested in SQL server DBA training. Please let me know, what is the best way to communicate ?
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to use Assignment Operator in SQL Server - SQL Server / TSQL Tutorial Part 128
The equal ( = ) sign is used in TSQL as assignment operator. You will be using assignment operator many time when you write your TSQL Code. 1) Assign Value to Variable Assignment Operator can be used to set the value for variable. You can simply assign stat...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to get Maximum and Minimum Length for each Column Values for all the tables in SQL Server Database
Scenario: Let's say you are working as SQL Server developer / Architect and you need to design tables from existing tables. While creating existing tables nobody thought about correct data types and used NVARCHAR(MAX) or VARCHAR(MAX) , text or even ntext. Y...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to download File from SharePoint and Add Datetime to it in SSIS Package by using Script Task - SSIS Tutorial / SSIS Interview Questions
Scenario: You are working as ETL/ SSIS Developer. You need to write an SSIS Package that should download the file from SharePoint site. Every time you run the SSIS Package it should download the file and add date_time to it. Solution: We will be using HTTP ...
Scenario: You are working as ETL/ SSIS Developer. You need to write an SSIS Package that should download the file from SharePoint site. Every time you run the SSIS Package it should download the file and add date_time to it. ...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to Run Stored Procedure Against Multiple Databases in SQL Server - SQL Server / TSQL Scripts
Scenario: You are working as SQL Server developer. The company you are working create a new database for each of the client with same objects such as tables/Stored Procedures. You have one stored procedure with the same name let's say dbo.LoadCustomer prese...
Scenario: You are working as SQL Server developer. The company you are working create a new database for each of the client with same objects such as tables/Stored Procedures. You have one stored procedure with the same name...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to delete all files except current date files in SSIS Package - SSIS Tutorial
Scenario: You are working as ETL Developer or an SSIS developer, you need to write an SSIS Package that should be able to delete all the old files from a folder and just leave the current day files. How to Delete all files from a folder except Files created...
Scenario: You are working as ETL Developer or an SSIS developer, you need to write an SSIS Package that should be able to delete all the old files from a folder and just leave the current day files. How to Delete all files fr...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
What Arithmetic Operators are available in SQL Server - SQL Server / TSQL Part 129
Arithmetic Operators are used to perform mathematical operations such as Addition, Subtraction, Multiplication and Division etc. 1 )  + will be used for Addition 2) - will be used for Subtraction 3) * will be used for Multiplication 4) / will be used for Di...
Arithmetic Operators are used to perform mathematical operations such as Addition, Subtraction, Multiplication and Division etc. 1 ) + will be used for Addition 2) - will be used for Subtraction 3) * will be used for Multipli...
1
Add a comment...

Aamir Shahzad

Shared publicly  - 
 
How to use ANY Logical Operator in SQL Server - SQL Server / TSQL Tutorial Part 127
ANY Logical operator returns TRUE if any one of a set of comparisons are TRUE. ANY compares a scalar value with a single column set of values. Let's understand ANY with examples. Scenario : Let's say that we  have two tables dbo.Customer and dbo.Customer1. ...
1
Add a comment...
Work
Occupation
Microsoft Business Intelligence Trainer/ Database Architect/DBA
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Charlotte, NC 28215
Contact Information
Home
Phone
505-414-1969
Email
Story
Tagline
Aamir Shahzad Warraich
Education
  • Dawood College of Engineering and Technology
    BE- Electronics, 1999 - 2004
  • New Mexico Highlands University
    Masters-Computer Science, 2007 - 2008
Basic Information
Gender
Male
Other names
Aamir Shahzad Warraich
Links
Contributor to
Links