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 »
So a two-for for the first day. One thing I find going in as a DBA to smaller companies is that the SQL versioning across the site is very rarely uniform. I think the reason for this, is that there are quite a few different versions of SQL, and unless you delve deeply, they all
SQL Editions and Development Vs The Real World (Not the MTV Version, sorry) Read More »
