Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: June 2010

PASS, Don’t Waste My Time

Update: Apparently I can't write, or get a point across from the comments and a few emails, so I have edited this to hopefully make it clearer.

The pre/post conference sessions came out today for the 2010 SQL PASS Summit. And to my surprise the list of sessions wasn’t… Read more

5 comments, 890 reads

Posted in The Voice of the DBA on 30 June 2010

Truncating the Log and Database Mirroring

I saw someone post recently that they wanted to run this code on their principal server in database mirroring to clean out a large transaction log and shrink it.

alter database <mydb> set recovery simple
go
checkpoint
go
alter database <mydb> set recovery full
go
backup database pubs to disk

Read more

0 comments, 805 reads

Posted in The Voice of the DBA on 30 June 2010

ASK SQLServerCentral - The New Community Model

We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange (SE) to an alternative, OSQA.net, without informing any of the people that work on the site. Needless to say this wasn’t a seamless transition, but it was fairly smooth. The… Read more

3 comments, 330 reads

Posted in The Voice of the DBA on 29 June 2010

Making a Little Effort at Networking - Part 1

I’m not a big networking person. I know that it’s good for my career, but I’ve been lucky enough to get myself fairly well known, my picture is on daily emails from SQLServerCentral, and so a lot of people know of me. As a result, I don’t have to… Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 28 June 2010

Speaking and Presenting Tips - Bullets

I’ve heard this before, it came up in the Tufte seminar I took, and it also was something that grated on my nerves at TechEd recently. I was in a presentation and saw a slide titled “Agenda” that had bullet points like this:

  • History of xxx
  • Problem of DIY
  • Reference…

Read more

2 comments, 389 reads

Posted in The Voice of the DBA on 25 June 2010

The Exceptional DBA of 2010

I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists, but typically a couple that stand out above the others. As we’ve gone through the judges’ voting, we usually agree on 3 or 4 of the finalists and then debate…

Read more

0 comments, 311 reads

Posted in The Voice of the DBA on 25 June 2010

Traveling with Steve

I don’t travel a lot, but with the success of SQL Saturday, I find myself heading out on the road more than I have in the past. I’m not what you’d call an experienced traveler, and Brad McGehee, who travels a lot, constantly tells me I’m doing it wrong… Read more

2 comments, 404 reads

Posted in The Voice of the DBA on 24 June 2010

SQL Saturdays are Catching On

Andy Warren (blog| Twitter) sent me a link recently to a piece written by Kalen Delaney on the recent SQL Saturday in Redmond. She gives us the reasons why she wasn’t sure they would be successful, but is pleasantly surprised by how well they are attended.

Read more

0 comments, 324 reads

Posted in The Voice of the DBA on 23 June 2010

Selling

I saw Paul Kenny at the first Business of Software conference, and then had dinner with him, chatting about sales. I actually had our company bring him in for some training and he was back last year again at the Business of Software. I’m not sure he’s coming… Read more

0 comments, 280 reads

Posted in The Voice of the DBA on 23 June 2010

The Spring Event

I hope you’ve seen the note from Andy Warren (Blog | Twitter) on a PASS Spring Event, and there’s another writeup from Kendal Van Dyke. The idea of growing PASS by offering another event, in addition to the Summit, that will hopefully grow, allow more people… Read more

2 comments, 468 reads

Posted in The Voice of the DBA on 22 June 2010

T-SQL - Finding Changes

Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table like this:

DECLARE @t_temp table (ID INT IDENTITY(1,1), Value VARCHAR(20))
insert into @t_temp
select 'Win32' UNION ALL
select 'Win32' union ALL
select 'Win32' union ALL
select 'Win32' union

Read more

3 comments, 1,187 reads

Posted in The Voice of the DBA on 21 June 2010

Speaking and Presenting Tips - Handouts

I’ve given quite a few presentations, one keynote with another to come, and attended many more. I’ve read a few books on how to get better, and then in an Edward Tufte seminar recently, I got another one.

Dr. Tufte mentioned the idea of a supergraphic, an image with a… Read more

4 comments, 590 reads

Posted in The Voice of the DBA on 18 June 2010

Finding SQL Server Client Ports

I saw a post recently asking if there was an easy way to find the port a client was using on a SQL Server since someone had multiple instances. I asked for some information since there are actually multiple ports in use.

The port the SQL Server listens on

The… Read more

2 comments, 881 reads

Posted in The Voice of the DBA on 17 June 2010

I’d buy an iPhone4, but ….

I don’t trust ATT.

That’s saying something. AT&T, the company that built US telco, that gave us innovations from Bell Labs, including Unix. They got an exclusive deal for the coolest phone I have ever used, and I don’t trust them.

Their network, despite upgrades, still has me worried.… Read more

2 comments, 355 reads

Posted in The Voice of the DBA on 16 June 2010

A Strange Twist in my life

As the plane was landing the other day for SQL Saturday in Pensacola, I was struck by how amazing my career has gone. 19 years ago, working in a cube in a power station, programming dbase and Clipper applications. A geek at a desk.

Now I’m flying halfway around the… Read more

6 comments, 261 reads

Posted in The Voice of the DBA on 16 June 2010

The Value of an Artist

A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they represented. A few people noted that webcasts or other headlines weren’t technical information, and they didn’t want to click through to find that out.

Made sense to me, though I… Read more

0 comments, 254 reads

Posted in The Voice of the DBA on 15 June 2010

Networking – A Year Later

I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked about it quite a bit and tried to promote it as a way to build your brand and perhaps get a better job. We were concerned that networking is a… Read more

7 comments, 246 reads

Posted in The Voice of the DBA on 15 June 2010

Me and Lil’ Buck at TechEd

I had been hearing about Lil’ Buck and so when I finally caught up with Buck Woody (Blog | Twitter) at TechEd, he told me to wait a minute. Unwrapped, from a separate box in his bag, in bubble wrap, out came Lil’ Buck

Apparently Marketing at Microsoft… Read more

2 comments, 266 reads

Posted in The Voice of the DBA on 14 June 2010

Tie It Back

I gave the Modern Resume: Building Your Brand presentation last week at the SQL Saturday #22 - Pensacola event and had about 30-40 people come see it. I got some good responses, but there was one interesting thing that came up.

I have talked about how it helps to prove… Read more

2 comments, 229 reads

Posted in The Voice of the DBA on 14 June 2010

Older posts