Microsoft Student Partner (MSP) Capacity Build up Training (Session 05)


Microsoft Student Partner (MSP) Capacity Build up Training (Session 05)
Course Title: Object Oriented Programming with C#
Venue: East West University, Dhaka, Bangladesh
Date: 30 July, 2016
Speaker / Trainer: Md. Mahedee Hasan,
Microsoft MVP, Visual Studio and Development Technologies
Software Architect, Leadsoft Bangladesh Limited
Trainer, Leads Technology Limited

Microsoft Student Partner (MSP) Capacity Build up Training (Session 04)

Microsoft Student Partner (MSP) Capacity Build up Training (Session 04)
Course Title: Object Oriented Programming with C#
Venue: East West University, Dhaka, Bangladesh
Date: 23 July, 2016
Speaker / Trainer: Md. Mahedee Hasan,
Microsoft MVP, Visual Studio and Development Technologies
Software Architect, Leadsoft Bangladesh Limited
Trainer, Leads Technology Limited

Certified Course on Object Oriented Programming with C#.NET and ASP .NET MVC 6 (Batch – 10)

Learn from expert professionals and build your career

  • Organized by : Leads Training and Consulting Limited
  • 35% of actual course fee will be subsidized by Leads Technology Limited
  • Total Duration: 90 Hours
  • Certificate will be provided by Leads Technology after completion course.
  • Fee: BDT 20,000 (BDT 12,000 for Ramadan)
  • An industry standard project will be developed by each team as final project
  • Your seat will be confirm on “First Come First Serve Basis”

Tentative weekly class schedule
Friday 3:00 PM – 9:00 PM
Sunday 6:00 PM – 9:00 PM
Tuesday 6:00 PM – 9:00 PM

OOP Batch 08
Sending

Rupayan Trade Center, 17th Floor, 114 Kazi Nazrul Islam Avenue,
Bangla Motors, Dhaka-1000, Bangladesh

Trainer
Md. Mahedee Hasan
Microsoft MVP, Visual Studio and Development Technologies
Microsoft Community Contributor
Senior Software Architect
Leadsoft Bangladesh Limited
Blog: http://mahedee.net
Linkedin: www.linkedin.com/in/mahedee
Software Architect| Microsoft MVP| Technical Trainer| Technical Blogger | Technical Speaker

If you have any questions or comments, feel free to contact us directly at 01811 44 80 63 or email to farhana.yousufi@leads-bd.com

Hands on Training, Class Tests, Lab test, Final Exam, an Industry level project. A dedicated PC for Hands-On Exercises throughout the Course
plus Opportunities for Collaborating During Hands-On Exercises

Course Content

  • Introduction to Visual Studio 2013
  • Programming Basics
  • C# Basics
  • Advanced C#
  • ADO.NET
  • Object Oriented Programming
  • Object Oriented Design Principle
  • Introduction to SQL Server Programming
  • Database designing
  • Introduction to web technology
  • ASP.NET MVC 5
  • Advanced ASP.NET MVC
  • ASP.NET Web API, Angular JS basics
  • Entity Framework 6
  • LINQ Basics
  • Version Control
  • Github
  • TFS
  • SVN
  • Code Quality & Smart Coding
  • Project Work

[Contents are given here from high level. Each topic has multiple sub topics which are not mentioned here.]

Steps to Know How to Rebuild Index in SQL Server

What is Index in SQL Server?

In RDBMS, there is a data structure that is used to improve the performance of SQL server at time of retrieving any data and this data structure is known as database index in SQL server. Instead of searching each row in table, one can use indexes that will provide a way of locating data and hence, accessing the database table.

What is Index Rebuilding?

The process of recreating a new structure of index in SQL Server for maintaining health of database is known as Index Rebuilding. There is a Rebuild option in SQL Server through which one can recreate the database index. If index is disabled from database, then one can use Rebuild operation for returning back to its working state.

NOTE: If user interrupts/cancel the working of rebuilding operation, then all the modification made will be rolled back to its previous state.

Need to Rebuild Index in SQL Server

Generally, while performing changes or modification index fragmentation takes place in form of wasted memory (termed as Gaps in data pages) and logical fragmentation. Gaps in data pages result in reduction of rows, which are archived in cache of the server. On the other hand, logical fragmentation occupies the disk storage space with useless data. Therefore, the only way to prevent rows reduction and save disk storage space is to rebuild indexes in SQL server. This will highly boost up the speed and performance of the database.

When to Rebuild Indexes?

If one constantly rebuild index in SQL server, then it will effect the physical storage of machine or will result in any other hazardous situation. Therefore, it is important to learn that when to rebuild indexes.

  • If there is rapid index fragmentation, and user eagerly wants to execute Rebuild Index tasks with all other tasks related to database maintenance, then they can do so for boosting server performance.
  • For weekly maintaining database and boosting server performance, user can perform rebuilding operation once in a week. However, it would be risky if user do not rebuild index since a week.
  • Another condition is when user has not performed rebuilding from long time. In this condition, users will have to take following two alternatives into consideration:
    • Use Reorganize Index tasks with Update Statistics tasks
    • Use online version of Rebuild Index tasks

Measures to Rebuild Indexes

A very common question among SQL server users that How to rebuild index in SQL server? Well, by making use of Maintenance Plan Wizard of SQL server in following way, user can perform rebuild operation:

  • Launch the Maintenance Plan Wizard on your machine
    Maintenance Plan Wizard
  • Click on the scroll down button of Databases field & then select databases on which you want to perform rebuilding operation. You will have to select any of the displayed databases and then click on OK button to continue.
    select displayed databases
  • Now you will return back to previous wizard. In this wizard you will come across two options:
    two options
  • Object: This option is only enabled with some selective database. In other words, it will not be enabled with all the databases of the server. However, there are three options provided to you in this field i.e. Tables, Views, and Tables and Views. If you select Tables and Views option, then Rebuild operation will be applied to indexes related to tables and indexed views of the selected database. Well as per your need, you can also choose Tables or Views option.
    options
  • Selection: By clicking on selection drop-down button, you can choose that whether you want to perform rebuilding operation on all objects or selected objects. If you want to perform selective operation, then enable These objects option and select the objects that you want to take in operation; else activate All objects option. After finishing with all your selection procedure click on OK button.
    all objects or selected objects
  • Next come Free space options field in which you are provided with two options and by default ‘Reorganize pages with default amount of free space’ option is enabled. You can make use of any one of the two options to clean the Gaps in data pages.
    Free space options
  • Now comes an advance options field. With help these two option your will be able to determine that how much benefit will you have during rebuilding procedure.
    advance options field
  • The last step of rebuilding indexes in SQL server is to define a valid schedule that can run your Rebuild Index job.
    Rebuild Index job
  • Fill all the mandatory fields of this window with correct details and click on OK button.
    Job Schedule

Conclusion

How to rebuild index in SQL server is query that arises when user has to deal with index fragmentation problem. After going through whole blog, one can say that rebuilding index is an effective resource intensive tasks. In case, if the above workaround failed to rebuild indexes in SQL Server then you can also go with a SQL Recovery tool to fix the index fragmentation issues.

How to install .NET Core 1.0 for windows

What is .NET Core?

  • .NET Core is a general-purpose development platform
  • Maintained by Microsoft and the .NET community on GitHub
  • Its work in cross-platform, supporting Windows, macOS and Linux
  • Can be used in device, cloud, and embedded/IoT scenarios.
  • First release on 27 June, 2016

Let’s see how to install .NET Core for windows

Step 1: Install Visual Studio 2015
Install Visual Studio 2015 Update 3
Download link of Visual Studio 2015 Update 3: https://go.microsoft.com/fwlink/?LinkId=691978
If you have already installed Visual Studio 2015, just install only Visual Studio 2015 update 3.
Download link of Update 3: https://go.microsoft.com/fwlink/?LinkId=691129

Step 2: Install the .NET Core tools preview for Visual Studio

Download .NET link of core 1.0.1 tools preview 2: https://go.microsoft.com/fwlink/?LinkID=827546
Then install .NET Core 1.0.1 tools preview 2.

Step 3: Create a .NET Core Project
File -> New project and select the project template C# -> .NET Core -> Console application (.NET Core).

0105_01

Step 4: Add some code in Main method of console application.

    public class Program
    {
        public static void Main(string[] args)
        {
            Console.WriteLine("Welcome to mahedee.net");
            Console.WriteLine("This is a asp.net core application");
            Console.ReadKey();
        }
    }

Step 5: Run your application
Run your application from Debug -> Start Debugging.
Yes! You are seeing the proper output. Means, .NET Core running in your machine. Let’s cheers!