Sawasdee Cup
This webpage is being used to organize important tech resources, and will provide announcements, please check daily.
Link of the day – https://www.youtube.com/watch?v=vJbkFwjeGIo
Getting Set Up
We will use the WSU Virtual Desktop software called VDI
a) MIS325 – will run Visual Studio.NET to create webpages using Visual Basic.NET (focusing on the ASP.NET and ADO.NET content)
(this is the main resource for MIS 325)
b) MIS 325 and MIS420 run SQL Server Management Studio to create database tables and manage data using the programming language SQL (this is the main resource for MIS420)
c) run Tableau, Excel and PowerBI to create data visualizations (reports and dashboards) that pull data from SSMS databases
(Both MIS325 and MIS420 use these programs at times)
To gain access to the VDI we need to install the VDI software to do that follow the link below (this is a 1-time deal)
Running Software Daily
– each development session click the link below to access the VDI
https://client.wvd.microsoft.com/arm/webclient/index.html
List of ASP.NET accounts – used to create and publish ASP.NET webpages
IIS shares/pages will be MF42TheirUsername
List of SSMS accounts – used to create database tables and manipulate data using SQL
|
SQLUsername
|
Password
|
|
erin.freese1
|
17798247
|
|
kayla.sutherland
|
fe306a98
|
|
keagan.nakazawa
|
29462e3c
|
|
brett.riggers
|
4d7b238e
|
|
olivia.r.nelson
|
b1a3d8ba
|
|
joireman
|
d776d836
|
Class Content
ASP.NET
https://faculty.business.wsu.edu/featherman/feathermans-coding-adventures-series/
password = ASP
SQL
https://faculty.business.wsu.edu/featherman/t-sql-training/
password = SQL
Connecting to your Database
Here is the base query to use in Visual studio – change it to use your database, your userID, your password
Private Shared con As New SqlConnection(“Data Source = cb-ot-devst06.ad.wsu.edu; initial catalog = Featherman_analytics; Persist Security Info = True;User ID = mfstudent;Password=BIanalyst”)
SQL Login Information – to connect to Featherman’s database (use your userID and pwd to connect to your DB)
server = cb-ot-devst06.ad.wsu.edu
userID = mfstudent
password = BIanalyst007