Development Tools ado.net tutorials

Tags: VB.NET, VB 2008, VB 2010, VB 2012, VB 2013

This lesson describes how to install development tools

The development tools used in these tutorials are Visual Studio 2013 and SQL Server 2014 Express edition.

At the time of this writing, the available version of Visual Studio is Visual Studio 2013 and to find download information about Visual Studio 2013 go to http://www.visualstudio.com/en-us/products/visual-studio-express-vs.aspx

SQL Server is one of the most advanced relational database management systems available, and comes with lots of services such as analysis services, data transformation services, reporting services, notification services, Service Broker, Database Mail, PowerShell support, and many more.

In addition, SQL Server offers a common environment, named SQL Server Management Studio (SSMS), for both database developers and database administrators (DBAs).

Now that you know a little bit about these development tools, i'll show you how to obtain and install them.

To install SQL Server 2014 Express, follow these steps:

1. Go to http://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx, select which version you need based on your CPU:
select the version
Select the language and Country/Location and then click Continue.

2. Save the setup utility to your prefered location e.g. C:\YourFolder\SQLEXPR_x86_ENU.exe or C:\YourFolder\SQLEXPR_x64_ENU.exe

3. Once it's downloaded, run the installer to begin the installation, and follow the steps to install it.

4. After a successful installation, you will see all the SQL Server components installed in your All Programs under Microsoft SQL Server 2014 menu.
Finally, make sure that your SQL Server service is running. To verify that, you need to invoke the Services list. Either type Services.msc in the or click the Administrative Tools Services in your Control Panel.
A Services window will load, so scroll down until you see SQL Server service listed, as shown in the figure.
services list

Note: the name in the parentheses is your SQL instance name and might be different from machine to machine. Anyway it is important to know this name to continue working with SQL Server and smoothly connect to and build database applications.


Share This

Subscribe