Where Learning is Pleasure

Jayaram Krishnaswamy

Subscribe to Jayaram Krishnaswamy: eMailAlertsEmail Alerts
Get Jayaram Krishnaswamy: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Latest Blogs from Jayaram Krishnaswamy
This is the final part of our visit to Rome. With this we will have seen the major attractions of Rome. We left out hotel after the lunch and rest.The visitors are scheduled with assigned time slots and ours was 5:00 PM to 7:00 PM. We could walk to Borghese from our hotel. It took perh...
pyodbc is an open source Python module that simplifies accessing ODBC databases. It implements the DB API 2.0 specs and has been filled with Python related items.Connecting to SQL Server (SQL Server 2016 Sp2) is easy as long as you get the needed items correctly.Review the following li...
This application is not working and I am not sure if this is a new Microsoft Feature.You try to do a vertical scroll, the sheet scrolls horizontally. You cannot type into certain cells as the mouse refuses to enter. I have to go to the top where you find cell reference to get to t...
Here is what I am going to do.Here is a query that retrieves FirstName, LastName, City from Employees table in the Northwind database on my SQL Server 2016 SP2 named instance OHANA.Use NorthwindGoSELECT FirstName, LastName, CityFROM EmployeesNow I will apply a datamask to the FirstName...
This was part 2 of our visit to Rome and after visiting the Forum, we got into the bus and arrived at the entrance to the Colosseum. Colosseum and the Forum are not too far apart.Colosseum also known as Flavian Amphitheatre was constructed between AD72-AD 96, the largest of its kind wi...
Based on the table design using SQL Server Management Studio, v17.7, the following data types can be identified. These are the ones you find in SQL Server 17 as well.Data types (text,ntext, image) continues to be present although Microsoft has been saying that they will be deprecated i...
If the table belongs to a database, then in the context of the database run the query:SELECT * FROM sys.columnsIf the column(s) is masked you should look for the column 'is_masked' in the response as shown.Here is an example. The FirstName column in the Employees table in Northwind dat...
PowerShell is very well supported in SQL Server and it is true with the latest version as well.What you begin with in Power Shell depends on from where it is invoked in the SQL Server Management Studio.You can invoke (or start) PowerShell from various objects and it will be contextual ...
There have been many versions of SQL Server released over a long period of time and of course these are followed up by Service Packs (SP). It is hard to know which version is going to be installed. There is an unofficial chart lists of all the known SP;s, Cumulative Updates(CU), patche...
I am not sure where Google gets it data for the analytics of its own pages on the Blogger but I fail to see why it is so differently displayed. Is there some kind of filtering at some point.Here is an example from my site http://hodetenk.blogspot.com
I had the earlier version 15.5.6. In a way, I was forced to upgrade to the next higher 15.5.7.The Visual Studio 2017 community has the link to Visual Studio Installer and makes it very easy to install.This is the program I have after upgrade;The installer presents you with number of op...
I tried to create a UWP project in Visual Studio 2017 and I got this surprise.empty_0I got this message when I tried to open an existing Project.empty_1Looks like Microsoft forced an update. Anyway, I needed one and clicked Update.The Visual Studio Installer came up and this takes some...
The entry you make in a text box control is of data type text and sometimes you need to format it as a currency with thousands separator while displaying.Also, if the number of decimal places you enter is more than 2, you need to round it up to 2 in the output.How do you code this in a...
In an earlier post getting data from WEB  was described which used Indian demographics data.In this post some analytics information will be added to the display using built-in analytic capabilities of Power BI.Here is the WEB retrieved data from the link mentioned earlier.Analytic...
September 24It was another fine day in Rome. We finished our breakfast as usual and we were out of the hotel waiting to board the bus to take us round Rome.Our itinerary for the day was huge and ambitious. However, we were able to complete the task with relative ease. Thanks to our loc...
Power BI is the Microsoft product for business intelligence. SQLite is well known for its use in mobile platforms and embedded apps.Get Power BI Desktop from here.There is no native way of connecting to SQLite using Power BI, but you could use the ODBC driver which was described in an ...
Arduino Create is a web based platform which you can use to connect, create, and colloborate to work with Arduino and related products.This online platform (you will need to create username/password) enables Makers and Professional Developers to:Write codeAccess contentConfigure boards...
You might have created a ODBC DSN's connecting to your various data sources and you may want to vrify they are doing what they are intended for before you are using them in some of your applications.The ODBC test tool is invaluable to you to verify your ODBC DSN's. Here is a guide to w...
ODBC is a easy way to connect to a database assuming an ODBC driver exists. There are ODBC drivers for SQLite available depending on the OS you are using.Please go to this site  to download your ODBC driver for SQLite.The current version are as described in my previous post. Downl...
On April 27th the exhibition closes. It is an unique event with exhibits by all those who participate in the Sumie Society of Hawaii.If you cannot make it. you can still see it here:https://youtu.be/7KplR7ZdRKAThe Venue :The following were randomly chosen. The YouTube video has most of...
WING is Nokia's worldwide IoT network grid. WING is a managed service that helps to get Network Service Providers(CSPs) to go to market supporting the myriad IoT opportunities quickly. A grid around the world helps to connect IoT assets and IoT consumers.Here is a short list of what WI...
I will be describing two aspects of the design. The first one deals with providing adequate space between textboxes when you have more than one. The second deals with designing textboxes so that they have the same style regarding back gorund color: font size and font family.Controlling...
SQLite is the right relational daatabase with zero configuration for mobile apps. There is a recipe in Microsoft documentation on using a SQLite database in a UWP app. This should be quite straight forward given a recipe but there are problems. Probably because of a plethora of version...
In a previous post I described an error wherein the C++ Windows Console Application failed to load. Visual Studio Community 2017 also failed to open a previous C++ Windows Console Application project (created two days earlier). There was no problem with C# programs.Well, the reaso...
Trying to create a C++ Windows Console Application brings up this error. I could create a project without an error two days ago. The only thing that has changed is that there was on OS build upgrade yesterday.Microsoft Visual Studio Community 2017 Version 15.5.7 on Windows 10 Pro, Vers...
If you do not find the template for Console Application in Visual Studio 2017 Community's New Project window, read this here.Launch VS 2017 Community and click New Project and expand the Visual C++ and Click Windows Desktop as shown. Provide a name, herein CplusDektop_1 and click OK. T...
There is no need to panic. Visual Studio 2017 Community has a fine-grained installer. It is possible that you missed choosing the required programs. Your New Project looks like this now.There are no templates in the above window. There is a link, Open Visual Studio UI shown in the abov...
Yes, you can. However you have to reference the Regex class (System.Text.RegularExpressions) as shown in this image.After this you can use its objects and you have intellisense to provide you help in coding.The Syntax for using RegularExpressions is:Match match = Regex.Match(InputStr, ...
I am using Python Shell from Python 3.7 download from my previous post. The OS is Windows 10 Insiders' Preview 17127.rs4_release.180318-0047Python 3.7.0b2 (v3.7.0b2:b0ef5c979b, Feb 28 2018, 01:32:48) [MSC v.1912 32 bit (Intel)] on win32IDLE is Python’s Integrated Development and Learni...
Looks like a trick question.There is no Array in Python but an object List exists which can be used to the same end.The List may contain different list items or same kind of list items.The List is indexed and zero based. The first list item has an index 0.You can retrieve list items us...
TableSample clause started with SQL Server 2015 limits the number of rows returned from a table to a sample % or sample numbers. In fact, it may not provide the specified rows of %. Also, it is not for tables with too few rows.Here is how TableSample is defined in the MSDN site:-------...
It is the same as a .NET array. In .NET System.Array is based on System.Object. Working with arrays in Power Shell is somewhat easier than in C#.Assigning as Array. $ stands for a variable.You assign the array to a variable 'flowers' as shown above. When you call the variable the ...
SplitView Class in XAML provides us with two views, one for Main content and the other, a Pane that can be used for navigation.This is the inheritance chain:DependencyObject |  UIElement | Framework Element | Control |SplitViewAn Example using Visual Studio Communit...
You may need to display an image stored in the asset of your UWP project from another control's event handler.Let us take the simple example of a button click event displaying an image stored in the project's Asset folder on the page.At a minimum we create a UWP Blank project. Then we ...
Yes, in a big way. Just the Intellisense support may by itself a great help.You need to install PTVS (Python Tools for Visual Studio) to have Python support in Visual Studio (2017,2015, 2013 and earlier). In Visual Studio 2015 you need a Python Interpreter (Python 3.5 or earlier, 3.6 a...
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 r...
In my previous post, I showed how ArcGIS map may be embedded in a Power BI report using the ArcGIS Map Control in Power BI. It is easy to embed and author a report easily.I had used US Census data for the Hawaaiian Islands' water and land areas mapped to the Hawaiian Islands. However, ...
Power BI has an ArcGIS Map Control. This post shows how you may use it. The example of using publicly available data (Census Data: Hawaiian Islands) to be displayed in the ArcGIS Map inside Power BI.Just watch the video:
Read this summation of an article in the Associated Press today,https://www.msn.com/en-us/news/politics/trump-wildlife-protection-board-has-many-trophy-hunters/ar-BBKj82K?li=BBmkt5R&ocid=spartandhpIn case you missed it, here is a gist."A review by The Associated Press of the backgr...
SmartCity, SmartHome, Smart... has entered out vocabulary in increasing frequency. Recently Home Automation has picked up a lot of traction with multiple players. It is important to know how these automation products get their connectivity for control. Some of the main connectivity opt...