| File Name | Description | |
|---|---|---|
| Meeting 1: Install, Configure and Connect SQL Server | ||
| MSFT_SQLServer_Meeting1.mp4 | Video: Meeting 1 (Duration 50:54) | |
| MSFT_SQLServer_Meeting1.pdf | Presentation for Meeting 1 | |
| MSFT_SQLServer_Lab1_Express_v101.pdf | Lab 1: Install, Configure and Connect SQL Server 2012 (Express Edition) | |
| MSFT_SQLServer_Lab1_Enterprise_v101.pdf | Lab 1: Install, Configure and Connect SQL Server 2012 (Enterprise Evaluation Edition) | |
| Microsoft Download Center | Use this link to go to the Microsoft page to download SQL Server 2012 SP1 Express | |
| Adventure Works for SQL Server 2012 |
This link takes you to a Microsoft page that contains sample databases that can be
installed in SQL Server 2012.
The sample database used in the lab is AdventureWorksLT2012_Data located near the bottom of the page. |
|
|
Which edition should you use?
The Express Edition is a no-charge edition. The Express Edition does not include the SQL Server Agent, which is used in Lab 2 and Lab 4, and it does not allow you to save data transfer requests (Lab 4). The Express Edition does not have an expiration date. The Enterprise Evaluation Edition includes all features of SQL Server, and can be used for Labs 1 - 5. It includes the SQL Server Agent and it lets you save data transfer requests. The Enterprise Evaluation Edition expires 180 days after you install it. The Enterprise Evaluation Edition can be installed on Windows 7, 8, 8.1 and Windows 10, in addition to Windows Server systems (2012 R2, 2012, 2008 R2, 2008). You can install both editions of SQL Server on your PC at the same time. You can download and install either SQL Server 2012 (Express or Evaluation) or a previous version of SQL Server (SQL Server 2008 R2 Express or Evaluation, SQL Server 2008 or SQL Server 2005). There are some slight differences between SQL Server 2012 and earlier versions, but the course materials can be used with all versions, with minor variations for older versions. You can also use SQL Server 2014 (Express or Enterprise) with this course. |
||
| Meeting 2: Work with Linked Servers | ||
| MSFT_SQLServer_Meeting2.mp4 | Video: Meeting 2 (Duration 43:20) | |
| MSFT_SQLServer_Meeting2.pdf | Presentation for Meeting 2. | |
| MSFT_SQLServer_Lab2L_v101.pdf | Lab 2L: Create and work with a Linked Server for your IBM i | |
| MSFT_SQLServer_Lab2A_v101.pdf | Lab 2A: Work with the SQL Server Agent. This lab does not work with SQL Server Express. It will work with the Enterprise Evaluation Edition or any other paid edition of SQL Server. |
|
| Meeting 3: Databases, Logins, Schemas, Synonyms and T-SQL | ||
| MSFT_SQLServer_Meeting3.mp4 | Video: Meeting 3 (Duration 54:33) | |
| MSFT_SQLServer_Meeting3.pdf | Presentation for Meeting 3. | |
| MSFT_SQLServer_Lab3_v101.pdf | Lab 3: Databases, Logins, Schemas, Synonyms and T-SQL | |
| Meeting 4: Work with the SQL Server Import and Export Wizard | ||
| MSFT_SQLServer_Meeting4.mp4 | Video: Meeting 4 (Duration 45:48) | |
| MSFT_SQLServer_Meeting4.pdf | Presentation for Meeting 4. | |
| MSFT_SQLServer_Lab4_v101.pdf | Lab 4: Work with the SQL Server Import and Export Wizard. | |
| Meeting 5: How to use the Microsoft JDBC driver on the IBM i | ||
| MSFT_SQLServer_Meeting5.mp5 | Video: Meeting 5 (Duration 1:02:50) | |
| MSFT_SQLServer_Meeting5.pdf | Presentation for Meeting 5. | |
| MSFT_SQLServer_Lab5_v101.pdf | Lab 5: How to use the Microsoft JDBC driver on the IBM i | |
| ibmiToSqlServer.java.txt | Example Java program. Use this version if you are working with Java 5 (JDK 1.5). | |
| ibmiToSqlServer6.java.txt | Example Java program. Use this version if you are working with Java 6 or Java 7. | |
| Other Documents | ||
| SQLServerWillNotStart.pdf | Document that describes a condition that may prevent the SQL Server database engine from starting, corrective steps to follow. | |
| IBMDoc_23062121_OLEDB_Properties.pdf | iSeries Access for Windows Custom Connection Properties for OLE DB. This document shows the values you can use in a connection string when using the OLE DB Provider. (Used in Lab 2 and beyond.) | |
| IBMDoc_404456535_SortOrder_LinkedServers.pdf | Describes an issue when working with data stored using CCSID 65535. | |
| IBMDoc_457017342_IBMDASQL_Restrictions.pdf | Describes restrictions when using the IBMDASQL OLE DB Provider. | |
| Verify_IBMiAccess_V5Rx.pdf | How to verify the features of IBM i Access that are installed on your PC. Use this document if you are using one of the V5Rx versions of iSeries Access or System i Access for Windows (V5R1, V5R2, V5R3, V5R4). | |
| Verify_IBMiAccess_V7Rx.pdf | How to verify the features of IBM i Access that are installed on your PC. Use this document if you are using the V6R1 version of IBM i Access or the V7R1 version of IBM i Access. This also describes how to perform a Service Pack update, including the additional required files from Microsoft. | |
| IBM_AutomaticallyStartJournaling_V5R4.pdf | Excerpt from an IBM manual that shows how to set up a library so that database files will be automatically journaled. This works with OS/400 V5R4 and above. | |
| Journaling at object creation on DB2 for iSeries | See this ==> Step-by-step instructions to use the automatic journaling technique. | |
Copyright © 2015, 2020 Craig Pelkie, ALL RIGHTS RESERVED. Last update: 2020-11-12