Monday, June 26, 2017

Is your Windows 10 computer SLAT Compatible?

SLAT stands for Seccond Level Address Translation is a hardware based virtualization technology. It reduces the overhead assoiated with software manged shadow page tables.

How do you find your computer is SLAT compatible?

There is a nice tool here that readily tells you if your computer is compatible.

Download the tool and extract the executable ( ChecksSLATStatusOfMachine.exe; 15KB) to a folder. Double click the executable to bring up this page.


SLAT_00

Just double click the label Click To Check.

You get the answer after a little while as shown.


SLAT_01

Although this works whether Hyper-V is enabled or not but if the OS supports Hyper-V you may assume it is SLAT compatible. In order to enable Hyper-V follow these posts.

Activating Hyper-V on Windows 10:
http://hodentekhelp.blogspot.com/2016/04/how-do-you-install-hyper-v-on-windows-10.html

Enabling Hyper-V on Windows 8.1 OS:
http://hodentekhelp.blogspot.com/2015/05/how-do-you-enable-hyper-v-in-windows-81.html

Friday, June 23, 2017

What is Microsoft Stream?

Microsoft Stream is meant as a replacement for Office 365 Video service. Microsoft Stream is video service for business users.

Microsoft is always aiming at corporate users and this service allows for uploading, sharing, managing and viewing corporate video for company-wide education and information sharing.

The base platform for Stream service is Azure Media Services. Of course integration of its various components be it Skype or Office is a feature paramount in its business vision and Stream integrates with SharePoint. Teams, Office 365 groups etc. Security is via Azure Active Directory with its authentication and encryption features.

Stream is a lot more than video managing, it can,

* searchable speech-to-text transcribed audios
* Face detection in videos
* Linked time codes

Follow the link below to see all the details about Microsoft Stream.

Migration from Office 365 Video to stream is phased and is supposed commence in the second half of 2017.

More on stream here.

This video gives some idea of what it was sometime ago (not the latest)


Wednesday, June 21, 2017

How does Win/Loss sparkline work?

There are three kinds of Sparklines in Excel you can create. These are small pictures that show the data trend.
These can be types Column, Line or Win / Loss. Read more here.

The first two are easy to understand as shown in the previous post. However if all your values are positive you may not see any significense difference in the sparkline as shown in the first image here:


However, if some of your data are negative, this is what you see in Win /Loss Sparkline. I have changed some values negative.



Monday, June 19, 2017

What are AngularJS directives?

AngularJS directives are extensions of HTML markups. They can be attributes, element names, CSS class etc. AnuglarJS script reference is important and the script can be found here:

https://ajax.googleapis.com/ajax/libs/angularjs/1.2.25/angular.min.js"
The above script reference needs to be added to your hTML page.

You can find the whole list of directives here:
https://docs.angularjs.org/api

Here is the usage of some directives placed in a html page that can be displayed on your localhost (in this case the IIS in Windows 10). Place this code with a suitable name in the inetpub / wwwroot directory.

======================


  Some directives in AngularJS

ng-app
Sorry, blogger still does not support the "pre" tag!
==============
When viewed on the browser (in this case Microsoft Edge), the HTML page renders as shown.



Type anything it gets copied next to Hello
Enter the increment region with your mouse, the count (presently 1) gets incremented
Click the link and you get to the page

More to come in future posts on AngularJS

Sunday, June 18, 2017

What is V8?

V8 is a 8 cylinder engine if you are a automobile geek. However V8 is also the open source, high performance ECMA compliant JavaScript engine from none other than Google.

V8 is written in C++. It is used in many embedding applications such as Chromium and Node.js ("Node.js® is a JavaScript runtime built on top of Chrome's V8 JavaScript engine).  Just like a web browser access the document object model(DOM), V8 engine together with Chromium provides the same functionality and additionally provides all data types, operators, objects, functions etc.

In addition to compiling Javascript code, it does memory managment; assigning objects to memory; monitoring property changes and doing garbage collection.

Read more here:
https://github.com/v8/v8/wiki/Introduction

Friday, June 16, 2017

How do you create Sparklines in Excel?

Sparklines are tiny charts of related information covering a range of data placed in an EXCEL cell.

I have Microsoft Office 365 Business version 1704. I will describe using this version of Excel. The data I choose to show is the data related to Opoid related deaths in New York state. I tried to get this data as data from Excel's (Data |From Web) Web menu item in Excel but it was not easy. I just copied and pasted and made some changes. The website for this data is coming
from here:

http://lohud.nydatabases.com/database/opioid-related-deaths-new-york-state

Here is a sample data in a Excel Spreadsheet.


Opoid_00.png

I have the data for all the counties, but the above has only for the top couple of counties.

In Excel you can create the following types of Sparklines:



Opioid_01.png

I will describe how to show the sparklines for the Opoid deaths for say the three counties Albany, Allegany and Bronx.

Highlight the data for the three counties as shown (keep a blank column for the Sparklines). Note that to show with some clarity, the row height has been changed.


Opioid_02.png

Click Sparklines and choose column.
The Sparklines gets into the next column as shown.


Opioid_03.png

Now you can see how the death varied from 2003 to 2014 in the three counties on a comparative basis. Looks like Allegany made the best changes.

Monday, June 12, 2017

How to make thumbnail show instead of image file icons in Windows Explorer?

Depending on your settings in the Control Panel instead of thumbnails in the Windows Explorer you may be seeing the icon of image program that opens the image.

You can make changes in the Control Panel to change this. Watch this slide show.

https://www.youtube.com/watch?v=uZ4fTHndHuA

Friday, June 2, 2017

How do you add Full-Text feature to an existing installation of SQL Server 2016 SP1?

It is a good practice that you only install what you need, otherwise you may end of reserving resources for things you do not need. However often times you need to add a feature to an existing installation of SQL Server 2016. There is no better place to go than the SQL Server Installation Center. This slide show shows how you may do this.

https://youtu.be/6S25lHM15E4

Friday, May 26, 2017

Microsoft BitLocker saga..

This is the classic example of getting out of one problem and getting into another.

I had the virus problem (probably the ransomeware except that I did not click on any link and the threatening page did not go away after a reboot, etc.) on my Toshiba tablet with Windows 10 and decided to System Reset to clean the tablet. It went through the process and now requesting entering of a recovery key. There is a Key ID on the tablet (8 alphanumeric characters) and if I try to enter I get a basic numeric keypad like on a calculator with keys marked with only numbers.
It may work if I can enter. But how can I enter this 8 character ID using this calculator-like numeric keypad? and Drive Label with a date.



The tablet is on a Wi-Fi network with 3 other laptops (two running Windows 10 Pro and the other Windows 7 Pro)

It turns out that I am supposed to have a key and what was shown above was the KeyID (only the first part of it). The key itself is all numeric with 48 characters.

Finally I used the manage-bde commandline command to see what is going on.
Finally using manage-bde, I could find out that I have only the recovery key id without a recovery key.


What surprises me is that I never meddled with BitLocker as I do not have great secrets to guard. How come the BitLocker was locked in the first place? I toook the tablet to the Microsoft Store where they might be able to find some thing.

 It is not I don't have a key, I believe there never was one!

It is still puzzling, that since I did not lock the machine with BitLocker, who did?

According to Microsoft Store, when I signed into Microsoft Account the BitLocker by default locks it. It did not seem credible to me. I did not get the impression the technician was fully conversant with BitLocker. I avoided BitLocker for the simple reason, I did not want another layer of complexity to my files/folder that do not contain sensitive information.

One of the members of Microsoft Forum provided some background information of BitLocker's evolution. This is what might have happenned (his words):

"Earlier, Microsoft used to enable bitlocker on the home version of windows if
A a microsoft account was used
B the computer fulfilled the hardware requirements (TPM chip, instant-go compatible).
That was quite an idea... they even shot the recovery key through the network in plain text - some german IT magazine ("IX") discovered that. By now, they stopped it."

Thursday, May 25, 2017

How do you create a Full-Text Catalog to a database in SQL Server?

A full-text catalog is a logical container where a group of full-text indexes are stored. A full-text catalog is needed before you can create a full-text index. Full-text catalog is a virtual object and does not belong to the file group.

In order to text search an full-text index will be needed. For example, the Categories table in Northwind does not have a full-text indexed column. If you try to create a Full-Text indexed column you will get this error:
-----------
Msg 9967, Level 16, State 1, Line 11
A default full-text catalog does not exist in database 'Northwind' or user does not have permission to perform this action.

--------------

You can create a Full-text catalog using the SQL Server Management Studio or using Transact-SQL(T-SQL)
---------
Here is how it is created for Northwind database in SQL Server 2016 using T-SQL. Read to end this post for error messages.

USE Northwind
Go
Create FULLTEXT CATALOG ftCat_Nwind as default
Go

------
Before the above statement was run there was no Catalog:


After the above statement was processed the named catalog was created:


You can access the properties as shown here


All tables and views are eligible and you can assign the objects to the Catalog by transferring using the > button.

Creating a Full-Text catalog for Northwind using SQL Server Management Studio is easy. Right click Full-Text Catalogs in the Storage node and provide a name for the catalog and a owner. Choose the accent sensitivity and click OK to create.


The Catalog gets created as shown.


Caution:

Although SQL Server 2016 SP1 allows you to create a Full-Text Catalog, you will find it missing in the System Views as in the following query.

This feature has not improved even from the older versions. It has not been fixed and the error messages that you get such as the following does not give a clue.

Property IsAccentSensitive is not available for the Full-Text catalog
Property PopulationStatus is not available for FullTextCatalog

The reason for this error is that the Full-Text feature was not installed in the first place.
Watch the video and review features not installed:

https://hodentekmsss.blogspot.com/2017/05/installing-sql-server-2016-sp1-for.html



How do you use the table hint TABLOCK in a SQL Query?

TABLOCK is one of several table hints in SQL Server which includes the following:

   FORCESCAN 
   FORCESEEK 
   HOLDLOCK  
   NOLOCK  
   NOWAIT 
   PAGLOCK  
   READCOMMITTED  
   READCOMMITTEDLOCK  
   READPAST  
   READUNCOMMITTED  
   REPEATABLEREAD  
   ROWLOCK  
   SERIALIZABLE  
   SNAPSHOT  
   SPATIAL_WINDOW_MAX_CELLS = integer 
   TABLOCK  
   TABLOCKX  
   UPDLOCK  
   XLOCK 

Table hints can be used with any of the following operations:
Applies to:
DELETE
INSERT
SELECT
UPDATE
MERGE

Here is a query that updates a value in the Northwind Shippers table:
----------
Use Northwind
GO
UPDATE  Shippers
WITH (TABLOCK)
SET CompanyName='Speedy Gonsalez'
WHERE ShipperID=1

--
SELECT * from Shippers
------------
The query updates the name of the shipping company whose ID=1 to a new name. When TABLOCK is used in the above manner it should be within the parenthesis.


Read this recommendation from Microsoft:

"An UPDATE statement always acquires an exclusive (X) lock on the table it modifies, and holds that lock until the transaction completes. With an exclusive lock, no other transactions can modify data. You can specify table hints to override this default behavior for the duration of the UPDATE statement by specifying another locking method, however, we recommend that hints be used only as a last resort by experienced developers and database administrators"

Sunday, May 21, 2017

Is it JSON or not?

The following is formatted in JSON

["wclass",
{"student":{"name":"Linda Jones","legacySkill":"Access, VB 5.0"}etc..
},
{  "student":{"name":"Adam Davidson","legacySkill":"Cobol, MainFrame"}
},
{"student":{"name":"Charles Boyer","legacySkill":"HTML, XML"}
}]

This is a valid JSON according to RFC 4627.


json_01

However when you use this in SQL Server to look at the JSON using the OpenJSON, for example, you will get this error:


json_00

The reason for this error:
Msg 103, Level 15, State 4, Line 2
The identifier that starts with "wclass"...
lies in the fact that SQL Server string starts with a single quote and therefore you need to provide this declaration:

declare @json nvarchar(Max)
set @json=
'["wclass",
{"student":{"name":"Linda Jones","legacySkill":"Access, VB 5.0"}
},
{"student":{"name":"Adam Davidson","legacySkill":"Cobol, MainFrame"}
},
{"student":{"name":"Charles Boyer","legacySkill":"HTML, XML"}
}]'


When you do this the error goes away as shown:


json_02


The character count in @json is also important as you see in this SQL query:


json_03

The answer is that RFC 4627 validation requires a string to start with a double quote("), but the SQL Server's JSON validation requires the JSON to begin with a single quote(') as we saw in this post.

How do you query the OpenJSON function with a SELECT statement?

OpenJSON converts an array of objects in a variable in JSON Format to a rowset
that can be queried with standard SQL Select statement.

Here is an example:

We are going to look at a JSON list of my first batch of students who took my course shown here. 

["wclass",
{"student":{"name":"Linda Jones","legacySkill":"Access, VB 5.0"}
},
{"student":{"name":"Adam Davidson","legacySkill":"Cobol, MainFrame"}
},
{"student":{"name":"Charles Boyer","legacySkill":"HTML, XML"}
}]

This is the result of running OpenJSON using the above:



Now you can run a SELECT query with a with clause on the rows returned by OpenJSON as shown here:

The first member "wclass" has nulls for the selected columns. It exists because it actually was in the original XML that got converted to JSON.
Here are my more recent JSON related articles:

JSON validation in SQL Server:
https://hodentekmsss.blogspot.com/2016/11/using-json-validator-in-sql-server.html

Nested JSON using SQL Server 2012:
https://hodentekmsss.blogspot.com/search?q=json

Retrieve JSON formatted data from SQL Anywhere 17
https://hodentekmsss.blogspot.com/2016/11/retrieve-data-from-sql-anywhere-17-in.html

Friday, May 19, 2017

What are geometry primitives in GeoJSON?

In Eucledian geometry we were taught about the concepts of 'Point' and straight line being the shortest distance between two points.

GeoJSON is an Open Standard format based on JavaScript Object Notation for representing simple geographical (geometrical?)features.

In GeoJson Point, Line and Polygon are the Geometric Primitives:

Point:
{ "type": "Point",
    "coordinates": [30, 10]
}
Line:
{ "type": "LineString",
    "coordinates": [
        [30, 10], [10, 30], [40, 40]
    ]
}
Polygon:
{ "type": "Polygon",
    "coordinates": [
        [[30, 10], [40, 40], [20, 40], [10, 20], [30, 10]]
    ]
}
This post is based on GeoJSON on Wikipedia.

Tuesday, May 16, 2017

What is Azure Cosmos DB?

This is how Azure Cosmos DB is described by Microsoft, "Azure Cosmos DB is Microsoft's globally distributed, multi-model database. With the click of a button, Azure Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure's geographic regions. It offers throughput, latency, availability, and consistency guarantees with comprehensive service level agreements (SLAs), something no other database service can offer"



If you are looking for Global Distribution, horizontal scaling, guaranteed latency, high availability, comprehensive SLA's and unrivalled Data Model and API that no RDBMS, no no-sql database can provide there is nothing out there to match Azure Cosmos DB.

Azure Cosmos DB Engine supports multiple database systems and it is based on the following:

 Atom: Consisting of a small set of primitive types (String, Bol, number)
 Records: Structs
 Sequence: Arrays of atoms, records and sequences

Azure Cosmos DB engine currently supports the following:

Document DB SQL
Mongo DB
Azure Table Storage
Gremlin Graphh Query API
It will support other API's in the future.

For developers looking for a globally distributed database system Azure Cosmos DB is the answer.



Sunday, May 14, 2017

How do you build an ODBC Connection String with Report Builder 3?

ODBC source is one of the many sources that you can connect to in Reporting
Services using the Report Builder.

Here are the steps. It is assumed you have SQL Server 2016 SP1 installed; Report Builder is also
installed on the same machine. For these steps it is assumed that the SQL Server is up and running
and you are the owner of the computer who installed the SQL Server.

1. Launch Report Builder with Administrative Privileges.
2. Right click Data Sources and Click Add DataSource... to bring up the Data Source properties window.
3.  Provide a name for the data source, DS_ODBC
4. Choose Use a connection embedded in my report
5. Select connection type: click handle and choose ODBC at the bottom of list
6. Click Build... to bring up the Connection properties window
7. In the Data source specification section choose Use connection string:
8. Click the Build... button that gets activated to display Select Data Source window
9. Click Machine Data Source
10. In Machine Data Source tabbed page, click New... to display Create New Data Source
11. Accept the default, User Data Source and click Next
12. In the Select a driver for which you want to set up a data source, scroll down and
    select SQL Server (SQLSRV32.dll); click Next to display the next window
13  Click Finish. Create a New Data Source to SQL Server is displayed
14. Provide a name of your choice (ODBC_DSN); Description:(ODBC for Report Builder); Server
    use handle to locate: Hodentek9\OHANA. Click Next
15. Accept the default in the displayed page: with Windows NT authentication using the
    Network login id. Click Next
16. Change the default database by clicking handle to Northwind. accept all other
    defaults. Click Next
17. Accept all defaults on the displayed page. Click Finish
18. In the ODBC Microsoft SQL Server Setup page test the connection and make sure it works. Click OK
19. ODBC_DSN enters the Machine Data Source tabbed page. Click OK
20. SQL Server Login window gets displayed. Enter creator owner's credentials
21. Copy the connection string from the connection properties window.
Dsn=ODBC_DSN;description=ODBC for Report Builder;trusted_connection=Yes;app=Microsoft SQL Server;wsid=HODENTEK9;network=DBNMPNTW
22. Test Connection to make sure it works
23. Click OK
The Connection string enters the Data Source Properties window as shown.






Thursday, May 11, 2017

How do you create a Report Model in SQL Server Reporting Services 2016 (Native Mode)?

You cannot as it is discontinued.

RS Web Portal is the new name for Report Manager of earlier versions.

The following two features related to Report Model are discontinued  in SQL Server 2016.

Feature                                                                Replacement or workaround
Upload report models through the web portal     This can still be done through the SOAP API.
Manage report models through the web portal    This can still be done through the SOAP API.

Note: Whereas HTML4 is supported, the future SQL Server Reporting Services will be using HTML5.

Wednesday, May 10, 2017

How do you fix the rsErrorOpeningConnection error in Reporting Services 2016?

The error, rsErrorOpeningConnection has been asked many times in almost
all versions of SQL Server Reporting Services starting from SSRS 2008. Various
reasons have been given. The error message hints at what may be wrong.

In the present case, a simple report with embedded data source  was created in Report Builder 3 by the creator owner who is also the local administrator. This report was saved to the
Report Server (also gets uploaded to the Web Portal front-end).


The report is processed in the Report Builder without any error.

If the Where_2 report is double clicked this is the message displayed after correct authentication
by the local administrator.




The Data Source is shown in the following and the report gets correctly displayed in
the Report Builder and it can be saved to the Report Server as seen above.


The rsErrorOpeningConnection arises because of the credentials to the Data Source is not
properly configured (what is shown is the default). Review the credentials for the data source:


When you make the proper entries for the report as shown here:


The error goes away.

 The SQL Server 2016 SP1, the Report Builder 3 are both on a Dell Laptop with Windows 10 Pro. The Reporting Services configuration is for Native Mode managed by the laptop owner.







Sunday, April 23, 2017

What is KanaType as related to SQL Server?

This is specifically for data in Japanese language databases. There are two types of Japanese phonetic scripts, the Hiragana and the Katakana. Of course there is also the Kanji (non-phonetic) which characters which are modified/simplified Chinese characters used in Japan together with Hiragana and Katakana.

While dealing with Japanese data Kanatype is used to distinguish between Katakana and Hiragana. Katakana is usually used for words of foreign origin not found in Japanese, like, Bus, Laser, harassment etc.

For example, the 'dataset' in Reporting Services have this property:

DataSetDefinition.KanatypeSensitivity


Here is a piece of text in Hiragana

ふるい もの の なか に ある かくれた うつくしさを 「さび」 と いいます。 また、かざらない そぼくな うつくしさ を 「わび」 と いいます。ふたつ を あわせて、「わび・さび」 と いいます。

Source: http://gakuu.com/haikyo-hiragana-reading-practice/

Here is a piece of text in Katakana (the same text written in Katakana):

フルイ モノ ノ ナカ ニ アル カクレタ ウツクシサヲ 「サビ」 ト イイマス。 マタ、カザラナイ ソボクナ ウツクシサ ヲ 「ワビ」 ト イイマス。フタツ ヲ アワセテ、「ワビ・サビ」 ト イイマス。

Source: en.calc-site.com/letters/convert_kana

Friday, April 21, 2017

Can you save reports created in Power BI to a Report Server? - FINAL

I apologize to the readers of my post,Can you save reports created in Power BI to a Report Server?  for having given the wrong impression. The reports you create cannot be saved to any report server but the stand-alone report server created using the same .msi file downloaded from the same location where you downloaded Power BI Desktop Technical Preview.

I am only partly to blame for this and I apologize. Let me correctly present what kinds of reports can be saved to what kind of report server. The other reason for the problem was created by the Power BI itself for giving the wrong guidance for the users while saving the report to the report server. It must be changed.


  • The only kind of reports that can be saved to Report Server (strictly speaking, you are only saving it to the Web Portal URL) are the ones created with data from the Analysis Services server.
  • In order to save you need to configure a stand-alone Report Server whose database is stored not on a SQL Server 2016 but an earlier version. In my case I use the SQL Server 2012. The .msi file for this server is on the same download site as the Power BI Technical Preview.


After you fulfill the above conditions then only you can host the report.


I was able to get the correct server by an answer to my question on StackOverflow.com.


http://stackoverflow.com/questions/43402339/invalid-url-error-while-saving-power-bi-report-to-sql-server-reporting-services


Where do you find 'hosts' file on Windows 10?

I don't think it's location in the fle/folder system has changed. It should be in the 'Windows' folder.

Try the following on a C:\ prompt:



C:\>cd %SystemRoot%\system32\drivers\etc
==========================
C:\Windows\System32\drivers\etc>dir/w
 Volume in drive C is TI10672700E
 Volume Serial Number is 16FB-D230

 Directory of C:\Windows\System32\drivers\etc

[.]           [..]          hosts         hosts.ics     lmhosts.sam   networks      protocol      services
               6 File(s)         24,174 bytes
               2 Dir(s)  667,711,660,032 bytes free



Saturday, April 8, 2017

Can you save reports created in Power BI to a Report Server?

The answer is yes if you use the Technical Preview version of Power BI Desktop. You can save reports to your on premises SQL Server.

NOTE: If you already have configured a SQL Server 2016 Reporting Services server you will not be able to upload the reports from Power BI. You need to install the SQLServerReportingServices.exe mentioned below and configure a Standalone SQL Server Reporting Services which will provide a http:///ReportServer.

You can download this for both x32 and x64 versions. With this you can,


  •     Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
  •     Visually explore data and create an interactive report
  •     Save that report to your report server running the Technical Preview
  •     View and interact with the report in your web browser

If you do have Power BI for Desktop on your computer you still need the (January 2017) Technical Preview. This can sit alongside your present Power BI.

https://www.microsoft.com/en-us/download/details.aspx?id=54610

Preview version details below:
Version:            Date Published:

0.1                1/11/2017

File Name:                                                               File Size:

PBIDesktopRS.msi                                      102.2 MB

PBIDesktopRS_x64.msi                           118.3 MB

SQLServerReportingServices.exe    49.6 MB



System Requirements:
Supported Operating System

Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

    You'll need
        .NET Framework 4.5.2 or later
        SQL Server Database Engine (2008 or later), to store the report server database
        SQL Server Analysis Services (2012 SP1 CU4 or later), to store your data models
    Links:
        Get SQL Server 2016 Evaluation
        Try SQL Server vNext CTP1.1









Friday, April 7, 2017

Download and Install Report Builder for SQL Server 2016

Report Builder is a highly productive, stand-alone tool for authoring reports and deploying them on configured Microsoft Reporting services report servers. It can use data from different kinds of data sources to produce  a variety of reports, from hard copies to web based reporting.

Report Builder 3 Details:
--------------
Version:
14.0.344.82
File Name:
ReportBuilder3.msi
Date Published:
3/9/2017
File Size:
22.6 MB
-----------------

You need Microsoft .NET Framework 4.5
. The memory and CPU requirements are average.

This is supported on  the following OSs:
Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

download from here:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=53613

Please review the earlier versions of Report builder in two of my published books here:


The second book Learning SQL Server 2008 Reporting Services is ideal for beginners who want to spin-out reports from a variety of data sources and deploy them to report servers. The book is replete with step-by-step, hands-on exercises where the users can hone their skills.



The fifth book Learning SQL Server Reporting Services 2012 is a revised edition and a deals with both Native and SharePoint Integrated modes of Report Servers. This covers every aspect of the first edition(second book) with lots of added material to include development in the intervening years.

  As the author of these Microsoft Business Intelligence related books I have great confidence in their usefulness. I would love to hear from you. Email me at: hodentek@live.com.

Installing Report Builder

You will have downloaded the ReportBuilder.msi file published on 3/9/3017. Note that there are other Report Builder.msi related to other versions (for example ReportBuilder.msi for SQL Server 2014 etc).

The installation is driven by a wizard and it installs without any problem. You need not indicate a Reporting Services Report Server during installation.

Here are screen shots of the installation:

Welcome Screen


License agreement window. Click I Accept...


 It will be installed on the local hard drive. Note that this product may also work with SQL Server vNext CTP1.3.


SQL Server 2016 reporting services has two modes and you need not have these installed and configured. You may keep this empty. Click Next.


Click Next and you are ready to install.


 Click Install. Begins installing with a progress screen.


 It is done installing.


 You should see these in All Programs on Windows 10.


Double click and you are ready to Author a report. If you want to put it out on the Report Server, you need a Report Server.

You are ready to go!

Wednesday, April 5, 2017

What is Markdown Syntax?

HTML markup is well known and Markdown markup is a construct to make a web page readable.  Markdown syntax is used to make it possible to write to the web using simple text.  It is a text-to-HTML tool for web authors.

Markdown syntax is very small and not extensive like that of HTML. It is not used to replace HTML but to make it easy to read/write/edit prose in a web page. Markdown does not need special editors.

Since Markdown consists of few constructs if you need beyond them you can use HTML. One of the special constraints in using Markdown is in the case of block level elements such as 'table', 'pre', 'p' etc. In this case for using Markdown just surround block-level elements with blank lines and Markdown syntax takes care of the rest.

Learn more about Markdown syntax here. While you are there click on the tab Dingus tool (written in Perl) to convert your Markdown Syntax to html syntax.

For example you can create first and second level headers by just typing them as shown here:

A First Level Header
=====================

A Second Level Header
---------------------


The above Markdown text will be converted  into the HTML source by the Dingus tool: (note: Firefox browser does not render the 'pre' tags which are in the source of this page. That is why you are seeing the h1 and h2 tags rendered. Review my post on this browser problem.

A First Level Header

A Second Level Header

The Markdown text is readable and can be typed in with a text editor and the tool converts it to web compliant HTML.

Review the screen shot here:

Saturday, April 1, 2017

What is a SQL Server Mobile Report Publisher?

SQL Server Mobile Report Publisher (SSMRP) is an authoring tool that can be used to quickly creating Reporting Services mobile reports that are optimized for mobile device with a variety of form factors. You can have an assortment of visualizations, from time, category, charts, tree maps, and custom maps.

With SSMRP you can,
  • Connect mobile reports to a range of data sources including on-premises SQL Server and Analysis Services
  • Layout reports on a design surface to accommodate flexible mobile reports
  • Save mobile reports to a Reporting Services server and interact with them in a browser or with Power BI on mobile devices(iPad, Android Phones and tablets and Windows 10 devices).
What do you need to create Reporting Services mobile reports?
You need the SQL Server Mobile Report Publisher

Version:
1.0.3923
File Name:
SSRS.MobileReportPublisher.Installer.msi
Date Published:
9/22/2016
File Size:
25.3 MB

System requirements:
Supported Operating System
Windows 10 , Windows 7, Windows 8.1
.NET Framework 4.5 (or later)
Visual C++ Redistributable for Visual Studio 2012 (x86)

Download SSMRP here:
https://www.microsoft.com/en-us/download/details.aspx?id=50400

Friday, March 31, 2017

What was the fix for the DVD drive that disappeared?

Quite a long time ago I reported in my post regarding the loss of DVD drive. I use the DVD very infrequently and it was on the back burner. Finally I decided to get to the bottom of it and succeeded. Here is the result.

In the Device Manager I could see that the DVD device was not working properly as reported in the previous link. The Toshiba, TSST Corp CDDVDW SU-208DB drive was not working and the DVD drive was not seen in the Windows Explorer. The properties of the problematic drive appeared as shown with the Code 19 error (image from the above post).


Finally I came across this Toshiba support site here.

Interestingly this page does not say anything about Windows 10 but describes the fix for Windows 8
My problem started when Windows 10 anniversary update was made and the DVD stopped working from that time.

The fix for this problem consisted of removing two of the programs from the Control Panel|...|Programs and Features shown here:

Toshiba Recovery Media Creator
Toshiba Disk Creator


and also uninstall the DVD\CD_ROM Drives element in the Device Manager.

I did not have the Toshiba Disk Creator, but I uninstalled the TOSHIBA Recovery Media Creator and the DVD/CD-ROM drives in the Device Manager.

These are as shown in the screen shots:


DVD-000


DVD-001

And now after restarting the computer I can see the DVD drive in the explorer.



Wednesday, March 29, 2017

What is a dual-band router?

A dual-band router is a router that has two bands.

For example, the Arris router used by subscribers to Time Warner Oceanic service provider uses the service provider provided router that two has bands, 2.4 GHZ and 5 GHz.

A typical dual-band router has an administration panel shown here:

 You can see that you can have separate settings (password, encryption, etc.) for the 2.4 GHz and 5 GHZ bands that this router can provide.

You can have devices working with either of these two bands or both. For example one or two of desktop works on 2.4 GHZ and my Lumia 950 on 5 GHZ.
My Samsung TV works on the 2.4GHZ as well.

If want to utilize the full power of bandwidth, or have multiple devices that depend on Wi-Fi it may be better to go to dual-band router although they may cost higher.

Tuesday, March 28, 2017

Are there tools to look at financial information of the stock market in R?

I read a very illuminating article on R-Bloggers which was originally published on R-Curtiss Miller's Personal Website (https://ntguardian.wordpress.com/2017/03/27/introduction-stock-market-data-r-1/).

Ever since Microsoft SQL Server began supporting R in its 2016 version, I got interested in R language. It is extremely rich with wide applicability from Astronomy(http://www.astro.umd.edu/~harris/r/index.html) to Zoology(https://www.zoology.ubc.ca/~schluter/R/data/) and everything in between.

Financial information from Yahoo as the source, the packgae 'quantmod' brings with it most of the useful financial information about stocks. quantmod gets data from Yahoo Finance and Google Finance plus from other sources.

In order to work with financial data you should download the package which can done as shown:
------------
> # Get quantmod
> if (!require("quantmod")) {
+     install.packages("quantmod")
+     library(quantmod)
+ }
Loading required package: quantmod
Installing package into ‘C:/Users/Jayaram/Documents/R/win-library/3.2’
(as ‘lib’ is unspecified)
--- Please select a CRAN mirror for use in this session ---
also installing the dependencies ‘xts’, ‘zoo’, ‘TTR’
[ I chose the CRAN site in California ]
trying URL 'https://cran.cnr.berkeley.edu/bin/windows/contrib/3.2/xts_0.9-7.zip'
Content type 'application/zip' length 662188 bytes (646 KB)
downloaded 646 KB

trying URL 'https://cran.cnr.berkeley.edu/bin/windows/contrib/3.2/zoo_1.7-14.zip'
Content type 'application/zip' length 905140 bytes (883 KB)
downloaded 883 KB

trying URL 'https://cran.cnr.berkeley.edu/bin/windows/contrib/3.2/TTR_0.23-1.zip'
Content type 'application/zip' length 432456 bytes (422 KB)
downloaded 422 KB

trying URL 'https://cran.cnr.berkeley.edu/bin/windows/contrib/3.2/quantmod_0.4-7.zip'
Content type 'application/zip' length 473601 bytes (462 KB)
downloaded 462 KB

package ‘xts’ successfully unpacked and MD5 sums checked
package ‘zoo’ successfully unpacked and MD5 sums checked
package ‘TTR’ successfully unpacked and MD5 sums checked
package ‘quantmod’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
        C:\Users\Jayaram\AppData\Local\Temp\RtmpOIHqF6\downloaded_packages
Loading required package: xts
Loading required package: zoo

Attaching package: ‘zoo’

The following objects are masked from ‘package:base’:

    as.Date, as.Date.numeric

Loading required package: TTR
Version 0.4-0 included new data defaults. See ?getSymbols.
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called ‘quantmod’
2: package ‘quantmod’ was built under R version 3.2.5
3: package ‘xts’ was built under R version 3.2.5
4: package ‘zoo’ was built under R version 3.2.5
5: package ‘TTR’ was built under R version 3.2.5
---------------
Once it is installed. You can set up start and end dates variables for viewing your stocks like in:
start<- as.date="" br="">end <- as.date="" br="">
With these defined, you can get the Apple's stock price using its ticker symbol AAPL using the functions in the package as shown obtaining data from the Yahoo source.
> getSymbols("AAPL", src="yahoo", from=start, to=end)
To view the data just run the statement
head(AAPL)

Thursday, March 23, 2017

How do you set up the DMZ on your router?

You may want to place one of your computers behind the firewall temporarily outside the firewall for troubleshooting purposes. Keeping a computer outside the firewall is not good practice except temporarily for troubleshooting.

In order to do this you need access to your router's IP Address. In most home computers connected to the Internet via a router, this address is http://192.168.0.1.

On my Arris router supplied by Oceanic Time Warner, I can go to the DMZ page directly by entering the router address as shown:




DMZ.png

Of course you need the username and password, which you can get from the service provider.

All you need to do is indicate which of the Internal computers behind the firewall goes to the DMZ. The settings of DMZ will have both a Public IP (WAN IP) as well as an Internal (Private IP). Note that all the ports on the computer in the DMZ can be attacked by hackers.