Enabling SQL Express User

Visual Studio(VS) lovers! Yes, we want to work on everything from within the VS. Yes, of course, our VS have required features to support us to perform various development and ALM operations. Database is one of the main parts of any application development. Instead of working on the database objects using SQL Server Management Studio, we prefer to use VS. Access the database directly from VS using the SQL Server Object Explorer. Moreover, we would like to work with the SQL express instead of connecting to a centralized database server for small project or at the starting of a project.

Read more at https://www.codeproject.com/Tips/1202659/Enabling-SQL-Express-User

 

 

Advertisements
Posted in SQL, Visual Studio | Tagged | Leave a comment

Resuming Writing – First article on Azure Data Lake

After a long time, I am resuming my writings. My current focus area include Azure, DevOps and Bot. You can expect more articles related to these topics in coming days.

My first article, after the long break, talks about Azure Data Lake. First half of the article dealing with Azure AD app creation will be applicable for those who plan to develop external applications talking to Azure resources. Following is an abstract from the article:

Azure Data Lake allows you to rapidly store and ingest data simply whatever its form, and do any type of processing and analysis on it across platforms and languages. It is ideal for batch, streaming and interactive analytics because it provides a unified repository for diverse enterprise data requirements.

There are many ways of uploading the files to Data Lake store, using Azure Data Factory Services, using Azure Data Lake Store .NET SDK, Java SDK, Node, REST API and so on.

Read more at https://www.red-gate.com/simple-talk/cloud/cloud-development/uploading-files-azure-data-lake-using-net-app/

 

 

Posted in Uncategorized | Leave a comment

QnA Maker

The QnA Maker, launched in beta, will let users train an automated conversation partner on existing frequently-asked-questions content. After that information is fed in, the service will create a bot that will respond to customer questions with the content from the knowledge base.

Once the information is loaded into the service, users can then view how the bot has paired up questions and answers and add their own custom questions and responses.

Explored with few FAQ links and documents; excellent service.
https://qnamaker.ai/

Posted in Cognitive Services, Microsoft | Tagged , , | Leave a comment

Excel to XML

Looks Simple ! Yes, even I thought the same. Obviously, excel provides an option to save the data in XML format. Did you tried any time the same ? If so, you may be faced the real challenge in converting excel data into required xml format.

 

I have penned down my experience in an article – https://gooroo.io/GoorooTHINK/Article/17231/Excel-to-XML

Posted in Office | Tagged , | Leave a comment

Continuous Deployment from GitHub to Azure

Integrations ! Integrations are part of every implementations and the hardest area too. There are many kind of integrations required like application integration with an ERP system, authorization of application using AD, and so on.

Growing adoption of DevOps practice introduced a new kind of integration between different ALM tools. We will discuss about few such challenges and solutions in a series of articles.

First in the series discuss about the Continuous Deployment from GitHub to Azure. Please find the article at https://gooroo.io/GoorooTHINK/Article/17161/Continuous-Deployment-from-GitHub-to-Azure

Posted in Azure, DevOps | Tagged , , | Leave a comment