Latest Posts Under: SQL Server

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 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 →

Recently one of my sites that was created using umbraco has started to behave somewhat strange. There was nothing that seem to be wrong and all the errors produced were:  No Document exists with Version ‘00000000-0000-0000-0000-000000000000’ As it turned out the problem was due to extreme delay in the SQL Server. What made me look… Read Article →

Ever wanted to get the current time and date from the SQL Server to avoid different times between yous server and the clients (for example having a centralized application running on many countries) ? Using LINQ to SQL there is no way to get the time from the database build in the class. What you… Read Article →

Scroll To Top