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, 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, 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
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
Hey, So wedding season is over and it’s back to reality, and back to getting beat up by SQL! As a follow on from my last post, SQL Server 32 Bit and AWE, I wanted to cover the topic of monitoring your memory. So as you may have noticed when you enabled it, if you
Today we’ll do the 4th and final part of the Maintenance Plan Wizard, which covers Backups and keeping your hard disks clean! Back Up Database (Full)The jobs get more obvious as they go on, making my explanations a bit easier! This takes a full copy of your database and dumps it to a file (usually
Introduction to the Maintenance Plan Wizard – Part 4 Read More »
Today I’m going to move on to part 3 (of 4) of explaining the Maintenance Plan Wizard. Here’s a picture of the layout again, just in case you forgot!So today we’ll start with:Update StatisticsSo first, what are statistics. Statistics are SQL Servers internal information which it uses to make sure that your Query Plans are
Introduction to the Maintenance Plan Wizard – Part 3 Read More »
Woo, 2 in a row! Today I’ll be doing the second part of walking through the Maintenance Plan Wizard, Re-Organizing and Re-Building indexes. Reorganize IndexAgain, does what it says on the tin. This task kicks off an “Alter index REORGANIZE” for all the indexes in your database. It moves around the data in your index
Introduction to the Maintenance Plan Wizard – Part 2 Read More »
