Bonus Rant: Conference Speakers and the Golden Rule

Fair warning: This isn’t a technical post. This is my opinion, and not Microsoft’s. I’ve been a public speaker at events since 1980. Interestingly, even though I’ve done this, it’s never been my paid job. I’ve spoken on technical topics at groups as small as 5 people to over 10,000, inlocal and global events. I’ve…

20

Importing SQL Server 2005 Registered Servers to SQL Server 2008

The team here discovered something that I thought we should share. I’ll get a Knowledge Base (KB) article out soon so that you have something more "official", but I wanted to get this out as soon as I could. A user wrote us and said that when he tried to import his registered servers from…

19

Should it be easy to delete a database?

We had a discussion yesterday about Management Studio, and we focused on the “Delete” command. In SQL Server 2005, you can right-click a database and select “Delete”. You get a panel where you can set some options, or you can just click OK and the database is gone. Unless, that is, there are people connected…

18

SQL Server Books Online

Most of us have stacks of books on our shelves about SQL Server. But you also have an amazing resource that you get for free with SQL Server, or even on the web: Books Online. Some of you might not know how SQL Server Books Online is put together and what goes into it, so…

15

Code Collapse and Expand Feature in SQL Server Management Studio 2008

In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN….END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you’re working with a really large set of code, that’s helpful. But…

15

Buck Woody is Changing Jobs

Recently I read an article (http://lifehacker.com/is-it-bad-to-stay-at-one-company-for-very-long-1295782130) that stated that if you are at the same company for more than a few years, it will harm your career. I don’t agree – consider any successful CEO, musician, or master-level craftsperson – those people may have been doing the same thing for decades. They certainly haven’t damaged their…

15

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, I got one of the earliest certs Microsoft had (long before…

13

Script of the day - Remove White Space from a String

OK – this might be stretching the “Is this Useful” question a bit, but hey, I needed it today and thought I would share it with you – it’s free!  This construct takes the whitespace out of a string. /* usc_DBA_Remove_White_Space.sql Removes extra white spaces between two words in a character string */ DECLARE @TEXT…

12

The Data Saturation Quotient

I was thinking about something this morning on the ride into work that I’d like to ask your opinion about. It has to do with the amount of data that could be absorbed and acted on by a unit or system in a given period of time.   The idea is that there is only…

12