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, Apologies for the continued absence of posting, work is a harsh mistress… Anyway, something I wanted to share with you as part of my ongoing virtualization learnings (AKA Hiccups). When you have limited resources you may find yourself needing to get deeper with how you dole out the resources to your SQL instance. Setting
Resource governor – Making VM’s a safer place to be Read More »
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, It’s quite a well known fact that indexes can be good for your queries. They offer a shorter route to your data, and take some load off your server. They achieve this by creating a Balanced Tree (B-Tree) with pointers to your data. So in a table with customer names, if you search for
Hey, So a less technical piece this week to touch on something I struggled to find information about when I was starting off. There comes a point where you accept the inevitable, and you decide you’re going to learn something about SQL Server. The logical decision is to go on a course, but what course,
So you wanna be a DBA? SQL Certification is the way! Kind of… Read 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
