Hey, So a hot topic in my work life at the moment is virtualization, and it’s going to become a hot topic in other peoples work lives very soon. Virtualization as a whole is a great idea, it’s a money saver, it makes hardware redundancy so much easier to manage, and there are so many […]
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
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
Hey, Just want to say thank you to everyone who came out to the talk tonight, I really do appreciate all the support and feedback. Below are links to the Powerpoint and Word doc on server builds. If anyone ever has any questions please contact me whenever. Here’s the link to a skydrive folder with
Weekend Warrior DBA Edition Presentation and notes Read More »
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 »
Hey, Sorry for the sporadic posts, planning a wedding and blogging do not necessarily go hand in hand! Anyway, moving on, I’m putting together a presentation for the Reluctant DBA, and part of it will be on the Maintenance plan wizard, and how it is the (slightly blunt) swiss army knife for the DBA with
Introduction to the Maintenance Plan Wizard – Part 1 Read More »
Hey, Updates are few and far between at the moment due to my own learning, but this one I’ve had a few questions on recently, so I thought it might be worthwhile sticking up a quick post. Building a server to host a SQL database is slightly different to building a regular App server, so
Afternoon all, Sorry for the absence of updates recently, I’ve been getting stuck into certifications and unfortunately between studying and a full work schedule, finding time for updates has been hard to come by. Hope to get a break soon though and get back to updating regularly. Just a quick one this time, it’s based
