Welcome to MSDN Blogs Sign in | Join | Help

October 2008 - Posts

Friday, October 31, 2008 9:37 AM

Quote of Day - On Knowledge

You do not really understand something until you can explain it to your grandmother. - Albert Einstein I've met lots of really smart people that can't explain what they know. I think this really sums it up!
Posted by Buck Woody | 2 Comments
Filed under:
Thursday, October 30, 2008 6:09 AM

SQL Serer 2005 - Script Tables and Data

I was asked about the "DUMP" command in MySQL yesterday. It will create a script (in order) of all the database objects and the data they contain. The question was, does SQL Server 2005 have anything like that? Why yes it does! Check out this
Posted by Buck Woody | 1 Comments
Filed under: , ,
Wednesday, October 29, 2008 6:20 AM

Mandelbrots and SQL Server

I was watching Nova last night and they talked to Benoit Mandelbrot, the man who codified some of the math that bears his name. This math branch deals with "rough" or repeating surfaces. You probably already know that Transact-SQL can be used
Posted by Buck Woody | 2 Comments
Filed under: ,
Tuesday, October 28, 2008 6:16 AM

Opening SQL Server Profiler from SSMS

The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you'll see a list of processes that you can order, sort and filter. If you right-click any process, you'll
Posted by Buck Woody | 2 Comments
Monday, October 27, 2008 7:08 AM

More SQL Server Videos

I was sent this link by a reader: http://www.sqlservervideos.com/series/ Not sure about the content, but I thought I would pass these along. If you review them, let us know what you think.
Posted by Buck Woody | 0 Comments
Filed under: , ,
Friday, October 24, 2008 8:42 AM

Quote of the Day: Do it now

"You cannot escape the responsibility of tomorrow by evading it today." - Abraham Lincoln I have a lot going on right now - I just got back from Brazil, I'm headed to Spain, and then back for PASS here in Seattle. One thing that I have learned when things
Posted by Buck Woody | 1 Comments
Filed under:
Thursday, October 23, 2008 6:21 AM

A few minutes of the virtual...

This is pretty cool – the first 10 minutes or so of one of the virtual conference I did earlier last month is now available for free online. You can see it here: http://www.vconferenceonline.com/speaker.asp?id=BWoody
Posted by Buck Woody | 1 Comments
Filed under: ,
Wednesday, October 22, 2008 11:12 AM

SQLH2 on Codeplex

Recently someone asked me if they could get the source to SQLH2, the "health" monitoring solution for SQL Server. I told them that I couldn't give out source code, but Microsoft can. I said "make the suggestion on http://connect.microsoft.com and see
Posted by Buck Woody | 1 Comments
Tuesday, October 21, 2008 8:22 AM

SQL Server 2008 Feature Pack

This is to let you know that the SQL Server 2008 Feature Pack for October is now available. What’s in this release? Find more details here : · ADOMD.Net · AMO · DMViewer · PowerShell extensions for SQL Server Replication Management Objects · Report Builder
Posted by Buck Woody | 0 Comments
Monday, October 20, 2008 9:58 AM

ERD Designer

So what are you using for an Entity Relationship Diagran (ERD) tool? I'm teaching a class at the University of Washington and we're doing that part of the class now. I normally use Visio, but find it a little less than perfect for this. And some of the
Posted by Buck Woody | 5 Comments
Filed under: ,
Friday, October 17, 2008 3:37 AM

Quote of the day, and the long flight home

I have one more presentation today here in Brazil, and then a 24-hour flight to Seattle. Ah, for the ability to sleep on the plane. I've never been able to do it! I have had an amazing time here in Brazil, and the people are the best part. They are so
Posted by Buck Woody | 1 Comments
Thursday, October 16, 2008 5:05 PM

TechEd Brazil - Day Three

I started today at TechEd by chatting with several folks about some issues they were having on planning solutions for their companies. They were lined up at the discussion area and had lots of questions ready! I also spoke with several folks on the improvements.in
Posted by Buck Woody | 0 Comments
Filed under:
Thursday, October 16, 2008 3:46 AM

Free SQL Server Videos

Microsoft is now including video content along with Books Online for SQL Server. Check them out here: http://msdn.microsoft.com/en-us/library/cc952928.aspx
Posted by Buck Woody | 1 Comments
Wednesday, October 15, 2008 11:06 AM

TechEd 2008 - Brazil (Day Two)

I started the day bright and early, meeting with several folks that are interested in growing the DBA role in companies here in Brazil. In all of my interactions with the technical professionals here I hear the same things - that we need to communicate
Posted by Buck Woody | 1 Comments
Filed under:
Tuesday, October 14, 2008 2:58 PM

TechEd 2008 - Brazil

Well, after an extremely long flight (24 hours total) I have arrived at TechEd Brazil. What an enthusiastic group of professionals! Yesterday I attended a meeting with the Brazil "MVP"s, or Most Valuable Professionals - and although I don't speak Portugese,
Posted by Buck Woody | 0 Comments
Filed under:
Monday, October 13, 2008 2:20 PM

SQL Server Grows Up

I spoke at the SQL Saturday event in Olympia, Washington, and I noticed that the questions I got were different than those I used to get for SQL Server. In my former life I managed not only SQL Server but other platforms as well. When I would speak to
Posted by Buck Woody | 2 Comments
Filed under:
Friday, October 10, 2008 7:35 AM

On Paying Attention to the Details

It's Friday - time for the quote of the day: "We think in generalities, but we live in detail." - Alfred North Whitehead
Posted by Buck Woody | 1 Comments
Filed under:
Thursday, October 09, 2008 9:13 AM

Editing Data from SSMS

Sometimes you want to edit data directly in a table (often a very bad idea!). In Enterprise Manager (SQL2K) and SQL Server Management Studio (SQL2K5) you right-click a table and select "Open Table" from the menu. That brings back ALL of the rows in the
Posted by Buck Woody | 1 Comments
Wednesday, October 08, 2008 7:08 AM

Spreading the Security Wealth

When I first started at Microsoft, I worked a couple of projects with the SQL Server Security team - and I really enjoyed that group. They are a very smart, fun group of folks to hang around with. Plus, they are really good at math! Anyway, they wrote
Posted by Buck Woody | 1 Comments
Filed under: ,
Tuesday, October 07, 2008 6:20 AM

SQL PASS Pre-Conference Presentation

I'll be presenting at lots of conferences soon - SQL Saturday in Olympia Washington, several webcasts, TechEd Brazil and then TechEd Europe in Barcelona. But I'll also be presenting at one of the biggest SQL-Geekfests there is - SQL PASS. I'll be doing
Posted by Buck Woody | 1 Comments
Filed under:
Monday, October 06, 2008 8:47 AM

Knowing the Business

I mentioned the other day that I'm teaching a college course at the University of Washington, and as part of that we're doing a complete database project from requirements gathering to a completed database with all its objects. The students have done
Posted by Buck Woody | 3 Comments
Filed under: , ,
Friday, October 03, 2008 6:14 AM

Is PowerShell Necessary?

We got an e-mail the other day from a DBA who said he didn’t see the need for PowerShell for SQL Server. He thought our time might have been spent better elsewhere. I’ll restate the reply I gave him below, but it brings up an interesting point
Posted by Buck Woody | 1 Comments
Thursday, October 02, 2008 9:09 AM

Video Interview

While I was at the SSWUG Virtual Conference prep, I did an interview – a very lengthy, hyper-caffeinated one. Not sure how well I came off in it – gosh, do I really sound (and look!) like that? Youch. There is some useful information in there about how
Posted by Buck Woody | 1 Comments
Filed under: ,
Wednesday, October 01, 2008 8:47 AM

Books Online is updated for SQL Server 2008

Wow - out only a couple of months and already the Books are updated! Here you go: http://www.microsoft.com/downloads/details.aspx?FamilyId=765433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en
Posted by Buck Woody | 1 Comments
 
Page view tracker