Announcing the JDBC Driver 6.4 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 6.4 for SQL Server! The 6.4 Release To World (RTW) adds support for the following: Java 9 along with some methods from the JDBC 4.3 API specification Caching prepared statement metadata (enabled via connection properties) SQLVariant data type in table queries, bulk…


How to set up an MS Bot and integrate it within Microsoft Teams

How you create the Bot from the Azure portal  Log into the Azure Portal – https://portal.azure.com  SelectNew > Bot Service (preview) 3. Create the Bot and add the required information Select  ‘Create’, then the Azure portal dashboard will load  Navigate to the Bot via the alert and select ‘Go to resource’. Select the ‘Create Microsoft App ID and password’. When creating the ID make sure you take a copy of it when the dialogue box opens. Copy the app id and password to the Azure portal browser window. Choose a language. At current the two Options are C# or NodeJS. Let’s select C#. Then select the Question and Answer template. Agree to the T&Cs and select ‘Create Bot’. In a dialogue box select ‘Create a New Knowledge Base’ in the drop-down. How to add the Bot that has been created into teams.  Navigate to the bot in the Azure portal and navigate to the Channels tab. This shows all the supported channels that the Bot can be added to. Let’s choose MS Teams channel. Select the team’s icon and click Done. The Microsoft Teams now appears under connect to channels section. 2. Click the Microsoft Teams Text.  If you use Chrome select ‘Open Microsoft Teams’. The bot will then open in MS Teams. The bot only currently responds to a singular input.  How to train the bot to be more intelligent and add different responses and questions.  Open the Microsoft QnA Maker, navigating to https://qnamaker.ai/Home/MyServices   Select your Bot.  Select the pen icon to edit the bot. This will open the Bot service up….


The Hitchhiker’s Guide to the Quantum Computing and Q# Blog

Lost? Confused? Don’t know where to start with all this quantum computing stuff? Don’t panic! This post is intended to function as a start page/guide to help you navigate your way through the various quantum computing and Q# posts hosted here on the Faculty blog (https://aka.ms/faculty). Q# is Microsoft’s new quantum-focused language, designed to bring…


Another Windows 10 version overview

This overview combines information from different TechNet/Blog/Support pages to have the most interesting values in one table. I will maintain this page from time to time. However, it could happen that some values are outdated. If so, please leave a comment and I will update the table. Therefore, always check the last modified date. Note,…


Microsoft Teams – Log in, log out and log out again

Start teams by clicking on the app and your windows login is being recognised. This will give you background process for teams and the teams app as you might expect! The Quit and the Log out options both will end the back ground process, but the log out will restart it for you so that you can login. Get the login window that gives you the option to login. This now also gives you the option to login to a different tenant.


Windows Service hosting ASP.NET Core Web API

Visual Studio 2017 project to demo how to host a Web API or WebSockets server locally as a Windows Service. Possible uses: – Replace ActiveX dependencies blocking the migration to modern browsers. – Use as REST wrapper for legacy 32- or 64-bit DLLs. – Access local system information such as registry keys or software versions…


How to edit SharePoint Metadata inside of the Office Documents

STEP 1: UPLOAD AND TAG A DOCUMENT The document has to exist in the SharePoint document library. Upload and tag a document by using a Document Information Panel within a modern document library. STEP 2: OPEN THE DOCUMENT Open the document with the Word/Excel/PowerPoint application, not using Office Online.  STEP 3: OPEN THE PROPERTIES PANEL Click on Info Tab, next click on Show All Properties All of the SharePoint document library metadata exists in your document. STEP 4: MAKE METADATA CHANGES For example, you need to change a Status from Pending to Submitted and save the document back to SharePoint by clicking Save button in Word/Excel/PowerPoint. STEP 5: CHECK REVISED METADATA IN SHAREPOINT In SharePoint another version of the document was created, check the Document Information Panel It works if you download a document from a SharePoint document library and start working on it offline.


Visual Studio Toolbox: Syncfusion

In this episode, I am joined by Daniel Jebaraj of Syncfusion, maker of more than 800 UI controls and frameworks spanning both .NET and JavaScript platforms. Daniel shows several Xamarin.Forms controls, including Chart, DataGrid and Excel, to give you an idea of how easy they are to integrate into your apps. He also shows Metro…


PowerShell for Programmers: How to write a function the right way

Just like I mentioned in my first post, PowerShell supports a lot of stuff that makes it pretty easy to dive in and get stuff running. The following two examples are supported in PowerShell, but not something you should really be doing for any reusable tool set. Putting your parameters (arguments) next to the function…

6

7 reasons you cannot find the documents in a SharePoint document library

REASON 1: Unique security and permissions set  If files and folders have unique security and permissions set at file or folder level, they are not visible to anyone else.   Check unique permissions at the folder level:  click the checkbox next to a file or folder  click on the “i” Document Information Panel   There you can see who has access to the given file or folder.  click Change permissions, add/remove users REASON 2: VIEW FILTERING  Files are filtered out via a view. Also, check default views in SharePoint lists and libraries. REASON 3: REQUIRED METADATA AND CHECK-OUT FEATUR  One of the reasons for missing files is settings some of the metadata.  For example:  You can upload but not tag files if you set some of the metadata columns to “required” in the document library or if you drag and drop multiple documents into the library with required columns. The files will be checked out since required metadata fields are not complete. REASON 4: CONTENT APPROVAL FEATURE  Content Approval feature, which allows to see uploaded and revised files revised to those who uploaded them,  is enabled. REASON 5: SEARCH INDEXING  If indexing is turn off at the library or Site level, the files are not searchable/discoverable via the search box, but it won’t make the files “disappear” from the document library.  Check whether or not indexing is on or off:  Library Level  Document Library Settings > Advanced Settings > Search Site Level  Site Settings > Search and Offline Availability (under Search)…