by sebmatthews | Jan 24, 2015 | Azure, Cloud, SQL
Something a little different today. Since SQL Server 2012 SP1 it has been natively supported to run a disk backup of databases and logs directly into Azure Blob storage. For organisations with on-prem SQL Servers but a desire to improve their backup capability by...
by sebmatthews | Dec 2, 2014 | Microsoft, SharePoint, Speaking, SQL
Thanks to those of you that attended my session in Hinckley – it was a great dialogue and I am always happy to have rooms full of people who want real-world questions answered. Head over to the ‘Slideware’ section to grab the deck if you want it....
by sebmatthews | Oct 22, 2014 | Microsoft, SharePoint, SQL
In a current project, we’ve been having problems with search indexing. By problems, I mean massive hairy problems. We’re not using SharePoint search or FAST so the knowledge we have in that space can’t be brought to bear in this case. I won’t...
by sebmatthews | Sep 20, 2014 | SQL, Top Tip
Nothing too clever here. In fact, quite the opposite. I’m posting so I can find this again in the future..! I recently needed to take some data about a large number of databases on an instance and generate a report for people that probably wouldn’t read...
by sebmatthews | Aug 17, 2014 | SQL, Top Tip
This week I have been looking at the usage of a large number of SharePoint content databases. By *large* I mean LARGE. Over 300 spread over a number of clustered instances. “Why should we care?” I hear you asking, “sounds like a normal day at the...
by sebmatthews | Jul 22, 2014 | Microsoft, SharePoint, SQL
Here’s a list of the Eventcache (changelog) EventType codes and their meanings. This list is from Wss3.0 (SharePoint 2007, MOSS) but still relevant in the main for later versions. Mostly here as a reference for me as I am continually looking this stuff up and...