Home
Videos uploaded by user “TechBrothersIT”
SQL Server Interview Question | What is the difference Between Index Rebuild and Index Reorganize
 
03:55
In this video you will be learning how to answer SQL Server DBA interview Question "What is the difference Between Index Rebuild and Index Reorganize?" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 20857 TechBrothersIT
SSIS Tutorial Part 25-Load Multiple Excel Files to SQL Server Table & Archive them with Datetime
 
16:08
In this video you will learn how to load Multiple Excel files to a SQL server Table and archive them after loading them. Expression used for video to get date_time. Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx" How to load Multiple Excel files to SQL Server Table How to Load Multiple Excel files to SQL Server Table and Archive with datetime added to them. In this video you will learn How to use foreach Loop Container How to use Excel Source in SSIS How to use File System Task to rename and move files. Check out our Step by Step SSIS Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/TechBrothersIT
Views: 60583 TechBrothersIT
SQL Server DBA Tutorial 110-How to Setup Database Mirroring in SQL Server
 
18:54
In this video you will learn how to setup Database mirroring step by step process. Process explains how to prepare database for Mirroring, how to configure Principle server, what is principle and Mirror server in SQL Server Mirroring, how to configure Mirror server, how to configure witness server, how to failover and how to get required permission for Mirroring configuration in SQL Server. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-setup-database-mirroring-in-sql.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 72879 TechBrothersIT
SQL Server DBA Interview Questions and Answers | What are the differences between DMV's and DMF's
 
03:40
SQL Server Interview Question "What are the differences between DMV's and DMF's?" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 12778 TechBrothersIT
SSIS Tutorial Part 04-How to Load Multiple Comma Delimited Files to SQL Server Table in SSIS Package
 
13:20
In this video tutorial you will learn how to load all text files ( Comma delimited) from a Folder to a SQL Server Table by using SQL Server Integration Services ( SSIS ) Package. This video can be used for beginners and as well for SSIS or ETL developers for real time scenarios. The video also explains How to create SSIS Package from Scratch How to use Foreach Loop Container in SSIS Package How to Loop through multiple text files by using Foreach Loop Container in SSIS Package How to use Data Flow task in SSIS Package How to write Expressions on Connection Manager in SSIS Package How to use Flat File Source in SSIS Package to read data from Text file or flat file How to load data into SQL Server Table by using OLE DB Destination Check out our SQL Server Integration Services ( SSIS ) Tutorial Step by Step http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 59447 TechBrothersIT
SSIS Interview Questions | What are different Methods to Filter Duplicate Records in Data Flow Task
 
10:20
SQL Server Integration Services (SSIS) Interview Question "How will you remove duplicate records in SSIS? Which transformation can help with this task?" You will learn three different ways how to remove duplicate records in Data Flow Task in SSIS. You will learn how to use Aggregate Transformation in Data Flow Task to remove duplicate records You will learn how to use Sort Transformation in Data Flow task in SSIS Package Complete List of SSIS Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS
Views: 53098 TechBrothersIT
How to Clone a Virtual Machine using HyperV
 
05:51
In this video we are going to learn how to Clone a virtual machine using HyperV. We will use Import/Export Wizard to clone virtual machine. The video shows how to step by step Export and Import Virtual Machine. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 65336 TechBrothersIT
SQL Server DBA Interview Questions and Answers | How to Shrink Database Log file in SQL Server
 
04:00
In this video you will learn how to answer this SQL Server DBA interview Question "The tran log of a database has grown huge, how would you shrink the log file". You will also learn How to shrink log file in SQL Server Step by Step how to shrink database log file in SQL Server How to find open Transactions in SQL Server Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 19488 TechBrothersIT
SQL Server DBA Tutorial 79-How to Restore a Database from Differential Backup in SQL Server
 
06:46
In this video you will learn how to restore SQL Server database using differential backup, how to add full backup and differential backup to restore, error concerning restore of differential backup with no full backup, database is not restored to correct earlier state. Tail Log backup options and best practices, restoring Differential database using T-SQL Script. Blog link for this video: http://sqlage.blogspot.com/2015/03/how-to-restore-database-from.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 20043 TechBrothersIT
SQL Server DBA Tutorial 113-How to Configure Database Log Shipping in SQL Server
 
15:17
In this video you will learn step by step process of how to configure Database Log Shipping using SQL Server Management studio as well as using T-SQL Script. It shows process of how to enable Log Shipping configuration, how to configure Backup settings on Primary, how to add Secondary Server for Log Shipping, how to configure Log Shipping Monitoring Server, what is Primary, Secondary and Monitoring servers in Log Shipping and how to configure copy/restore Operation in SQL Server Log Shipping. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-configure-database-log-shipping.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 56777 TechBrothersIT
SSRS Tutorial 35 - How to Create DrillThrough Report in SSRS
 
11:58
In this video of SSRS Tutorial, You will be learning Create Summary Report Create Detail Report by using Parameter Create Drillthrough Functionality by using Summary and Detail Report and Map Parameter Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 51334 TechBrothersIT
How to change Quorum Configuration in Windows server 2012 R2 Cluster
 
08:38
This video illustrates: What is Quorum? What is Node Majority? What is node and quorum vote priority? Quorum configuration? How to change Quorum configuration in windows server 2012 R2 Cluster? You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge The playlist contain following videos How to install .Net Framework 3.5 in windows server 2012 R2 Installing Windows 2012 R2 Clustering Part 1 Installing Windows server 2012 R2 Cluster part 2 How to Change SID of Windows Server 2012 R2 How to install Active Directory (AD) Domain Services in Windows server 2012 R2 How to change Quorum Configuration in Windows server 2012 R2 Cluster
Views: 24840 TechBrothersIT
SQL Server DBA Tutorial 34- How to Create Database Snapshot in SQL Server
 
10:24
In this video you will learn how to create sql server database snapshot using T-SQL Script, it also demonstrates how to view the snapshots using SQL Server Management Studio, how to restore the database from the snapshot, how to revert database using database snapshot. You will also learn some real time scenarios when it is best to use snapshot options. Blog post link for Script used in this video: http://sqlage.blogspot.com/2015/02/how-to-create-database-snapshot-sql.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 24294 TechBrothersIT
SSIS Tutorial Part 28-Archive Files with Datetime after Loading into SQL Server Table
 
18:32
In this video you will learn how to load multiple files to SQL Server Table and then archive them to archive folder by adding date and time to them. In this video you will learn following tasks/transformations How to create an SSIS Package How to use Foreach Loop Container to read the files from folder in SSIS Package How to load multiple text files to SQL Server Table in SSIS Package How to use Data Flow Task in SSIS Package How to Flat File Source in SSIS Package to read text file How to use OLE DB Destination to load data to SQL Server Table in SSIS Package How to write expressions in SSIS Package How to use File System Task in SSIS Package How to rename and move file in SSIS Package To Follow Step by Step this SSIS video tutorial By Tech Brothers http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 34145 TechBrothersIT
SSIS Interview Questions Answers | Why do we need to use SSIS Configuration
 
02:35
In this video you will find out the answer of question asked in real time SSIS Interview, Why do we need to use SSIS Configuration in our SSIS Packages. SSIS Configuration is the way to make your SSIS Packages dynamic so you can configure or pass the value of connection mangers, variables as per the environment in which your SSIS Package is running without hard coding the values inside the SSIS Package. XML Configuration in SSIS Package Parent Package Configuration in SSIS Package Windows Registry Configuration in SSIS Package System Variable Configuration in SSIS Package SQL Server Configuration in SSIS Package There is difference between configuration in ssis 2005,2008 to 2012 and ssis 2014. I have answered the questions in detail in other video that talks about different types of SSIS Configuration. Check out our SSIS Interview Questions and Answers http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS
Views: 20369 TechBrothersIT
SSIS Tutorial Part 141 - What are Event Handlers in SSIS Package
 
04:24
In this SQL Server Integration Services (SSIS) Interview Question video you will learn the answer of " What are Event Handlers in SSIS Package?" Complete list of SSIS Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 13510 TechBrothersIT
SQL Server DBA Tutorial 06- How to Create Integration Services Catalog in SQL Server
 
04:19
In this video we are going to learn how to create Integration Services Catalog. To deploy your SSIS Package you need this database. This video is part of SQL Server 2014 complete installation package in which you will learn how to Install Database Engine,SQL Server Integration Services ( SSIS), SQL Server Reporting Services(SSRS), SQL Server Master Data Services, SQL Server Data Quality Service. Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 27768 TechBrothersIT
TFS 2013 Tutorial : 09- How to Map a Team Project to Local Server in Team Foundation Server 2013
 
01:59
In this Team Foundation Server (TFS) 2013 tutorial video you will learn "How to map a Team Project to local server in Team Foundation Server 2013". Team Foundation Server Tutorial Step by Step List by Tech Brothers http://sqlage.blogspot.com/search/label/Team%20Foundation%20Server%202013%20Video%20Tutorial
Views: 24541 TechBrothersIT
SSRS Tutorial 32 - How to Create Cascade Parameters in SSRS Report
 
14:42
In this video of SSRS Tutorial, You will be learning How to create Tabular Report with Two Parameters How to create Main Parameter How to create Cascade Parameter by using Main parameter How to provide values to Main parameter and Sub Parameter from SQL Queries Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 26948 TechBrothersIT
SQL Server DBA Tutorial 75-How to Create Backup Maintenance Plan in SQL Server
 
09:08
In this video you will learn how to create Database Backup Maintenance Plan step by step. After watching this video, you will be able to create new maintenance plan, navigate to the Tool Box, Navigate to the database backup task, configure database Task, step by step walk through maintenance plan options and whether to select system database, user database, all database or selective databases. You will also learn how to view maintenance plan and SQL Server Agent Jobs for newly created maintenance plan. To Follow Step by Step for SQL Server DBA Video Tutorial By Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 32808 TechBrothersIT
SQL Server DBA Tutorial 77-How to Cleanup Old Backups in SQL Server
 
10:22
In this video you will learn how to schedule cleanup task to delete older backups in sql server. How to add cleanup task from the Tool box and configure to delete backup files from specific directory. It also shows various options of cleanup tasks such as retention period, deleting backup history as well as all scheduling option for backups. blog post link: http://sqlage.blogspot.com/2015/03/how-to-cleanup-old-backups-in-sql.html To Follow Step by Step for SQL Server DBA Video Tutorial By Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 26836 TechBrothersIT
SQL Server DBA Tutorial 67-What is Contained Database and how to Create Contained Database
 
12:44
In this video you will learn how to create contained database in SQL Server 2012 and SQL server 2014 using SQL Server Management studio as well as using T-SQL script. It also demonstrates what is contained databases, various option and properties of contained databases, how to configure SQL Server instance for contained databases, how to configure SQL Server database for partial contained database, what is partial contained database in SQL Server and how contained databases are isolated from normal databases in SQL server. Blog link for this video: http://sqlage.blogspot.com/2015/03/what-is-contained-database-and-how-to.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 14543 TechBrothersIT
SSIS Tutorial Part 17-Create Excel File with DateTime On Each Package Execution in SSIS Package
 
20:15
In this video you will learn how to create An Excel file with datetime on each package execution. This is important when we want to run our package multiple times in a days and don't want to append the data to already existing Excel File. The video will cover following Items How to Load Data from SQL Server Table to Excel Sheet How to use Data Conversion Transformation to Convert SQL Data To Excel Data Types How to use OLE DB Source and Excel Destination in SSIS Package How to use Variables in SSIS Package How to Write Expressions to get Datetime in SSIS Package How to use variable in Excel Connection Manager to provide File Name with Datetime How to use DelayValidation property in SSIS Package to ignore prevalidation in SSIS Package link to the post: http://sqlage.blogspot.com/2015/03/how-to-create-excel-file-with-datetime.html Expressions used in the SSIS Package to Create Excel file with Date Time: @[User::DestinationFolder]+"RegionalCustomer_"+Replace(Replace(Substring((DT_WSTR,30)GETDATE(),1,16),":","_"),"-","_")+".xlsx" To Follow Step by Step this SSIS video tutorial By Tech Brothers http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 47354 TechBrothersIT
SQL DBA Interview Questions & Answers | Migration strategy For SQL Server 2008 to SQL Server 2012
 
07:39
In this video you will learn how to answer this SQL Server Interview Question "How would you migrate a database from SQL Server Instance to Another SQL Server Instance?", The video explain different type of migration types or strategies we use to migrate SQL Server from old version to new version. The video talks about How to perform SQL server Migration by using in place migration How to perform SQL server Migration by using parallel upgrade strategy It also explain what objects do you need to script/backup for SQL Server migration. Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 44506 TechBrothersIT
SSIS Interview Questions and Answers | What is SSIS Configurations Table
 
10:12
In this video you will learn about using SQL Server Configuration Table in SSIS Configuration. When you enable SQL Server Configuration in SSIS Package, it has to create a table by using wizard with name SSISConfiguraitons. The table have 4 columns. Configuration filter and configured value are the most important columns those we use to store different configuration values for connection managers and variables etc. The video shows you how to create the SSIS Configuration Table How to insert configuration value in SSIS Configuration table by using Package configuration What are the best practices to choose properties for Connection managers, variables etc. Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 19712 TechBrothersIT
What is the difference between Drill down and Drill Through Report in SSRS   SSRS Interview Question
 
02:58
What is the difference between Drill down and Drill Through Report in SSRS- SSRS Interview Question Drill Down is the way to have summary values view and if we would like to see the detail , we can expand that part to see the details. You can use + and - signs to change to summarize view or detail view of a report. Drill through Report: Drill-through report is report that is open by the clicking a link within another another report. Let's think about a real time scenario, Where we have Region Sale Summary report. Once we click on Region value, we would like to open a detail report for sale in that region. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial http://www.techbrothersit.com/
Views: 10409 TechBrothersIT
SQL Server Interview Questions | What is the difference between log shipping and replication
 
01:25
SQL Server DBA Interview Question "What is the difference between log shipping and replication" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 9206 TechBrothersIT
SQL Server DBA Tutorial 96 Intro-What are Extended Events in SQL Server
 
12:11
In this video you will learn What are extended events in SQL Server, what are extended events components such as Package, consumers(Targets),Engine and session. How to nevigate to extended events in in SQL Server Using SQL Server Management Studio. How to get list of extended events in SQL Server. What are the main differences between Extended Events and SQL Server Profiler. Blog post link for video: http://sqlage.blogspot.com/2015/03/what-are-extended-events-in-sql-server.html Complete Step by Step List for DBA Tutorial Videos: http://sqlage.blogspot.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 10773 TechBrothersIT
SSIS Tutorial Part 05-How to Load Fixed Width Text File to SQL Server Table in SSIS Package
 
08:18
The video tutorial explains how to load fixed width text file to SQL Server table by using SQL Server Integration Services( SSIS ) Package. The video also shows how to create ssis package from start how to use data flow task in ssis package how to use flat file source to read data from fixed width text file in ssis package how to load data to sql server table by using ole db destination in ssis package how to rename an ssis package in SSIS Project Check out our SQL Server Integration Services ( SSIS ) Tutorial Step by Step http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 30081 TechBrothersIT
SQL Server DBA Tutorial 149-In Place Upgrade of SQL Server 2012 to SQL Server 2014 Part1
 
08:22
In this video you will learn In-Place upgrade of SQL Server 2012 to SQL Server 2014, you will learn following in this demo, 1- How to install SQL Server 2014 upgrade advisor 2- How to install pre-requisites of SQL Server 2014 upgrade advisor 3- How to take care of Upgrade advisor error " Upgrade advisor missing pre-requisites ....." 4- Best practices of In-place upgrade of SQL Server 2012 5- Rollback options in In-Place upgrade 6- How to run Upgrade Wizard of SQL Server 2014 7- How to view whether SQL Server 2012 is upgrade to SQL Server 2014 after Upgrade Wizard completes 8 - How to upgrade all management components from SQL Server 2012 to SQL Server 2014 Blog post link for this video http://sqlage.blogspot.com/2015/04/in-place-upgrade-of-sql-server-2012-to.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 18011 TechBrothersIT
SQL Server Interview | What is the difference between Physical and Logical Reads in SQL Server
 
01:32
In this video you will learn the answer of SQL Server Interview Question " What is the difference between Physical and Logical Reads in SQL Server" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 8109 TechBrothersIT
SSRS Tutorial 19- Create Multi Group Drilldown report with Group Totals and Grand Total
 
13:10
In this video of SSRS Tutorial, you will learn below items How to create empty report How to use Shared Data Source in Report How to Add DataSet to SSRS Report How to Add Parent Group and Child Group How to use Visibility Property to create Drilldown Report How to Add Total by Child Group, Parent Group and Grand Total Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 47736 TechBrothersIT
SQL Server DBA Tutorial 158-How to Migrate SQL Server Agent Jobs in SQL Server
 
07:26
This video explains following: 1- How to script out all the SQL Server Agent Jobs in SQL Server 2008 R2 2- How to view all SQL Server Agent Jobs in Object Explorer Detail 3- How to select multiple SQL Server Agent jobs in SQL Server management studio (SSMS) 4- What are the limitations of Scripted SQL Server Agent Jobs 5- How to run the script on Target server to transfer jobs from SQL Server 2008 to SQL Server 2014 Blog post link for the video with script http://sqlage.blogspot.com/2015/05/how-to-migrate-sql-server-agent-jobs.html Complete Step by Step List for DBA Tutorial Videos: http://sqlage.blogspot.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 9623 TechBrothersIT
SSRS Tutorial 29 - Create Multi Value Parameter in SSRS Report
 
12:55
In this video of SSRS Tutorial, you will be learning How to create tabular Report with Multi value parameter How to provide values to Parameter from Query How to provide Default Values to Parameter Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 20102 TechBrothersIT
SQL Server DBA Interview Questions & Answers | Why do we use Replication, Provide couple scenarios
 
03:03
SQL Server DBA Interview Question "Why do we use Replication, Provide couple scenarios" Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 12283 TechBrothersIT
SQL Server DBA Tutorial 07- How to install and configure Reporting services in SQL Server 2014
 
13:40
This video illustrates step by step process of SQL Server Reporting Services 2014 installation and Configuration in native mode. This video is part of SQL Server 2014 complete installation package in which you will learn how to Install Database Engine,SQL Server Integration Services ( SSIS), SQL Server Reporting Services(SSRS), SQL Server Master Data Services, SQL Server Data Quality Service. Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/TechBrothersIT
Views: 65908 TechBrothersIT
SSIS Tutorial 27-Extract file Names from Folders and save in SQL Server Table by using SSIS Package
 
09:04
In this video you will learn how to extract the file name from folder and sub folders and insert that into a SQL Server Table by using SSIS Package. In this video we will also learn How to create an SSIS Package How to use Foreach Loop Containers to read the files from folders in SSIS Package How to use Execute SQL Task in SSIS Package How to pass parameter to Execute SQL Task in SSIS Package To Follow Step by Step this SSIS video tutorial By Tech Brothers http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 26072 TechBrothersIT
How to display data on single tablix from two datasets in ssrs report by joining on single column
 
04:24
SSRS Interview Questions and Answers: How to display data on single tablix from two datasets in ssrs report by joining on single column We can use the Lookup Function in SSRS Report to join the data from two datasets. There should be at-least one matching column on which we will join the datasets. Let's say we have DataSet1 with column FName,LName and DataSet2 with columns FirstName and Region. If we would like to display FName,LName (from DataSet1) along with Region Column from DataSet2. We can use Lookup Function and write our expressions as shown below. Lookup Function with Parameters LookupSet(source_expression, destination_expression, result_expression, dataset) Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial http://www.techbrothersit.com/
Views: 14378 TechBrothersIT
Installing Windows 2012 R2 Clustering Part 1
 
12:06
This video illustrate: How to configure static IP, enable/install failover cluster services, enable/install Distribution services (DTC), Add Network adopter in HyperV VM machine, Create and configure Shared disks using ISCSI initiator,validate windows server 2012 R2 cluster, Create cluster in windows server 2012 R2. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 73867 TechBrothersIT
01-How to install windows components as prerequisites of installing Microsoft Dynamics AX 2012 R2
 
06:41
This video shows how to install prerequisites of installation of Microsoft Dynamics AX (Windows components). It also shows how to install windows components such as Windows IIS services, Windows Identity foundation services, Windows communication services and World Wide Web Services. To Follow Step by Step MS Dynamics AX 2012 R2 Video Tutorial by Tech Brothers http://sqlage.blogspot.com/search/label/MS%20Dynamics%20AX%202012%20R2%20Video%20Tutorial
Views: 32831 TechBrothersIT
SQL Server DBA Interview Questions and Answers | What is IO Affinity
 
05:29
In this video you will be able to learn how to answer interview question related to "What is IO Affinity in SQL server". The video also explain what is CPU Affinity in SQL Server. SQL Server CPU affinity is important concept to understand for DBA to share the resource of Servers according to the load of SQL Server Instances. The video will walk you through how to enable CPU Affinity and IO Affinity in SQL server Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 97154 TechBrothersIT
SQL Server DBA Tutorial 117-How to Create Job using SQL Server Agent
 
16:14
In this video you will learn how to create a job using SQL Server Agent in SQL Server. It shows step by step process of creating the job using SQL Server Management Studio as well as T-SQL Script in SQL Server. It teaches you how to configure Job parameters such as names, job owner, categories and best practices of choosing Job owner while creating SQL Server Agent Jobs. It helps you to configure Job step parameters and will walk through different step options and how to use them under what circumstances. Also you will learn how to configure Job history options such as storing Job output to a file, loading into a table and including job execution history in Windows Application Log. It talks about best practices of storing Job history as well as Job retentions in SQL Server Agent. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-create-job-using-sql-server.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 69469 TechBrothersIT
SQL Server DBA Tutorial 60- How to Provide Explicit Permission to Specific Tables to a User
 
06:15
In this video you will learn step by step process of providing explicit Table permissions to a User in SQL Server using SQL Server Management studio as well as using T-SQL script. It also walks you though best practices of adding tables and other objects to user's permissions, how to give select permission on a specific table, how to give update permissions on a specific table in SQL Server database. Blog link for this video: http://sqlage.blogspot.com/2015/03/how-to-provide-explicit-permission-to.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 11642 TechBrothersIT
SSIS Tutorial Part 18-How to Load Multiple Excel Sheets to a SQL Server Table in SSIS Package
 
14:58
In this video post you will learn How to Load Multiple Excel Sheets from a single Excel file to a SQL Server Table. This scenario can be used when you often get data on multiple sheets. The structure of columns is same on each sheet but data can be different. The number of sheets can be deleted or added to the file as long as the new sheet follow the same column structure. In this video you will learn following Items How to use Foreach Loop Container with "Foreach ADO.NET Schema Rowset" How to load Data from Excel Sheet to SQL Server Table How to use Data Conversion Transformation in ssis Package to Convert Excel Data to Destination Table data Type How to use Variables in SSIS Package to generate Dynamic Connection Manager How to use Data Flow Task in SSIS Package To Follow Step by Step this SSIS video tutorial By Tech Brothers http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 57177 TechBrothersIT
SQL Server DBA Tutorial 52- How to create Windows Group Authentication Login in SQL Server
 
08:56
In this video you will learn how to add Active directory group to SQL Server, how to create login using Windows Authentication while selecting the active directory group. How SQL Server communicates with Active directory for Authentication and Authorization. What option to select when adding Active directory (AD) group to SQL Server Login. Video shows both ways of creating Group login, using SQL Server Management studio as well as T-SQL script. Blog post link for the video for scripts used in the video http://sqlage.blogspot.com/2015/03/how-to-create-windows-group.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 18152 TechBrothersIT
SQL Server DBA Tutorial 31- How to Attach and Detach Databases
 
12:32
In this video you will learn how to attach and detach databases using SQL Server Management Studio as well as using T-SQL script. After watching this video, you will also learn real time scenarios where it would be a good practice to attach and detach databases. Blog link for script http://sqlage.blogspot.com/2015/02/how-to-attach-and-detach-databases-sql.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 34872 TechBrothersIT
SQL Server DBA Tutorial 143-How to Find out How Much Memory is Allocated to SQL Server Instance
 
06:51
In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-find-out-how-much-memory-is.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 8993 TechBrothersIT
SQL Server Integration Services Tutorial -Check If File Exists in a Folder in SSIS Package
 
10:25
SQL Server Integration Services (SSIS ) Interview Question " If you need to check that a file exists in a folder, which task(s) will you use? " To Follow Step by Step SSIS Video Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 15928 TechBrothersIT
How to Install MariaDB on Windows 10 - MariaDB Admin Tutorial
 
09:28
How to Install MariaDB on Windows 10How to Install MariaDB 10.2 on Windows 10below topics How to download MariaDB for Windows Installation How to Run Installation Process for MariaDB on Windows 10. How to provide location for MariaDB installation directory Provide the Root Password during MariaDB installation on Windows 10 Choose the features while installing MariaDB on Windows 10 MySQL Client MySQL Database service HeidiSQL Third Party interface to connect to MariaDB At the end of the video, I showed How to create the database by using MySQL Client interace How to connect to HeidiSQL and connect to MariaDB How to use mysql -uroot -p to connect to MariaDB The same procedure can be used to connect to mysql DB. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) MariaDB Administration Tutorial http://www.techbrothersit.com/ http://www.techbrothersTutorials.com
Views: 14463 TechBrothersIT
SQL Server DBA Tutorial 70-What is Database Backup & How Many Types of Backups available
 
09:02
In this video you will learn what is database backup, why we need database backups, what are the best practices of backing up SQL Server databases. It also illustrates how many types of backups available in SQL Server, what is Full backup? What is Differential Backup and what is Transaction Log backup. It also shows different scenarios of backup strategy in real time production environment. it is part of complete SQL Server DBA Tutorial. Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 38187 TechBrothersIT

San diego court records
River city chicago
Baby shower venues charlotte nc
Jewish deli miami
Amnesia visual novel free download