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: 21384 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: 61884 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: 54287 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: 74239 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: 66346 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: 13011 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: 61045 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: 19810 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: 20358 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: 57972 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: 25275 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: 24690 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: 13835 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: 27574 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: 20707 TechBrothersIT
SQL Server DBA Tutorial 02- How to Install Data Quality Services (DQS) in SQL Server 2014
 
05:12
In this video you will learn how to install and configure Data Quality Services. There are two components DQS server and Client. DQS is feature of SQL Server, so we use the same media to install DQS. In this video we only install DQA Server. I have another video that show how to install Data Quality Services Client and how to connect to DQS server. 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: 44285 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: 27369 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: 34875 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: 48389 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: 11006 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: 48760 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: 18477 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: 45522 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: 8250 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: 20108 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: 33538 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: 10626 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: 9829 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: 39184 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: 14729 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: 11828 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: 20659 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: 74228 TechBrothersIT
SQL Server DBA Interview | Is it best practice to have Auto Shrink enable on Database
 
03:04
In this short interview question video you will learn the answer of "Is it best practice to enable auto shrink on Database". you will also learn in which cases it is Ok to shrink the data files or log files 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: 29321 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: 66228 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: 70380 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: 26730 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: 98487 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: 9188 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: 15658 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: 35364 TechBrothersIT
SQL Server DBA Tutorial 132-How to configure DBMail in SQL Server
 
14:59
In this video you will learn how to configure DBMail in SQL Server using SQL Server Management studio as well as using T-SQL. It also explains how to configure Google smtp server as dbmail account in SQL Server using SQL Server management studio as well as T-SQL Script. It illustrates the smtp server configuration both for Exchange as well as google, what is the port google smtp server uses as well as port number of Microsoft Exchange Server. Step by step dbmail profile configuration as well as account stepup. It also shows how to delete dbmail profile and account in sql server. blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-configure-dbmail-in-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: 27892 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: 16365 TechBrothersIT
SSIS Interview Questions | What is the difference between Script Task and Script Component in SSIS
 
05:06
In this video we will learn the answer of this SSIS Interview Questions " What is the difference between Script task and Script component in SSIS Package" The video explains how script task is different from Script Component in SSIS Package Complete List of SSIS Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS
Views: 15980 TechBrothersIT
SQL Server DBA Tutorial 87-How to Move Tempdb data and Log Files in SQL Server
 
02:40
In this video you will learn how to move Tempdb data and log files from current location to new location. It also demonstrates step by step process of how to find current location of Tempdb Files, How to move Tempdb Files to new location using T-SQL Script and what is required for sql server to use new tempdb file location. How to restart SQL Server Services. Blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-move-tempdb-data-and-log-files.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: 7953 TechBrothersIT
SQL Server DBA Tutorial 120-How to Create an Operator in SQL Server
 
07:29
In this video you will learn how to create an operator in SQL Server using SQL Server Management Studio as well as using T-SQL Script. It also teaches you how to configure General settings of SQL Server Operator such as workstart, workend and configuration of weekend operation. It also help you to configure Notification settings of an Operator such as assigning alerts to an operator. It shows step by step process of creating Operator in SQL Server. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-create-operator-in-sql-server-ms.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: 8311 TechBrothersIT
SQL Server 2016 - How to use Query Store Feature in SQL Server 2016
 
07:52
In this video you will learn How to use Query Store database feature of SQL Server 2016, this video illustrates following reports and options of Query Store database features - Regressed Queries - Overall Resources Consumption - Top Resources Consumption Queries - Tracked Queries Step by Step DBA Tutorial by TechBrothersIT http://www.techbrothersit.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 9064 TechBrothersIT
Difference b/w Full Load and Incremental Load - SSIS Interview Questions & Answers
 
05:05
SQL Server Integration Services Interview Question "What is the difference between Full Load and Incremental Load? What is your approach to load data into Staging Database?" Complete list of SSIS Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS
Views: 17274 TechBrothersIT
SQL Server DBA Tutorial 04- How to Install Data Quality Services Client in SQL Server
 
04:19
In this video we will learn how to install and configure Data Quality Services Client. The Data Quality Services Server and Client can be installed separately. You can install Data Quality Services Client on the same machine where you have installed Data Quality Services Server or on different machine. 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: 21656 TechBrothersIT
SSIS Interview Questions Answers | How would you load data into Object Type variable in SSIS Package
 
04:26
In this video you will learn the answer of SSIS Interview questions "If you have created object type variable that you want to use in script task later, how will you load data into Object Type variable in Control flow? Which task will help? " In this video you will learn How to create Object type variable in SSIS Package How to use Execute SQL Task to load data into Object Type variable in SSIS Package How to configure Execute SQL Task with Full Result Set to save recordset into object type variable. How to use RecordSet Destination in SSIS Package to save data into object type variable How to save data in Object Type variable 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: 11576 TechBrothersIT