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: 18489 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: 66177 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: 51990 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: 17772 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: 54299 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: 46592 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: 60136 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: 11584 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: 22379 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: 29262 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: 18766 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: 17769 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: 18457 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: 50723 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: 22302 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: 41200 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: 23371 TechBrothersIT
How to use Excel as Data Source in SSRS Report - SSRS Interview Questions and Answers
 
04:19
How to use Excel as Data Source in SSRS Report - SSRS Interview Questions and Answers If we would like to use Excel as data source in SSRS Report, we can create DSN entery by using ODBC. Once DSN is created, we can use that in Data Source in SSRS Report. We will be using Select * From [SheetName$] in dataset. How to use Excel as Data Source in SSRS Report How to read data from Excel in SSRS Report How to read data from Excel Sheet in SSRS report How to create SSRS Report from Excel File 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: 11893 TechBrothersIT
TFS 2013 Tutorial : 07- How to connect to Team Foundation Server using Visual Studio
 
03:41
DescriptionIn this Team Foundation Server (TFS) 2013 tutorial video you will learn "How to connect to Team Foundation Server using Visual Studio". Team Foundation Server Tutorial Step by Step List by Tech Brothers http://sqlage.blogspot.com/search/label/Team%20Foundation%20Server%202013%20Video%20Tutorial
Views: 34212 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: 63931 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: 23936 TechBrothersIT
TFS 2013 Tutorial : 16- How to Merge code between branches in Team Foundation server 2013
 
03:43
In this Team Foundation Server (TFS) 2013 tutorial video you will learn "How to Merge code between branches 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: 27225 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: 26921 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: 42292 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: 25865 TechBrothersIT
SQL Server DBA Tutorial 46-How to Reduce TempDB Size without Restarting SQL Server Services
 
05:35
In this video you will learn how to reduce TempDB size without restarting SQL Server Services? Video explains couple ways to do it, 1- Using SQL Server Management Studio 2- Using T-Script It also walks you through where these methods of reducing TempDB size might not work and best practices of shrinking TempDB Files. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-reduce-tempdb-size-without.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: 23631 TechBrothersIT
SSIS Tutorial Part 141 - What are Event Handlers in SSIS Package
 
04:25
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: 12052 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: 14390 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: 32211 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: 30388 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: 70886 TechBrothersIT
What is the difference between Restore With NoRecovery option and Restore With StandBy option
 
02:04
In this video you will learn the answer of SQL Server DBA Interview Question " What is the difference to Restore database "Restore With NoRecovery" and "Restore With StandBy"?" You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge SQL Server DBA Interview Questions Real time SQL Server Interview Questions with Answers Experienced SQL Server Interview Questions Top 100 SQL Server DBA Interview Questions and Answers Microsoft SQL SErver DBA Interview Questions for Fresher SQL Server DBA Advanced Interview Questions and Answers
Views: 13121 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: 42652 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: 51957 TechBrothersIT
SQL Server DBA Tutorial 139-What is DAC in SQL Server and how to use DAC
 
09:46
In this video you will learn: What is DAC in SQL Server? How to connect to SQL Server using DAC via SQL Server Management Studio and how to connect to SQL Server using DAC via SQLCMD. It also provides the resolution to the errors below: 1- Dedicated Administrator connection are NOT supported visa SSMS as it establishes multiple connection by design 2- Connection was established successfully and then failed during handshake. It also demonstorates how to force connection to use TCP/IP protocol as well as how to enable and disable Named Pipe protocol in SQL Server. Below are the DAC commands used in this video: admin:DynamicsAXDev\SQLTEST --SSMS connection sqlcmd -Sadmin:DynamicsAXDev\SQLTEST sqlcmd -S admin:DynamicsAXDev\SQLTEST Blog post link for the video: http://sqlage.blogspot.com/2015/03/what-is-dac-in-sql-server-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: 8038 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: 26622 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: 89619 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: 7410 TechBrothersIT
SQL Server DBA Tutorial 86-How to Rebuild Master and other System Databases in SQL Server
 
15:50
In this video you will learn How to rebuild Master database in SQL Server by rebuilding all system databases and then restoring master database backup as well as all other system database backups. It takes the scenario of rebuilding master database with no backup and SQL Server services are not starting due to master database corruption. It also demonstrates the process of rebuilding master database using couple of ways and explain method 2 to rebuild entire system databases. You will also learn how to recreate all lost changes after rebuilding master database. blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-rebuild-master-and-other-system.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: 15172 TechBrothersIT
SSIS Tutorial Part 29-How to Create Multiple Files from a SQL Server Table in SSIS Package
 
14:09
In this video you will learn how to create multiple files from a sql server table in SSIS Package. Let's say you have a table with some region code information and you want to create files for each of the region with region code name , this example can be use to do that. In this video you will also learn How to create an SSIS Package How to use OLE DB Source with parameters in ssis package how to use Execute SQL Task to populate object type variable in ssis package how to save data to object type variable in ssis package how to read rows one by one from object type variable by using foreach loop container how to create text files dynamically in ssis package how to write expression on connection manager in ssis package how to use data flow task in ssis package how to use Foreach loop container 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: 17063 TechBrothersIT
SQL Server Integration Services - How to use Stored Procedure in OLE DB Source in SSIS Package
 
06:19
In this video we will learn the answer of SQL Server Integration Services(SSIS) Interview Question " Can we use Stored Procedure in OLE DB Source? If yes, how do you map the parameters?" How to use Stored Procedure in OLE DB Source in SSIS Package How to map parameters in OLE DB Source in SSIS Package How to pass value of variable to Stored Procedure parameter in OLE DB Source in Data Flow in SSIS Package To Follow Step by Step this SSIS video tutorial By Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20Video%20Tutorial
Views: 26347 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: 33469 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: 10915 TechBrothersIT
How to Change SID of Windows Server 2012 R2
 
06:51
This video explains how to change SID of a Cloned Windows Server 2012 R2 Virtual Machine in Hyper-V environment. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 40594 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: 9599 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: 8502 TechBrothersIT
SQL Server DBA Interview Questions| How many SQL Server Instances can be installed on one machine
 
02:14
In this video you will learn what is default sql server instance and what is named sql server instance. You will also learn how many named SQL server instances can be installed on one machine. Complete list of SQL Server DBA Interview Questions by Tech Brothers http://sqlage.blogspot.com/search/label/SQL%20SERVER%20DBA%20INTERVIEW%20QUESTIONS
Views: 22642 TechBrothersIT
SSIS Interview Question - What is the difference between Project Deployment and Package Deployment
 
05:08
In this video you will learn the answer of SQL Server Integration Services (SSIS ) interview question " What is the difference between Package Deployment and Project Deployment?" What is the difference between Project Deployment and Package Deployment in SSIS You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge SQL Server Integration Services Google plus Community https://plus.google.com/u/0/communities/114040360074888459329 SSIS Interview Questions for Real time Interview SQL Server Integration Services Interview questions and Answer SSIS Experienced interview questions and answers Fresher interview Questions and Answers for SSIS SQL Server Interview Questions and Answers Top 100 Interview Questions for SSIS with Answers SSIS 2014 Interview Questions SSIS 2012 Interview Questions and Answers SQL Server Integration Services (SSIS) Tutorial Tech Brothers Free technology Video Tutorials SQL Server Integration Services(SSIS) Developer Interview Questions SSIS Developer Interview Questions SSIS (SQL Server Intergration Services) Tutorial SSIS Demo with real time examples
Views: 27064 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: 10558 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: 17250 TechBrothersIT

Cover letter for junior it technician
Resume format for hotel and restaurant management
Consumer s report magazine
Gentrification case study manchester
Office clerk cover letter for resume