This article is contributed. See the original author and article here.
(English)
These last weeks we got several cases that our customers reported that they need to identify the query that is taking time and they are not able to find it. In this video recorded in Spanish we covered several techniques to identify it.
For example, in .NET we have the option to debug our application using instrumentation to know the time spent. You could use it in combination with StopWatch, Query Data, SQL Server Management Studio and the Portal.
I hope that you could enjoy this video in spanish. This session was recorded in NetCoreConf event this last 2nd Oct 2020.
(Spanish)
Estas últimas semanas hemos tenidos casos de soporte que nuestros clientes solicitan identificar la query que está tomando mucho tiempo en ejecutarse. En este video en español vamos a revisar ciertos técnicas que nos permitirán encontrarlo.
Por ejemplo, en .NET tenemos una opción para depurar nuestra aplicación usando la instrumentación que nos permite conocer los tiempos invertidos en cada proceso. Esto se puede usar en StopWatch, Query Data, SQL Server Management Studio, Portal, etc.
Espero que lo encuentres interesante. Esta session fue grabada en el evento NetCoreConf de este pasado 2 de Octubre 2020.
This article is contributed. See the original author and article here.
These last weeks we got several cases that our customers reported the following error message: Login timeout expired – A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, in the following video I would like to share with you what is the issue, how to identify, fix and prevent it.
This article is contributed. See the original author and article here.
Currently, there are115+ million Teams daily active users. That is millions of new users that developers can reach when they develop apps for Teams. A huge number of academic institutions world wide are now utilizing Microsoft Teams.
A huge number of academic institutions world wide are now utilizing Microsoft Teams. A number of institutions including University College London have included the development of Teams apps into their courses and curricula ranging from Bots to native app. So if your trying to inspire and educate the developers of future. Let us share how to create engaging and unique application experiences on Teams. In this two-hour livestream onLearn TV.
On Dec 16th 2020 join our Microsoft team for a free two-hour livestream event for developers by developers. Let’s talk app dev for Microsoft Teams.
Attendees will gain the following insight and knowledge
• Why you should consider building apps for Teams • How to get started building apps for Teams in VS Code • Where you can integrate your apps in the Teams user experience
The students will be using Microsoft Teams to showcase the remote computer science class of the future. Students will be using remote learning to program a robot which uses a Machine Learning Model based on http://Lobe.ai to detect and identify Pokémon Energy Card using a robot. All the collaboration will be done over teams and the rover programmed with .NET using Microsoft Teams and .NET interactive using a Microsoft Bot.
As you can see the students simply interact via the Rover Bot within Microsoft teams
This article is contributed. See the original author and article here.
As many of you may know I run the Glasgow Azure User Group, and over the last three years I’ve had the privilege to hear a good number of excellent speakers deliver their sessions at the group’s meetups. Recently Tricia Sinclair, delivered a brill session going into Azure DevOps Boards. Something I use daily, but don’t even scratch the surface of functionality wise. So, Tricia’s session opened a whole new world to me.
This plug in is part of the Azure DevOps Office Integration 2019 feature that allows non-developers to interact with Azure DevOps. Now I don’t believe this tool is only for non-developers, I think it can help everyone that needs to interact with DevOps Boards.
To get to work with this feature you need to have Excel 2010 or later installed, the plug, be a member of the project you want to interact with, have the relevant permissions to modify items in the project you want to interact with and of course be using Azure DevOps. For a full list of prerequisites please do check out the official documentation.
Use Excel to create items in Azure DevOps Boards
Using Azure DevOps Boards to keep track of work items, bugs, whatever it might be is an awesome way to create visibility for you and your team, however, it can be a bit tiresome entering a bunch of those things at a time. And being able to bulk load would be handy and this is what the plugin allows you to do!
Once you install the plug in when you open Excel, you have a tab called Team, which allows you to connect with Azure DevOps within Excel.
So, if you have a new Azure DevOps Project and want to bulk import a bunch of tasks for the team to work through you can do that by connecting Excel to the Project and starting the list.
Create a new DevOps List from Excel
You can also do this if you have new tasks or bugs or issues, to add to an existing project. And I will be using this feature in the future to track my work, especially when I’ve been neglecting my duties and not adding my tasks to the team board.
Update items from Excel to your Azure DevOps Board
What about updating items, you can do that as well. Which again allows you to create items, update items, add more information to items. All of that is available.
The best way I have found to bulk update tasks on an existing project is to have a query setup that pulls the items I want to update and then use that to help pull the information into Excel.
Opening up the plug in within Excel, this time I tell it I want to pull the information from the query.
Pull information from DevOps into Excel
Once the information is pulled down I can update the items that I need to, either bulk closing items, or reassigning the items to others.
It’s also a great opportunity to link any items together using the “Links and Attachment” button or even uploading any supporting information for that item.
Add files to your DevOps Items
Speed up those admin tasks
As I said at the top of this blog post I don’t think this is something only for non-developers I think this is a great tool for everyone, if you set aside time at the end of your week to go through and update your Azure DevOps Board this can help speed things up. I’d love to hear if you are using this plugin and if it’s helping to speed up the management of your items or not!
Recent Comments