King Arthur's Technology Round Table
Monday, 12 February 2018
Trace DTC Transactions
In the SQL Server go to
C:\Windows\System32\Msdtc\Trace
msdtcvtr.bat -tracelog c:\windows\System32\MsDtc\Trace\dtctrace.log -o dtcTextLog
If it shows the following error
1) The utility TraceFmt.exe is missing
Download and install Windows Driver Kit (WDK)
https://msdn.microsoft.com/en-us/windows/hardware/hh852365
The executable location should be in the environment variable path
Thursday, 8 September 2016
Office 365 Design
The front-end toolkit that makes your app or add-in blend seamlessly into Office 365.
https://dev.office.com/fabricMonday, 16 May 2016
Tech Crawling
http://yeoman.io/
Yeoman helps you to kickstart new projects, prescribing best practices and tools to help you stay productive
http://bower.io/
Web sites are made of lots of things — frameworks, libraries, assets, and utilities. Bower manages all these things for you.
Keeping track of all these packages and making sure they are up to date (or set to the specific versions you need) is tricky. Bower to the rescue!http://gruntjs.com/
The JavaScript Task Runner
http://ionicframework.com/
Free and open source, Ionic offers a library of mobile-optimized HTML, CSS and JS components and tools for building highly interactive native and progressive web apps. Built with Sass, optimized for AngularJS.
http://www.omnisharp.net
OmniSharp is a set of tooling, editor integrations and libraries that together create an ecosystem that allows you to have a great programming experience no matter what your editor and operating system of choice may be.
Thursday, 30 April 2015
Windows Convert Text File Encoding
Sometimes UTF-8 encoding just doesn't cut it for some developments and there is need for another type of encoding.
Found this problem working with portuguese language, the accentuation was all wrong.
You can do this with powershell.
Just run this in windows powershell
Useful when the files are really big.
Found this problem working with portuguese language, the accentuation was all wrong.
You can do this with powershell.
Just run this in windows powershell
gc -en utf8 file_with_utf8.txt | Out-File -en unicode filewith_unicode.txt
Useful when the files are really big.
Monday, 6 April 2015
How to add a timezone to datetimeoffset column
Sometimes developers forgot to give the appropriate datatype and the date timezone is simply truncated.
For instance, you wanted to insert the date 2015-04-06 17:37:03.106 +01:00 but at some point the type of the variable you stored the value was datetime as implicity conversion truncates de timezone
As shown in the following example
To fix this apply the function TODATETIMEOFFSET
https://msdn.microsoft.com/en-us/library/bb630335.aspx
And the result is
You loose some precision but for my case it's just fine,
For instance, you wanted to insert the date 2015-04-06 17:37:03.106 +01:00 but at some point the type of the variable you stored the value was datetime as implicity conversion truncates de timezone
As shown in the following example
To fix this apply the function TODATETIMEOFFSET
https://msdn.microsoft.com/en-us/library/bb630335.aspx
And the result is
You loose some precision but for my case it's just fine,
Which SQL Server Editions supports Table and Index Partitioning
- SQL Server 2012 and 2014 Enterprise Edition
- SQL Server 2008 R2 DataCenter and Enterprise Edition
- SQL Server 2008 Enterprise Edition
- SQL Server 2005 Developer and Enterprise Edition
Thursday, 2 April 2015
Lightweight WebService Testing Tool
WebService Studio 2 available for download at https://code.google.com/p/webservicestudio2/
WebServices have evolved but there's still a lot of ASMX Web Service out there.
ASMX is simple and because it is simple, it isn’t very powerful, but you still have to work with them.
Instead of downloading SoapUI massive 1OO MB installer for basic testing why not use this tool 200KB Executable, I definitetly do!
Subscribe to:
Posts (Atom)