Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

Database skills are essential in whatever organization and in whatever position and it is crucial that you have this in your arsenal (Resume')
Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database.
This is a hands-on course which will take you from installing SQL Server 2016 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.

What's new in this session:

SQL Server Using Powershell
JSON and XML

 Section 1 - Apr 24 - May 24; TTh; 5:30 pm - 7:30 pm; 10 mtgs (Register Online)

Set-Location : A positional parameter cannot be found that accepts argument <.....>

Power Shell does not like white spaces. While it may like or .  I got stumped for while as I started getting this exception.

The trick to do this changing directory is to use double quotes around words with white spaces as shown here.

I have Power Shell 5.0 on my Windows 10 Pro OS.

Basic SQL course in Honolulu, Hawaii - 2015

You are welcome to attend my course at the Pacific Center for Advanced Technology Training (PACTT). Please register at the PCATT.org site.

Summary:

Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about databases and the basics of Structured Query Language (SQL) including sorting, distinct, and aggregate functions and grouping of data. All SQL statements will initially be written from one table. Most practical, modern and relational databases will include a large number of tables. SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course.


New in 2015: You will also get an introduction to Power Shell.

Dates: (Section 1) Section 1 - Feb 17 - Mar 12, 2015; TTh; 5:30 pm - 7:30 pm; 10 mtgs.
Venue: Honolulu Community College;

Note: SQL Server 2012 Express will be used and a knowledge of SQL Server is not assumed. Students will be using the free version.

For details : Access http://pcatt.org/index.php/search and look up the course or write to:
Hodentek@live.com with course name in the Subject line.

This Windows 8.1 (x64 bit) problem is a tough nut to crack

Each software and each version brings its own bag of problems and a whole lot of bug fixes and patches.

Windows 8.1 is no different. Recently I came across a problem which I have not been able to solve but making all efforts to fix. This post describes the problem and the attempts to correct it.

Recently I copied over several hundred image/video files from my Windows Phone 8.1 Preview to my Windows 8.1 (x64 bit) Toshiba Laptop. This is when I started noticing problems. The computer became slow and I lost access to the properties of files / folders on the desktop. I also noticed that it
was not possible to run the command processor (cmd.exe) in the elevated mode which I required for some diagnostics. For example, if I right click any file, the rotating wheel would start and after a minute or so, the whole desktop would refresh as if nothing happened.

Of course I found some work arounds to achieve what I wanted but the OS was not operating as expected. You may find links to the work arounds here, and here.

After succeeding to run the SFC /scannow command in the elevated mode, I was able to determine that certain files were corrupted and could not be repaired. These files were posted to the forum and here is a list files that could not be repaired..
-------
2014-10-16 10:28:25, Info                  CSI    000006fc [SR] Cannot repair member file [l:36{18}]"Amd64\CNBJ2530.DPB" of prncacla.inf, Version = 6.3.9600.16384, pA = PROCESSOR_ARCHITECTURE_AMD64 (9), Culture neutral, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type = [l:24{12}]"driverUpdate", TypeName neutral, PublicKey neutral in the store, hash mismatch
2014-10-16 10:28:31, Info                  CSI    000006fe [SR] Cannot repair member file [l:36{18}]"Amd64\CNBJ2530.DPB" of prncacla.inf, Version = 6.3.9600.16384, pA = PROCESSOR_ARCHITECTURE_AMD64 (9), Culture neutral, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type = [l:24{12}]"driverUpdate", TypeName neutral, PublicKey neutral in the store, hash mismatch
2014-10-16 10:43:57, Info                  CSI    00000b73 [SR] Cannot repair member file [l:36{18}]"Amd64\CNBJ2530.DPB" of prncacla.inf, Version = 6.3.9600.16384, pA = PROCESSOR_ARCHITECTURE_AMD64 (9), Culture neutral, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type = [l:24{12}]"driverUpdate", TypeName neutral, PublicKey neutral in the store, hash mismatch
2014-10-16 10:43:58, Info                  CSI    00000b75 [SR] Cannot repair member file [l:36{18}]"Amd64\CNBJ2530.DPB" of prncacla.inf, Version = 6.3.9600.16384, pA = PROCESSOR_ARCHITECTURE_AMD64 (9), Culture neutral, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type = [l:24{12}]"driverUpdate", TypeName neutral, PublicKey neutral in the store, hash mismatch
-----------------
In order to troubleshoot my original problem, I managed to repair the corrupt files using dism and then carried out a SFC scan of the computer (although this was not really necessary since dism provides the same informaiton). Now there are no corrupt files in the computer.

The original problem still persists. I am trying to further troubleshoot.

Learn SQL Server 2012 Reporting Services is released

Learning SQL Server 2012 Reporting Services was released today by Packt publishers. This is my second book on Microsoft SQL Server Reporting Services (which may be called a second edition). It is enlarged to include Reporting Services Integration with SharePoint 2010. With 566 pages it is somewhat thicker than the first edition (Learning SQL Server 2008 Reporting Services). However, the book has a large number of screen shots like my first book and is somewhat thinner than most other books in this genre. The reviewers and technical editors have put in a lot of effort and time to make this happen.

I take this opportunity to thank the reviewers (Satya Shyam Jayanty and Ritesh Shah) for their meticulous reading of the manuscript; the technical editors, Azharuddin Sheik, Mausam Kothari, Varun Pius Rodrigues, and Lubna Shaikh and many others at Pakct Publishing for their excellent editing and Microsoft Forums' (MSDN, TechNet and SharePoint) help for answering so many of my questions.

Summary of Hands-on tasks you learn:

• Install SQL Server 2012, SharePoint Server 2010, and configure Reporting Services both native and SharePoint Integrated on Windows 7
• Install SSDT and author reports, both local and remote, and deploy them to report servers
• Develop desktop and web applications by using Report Viewer controls
• Author different kinds of reports with the latest gadgets by working with Report Builder
• Manage access to the report server, report scheduling, report delivery, report uploads, and downloads with Report Manager
• Create Tabular Models with SQL Server Analysis Services and deploy them to SSAS Server using SSDT
• Author Power View Reports from your SharePoint Site and export them as Power Point files
• Learn to create Data Driven alerts in SharePoint and monitor them on SQL Agent on SSMS
• Work with Windows Azure Reporting Services using Windows Azure Portal and SSMS
• Write applications in SSIS and WPF to access reports and access native server reports from SharePoint Site

I hope this book is appreciated as much as the earlier one.