My dear friends Erin Stellato (Blog | Twitter) and Michelle Ufford (Blog | Twitter) tagged me for Meme Monday series…so here we go Actual start of blog HEAP, One index. Select Column with predicate other column. RID Lookup. End of blog
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
One of the most important tasks a DBA should know how to perform, and should test regularly, is a database restore. It is absolutely necessary to back up your data so you have it if a disaster strikes, but it is equally important that you know how to retrieve that data when needed. The basic RESTORE syntax looks like: RESTORE DATABASE [Name] FROM [Device] WITH [Options]... That restores an entire database to the last full backup.
For the past two Saturday’s I have been lucky enough to not only participate in but also present at a SQL Saturday. It has been an honor to be selected as a presenter when there have been so many great speakers to choose from. If you haven’t been to a SQL Saturday before, or it’s been awhile since your last one, I encourage you to check out the SQL Saturday website and find one near you to attend.
Good old fashion error handling……….This is something that is often skipped over when we code because we don’t stop and take the time out to plan it out. I’ve put together a presentation on this topic and I’ll be submitting it to the next SQL Saturday that I attend, but would like to share the main points here.Obviously, there is a lot I left out here, don’t want to spoil the presentation!
In November 2010, before the annual PASS Summit, Brent Ozar held the first Free-Con, in Seattle WA. He invited a pretty impressive list of SQL community speakers and bloggers to talk about, well, speaking and blogging, and careers. You can read his wrap-up of it here: http://www.brentozar.com/archive/2010/11/my-latest-experiment-sqlpass-freecon/. Grant Fritchey, Kendra Little, Jeremiah Peschka, Tom LaRock, Karen Lopez, and more were there. I remember quickly reading the post and thinking, “OK, Brent got a bunch of Those People in a room to talk about cool stuff.
Well this is my first blog posting and I have plenty to blog about. Last week was amazing! It all started on…. Tuesday: My day started at Microsoft in St. Louis. I got there nerdy early, as usual. Microsoft is located on the 11th floor so I rode the elevator up and the doors opened up and there stood two guys and a bunch of bagels! It was Jose and Austin from PragmaticWorks.
To follow this article, download [Refresh Development.zip][1] and add it to a new or exisitng SQL Server 2008 Integration Services Project in BIDS. This past weekend I presented a new session titled SSIS: The DBA Multipler. The session covered taking the power of SSIS and extending the SQL Server Agent with it in order to multiply and automate DBA tasks. The session went very well and I received a lot of great feedback.
LessThanDot (LTD) is coming of age and making a great name for itself with all the communities. This past week the primary administrators and operators of the site once again paid, from their own pockets, the server costs to keep us going. We also moved the site to a better server during this process. OK, we may not be running on Watson but I have a feeling it will help a bit when chrissie1 says he is leaving VB.
If memory serves us right we have had the current server for 4 years now. And it’s time to switch to a new one which is cheaper and better. Our local sysadmin, damber, will be doing this over the next week, so there will be a little down time and we will be changing IP-address so there might be a little lag there too. If you have to miss your favorite site for a little while this week, don’t worry, we will be back.
My very first SQL Saturday was #31, Chicago 2010. I showed up, I volunteered, I learned a hundred things I got to use, and I met some great people – some of my best friends, now. So when I heard there would be a Chicago 2011, I was stoked. Sign me up! Better yet, let me speak! And how about I offer to help with anything the organizers need? So, on Friday, March 25, I set out on a road trip.