Last edited: 2020-07-16
How to access the Virtual Classroom, the Lab environment (Lab on Demand) and the class Recordings:
Browse to http://www.FocalPointLearn.com
Log in using your work or other supplied email address as the username
Your default initial password will likely be = P@ssw0rd (zero)
Click on the link for the relevant course.
After the first class day has ended you can click on the “Recordings” link
to listen to one of the recordings.
Screenshots illustrating how to access
the New Horizons Lab on Demand environment:
General class times (in Eastern time), check the LMS website as the final authority.
Dedicated and onsite events, especially, may have non-standard schedules.
Morning Break: 10:30am (~15 minutes)
Lunch Break: 12:30pm (~60 minutes)
Afternoon Break: 3:00pm (~15 minutes)
Please record the following Student Help Desk information:
[…In case the support team
wants you to run a speed test.]
To access your Skillpipe digital courseware:
You can access your content while connected to the Internet, or,
install one of the available Reader applications for offline viewing.
The courseware content does not expire.
Please record the following Arvato / Skillpipe
digital courseware support information:
https://policies.skillpipe.com/en/faq [lots of questions answered here]
Google Chrome is a recommended browser for Skillpipe.
To reach me via email:
George . Squillace @ Focal Point Learn . com
Everything below this point is non-essential…
…but listed below is a large number of potentially valuable resources.
To get a free DropBox account:
To find out more about DropBox, go to http://www.DropBox.com
George’s Lab Time Rules…
Rule #1: Use the Lab Answer Key instructions, or the inline lab instructions if they exist.
Rule #2: Use the RAISE HAND feature if you need help during lab time.
Rule #3: Use the THUMBS UP feature to indicate you’ve completed the lab.
Rule #4: Use the AWAY feature to mark that you’re away if you are indeed away.
Here are the links to resources on my (George Squillace) website you may find valuable.
(http://www.e-squillace.com) [and for the moment, also http://wordpress.e-squillace.com]
— <SQL> — <SQL> — <SQL> — <SQL> — <SQL>
Search button (for example, search for “ebook”) to find the many ebook links I have posted
Strategies for Passing Certification Exams (PowerPoint presentation link)
Library book listing:
Pay particular attention to the T-SQL books authored by Itzik Ben-Gan
SQL Server homepage:
Notice there is an additional page for SQL Development references:
Notice there is an additional pages for Business Intelligence references:
Power BI SSRS SSIS SSAS
Screenshot Gallery homepage:
Look for the configuration steps for many activities in SQL Server, in particular, especially for SQL 2005.
Especially take a look at the SQL & Database related diagrams.
Some need explaining but you may still find them useful.
Finally, a general Tips & Tricks homepage:
Here are the links to important Microsoft websites:
Microsoft Learning Experiences
Information on Courses, Exams, and Certifications
Microsoft Learning – Companion MOC downloads http://www.Microsoft.com/Learning/CompanionMOC
Extra resources related to a particular course
“MOC” = Microsoft Official Curriculum
To post questions to the Microsoft TechNet Forums:
Click on the “Forums” link up top.
Sign in with your Windows ID (required, to post questions, not required to browse).
Click on the “Forums [view all]” link.
Click on the “>>SQL Server” choice to expand the list of SQL Server forums.
Select the forum(s) of interest.
View the forum posts.
Click on the “Ask a question” button.
Microsoft Hands-on Labs:
George’s Facts & Rules…
Rule #1: The answer to every question you give a consultant is “It depends.”.
See Paul Randal’s (SQLSkills.com) related and funny post here, http://www.sqlskills.com/blogs/paul/it-depends-it-really-really-does/
Rule #2: Think like a suit but work like a nerd.
Put yourself in the shoes of your users and try to think like them while you’re using your technical skills.
Rule #3: If I have to do something once, I will probably have to do it again.
So, keep reusability and abstraction in mind
Rule #4: When in doubt in Windows, right-click.
Rule #5: Leave a trail.
Leave documentation behind as if today were your last day on the planet or your last day on the job.
Rule #6: Select to Affect or…Select (the proper object) to affect (the properties of) (the proper object).
Rule #7: “Accept pain as early in the development as possible” – Dave Rodabaugh, BI Developer
Rule #8: Just because I CAN, doesn’t mean I SHOULD.
Rule #9: Write once, run many. This expresses the programming principals of modularity/encapsulation/abstraction. (related to rule #3)
Rule #10: I can’t turn to the left or right in SQL Server without being permitted to do so.
Rule #11: SQL Server doesn’t do what you WANT it to do, it does what you TELL it to do.
Rule #12: SQL Server won’t guarantee the sort order (presentation order) of results unless you force it to with an ORDER BY clause.
Rule #13: Read the manual.
Rule #14: Always query for the least amount of data that’s meaningful.
Rule #15: Anything I can “engineer” I can also typically “over-engineer”.
Rule #16: If I run into a particular problem it is likely someone else has already run in to the same problem and figured out how to solve the problem. So, SEARCHING becomes as important as SOLVING. Have a good arsenal of resources available to help you.
Email Newsletters Email newsletters & resources (free) you should sign up for:
Find your local PASS User Group (Professional Association for SQL Server):
http://www.PASS.org (search for a user group near you)
Find out if there is an upcoming SQLSaturday event nearby:
Find your local Power BI User Group and forum