{"id":222,"date":"2009-01-13T11:22:00","date_gmt":"2009-01-13T10:22:00","guid":{"rendered":"http:\/\/www.tsls.co.uk\/?p=222"},"modified":"2026-03-11T10:41:39","modified_gmt":"2026-03-11T10:41:39","slug":"remove-stuck-messages-in-biztalk-2004","status":"publish","type":"post","link":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/","title":{"rendered":"Remove stuck messages and purge messages in BizTalk 2004"},"content":{"rendered":"

note:<\/strong> this will remove everything and should be tested in a UAT environment first.<\/p>\n

If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following:<\/p>\n


\n-- Stop Receive Locations
\n-- Stop BizTalk Service (all Nodes)
\n-- Make Sure HAT is cleared of all messages (apart from the stuck messages)
\n-- Drop BTS views
\nuse biztalkdtadb exec dtasp_DropViews
\nGO
\n-- Truncate tables dta
\nuse biztalkdtadb TRUNCATE TABLE dta_ServiceInstances
\nuse biztalkdtadb TRUNCATE TABLE dta_MessageInstances
\nuse biztalkdtadb TRUNCATE TABLE dta_MessageFieldValues
\nuse biztalkdtadb TRUNCATE TABLE dta_CallChain
\nuse biztalkdtadb TRUNCATE TABLE dta_MessageInOutEvents
\nuse biztalkdtadb TRUNCATE TABLE dta_DebugTrace
\nuse biztalkdtadb TRUNCATE TABLE dta_RulesAgendaUpdates
\nuse biztalkdtadb TRUNCATE TABLE dta_RulesConditionEvaluation
\nuse biztalkdtadb TRUNCATE TABLE dta_RulesFactActivity
\nuse biztalkdtadb TRUNCATE TABLE dta_RulesFired
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Spool1
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Parts1
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Fragments1
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Spool2
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Parts2
\nuse biztalkdtadb TRUNCATE TABLE Tracking_Fragments2
\nuse biztalkdtadb TRUNCATE TABLE dta_serviceinstanceexceptions
\nGO
\nuse biztalkdtadb exec sp_updatestats
\nGO
\n-- Recreate the views
\nuse biztalkdtadb exec dtasp_CreateMessageFactsFindMsgViews
\nuse biztalkdtadb exec dtasp_CreateRealNamesView
\nuse biztalkdtadb exec dtasp_CreateServiceFactsView
\nGO
\n-- Truncate MsgBox
\nuse biztalkMsgBoxdb exec bts_cleanupmsgbox
\nuse biztalkmsgboxdb exec sp_updatestats
\nGO
\n-- shrink log
\nBACKUP LOG biztalkdtadb WITH TRUNCATE_ONLY
\nBACKUP LOG biztalkmsgboxdb WITH TRUNCATE_ONLY
\nGO
\ndbcc shrinkdatabase (BizTalkDTADb, 10)
\ndbcc shrinkfile (BizTalkDTADb_log, 10)
\nGO
\ndbcc shrinkdatabase (BizTalkmsgboxDb, 10)
\ndbcc shrinkfile (BizTalkmsgboxDb_log, 10)
\nGO
\n-- Confirm that the tables are empty
\n\/*
\nuse biztalkdtadb select * from dta_ServiceInstances
\nuse biztalkdtadb select * from dta_serviceinstanceexceptions
\nuse biztalkdtadb select * from dta_CallChain
\nuse biztalkdtadb select * from dta_MessageInstances
\nuse biztalkdtadb select * from dta_MessageFieldValues
\nuse biztalkdtadb select * from dta_MessageInOutEvents
\nuse biztalkdtadb select * from dta_DebugTrace
\nuse biztalkdtadb select * from dta_RulesAgendaUpdates
\nuse biztalkdtadb select * from dta_RulesConditionEvaluation
\nuse biztalkdtadb select * from dta_RulesFactActivity
\nuse biztalkdtadb select * from dta_RulesFired
\nuse biztalkdtadb select * from Tracking_Spool1
\nuse biztalkdtadb select * from Tracking_Parts1
\nuse biztalkdtadb select * from Tracking_Fragments1
\nuse biztalkdtadb select * from Tracking_Spool2
\nuse biztalkdtadb select * from Tracking_Parts2
\nuse biztalkdtadb select * from Tracking_Fragments2
\nuse biztalkMsgBoxdb select * FROM Spool
\nuse biztalkMsgBoxdb select * FROM MessageParts
\nuse biztalkMsgBoxdb select * FROM MessageZeroSum
\nuse biztalkMsgBoxdb select * FROM Tracking_spool1
\nuse biztalkMsgBoxdb select * FROM Tracking_spool2
\nuse biztalkMsgBoxdb select * FROM Tracking_parts1
\nuse biztalkMsgBoxdb select * FROM Tracking_parts2
\nuse biztalkMsgBoxdb select * FROM Tracking_fragments1
\nuse biztalkMsgBoxdb select * FROM Tracking_fragments2
\nuse biztalkMsgBoxdb select * FROM trackingdata
\nuse biztalkMsgBoxdb select * FROM messagerefcountlogtotals
\nuse biztalkMsgBoxdb select * FROM partrefcountlogtotals
\nuse biztalkMsgBoxdb select * FROM instances
\nuse biztalkMsgBoxdb select * FROM instancespendingoperations
\nuse biztalkMsgBoxdb select * FROM instancestatemessagereferences_biztalkserverapplication
\n*\/
\n-- Open HAT and remove any other messages
\n-- Start Biztalk on one node
\n-- Enable 1 recieve location and confirm that the message goes through
\n-- Start all Reclocations and confirm that the message goes through
\n-- Start all other BTS nodes
\n<\/code><\/p>\n

\/*
\n–\/ script to create bts_cleanupmsgbox if it does exist (biztalk 2004 sp1 or above)
\n–\/ script can be found in Microsoft Biztalk Program FilesMicrosoft BizTalk Server 2004Schemamsgbox_cleanup_logic.sql<\/p>\n

–\/ Copyright (c) Microsoft Corporation. All rights reserved.
\n–\/
\n–\/ THIS CODE AND INFORMATION IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND,
\n–\/ WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED
\n–\/ WARRANTIES OF MERCHANTABILITY AND\/OR FITNESS FOR A PARTICULAR PURPOSE.
\n–\/ THE ENTIRE RISK OF USE OR RESULTS IN CONNECTION WITH THE USE OF THIS CODE
\n–\/ AND INFORMATION REMAINS WITH THE USER.
\n–\/
\n——————————————————————————
\nif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bts_CleanupMsgbox]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1)
\ndrop procedure [dbo].[bts_CleanupMsgbox]
\nGO<\/p>\n

CREATE PROCEDURE [dbo].[bts_CleanupMsgbox]
\n@fLeaveActSubs int = 1
\nAS<\/p>\n

set nocount on
\nset transaction isolation level read committed<\/p>\n

declare @tnActiveTable tinyint<\/p>\n

–Clean up simple tables
\ntruncate table ConvoySetInstances
\ntruncate table Fragments
\ntruncate table MessageParts
\ntruncate table MessagePredicates
\ntruncate table MessageProps
\ntruncate table Parts
\ntruncate table MessageRefCountLog1
\ntruncate table MessageRefCountLog2
\ntruncate table MessageRefCountLogTotals
\ntruncate table PartRefCountLog1
\ntruncate table PartRefCountLog2
\ntruncate table PartRefCountLogTotals
\ntruncate table MessageZeroSum
\ntruncate table PartZeroSum
\ntruncate table Spool
\ntruncate table Instances
\ntruncate table InstancesPendingOperations
\ntruncate table TrackingData
\ntruncate table ProcessHeartbeats<\/p>\n

truncate table Tracking_Fragments1
\ntruncate table Tracking_Parts1
\ntruncate table Tracking_Spool1
\ntruncate table Tracking_Fragments2
\ntruncate table Tracking_Parts2
\ntruncate table Tracking_Spool2
\ntruncate table TrackingMessageReferences<\/p>\n

— Reinserting the Restart message, for use in service recovery
\nINSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)
\nINSERT INTO MessageRefCountLogTotals (uidMessageID, snRefCount) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 1)<\/p>\n

SELECT TOP 1 @tnActiveTable = tnActiveTable FROM ActiveRefCountLog WITH (ROWLOCK REPEATABLEREAD) WHERE fType = 2 OPTION (KEEPFIXED PLAN)<\/p>\n

if (@tnActiveTable = 1)
\nBEGIN
\nif (@fLeaveActSubs <> 0)
\nBEGIN
\nINSERT INTO PredicateGroupZeroSum1 WITH (ROWLOCK)
\nSELECT pg.uidPredicateORGroupID, pg.uidPredicateANDGroupID
\nFROM PredicateGroup pg WITH (ROWLOCK), Subscription s WITH (ROWLOCK)
\nWHERE s.uidInstanceID IS NOT NULL AND
\ns.uidPredicateGroupID = pg.uidPredicateORGroupID AND
\npg.fIsDistributionList = 0
\nOPTION (KEEPFIXED PLAN)<\/p>\n

DELETE FROM Subscription WHERE uidInstanceID IS NOT NULL
\nDELETE FROM UniqueSubscription WHERE uidInstanceID IS NOT NULL
\nEND
\nelse
\nBEGIN
\nTRUNCATE TABLE EqualsPredicates
\nTRUNCATE TABLE EqualsPredicates2ndPass
\nTRUNCATE TABLE GreaterThanPredicates
\nTRUNCATE TABLE GreaterThanOrEqualsPredicates
\nTRUNCATE TABLE LessThanPredicates
\nTRUNCATE TABLE LessThanOrEqualsPredicates
\nTRUNCATE TABLE ExistsPredicates
\nTRUNCATE TABLE BitwiseANDPredicates
\nTRUNCATE TABLE PredicateGroup
\nTRUNCATE TABLE PredicateGroupZeroSum1
\nTRUNCATE TABLE PredicateGroupZeroSum2<\/p>\n

truncate table Subscription
\ntruncate table UniqueSubscription
\nEND
\nEND
\nELSE
\nBEGIN
\nif (@fLeaveActSubs <> 0)
\nBEGIN
\nINSERT INTO PredicateGroupZeroSum2 WITH (ROWLOCK)
\nSELECT pg.uidPredicateORGroupID, pg.uidPredicateANDGroupID
\nFROM PredicateGroup pg WITH (ROWLOCK), Subscription s WITH (ROWLOCK)
\nWHERE s.uidInstanceID IS NOT NULL AND
\ns.uidPredicateGroupID = pg.uidPredicateORGroupID AND
\npg.fIsDistributionList = 0
\nOPTION (KEEPFIXED PLAN)<\/p>\n

DELETE FROM Subscription WHERE uidInstanceID IS NOT NULL
\nDELETE FROM UniqueSubscription WHERE uidInstanceID IS NOT NULL
\nEND
\nelse
\nBEGIN
\nTRUNCATE TABLE EqualsPredicates
\nTRUNCATE TABLE EqualsPredicates2ndPass
\nTRUNCATE TABLE GreaterThanPredicates
\nTRUNCATE TABLE GreaterThanOrEqualsPredicates
\nTRUNCATE TABLE LessThanPredicates
\nTRUNCATE TABLE LessThanOrEqualsPredicates
\nTRUNCATE TABLE ExistsPredicates
\nTRUNCATE TABLE BitwiseANDPredicates
\nTRUNCATE TABLE PredicateGroup
\nTRUNCATE TABLE PredicateGroupZeroSum1
\nTRUNCATE TABLE PredicateGroupZeroSum2<\/p>\n

truncate table Subscription
\ntruncate table UniqueSubscription
\nEND
\nEND<\/p>\n

declare @nvcAppName nvarchar(256)
\ndeclare curse cursor for
\nSELECT nvcApplicationName FROM Applications
\nopen curse
\nFETCH NEXT FROM curse INTO @nvcAppName
\nWHILE (@@FETCH_STATUS = 0)
\nBEGIN
\nexec (‘truncate table [‘ + @nvcAppName + ‘Q]’)
\nexec (‘truncate table [‘ + @nvcAppName + ‘Q_Suspended]’)
\nexec (‘truncate table [InstanceStateMessageReferences_’ + @nvcAppName + ‘]’)
\nexec (‘truncate table [DynamicStateInfo_’ + @nvcAppName + ‘]’)<\/p>\n

FETCH NEXT FROM curse INTO @nvcAppName
\nEND
\nclose curse
\ndeallocate curse<\/p>\n

declare @dbname sysname
\nset @dbname = db_name()
\nBACKUP LOG @dbname WITH TRUNCATE_ONLY<\/p>\n

GO
\n*\/<\/p>\n","protected":false},"excerpt":{"rendered":"

note: this will remove everything and should be tested in a UAT environment first. If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following: — Stop<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[21],"tags":[131,421],"class_list":["post-222","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-131","tag-biztalk"],"jetpack_publicize_connections":[],"yoast_head":"\r\nRemove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_GB\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Remove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith\" \/>\r\n<meta property=\"og:description\" content=\"note: this will remove everything and should be tested in a UAT environment first. If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following: -- Stop\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/\" \/>\r\n<meta property=\"og:site_name\" content=\"TSLS - Luke Smith\" \/>\r\n<meta property=\"article:published_time\" content=\"2009-01-13T10:22:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-11T10:41:39+00:00\" \/>\r\n<meta name=\"author\" content=\"Luke Smith\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/\",\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/\",\"name\":\"Remove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith\",\"isPartOf\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#website\"},\"datePublished\":\"2009-01-13T10:22:00+00:00\",\"dateModified\":\"2026-03-11T10:41:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tsls.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remove stuck messages and purge messages in BizTalk 2004\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tsls.co.uk\/#website\",\"url\":\"https:\/\/www.tsls.co.uk\/\",\"name\":\"TSLS - Luke Smith\",\"description\":\"- Knowledge - Thoughts - Microsoft -\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tsls.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\",\"name\":\"Luke Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"caption\":\"Luke Smith\"},\"description\":\"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint\",\"sameAs\":[\"http:\/\/www.tsls.co.uk\"],\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Remove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/","og_locale":"en_GB","og_type":"article","og_title":"Remove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith","og_description":"note: this will remove everything and should be tested in a UAT environment first. If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following: -- Stop","og_url":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/","og_site_name":"TSLS - Luke Smith","article_published_time":"2009-01-13T10:22:00+00:00","article_modified_time":"2026-03-11T10:41:39+00:00","author":"Luke Smith","twitter_misc":{"Written by":"Luke Smith","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/","url":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/","name":"Remove stuck messages and purge messages in BizTalk 2004 - TSLS - Luke Smith","isPartOf":{"@id":"https:\/\/www.tsls.co.uk\/#website"},"datePublished":"2009-01-13T10:22:00+00:00","dateModified":"2026-03-11T10:41:39+00:00","author":{"@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7"},"breadcrumb":{"@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tsls.co.uk\/index.php\/2009\/01\/13\/remove-stuck-messages-in-biztalk-2004\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tsls.co.uk\/"},{"@type":"ListItem","position":2,"name":"Remove stuck messages and purge messages in BizTalk 2004"}]},{"@type":"WebSite","@id":"https:\/\/www.tsls.co.uk\/#website","url":"https:\/\/www.tsls.co.uk\/","name":"TSLS - Luke Smith","description":"- Knowledge - Thoughts - Microsoft -","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tsls.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7","name":"Luke Smith","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","caption":"Luke Smith"},"description":"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint","sameAs":["http:\/\/www.tsls.co.uk"],"url":"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2gf1k-3A","_links":{"self":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":1,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":6412,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions\/6412"}],"wp:attachment":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}