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,


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!

Regular Expression Tester

Check out https://regex101.com Great Online Regular Expression Tester, with a full reference help and awesome explanation of the regular expression that you're building. It's specially helpful when the regular expression starting getting big and it's hard to find mistakes

Monday, 15 October 2012

View user permissions in SQL SERVER

Hi, To check your permissions just run the following queries and you'll get a list of assigned permissions SELECT * FROM fn_my_permissions(NULL, 'SERVER'); USE YourDatabaseName; SELECT * FROM fn_my_permissions (NULL, 'DATABASE'); GO

Tuesday, 10 April 2012

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. (0xC0209303)

Whenever this error happens

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.   failed with error code 0xC0209303


Check you connection string if the provider is
;Provider=sqlncli10.1

In my case the was because I had a connection string with Provider=SQLNCLI.1 from Integration 2005 and when I upgraded to 2008 didn't change it.

It took me along time to find this out hope it helps

Tuesday, 12 April 2011

Error when workflow is running in publishing page

I had a custom workflow associated with a content type  used by a publishing page, that gave this error

[NullReferenceException: Object reference not set to an instance of an object.] Microsoft.SharePoint.Publishing.Internal.WorkflowUtilities.GetAssociationDataValue(CachedWorkflow workflow, String xmlNodeName) +124


Digging throught the web I found a solution.


We need to had this association data to the workflow


<my:myFields xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD\" xml:lang=\"en-us\"><my:ItemChangeStop>false</my:ItemChangeStop></my:myFields>


Apparently Sharepoint is looking for node called "ItemChangeStop"


Thanks to Julien C (http://www.sharepointdev.net/sharepoint--workflow/sharepoint-error-when-editing-documents-with-custom-content-types-44343.shtml)


Somewhere else people talked about and hotfix from microsot that isn't available on the web ...