Where Learning is Pleasure

Jayaram Krishnaswamy

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


Top Stories by Jayaram Krishnaswamy

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 alsoinstalled on the same machine. For these steps it is assumed that the SQL Server is up and runningand 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_ODBC4. Choose Use a connection embedded in my report5. Select connection type: click handle and choose ODBC at the bottom of list6. Click Build... to bring up the Connection properties window7. In the Data source specification section choose Use connection string:8. Click the Build... button that gets act... (more)

Map with Microsoft Excel

Excel provides excellent, easy-to-use MAP element that can be inserted into an Excel spreadsheet. It is easily accessed from the Insert menu item as shown. Of course your data must have geographical data. Let us get some data into a work sheet. Click create Data and use the option to get from the Web. Let us use some data from Wikipedia which in turn shows data from Indian census. Let us use the Basic option. Click OK. You will get the next window that you are accessing the web content anonymously. Click Connect. The connector starts connecting to the Demographics of India source. ... (more)

Power BI and OLE DB Provider MSDASQL

Power BI does not support the Microsoft OLEDB Provider for ODBC Drivers also known as MSDASQL. Power BI uses the .NET Framework Data Provider of OLEDB (System.Data.OLEDB).This was found while connecting Power BI to Microsoft Excel using the connection string developed using a (Universal Data Link) UDL file.----------[oledb]; Everything after this line is an OLE DB initstringProvider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel7_11;DBQ=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam_old.xls;DefaultDir=C:\Users\Owner\Desktop\Blog2017\MSSS2017;DriverId=104... (more)

Do we live in a civilized world?

Somethings should not be reversed especially those that affects nature and environment. Fine the perpetrators such as the one shown here.What kind of sickness is this, killing helpless animals. Shame on you! Video source http://time.com/5028798/elephant-hunting-trophy-zimbabwe/ ... (more)

Which one you want CEO or CDO?

What we more importantly need is a CDO. CDO is Chief Data officer(DBA in disguise?) who can mesmerize your customers with the infinite possibilities of data analytics. Well, you also need a CAO, the Chief Analytics Officer. Here is a play on the anagrams from Gannet. ... (more)