by community-syndication | Oct 8, 2013 | BizTalk Community Blogs via Syndication
I had to use the Windows Azure BizTalk Service Cmdlets to start a Bridge source but i kept getting this error; Windows PowerShell Copyright (C) 2012 Microsoft Corporation. All rights reserved. PS C:\Windows\system32> Import-module "C:\Program Files\Windows Azure BizTalk Services SDK\Microsoft.BizTalk.Services.Powershell.dll" PS C:\Windows\system32> Get-AzureBizTalkBridge cmdlet Get-AzureBizTalkBridge at command pipeline position 1 Supply values for the following […]
Blog Post by: mbrimble
by community-syndication | Oct 8, 2013 | BizTalk Community Blogs via Syndication
2013 %u5e74 10 %u6708 9 %u65e5 (%u65e5%u672c%u6642%u9593)%u3001%u30de%u30a4%u30af%u30ed%u30bd%u30d5%u30c8%u306f%u8a08 8 %u4ef6 (%u7dca%u6025 4 %u4ef6%u3001%u91cd%u8981 4 %u4ef6) %u306e%u65b0%u898f%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u3092%u516c%u958b%u3057%u307e%u3057%u305f%u3002%u307e%u305f%u3001%u65e2%u5b58%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3 %u30a2%u30c9%u30d0%u30a4%u30b6%u30ea 2 %u4ef6 (2862973%u30682887505) %u3092%u66f4%u65b0%u3057%u3066%u3044%u307e%u3059%u3002%u306a%u304a%u3001%u4eca%u6708%u306e%u300c%u60aa%u610f%u306e%u3042%u308b%u30bd%u30d5%u30c8%u30a6%u30a7%u30a2%u306e%u524a%u9664%u30c4%u30fc%u30eb%u300d%u3067%u306f%u3001%u65b0%u305f%u306b%u78ba%u8a8d%u3057%u305f 2 %u7a2e%u985e%u306e%u30de%u30eb%u30a6%u30a7%u30a2%u306b%u5bfe%u5fdc%u3057%u3066%u3044%u307e%u3059%u3002
%u304a%u5ba2%u69d8%u306f%u3067%u304d%u308b%u3060%u3051%u65e9%u671f%u306b%u3001%u4eca%u6708%u516c%u958b%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0%u3092%u9069%u7528%u3059%u308b%u3088%u3046%u304a%u9858%u3044%u3057%u307e%u3059%u3002%u4f01%u696d%u306e%u304a%u5ba2%u69d8%u3067%u9069%u7528%u306b%u512a%u5148%u4ed8%u3051%u304c%u5fc5%u8981%u306a%u5834%u5408%u306f%u3001%u3044%u305a%u308c%u3082%u7dca%u6025%u306e%u6b21%u306e 3 %u3064%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831 MS13-080 (Internet Explorer), MS13-081 (Windows %u30ab%u30fc%u30cd%u30eb %u30e2%u30fc%u30c9 %u30c9%u30e9%u30a4%u30d0%u30fc), MS13-083 (Windows %u30b3%u30e2%u30f3 %u30b3%u30f3%u30c8%u30ed%u30fc%u30eb %u30e9%u30a4%u30d6%u30e9%u30ea) %u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0%u3092%u512a%u5148%u7684%u306b%u9069%u7528%u3059%u308b%u3053%u3068%u3092%u63a8%u5968%u3044%u305f%u3057%u307e%u3059%u3002
%u25a0 %u65e2%u5b58%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3 %u30a2%u30c9%u30d0%u30a4%u30b6%u30ea%u306e%u66f4%u65b0 (2 %u4ef6)
%u25a02013 %u5e74 10 %u6708%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u4e00%u89a7
%u5404%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u306e%u6982%u8981%u3001%u5404%u8106%u5f31%u6027%u306e%u60aa%u7528%u53ef%u80fd%u6027%u6307%u6a19 (Exploitability Index)%u3001%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0%u306e%u30c0%u30a6%u30f3%u30ed%u30fc%u30c9%u5148%u306a%u3069%u304c%u3054%u89a7%u3044%u305f%u3060%u3051%u307e%u3059%u3002
http://technet.microsoft.com/ja-jp/security/bulletin/ms13-oct
%u30de%u30a4%u30af%u30ed%u30bd%u30d5%u30c8%u306f%u65b0%u305f%u306b%u78ba%u8a8d%u3057%u305f%u8106%u5f31%u6027%u306b%u3064%u3044%u3066%u3001%u6b21%u306e 8 %u4ef6%u306e%u65b0%u3057%u3044%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u3092%u516c%u958b%u3057%u307e%u3057%u305f%u3002
|
%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831 ID
|
%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u30bf%u30a4%u30c8%u30eb
|
%u6700%u5927%u6df1%u523b%u5ea6
|
%u8106%u5f31%u6027%u306e%u5f71%u97ff
|
%u518d%u8d77%u52d5%u306e%u5fc5%u8981%u6027
|
%u5f71%u97ff%u3092%u53d7%u3051%u308b%u30bd%u30d5%u30c8%u30a6%u30a7%u30a2
|
|
MS13-080
|
Internet Explorer %u7528%u306e%u7d2f%u7a4d%u7684%u306a%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0 (2879017)
|
%u7dca%u6025
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u8981%u518d%u8d77%u52d5
|
Windows XP%u3001Windows Server 2003%u3001Windows Vista%u3001Windows Server 2008%u3001Windows 7%u3001Windows Server 2008 R2%u3001Windows 8%u3001Windows 8.1%u3001Windows Server 2012%u3001Windows Server 2012 R2%u3001Windows RT%u3001%u304a%u3088%u3073 Windows RT 8.1 %u4e0a%u306e Internet Explorer
|
|
MS13-081
|
Windows %u30ab%u30fc%u30cd%u30eb%u30e2%u30fc%u30c9 %u30c9%u30e9%u30a4%u30d0%u30fc%u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2870008)
|
%u7dca%u6025
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u8981%u518d%u8d77%u52d5
|
Microsoft Windows XP%u3001Windows Server 2003%u3001Windows Vista%u3001Windows Server 2008%u3001Windows 7%u3001Windows Server 2008 R2%u3001Windows 8%u3001Windows Server 2012%u3001%u304a%u3088%u3073 Windows RT
|
|
MS13-082
|
.NET Framework %u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2878890)
|
%u7dca%u6025
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u518d%u8d77%u52d5%u304c%u5fc5%u8981%u306a%u5834%u5408%u3042%u308a
|
Windows XP%u3001Windows Server 2003%u3001Windows Vista%u3001Windows Server 2008%u3001Windows 7%u3001Windows Server 2008 R2%u3001Windows 8%u3001Windows Server 2012%u3001%u304a%u3088%u3073 Windows RT %u4e0a%u306e .NET Framework
|
|
MS13-083
|
Windows %u30b3%u30e2%u30f3 %u30b3%u30f3%u30c8%u30ed%u30fc%u30eb %u30e9%u30a4%u30d6%u30e9%u30ea%u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2864058)
|
%u7dca%u6025
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u8981%u518d%u8d77%u52d5
|
Microsoft Windows XP%u3001Windows Server 2003%u3001Windows Vista%u3001Windows Server 2008%u3001Windows 7%u3001Windows Server 2008 R2%u3001Windows 8%u3001Windows Server 2012%u3001%u304a%u3088%u3073 Windows RT
|
|
MS13-084
|
Microsoft SharePoint Server %u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2885089)
|
%u91cd%u8981
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u518d%u8d77%u52d5%u304c%u5fc5%u8981%u306a%u5834%u5408%u3042%u308a
|
Microsoft Windows SharePoint Services 3.0%u3001SharePoint Foundation 2010%u3001Web Applications 2010%u3001Excel Web App 2010%u3001SharePoint Server 2007 %u4e0a%u306e Excel Services%u3001%u304a%u3088%u3073 SharePoint Server 2010 %u304a%u3088%u3073 SharePoint Server 2013 %u4e0a%u306e Excel Services %u304a%u3088%u3073 Word Automation Services
|
|
MS13-085
|
Microsoft Excel %u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2885080)
|
%u91cd%u8981
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u518d%u8d77%u52d5%u304c%u5fc5%u8981%u306a%u5834%u5408%u3042%u308a
|
Microsoft Excel 2007%u3001Excel 2010%u3001Excel 2013%u3001Excel 2013 RT%u3001Office 2007%u3001Office 2010%u3001Office 2013%u3001Office 2013 RT%u3001Excel Viewer%u3001Office %u4e92%u63db%u6a5f%u80fd%u30d1%u30c3%u30af%u3001%u304a%u3088%u3073 Mac 2011 %u7528%u306e Office
|
|
MS13-086
|
Microsoft Word %u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b (2885084)
|
%u91cd%u8981
|
%u30ea%u30e2%u30fc%u30c8%u3067%u30b3%u30fc%u30c9%u304c%u5b9f%u884c%u3055%u308c%u308b
|
%u518d%u8d77%u52d5%u304c%u5fc5%u8981%u306a%u5834%u5408%u3042%u308a
|
Microsoft Word 2003%u3001Word 2007%u3001%u304a%u3088%u3073 Office %u4e92%u63db%u6a5f%u80fd%u30d1%u30c3%u30af
|
|
MS13-087
|
Silverlight %u306e%u8106%u5f31%u6027%u306b%u3088%u308a%u3001%u60c5%u5831%u6f0f%u3048%u3044%u304c%u8d77%u3053%u308b (2890788)
|
%u91cd%u8981
|
%u60c5%u5831%u6f0f%u3048%u3044
|
%u518d%u8d77%u52d5%u4e0d%u8981
|
Mac %u7528%u306e Microsoft Silverlight 5%u3001Mac %u7528%u306eSilverlight 5 Developer Runtime%u3001Windows %u7528%u306eSilverlight 5%u3001%u304a%u3088%u3073 Windows %u7528%u306e Silverlight 5 Developer Runtime
|
%u25a0%u6700%u65b0%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u3092%u52d5%u753b%u3068%u97f3%u58f0%u3067%u307e%u3068%u3081%u3066%u78ba%u8a8d
%u30de%u30a4%u30af%u30ed%u30bd%u30d5%u30c8 %u30bb%u30ad%u30e5%u30ea%u30c6%u30a3 %u30ec%u30b9%u30dd%u30f3%u30b9 %u30c1%u30fc%u30e0%u304c IT %u30d7%u30ed%u306e%u7686%u3055%u307e%u306b%u5411%u3051%u3066%u3001%u77ed%u6642%u9593%u3067%u6700%u65b0%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0%u306e%u77e5%u308a%u305f%u3044%u30dd%u30a4%u30f3%u30c8%u3092%u52d5%u753b%u3068%u97f3%u58f0%u3067%u3054%u7d39%u4ecb%u3059%u308b%u4eca%u6708%u306e%u30de%u30a4%u30af%u30ed%u30bd%u30d5%u30c8 %u30ef%u30f3%u30dd%u30a4%u30f3%u30c8 %u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u60c5%u5831%u306f%u672c%u65e5%u5348%u5f8c%u516c%u958b%u4e88%u5b9a%u3067%u3059%u3002%u3054%u8996%u8074%u3044%u305f%u3060%u304f%u3053%u3068%u3067%u3001%u6700%u65b0%u306e%u30bb%u30ad%u30e5%u30ea%u30c6%u30a3%u66f4%u65b0%u30d7%u30ed%u30b0%u30e9%u30e0%u306e%u9069%u7528%u512a%u5148%u5ea6%u3084%u518d%u8d77%u52d5%u30fb%u56de%u907f%u7b56%u306e%u6709%u7121%u3001%u78ba%u8a8d%u3057%u3066%u3044%u308b%u65e2%u77e5%u306e%u554f%u984c%u306a%u3069%u3092%u307e%u3068%u3081%u3066%u5165%u624b%u3067%u304d%u307e%u3059%u3002Web %u30ad%u30e3%u30b9%u30c8%u516c%u958b%u5f8c%u306b%u3001%u3053%u3061%u3089%u306e%u30d6%u30ed%u30b0%u3067%u3082%u304a%u77e5%u3089%u305b%u3057%u307e%u3059%u3002
Blog Post by: JSECTEAM
by community-syndication | Oct 8, 2013 | BizTalk Community Blogs via Syndication
In the new adapters series I discussed the adapters released with BizTalk Server 2013. I demonstrated the relay adapters (HTTP, NetTcp), Service Bus Messaging, WebHttp (REST) and linked to the TechNet Wiki article on SFTP. I have written a White paper that discusses the BasicHttpRelay more in-depth. You can find it here:
http://go.biztalk360.com/wcf-basichttprelay-adapter/
Cheers,
Steef-Jan
by community-syndication | Oct 6, 2013 | BizTalk Community Blogs via Syndication
DebugDiag is a tool for collecting and analyzing memory dumps. Version 2.0 was just released and makes it extremely easy to write your own custom analysis rules using any language that target the CLR. SPListAnalysis is a sample analysis rule I implemented to show the basic steps involved in the process. The rule does the […]
Blog Post by: Tomas Restrepo
by community-syndication | Oct 6, 2013 | BizTalk Community Blogs via Syndication
I recently returned back from Europe where I had a chance to participate in two extraordinary events: Bouvet BizTalk Innovation Day (s) in Stavanger, Norway and the 40th running of the Berlin Marathon.
Bouvet BizTalk Innovation Day-Norway Recap
This was a two day event hosted by Bouvet. For those of you who are not familiar with Bouvet, Bouvet provides services in the fields of information technology, digital communication and enterprise management. Bouvet has about 900 employees divided between 14 offices in Norway and Sweden. – See more at: http://www.bouvet.no/en/About-Bouvet/
On day one each of the speakers had the opportunity to present their topic to a crowd of around 70 BizTalk professionals from all over Scandinavia. The topics ranged from newer technologies like Windows Azure BizTalk Services, Windows Azure Mobile Services, Windows Azure Service Bus and some more universal topics like being proactive when monitoring the health of BizTalk solutions, BizTalk Mapping Patterns, identifying and rescuing a BizTalk Hostage Project and seeing a preview of the next version of BizTalk360. There was also a special keynote by Paolo Salvatori who works for Microsoft Italy and is recognized world wide for his abilities. All presentations were very well received as indicated by the attendee surveys.
My presentation focused on Enterprise Mobility. This is a topic that I have been dealing with at my day job so I had an opportunity to demonstrate some of the areas of enterprise mobility that I have been thinking about lately. It was also an opportunity to demonstrate a ’reference’ application that I have been collaborating on with Mikael Hakansson.
Some of the core principles that I have taken into consideration when dealing with Enterprise Mobility include:
- Active Directory Federation: When a person leaves the company and their AD account has been disabled, this “tap” should be turned off for other mobile/cloud based services.
- Leverage a Mobility platform to reduce the diversity required in supporting multiple platforms. Windows Azure Mobile Services helps us address this by providing APIs for the popular platforms that allow us to centralize activities like Data access, Authentication, Identity Providers, Custom APIs and Scheduled tasks.
- Most, if not all, Enterprise Mobile apps need to consume Line of Business (LOB) System data. Windows Azure BizTalk Services (and the BizTalk Adapter Service) allow us a secure way in and out of our enterprise without poking holes in firewalls. I should note that these capabilities are also available with BizTalk Server 2013.
- Accessing On-Premise LOB systems isn’t possible (in my scenarios) without the underpinnings of the Windows Azure Service Bus. Using this technology to span network layers never gets old. The BizTalk Adapter Service has a strong dependency on these services.
- Data Storage: Even though I am leveraging SAP master data in this scenario, I do need to maintain the state of the business process. In this case I am using SQL Azure to host our data. We can leverage Windows Azure Mobile Services’ APIs that make getting data in and out of the database a breeze.
- Finally, we can’t forget about Toast Notifications. We want the ability to send notifications out to users (in this case approvers) and Windows Azure Mobile Services helps us deal with sending Toast Notifications to a variety of platforms.
Here is one of the scenarios from my demo that illustrates many of the principles that were previously mentioned.
A few screenshots of the application running in the Windows Phone Emulator:
This was one of the more challenging demos that I have ever been involved in. I had a lot of fun working on this reference app with Mikael and learned a lot in the process. My complete slide deck can be found here.
Conclusion
Many people work on bringing events alive, but two people who I would like to recognize are Tord Glad Nordahl and Anders Stensland. They, in addition to the support Bouvet provided, pulled off a fantastic event. I have had the opportunity to present in Sweden in 2010 and 2011 and I continue to be amazed by the amount of BizTalk interest in Scandinavia. If you do have the opportunity to attend the Bouvet BizTalk Innovation conference in the future, I highly recommend it. They did an amazing job.
40th Berlin Marathon
One of my hobbies is running. I am a pretty average runner but I enjoy the challenges of running and also try to reap the health benefits of staying active. I have run over 12 half marathons over the past 6 years and finished my first marathon last year in Chicago. Whenever I have gone to Europe to speak in the past I have always tried to make a side trip within Europe to experience another culture. In speaking with one of the other presenters (Steef-Jan Wiggers) we had decided that we would head to Berlin after the conference in Norway. He recommended going to Berlin to experience its rich history. Having never been to Germany, myself and my wife made plans to join him in Berlin.
I knew that the Berlin Marathon was held in late September. The Berlin Marathon is one of the 6 major Marathons in the world. The others include New York, Boston, Chicago, London and Tokyo. So when I found out that I would be in Berlin on the same day of this historic event, I couldn’t resist the temptation of participating in this event.
The registration deadline had passed but I was able to find a travel agent from Boston who would sell us packages. With this information, I presented the opportunity to Steef-Jan and he obliged. He has recently gotten back into running and this would provide a great opportunity to run his first marathon.
The event itself was rather amazing. Over 42 000 runners participated in the event with an estimated 1 million spectators. It was an awesome experience and one that I will never forget. I finished the marathon in 4 hours 34 minutes and 56 seconds which was 4 minutes faster than my Chicago time.
A few pictures:
The prize
Before the race. The garbage bags helped keep us warm while we waited for our turn.
Steef-Jan before the race
After the run
Celebrating – German style
After the race the Adidas store would engrave your time into a running band that was provided as part of your registration.
One of the best parts of the MVP program is the people you meet and the friendships that you develop. Without being in the MVP program, this trip would have never happened. Being part of the program is truly an honor.
Thanks Tord for your hospitality in Norway. It was a great opportunity to experience my Norwegian heritage and I thoroughly enjoyed your beautiful country.
Thanks Steef for being an amazing tour guide while in Germany. Your German came in handy many times and I learned a lot about German history while I was there. Running the marathon with you was also a great experience. Next time we won’t do as much sightseeing the day before the race 
.
I also would like to thank the other MVPs (Sandro, Nino, Saravana) and Paolo for a great experience as well. Talking shop whenever we get together is a lot of fun and always interesting.
by community-syndication | Oct 6, 2013 | BizTalk Community Blogs via Syndication
It is time to continue the BizTalk Community Series after a recent successful event in Norway, the Bouvet BizTalk Innovation Day. This event was a great opportunity for me to meet up with many Scandinavian BizTalk professionals.
During the two day event we as BizTalkCrew, Kent Weare and Paolo Salvatori (Microsoft) presented about the latest (Windows Azure BizTalk Services, BizTalk 2013), proven
by community-syndication | Oct 4, 2013 | BizTalk Community Blogs via Syndication
I found a great article about comparison between BizTalk Server and BizTalk service on codit I have given quite some sessions and presentations recently on Windows Azure BizTalk Services. We had the opportunity to work together with the product team on WABS as a strategic Launch Partner. I had a lot of discussions and questions […]
Blog Post by: Jeremy Ronk
by community-syndication | Oct 3, 2013 | BizTalk Community Blogs via Syndication
One of my clients wanted to know how many messages were processed on a certain BizTalk port.
To show some statistics, I created a SQL query that lists a message count of the messages processed per hour for a certain Port.
Here’s the SQL query I used:
use BizTalkDTAdb
SELECT top 200
a.[Event/Direction],
a.[Event/Port],
CONVERT(VARCHAR(10), a.[Event/Timestamp], 111) as [date],
DATEPART(HOUR,a.[Event/Timestamp]) as [Hour],
COUNT(*) as [Count]
FROM [dbo].[dtav_MessageFacts] a
inner join dbo.btsv_Tracking_Parts b on a.[MessageInstance/InstanceID] = b.uidMessageID
WHERE a.[Event/Port] <> 'PortSqlMonitor'
AND a.[Event/Port] = 'BizTalkPort'
AND a.[Event/Direction] = 'Receive'
AND a.[Event/Timestamp] > DATEADD(day, -3,GETDATE())
GROUP by a.[Event/Port], CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp]), a.[Event/Direction]
ORDER BY CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp])
