Sudenly I received a strange error in a production website while trying to do a simple http request that was working fine the previous day. The error that was thrown was the following: This line was trying to make a call to an API endpoint at MailChimp that added an email to a list. Testing… Read Article →
I resently had to move an old project that I had from an Windows 2003 Server to a brand new Windows 2012 Server R2. The concern that I wad was with some ISAPI dlls that I was using to sync data from an SQL Server to some Windows Mobile devices using SQL Server CE. I… Read Article →
Recently I had a project that required to track events happening within the business layer and could not be tracked using JavaScript from the client. To do this a helper class was required in order to communicate with Google Analytics and track those extra events. Below you will find that class that can be used to do… Read Article →
How many times have you sent an email simply to share a link or a note with the person next to you at the office or an internet cafe? Many times you will use Facebook Messenger or Google Chat or email to sent some text to the person next to you. Some of those time… Read Article →
A general problem that I recently encountered for the second time is an Umbraco site not being able to generate any page without displaying an error or timeout. After examining the log (umbracoLog table on SQL server) you will see the error below: Error Republishing: System.Xml.XmlException: ‘ ’, hexadecimal value 0x1F, is an invalid character. Line 1,… Read Article →
Recently I had a problem with an Umbraco 4.7.1 installation that had became 10GB in SQL Server and had about 20000 published pages. Since there is no way to do something like this from the umbraco administration panel I had to create a T-SQL to clear the database. DECLARE @createdDate Datetime = ‘2012-03-01’ DELETE FROM… Read Article →
Updated thanks to jeffreypriebe — Uncomment below to verify the number of nodes returned is the same as the number of nodes that is in the Recycle Bin — SELECT * FROM umbracoNode WHERE path LIKE ‘%-20%’ AND id != -20 –Setup the temporary table CREATE TABLE #temp ([id] int); INSERT #temp select id from… Read Article →
How many times you wanted to copy a message/phone/email from one device to another on your local network and in order to do it you had to share a notepad file or sent an email to yourself or logged in your google account to create a note etc. Since this had happend to me quite… Read Article →
Below you will find a select that will help you check the state of all your publication on SQL server in order to know if all the subscribers are in synch or the syncronization agent has stopped running. SELECT (CASE WHEN mdh.runstatus = ‘1’ THEN ‘Start – ‘+cast(mdh.runstatus as varchar) WHEN mdh.runstatus = ‘2’ THEN… Read Article →
Recently I changed the name of my SQL Server computer from the generic one given by the Windows installation to ‘SERVER’. In the beggining there was no apparent problem in the connections since I used IP addresses. After a while I wanted to use Replication and tried to create an SQL Server Publication only to… Read Article →