Posts

Showing posts from January, 2017

SQL to Find Umbraco Nodes using a Certain Umbraco Document Type

In order to get the Umbraco nodes which use a certain umbraco Document Type, you can use the following SQL script. You can then simply login to umbraco backoffice and search for the nodeId value in there and find the node that you want.

SELECT*FROM cmsContent C INNERJOIN cmsContentType CT ON C.contentType = CT.nodeId INNERJOIN umbracoNode N ON C.nodeId = N.id WHERE CT.alias ='YourDocumentTypeAlias'

Upgrading from Umbraco Contour to Umbraco Forms: Fix for Could not load type 'Umbraco.Forms.Core.Services.RecordService' from assembly 'Umbraco.Forms.Core, Version=4.3.2.0, Culture=neutral, PublicKeyToken=null'.

Image
If your Umbraco website is already using Umbraco Contour and if you want to upgrade to Umbraco Forms then you might experience "Could not load type 'Umbraco.Forms.Core.Services.RecordService' from assembly 'Umbraco.Forms.Core, Version=4.3.2.0, Culture=neutral, PublicKeyToken=null'." while installing Umbraco Forms.

Please go to this Umbraco Forums url to see how I fixed my problem.

After installing the Umbraco Forms successfully, then you might want to remove Contour items from the Macro Dropdown List. To do that simply go to /Developer/Macros section and delete the Contour items.


That is all, hope this post helps.


















Tracking MS SQL CPU Usage

--T-SQL to identify the Top 20 most costly queries in terms of Total CPU:
SELECTTOP 20     st.dbid, DB_NAME(st.dbid)AS Database_Name,     qs.sql_handle,     qs.execution_count,     qs.total_worker_time AS Total_CPU,     total_CPU_inSeconds =--Converted from microseconds     qs.total_worker_time/1000000,     average_CPU_inSeconds =--Converted from microseconds (qs.total_worker_time/1000000)/ qs.execution_count,     qs.total_elapsed_time,     total_elapsed_time_inSeconds =--Converted from microseconds     qs.total_elapsed_time/1000000,     st.text,     qp.query_plan FROM sys.dm_exec_query_statsAS qs CROSSAPPLYsys.dm_exec_sql_text(qs.sql_handle)AS st CROSSapplysys.dm_exec_query_plan(qs.plan_handle)AS qp ORDERBY qs.total_worker_time DESC
--This shows the number of connections per each DB: SELECT DB_NAME(dbid)as DBName,