Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

Friday, February 27, 2009 8:47 AM

quote of the day - not focusing on the past

"My interest is in the future because I'm going to spend the rest of my life there."  - Charles F. Kettering
Posted by Buck Woody | 0 Comments
Filed under:
Thursday, February 26, 2009 6:23 PM

Object Search - Search Only What You Need

At the top of the Object Explorer Details (OED) pane in SQL Server Management Studio 2008 there is a box to type in a search term for database objects. You can use the exact name, or use standard T-SQL wildcards to find an object such as a table or a
Posted by Buck Woody | 1 Comments
Wednesday, February 25, 2009 7:46 AM

Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft likes for its people to be certified in as many technologies as possible. Personally, I find certifications useful since they help me focus my study, but I don't think that certification = expert. It's just one part of the puzzle. To that end,
Posted by Buck Woody | 6 Comments
Tuesday, February 24, 2009 9:02 AM

Using PowerShell to Discover Login Failures on SQL Server

If you have PowerShell installed (even if it isn’t the SQL Server 2008 provider), you can and should check your servers each day to see if you have login failures. This is very useful to help ensure that your server is safe and secure. Whenever someone
Posted by Buck Woody | 1 Comments
Monday, February 23, 2009 8:10 AM

SQL Server Chargeback?

Whenever economic situations change, the IT department has to adapt. The situation in many shops is that IT is a recurring cost, carried by the entire business. What that means is that your IT department is asked to service the entire organization, no
Posted by Buck Woody | 1 Comments
Friday, February 20, 2009 8:23 AM

Quote of the Day - on Being Careful with Free Gifts

No commentary needed, I think: There is always free cheese in a mousetrap. - Anonymous
Posted by Buck Woody | 1 Comments
Filed under:
Thursday, February 19, 2009 7:03 AM

SQL Server Background Picture

I use a particular background in my presentations that I've been asked about a lot. I thought I would share that here: http://blogs.msdn.com/photos/buck_woody_-_msft/images/9286756/original.aspx
Posted by Buck Woody | 1 Comments
Filed under: ,
Wednesday, February 18, 2009 9:50 AM

"Kitchen Drawer" Databases

Almost everyone I know has a drawer in the kitchen that ends up overstuffed, containing rubber bands, homework, pencils, a non-matching butter-knife, some string, a dog leash and whatever else. And in a lot of companies you'll see the same thing, only
Posted by Buck Woody | 2 Comments
Filed under:
Tuesday, February 17, 2009 8:00 AM

Free User Group Support

As you know, I'm a big proponent of User Groups. I've been in charge of many, and I still present at them and attend my local PASS chapter. I just found a fantastic free resource for user groups - free content, advice, and even money!  Check it out
Posted by Buck Woody | 1 Comments
Monday, February 16, 2009 8:06 AM

Of Mainframes and Rivers

I started working with technology a long time ago - long enough to remember the mainframe way of life. Back then, a select group of folks controlled access to "the computer". On certain desks stood terminals, and programs were all custom-written
Posted by Buck Woody | 1 Comments
Filed under:
Friday, February 13, 2009 6:14 AM

Quote of the Day: Negative Recursion

Happy Friday the 13th!  Remember: "It is bad luck to be superstitious."
Posted by Buck Woody | 1 Comments
Filed under:
Thursday, February 12, 2009 8:28 AM

Portland User Group

I spoke at the Portland User Group in Oregon last night, and what a great group of folks! I spoke for over two hours on the improvements in SQL Server 2008 for the Developer. As I spoke it reminded me that all over the world, people meet to talk about
Posted by Buck Woody | 2 Comments
Filed under: , ,
Wednesday, February 11, 2009 7:58 AM

Scripts, Blogs, and Learning

I received an e-mail from a reader asking if I could post a link to a script he's documented in an article. I'm always happy to do that, but there are some things you should know about ANY script you find on the web, and while I'm at it, for how you read
Posted by Buck Woody | 4 Comments
Filed under: , , ,
Tuesday, February 10, 2009 8:01 AM

Of Patterns and Practices

Does the data professional need to know about Patterns and Practices? Well, if you're on the development side of things, you're more than likely already familiar with this term. At the bottom it's a list of "best practices" that you use to solve
Posted by Buck Woody | 1 Comments
Monday, February 09, 2009 11:17 AM

PowerShell Script of the Week - Script and Compare Permissions

One of the biggest issues in compliance is finding out who has permissions to what. And once you're done with that, you need to track when that changes. PowerShell to the rescue!  Here's what I'm using for that: 1: # Scripting database objects: 2:
Posted by Buck Woody | 1 Comments
Friday, February 06, 2009 7:27 AM

Quote of the Day - Software Development and Miracles

I was sent this week's quote by my good friend Chris Pelley. Not sure who it is attributed to, but it sure sounds right to me: "Walking on water and developing software from a specification are easy if both are frozen."
Posted by Buck Woody | 1 Comments
Filed under:
Thursday, February 05, 2009 7:35 AM

Building Your Toolbox

Years ago, "finish" carpenters would travel from job to job to find work. When they showed up on site, they would speak with the foreman, who would ask to see their toolbox. See, in those days, there were no power tools, so the carpenter carried
Posted by Buck Woody | 1 Comments
Wednesday, February 04, 2009 7:29 AM

Server Consolidation Done Right

Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the
Posted by Buck Woody | 1 Comments
Tuesday, February 03, 2009 9:12 AM

Service Broker and the Need for Planning

I mentioned yesterday about the database I was using implemented Service Broker. I wanted to mention (again) the incredible need for planning when you're setting up a project. Whenever you're working on something as distributed as Service Broker, you
Posted by Buck Woody | 1 Comments
Monday, February 02, 2009 9:50 AM

Check that database before you restore it...

I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as
Posted by Buck Woody | 1 Comments
 
Page view tracker