Hey, With the release of MAP toolkit 7.0, Microsoft have taken a huge leap in making this tool more useful across the board. Previously, if you didn’t have the CPT Excel plugin also, manipulating data coming out of the tool wasn’t the most fun. Now however, it puts so much information at your fingertips so […]
You can if you want, but there’s no need really. But go on, have a bit of a panic…. Done? Great! Going through some stuff here in preparation for me leaving my current job, and it occurred to me that while I have experienced this, and dealt with it now, that back when I first
Hey, This is something I’ve been wanting to blog about for a while, because I’m a big fan of database mirroring, however in a lot of scenarios (And I have been guilty of this in the past too), it’s almost a false safety net. Yes, your data is on a separate server in case your
Hey, I may be alone on this ship, but migrations from SQL 2005 to SQL 2008 are a happening all over my office, and one of the pains is migrating the non database services surrounding SQL, such as Analysis Services, Reporting Services etc. So after one pain staking migration of Reporting Services, I thought I’d
Hey, I wanted to get back to the original theme of the blog for a bit, making stupid mistakes! I reckon I can fill the internet with these… But one in particular I wanted to share with you real quick. I get where Rick Deckard (Blog) was coming from. I’ve often thought of shooting rogue
Hey, Thanks to a massive rollout internally here the blogs have been few and far between, and unfortunately that’s likely to be the case for the next 3 months, but I’ll try to add something of value when I do manage one! Hope the new year is treating everyone well, and to help your January
Setting up your disks correctly – Worth while? Obvious answer to follow… Read More »
Hey, Sorry for the long delay in posts, the usual, life getting in the way! But I recently had what to me seemed an obscure problem (although in hindsight, duh), but turned out to be caused by out of date statistics (Big thanks to Brent Ozar for the assist twitter | blog). The Problem To
Hi, ***Update 23/11/2011 – Issue identified, with thanks to Brian Carrig! Check the comments for the details *** Just a short one to share something interesting I found while using VMWare to run SQL Server in production. As soon as I get over the mad pre-Christmas rush, I hope to get posts out with more
Hey, I’ve finally gotten around to doing this. I had so much difficulty getting the video done that I just left in some of the, what should have been, out takes, so apologies for that! This is a very quick guide to gathering data, and importing it into an app called SQL Nexus. It will
Hey, Just a quick post based on some questions on performance boosts I received at the presentation the other night. There are so many ways to tune your SQL Instance/application, but for someone who wouldn’t be too comfortable going in deep, the biggest bang for the buck, for me, comes from loading your server with
