Contact Support for Windows 10 | Windows 10 Features

Contact Support for Windows 10 - Call MS for free for 15 minutes
In this video you will learn following:
                - How to Open Contact Support Option in Windows 10?
  - How to look at various support option in Windows 10?
  - Free 15 minutes Support call with MS if you upgraded to
                  Windows 10

Contact Support for Windows 10 | Windows 10 Features

Phone Companion New Application in Windows 10 | Window 10 Features

Setup Phone Companion application in Windows 10 for your Phones
In this video you will learn following:
                - Download Phone companion App from Store using
                  Windows 10
  - Get what you Love from your PC to your Phone
  - Helps you to setup your phone to backup your Photos
                  on One Drive
     - Get Xbox music Tracks onto your Andriod Phone

Phone Companion New Application in Windows 10 | Windows 10 Tutorial

DirectX 12 for Windows 10 | Windows 10 Features

Microsoft Graphics API includes DirectX 12 in Windows 10
In this short video you will learn brief introduction to this feature as below:
                - Latest Microsoft Graphics API
  - Major Performance Improvements
  - Will also work with lots of existing Graphics Cards
  - Great news if you like Games
  - Make Direct3D Apps which uses DirectX 12 faster
  - DirectX 12 include CAD software and other Graphics
                  Tools

DirectX 12 for Windows 10 | Windows 10 Tutorial

Face Scanning or Fingerprints Login to Your Computer with Windows 10 | Windows 10 Features

Face scanning to login to your Windows 10
In this video you will learn following:

 Windows 10 Scanning Support
   a) Fingerprints
  b) Face Recognition
  c) OR IRIS
  d) Once you logged in your computer, It will establish
                    connection without putting your password i.e. MS Azure
                    Active Directory

 Requirements:
  a) New 3D Infrared Camera in your PC
  b) Infrared checks if you are alive, takes contours of your
                    face
    c) Doesn't work if you hold photo or wears a Mask

Face Scanning or Fingerprints Login to Your Computer with Windows 10 | Windows 10 Tutorial

How to Find Control Panel in Windows 10 | Windows 10 Features

Settings And/OR Control Panel in Windows 10

In this video you will learn following:
        1- Settings App VS Control Panel
 2- How to find Control Panel?
 3- How to use Settings App?

How to find Control Panel in windows 10 | Windows 10 Tutorial

How Continuum works in windows 10 | Windows 10 Features

Continuum in Windows 10
In this video you will learn following
       1- Switching to Tablet Mode?
  a) From Taskbar
  b) From Settings
  c) Folding Away the Keyboard on Touch Screen
 2- How to get back PC mode?
   3- How to look at all application column using Tablet mode?

How Continuum works in windows 10 | Windows 10 Tutorial

How to download and install Universal Apps in windows 10 | Windows 10 Features

How to download and install Universal Apps in windows 10?
In this video you will learn following:

 1- What are Universal Apps (PC, Windows Phones, XBox One
              etc.)?
 2- How to Quickly lauch Windows Store?
 3- How to Search for a specific App?
    4- How to download Office components and install

How to download and install Universal Apps in windows 10 | Windows 10 Features

How to Schedule restarts in Windows 10 | Windows 10 Features

How to schedule restarts in Windows 10?
In this video you will learn following:
        1- How to open Schedule restarts option in Windows 10?
 2- Schedule Restart Options
  a) Skip specific time Range and dates
               b) More Control when Your PC can restart instead of
                    short notice
 3- Limitations of Scheduling Restarts in Windows 10
 4- Different settings of Windows Updates and Security

How to Schedule Restarts in Windows 10 - Windows 10 Tutorial

How to add multiple Virtual Desktops in Windows 10 | Windows 10 Features

How to add multiple Virtual Desktops in Windows 10?

In this video you will learn following:
        1- How to add Virtual Desktops using Task View?
 2- How to switch between apps on multiple desktops
 3- How to switch between multiple Virtual desktops
 4- Advantages of Multiple Desktops

How to add multiple Virtual Desktops in Windows 10 | Windows 10 Features

How to Open IE in Windows 10 | Windows 10 Tutorial

How to open or find Internet Explorer in windows 10?
In this video you will learn following:
        1- Microsoft Edge VS IE 11?
 2- Limitation of MS Edge browser?
   3- How to open IE in Windows 10?

How to use IE in Windows 10 - Windows 10 Tutorial

How to use New Microsoft Edge Browser in Windows 10 | Windows 10 Features

The New Microsoft Edge Browser in Windows 10
In this video you will learn following about Edge Browser:
        1- Much Faster than IE
 2- Build-in Cortana for Web assistance
 3- Scribbling capability to make it more interactive
 4- Site Support Improvements

How to use New Microsoft Edge Browser in Windows 10  | Windows 10 Tutorial

What are Windows Explorer Improvements in Windows 10 | Windows 10 Features

What are Windows Explorer Improvements in Windows 10?
In this video you will learn following:
1- Quick Access to the useful links and Files that you recently visited?
2- Share Tab on the Ribbon?

What are Windows Explorer Improvements in Windows 10 | Windows 10 Features

What are Command Prompt Improvements in Windows 10 | Windows 10 Features

What are command prompt improvements in Windows 10?
In this video you will learn following:
 1- Resizing command prompt window in windows 10?
 2- Copy Paste options in windows 10?
 3- How to switch to Legacy Command Prompt in windows 10?
 4- overview of other settings in windows 10

What are Command Prompt Improvements in Windows 10 | Windows 10 Tutorial

How to use Action Center in Windows 10 | Windows 10 Features

How to use Action Center in Windows 10?
In this video you will learn following:
 1- What is Action Center in windows 10?
 2- How to find Action Center windows 10?
 3- How to Turn off Notification of various apps windows 10?
 4- How to Change Notification settings windows 10?
  5- How to turn on or off Action Center windows 10?

How to use Action Center in Windows 10 | Windows 10 Tutorial

How to use Snap Assist in Windows 10 | Windows 10 Features

How to use Snap Assist in Windows 10?
In this video you will learn following:
1- What is Snap Assist in Windows 10?
2- How to use Snap Assist in windows 10?
3- How does Snap Assist work with Task view?
4- How to add multiple Virtual Desktops in Task view and use Snap Assist?
5- How to change Setting of Snap Assist?

Use Snap Assist in Windows 10 - Windows 10 Tutorial

What's New in Taskbar in Windows 10 | Windows 10 Features

What's New in Taskbar in windows 10?
In this video you will learn following:
1- How to pin or unpin items from Taskbar in windows 10?
2- How to hide Cortana from Taskbar in windows 10?
3- How to show search bar (Cortana) from hidden in windows 10?
4- How to show Cortana Icon?
5- How to access Action Center from Taskbar?

How to use Taskbar in Windows 10 - Windows 10 Tutorial

How to use Task Switcher or Task View in windows 10 | Windows 10 Features

How to use Task View (Task Switcher) feature in Windows 10

In this video you will learn following:
1- What is Task switcher?
2- How to use Task Switcher using Task view in windows 10?
3- Where to find Task view in Windows 10?
4- How to add multiple desktops in Windows 10?
5- How many ways Task switcher can be used?

How to use Task Switcher or Task View in windows 10 | Windows 10 Features

What is Cortana Feature in Windows 10 and how to use her? | Windows 10 Features

How to use Cortana Feature in Windows 10

In this video you will learn following:
1- What is Cortana in windows 10?
2- Where to find Cortana in windows 10?
3- How to use Cortana (Typing or using Microphone)?
4- How to enable or disable Cortana from Microsoft Edge?
5- How to enable or disable Cortana from the system?

How to Enable/Disable Cortana Feature in Windows 10 - Windows 10 Features

Execute .SQL Files from Main Folder and Sub Folders by using PowerShell

The below script can be used to run multiple .sql files which resides in sub folders or in your main folder. It is very common to manager .sql files in sub folders for projects and as DBA we often have to deploy all the sql scripts from Main folder and Sub Folder. It is really pain if we have to open each of the folder and deploy the scripts. This is short script that can help to deploy all the .SQL Files to your Server.

In the Script you have to change the ServerName, Database Name and Location of your SQL Files.

#Provide SQLServerName
$SQLServer ="ComputerName\InstanceName"
#Provide Database Name 
$DatabaseName ="Test"
#Scripts Folder Path
$FolderPath ="C:\PowerShell\SQLScripts\"

#Loop through the .sql files and run them
foreach ($filename in get-childitem -path $FolderPath -recurse -file -filter "*.sql" | 

sort-object)
{
invoke-sqlcmd –ServerInstance $SQLServer -Database $DatabaseName -InputFile 

$filename.fullname
#Print file name which is executed
$filename
}

How to use Start Menu in Windows 10 - Windows 10 Features

How to use Start Menu in Windows 10

In this video you will learn following:
1- How to use Start Menu in Windows 10?
2- Where to find Start Menu in Windows 10?
3- How to access all apps using Start Menu in Windows 10?
4- How to Pin Items to Start Menu and Task Bar in Windows 10?
5- Where to find Mostly used Items using Start Menu in Windows 10?

How to use Start Menu in Windows 10 - Windows 10 Features

How to Upgrade Windows 8.1 to Windows 10 Step by Step

How to upgrade windows 8 or 8.1 to Windows 10

In this video you will learn following:
1. How to download Windows 10 media creation Tool?
2. Limitation of Using Windows 10 media creation Tool
3. How to select Media (USB/DVD or ISO) while creating media for the upgrade?
4. System requirement to upgrade windows 8.1 to Windows 10
5- Step by Step upgrade windows 8.1 to Windows 10

How to Upgrade Windows 8.1 to Windows 10 Step by Step

How to Execute .SQL Files from Directory by using PowerShell

Powershell scripts can be used to execute SQL Scripts. The below scripts can be used to run all the .sql scripts from a directory. I did not use sort-object , that means the files will run in ascending order.

#Provide SQLServerName
$SQLServer ="MySQLSErver\InstanceName"
#Provide Database Name 
$DatabaseName ="Test"
#Scripts Folder Path
$FolderPath ="C:\MyScripts\Test\"

#Loop through the .sql files and run them
foreach ($filename in get-childitem -path $FolderPath -filter "*.sql")
{
invoke-sqlcmd –ServerInstance $SQLServer -Database $DatabaseName -InputFile $filename.fullname
#Print file name which is executed
$filename 

} 

If you would like to run the script in descending order you can use below script

#Provide SQLServerName
$SQLServer ="MySQLSErver\InstanceName"
#Provide Database Name 
$DatabaseName ="Test"
#Scripts Folder Path
$FolderPath ="C:\MyScripts\Test\"

#Loop through the .sql files and run them
foreach ($filename in get-childitem -path $FolderPath -filter "*.sql" |sort-object 

-descending)
{
invoke-sqlcmd –ServerInstance $SQLServer -Database $DatabaseName -InputFile $filename.fullname
#Print file name which is executed
$filename 

} 

How to Install Windows 10 from Scratch Step by Step

How to install windows 10 from basics step by step

In this video you will learn following:
1- How to download windows 10 media creation Tool?
2- What does windows 10 media creation tool do for you?
3- How to select media such as USB, DVD or ISO file to install windows 10?
4- How to setup Boot Option from USB or DVD in your PC Bios Setup?
5- System requirements for installing windows 10 from scratch?
6- How to identify which Operating system Type are you currently running?
7- Step by step demo of windows 10 installation from scratch.

How to Install Windows 10 from Scratch Step by Step

How to Upgrade Windows 7 to Windows 10 Step by Step

How to upgrade windows 7 to Windows 10 step by step tutorial

In this video you will learn following:
1- How to download windows 10 media creation Tool?
2- How to identify which Operating system type you are currently running?
3- How to select windows 10 Media (USB, DVD and ISO)?
4- What are the system requirements to install windows 10 or upgrade windows 7 and 8 to windows 10?
5- Troubleshooting different errors and their explanation
6- Limitations of Windows Enterprise version when it comes to upgrading Windows 7 and Windows 8 to Windows 10

How to Upgrade Windows 7 to Windows 10 Step by Step

Windows 10

Installation

How to Install Windows 10 from Scratch
How to Upgrade your Win 7 to Windows 10
How to Upgrade your wind 8.1 to Windows 10

Features

Windows 10 Features - How to use Start Menu in Windows 10
Windows 10 Features - How to use Cortana for Search and Control
Windows 10 Features - How to use Task switcher or Task View
Windows 10 Features - What's New in TaskBar
Windows 10 Features - How to use Snap Assist
Windows 10 Features - Action Center
Windows 10 Features - Command Prompt Improvements
Windows 10 Features - Improvements to Windows Explorer
Windows 10 Features - How to use Edge Browser
Windows 10 Features - How to Open IE in Windows 10
Windows 10 Features - How to Setup Multiple desktops in Windows 10
Windows 10 Features - How to Schedule restarts in Windows 10
Windows 10 Features - Universal Apps
Windows 10 Features - Continuum
Windows 10 Features - Settings and Control Panel
Windows 10 Features - Face Scanning  Or Fingerprints to login to Computer
Windows 10 Features - DirectX 12
Windows 10 Features - Phone Companion App
Windows 10 Features - Contact Support app

Windows 10 Tips and Tricks 

Snapping current Window using Mouse and Keyboard Shortcuts - Windows 10 Tips & Tricks

Switching Between Virtual Desktops using mouse and keyboard shortcuts - Windows 10 Tips & Tricks 

Command Line Controls using Mouse and keyboard in Win 10 - Windows 10 Tips & Tricks

Command Line Text Editing Tips for Win 10 - Windows 10 Tips and Tricks

How to Switch Running Applications in Windows 10 - Windows 10 Tips & Tricks

Keyboard Shortcut for Switching between Virtual Desktops in Win 10 - Windows 10 Tips & Tricks

How to Enabling Cortana in MS Edge Browser - Windows 10 Tips and Tricks

How to use Cortana in MS Edge Browser - Windows 10 Tips and Tricks

How to Find Address Bar in MS Edge in Win 10 - Windows 10 Tips and Tricks

Open Find Dialog for Searching in Command Prompt in Win 10 - Windows 10 Tips and Tricks

SSRS Tutorial 58 - Creating Tabs in SSRS Report

In this video of SSRS Tutorial, we will learn
How to create a SSRS Report with Tabs. There is no straight forward way to include tabs in SSRS report. We have to achieve this by using different tricks. Here is what we will learn while creating this report

1. Create Empty report in SSRS in SSRS Project
2. Add Report Header so can display the Report Title on each of the Page
3. Add Rectangle and then place Text Boxes to use them as Tabs, use the Border to show kinda Tab is pressed or released. You can use image for this purpose as well.
4. Add the Page Break on Rectangle, Provide Bookmark value to each Rectangle
5. Set TextBox property to go to Bookmark value 



How to create SSRS Report with Tabs - SSRS Tutorial

  Check out related Posts / Videos 

• Create Tabular/Detail Report from Basics in SSRS
• Create Stepped Grouped Report with Subtotal and Grand Total from Basics
• Create Block Group Report with Sub Totals and Grand Total from Basics
• Create Drill-down Group Report with Group Total and Grand Total from Basics
• Create Multi Group Drill-down report with Group Totals and Grand Total
• Create Report with Group on Page without Wizard in SSRS
• Create List Reports in SQL Server Reporting Services
• Display Report Name and Header Row on Each Page in SSRS Report
• How to Display all the rows on Single Page in SSRS Report
• How to Add Running Total To Tabular Report in SSRS
• Add Running Total by Group and DataSet Level in SSRS Report
• Add Row Number to rows in SSRS Report ( DataSet Scope and Group Scope)
• Create Drill through Report
• Create Sub Reports and Call them in Master( Main) Report
• How to create report that get Image from Database Table in SSRS

SSRS Tutorial 57 - Hide/UnHide Columns and Shrink the Remaining Columns By Using Parameter Value in SSRS Report

In this video of SSRS Tutorial, we will learn

How to Hide/UnHide Columns and Shrink the remaining columns by using Parameter in SSRS Report.
The demo will present a scenario in which we will use a Boolean Type parameter, by Clicking True we would like to see all the columns or you can call that detail report. When we click False we would like to see limited number or columns or compact format of our report. We will follow below steps to create our final report in SQL Server Reporting Services

1. Create empty Report in SSRS
2. Create Tabular report in SSRS
3. Create Boolean type Parameter
4. Write Expressions to Hide Column/s by using Parameter value in SSRS Report

Hide/UnHide Columns and Shrink the Remaining Columns By Using Parameter in SSRS Report

SSRS Tutorial 56 - Pass Parameter Values from Image Click in SSRS Report

In this video of SSRS Tutorial, you will learn
" How to pass parameter value from Image Click in SSRS Report to Tablix Dataset". We will have two images in our report. Which will show Country such as Pakistan and India. By Clicking on each of image we want to show only the data related to that country in our tablix.

1. We will learn how to add Images to the SSRS Report
2. How to Add Images in Report Header so they will be display on every page if we will have records going to multiple pages
3. How to create Dataset with single Parameter and then use Dataset fields in Tablix
4. How to pass value to the parameter from Image Click 
5. How to Hide Parameter and Set default value for Parameter

 Pass parameter values from Image Click in SSRS Report - SSRS Tutorial

How to configure and use Windows Cluster Aware Updating Role Part 2

Windows Cluster-Aware Updating (CAU) -
In this video you will learn -

1- How to configure and use Windows Cluster-Aware updating Role?
2- How to Analyze cluster updating readiness?
3- How to preview updates for existing cluster?
4- How to apply updates to the cluster using Windows Cluster-Aware updating (CAU)?
5- How to generate CAU reports for the past runs?
6- How to use and modify updating Run Profile?

How to configure and use Windows Cluster Aware Updating Role Part 2

How to configure and use Windows Cluster Aware Updating Role Part 1

Windows Cluster-Aware Updating -
In this video you will learn -
1- How to configure and use Windows Cluster-Aware updating Role?
2- How to Analyze cluster updating readiness?
3- How to preview updates for existing cluster?
4- How to apply updates to the cluster using Windows Cluster-Aware updating (CAU)?
5- How to generate CAU reports for the past runs?
6- How to use and modify updating Run Profile?

How to configure and use Windows Cluster Aware Updating Role Part 1