Entries for the ‘Databases’ Category

DPM 2012: Job Failed, SQL Server Instance Refused Connection To The Protection Agent

> Working with Microsoft DPM can be incredibly frustrating at times. Some of the error messages can be a little too vague and sometimes the replicas can just be inconsistent for no apparent reason. However what it does very well, is potentially get you out of a massive hole should something go catastrophically wrong. Recently, […]






How to fix MySQL Error 1067 Windows Server 2008r2

>Let me just start by saying that this has been really annoying me for some time now and obviously taking the server offline to fix this is difficult at the best of times. Fortunately, this week I’ve had the time to take a look at this and see if I can sort the issue. Could […]






Manage Memory Limits SQL Server Enterprise 2008

>Currently on our network is a server that’s running SQL Server Enterprise 2008 running on our Hyper-V cluster. On the cluster, dynamic memory is enabled. Now, normally this isn’t a problem, but when configured incorrectly SQL Server Enterprise will eat up as much data as it needs and so you suddenly have a server (low […]






PHP: mysql_fetch_assoc Vs. mysql_fetch_array

>Recently I’ve been doing a lot of work to optimise my work so that pages load more quickly and server load is reduced. When I was looking through to my database calls, typically I’ve always used the mysql_fetch_assoc function because it always returned less data than the mysql_fetch array which actually returns two arrays – one which […]






SQL Server and Dynamic Memory

>Since our move to Hyper-V and the addition of Service Pack 1 for Windows Server 2008r2, the addition of Dynamic memory has helped us vastly manage the resources within our virtual servers much better. For those who don’t know, Dynamic Memory is where the memory utilised in virtual environments can be changed dynamically while the virtual machine is […]






Moving on, onwards and upwards!

>Following on where I left off really from my last post! I briefly mentioned in my last post that I had an upgrade path in place (after testing of course!) for ‘Connect’. The time was approaching to move on with the technology, whereby Connect had been in place for three years and in that time […]






From the start…

>Hi everybody, just to introduce myself and my blog firstly! I’ll start by saying that this isn’t my first blog, but it is my first one for quite some time – about four years to be precise. The reason for a re-start of my blog is to work more closely with other developers in the […]






  
  • Categories

  • Social

  • Tag Sphere

  • Recommended

  • Archives

Get Adobe Flash player