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: May 2011

Identity Reseeding

I love the identity property. I use it in many of my tables, mostly because it gives me a fairly reliable surrogate key that I can use in my tables, especially when testing something. I often do something like this:

CREATE TABLE MyIdentityTest
( id INT IDENTITY(1,

Read more

2 comments, 1,229 reads

Posted in The Voice of the DBA on 31 May 2011

Better Writing from Hemingway

These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely try to incorporate them into your writing, especially being short and positive.

(Cross posted from The Modern Resume)


Filed under: Blog Tagged: syndicated, writing

Read more

0 comments, 676 reads

Posted in The Voice of the DBA on 30 May 2011

More Bloopers for Memorial Day

It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in there, so I’ve pulled out a few more items. Mostly body mistakes or movements and some speaking issues. Enjoy!

The editorial blooper reel is here: http://m.podshow.com/media/15351/episodes/282544/sqlservercentral-282544-05-26-2011.mp4


Filed under: Blog Tagged:…

Read more

0 comments, 640 reads

Posted in The Voice of the DBA on 30 May 2011

No Shrink-y Tempdb

I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues.

I’ve never thought about it before, but someone… Read more

6 comments, 868 reads

Posted in The Voice of the DBA on 26 May 2011

The Exceptional DBA for 2011

Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last three years, and it’s been a hard choice trying to pick from some great applications. This year the judges are Brad McGehee, Brent Ozar, Rodney Landrum and me.

Nominations are… Read more

0 comments, 315 reads

Posted in The Voice of the DBA on 25 May 2011

Fun with Light Bulbs

I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr and then realized I could just as easily do my own picture. So I enlisted Kendall for this series of shots.

 

We had fun, with Kendall holding some of… Read more

3 comments, 399 reads

Posted in The Voice of the DBA on 24 May 2011

Collation Conflicts in a SQL Server Join

I went to run this query recently:

select TOP 10 *
 from users a
   inner join Banned b
   on a.username = b.username

and got this lovely message.

I’d seen that message before, so I knew what was wrong. The collations for the two tables were inconsistent.… Read more

4 comments, 1,689 reads

Posted in The Voice of the DBA on 23 May 2011

IT and Innovation

This is a powerful quote:

“This is the digital world IT must keep up with–one where Apple can view a $40,000 car as an accessory to the iPhone.” – From IT Is Too Darn Slow

The IT world definitely needs to learn to move quicker, and that means that we… Read more

2 comments, 292 reads

Posted in The Voice of the DBA on 19 May 2011

Fun with SQLskills

I’m in a fun mood today, so a few silly items for you.

The last few weeks, Paul Randal (blog | @PaulRandal) of SQLskills has been doing a quiz on Twitter some days. He’s asked some rather difficult questions on Twitter, and people have had fun following along.… Read more

4 comments, 393 reads

Posted in The Voice of the DBA on 18 May 2011

How To Make Your Laptop 100x Faster

Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to try to top his suggestions. Here’s what I came up with:

Anyone needing help, let me know. I can swing by.


Filed under: Blog Tagged: Humor, syndicated

Read more

15 comments, 1,428 reads

Posted in The Voice of the DBA on 18 May 2011

Checking Permissions

Someone posted this query recently:

select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_id

That’s a little ugly, so let’s fix it:

SELECT  a.name, a.principal_id, a.is_fixed_role
, a.default_schema_name
, b.permission_name,…

Read more

8 comments, 1,004 reads

Posted in The Voice of the DBA on 17 May 2011

Colorado SQL Server User Groups – May

I saw a post from Marc Beacom on the presentations this week for various groups. You can get the info on them all from Marc’s post, but basically this is user group week in CO.

  • Tuesday – Boulder
  • Wednesday – Colorado Springs
  • Thursday – Denver

I’m not sure I’ll… Read more

2 comments, 288 reads

Posted in The Voice of the DBA on 16 May 2011

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this:

select a.*,name, b.*
 from sys.database_principals a, sys.database_permissions b

where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_id

 

Ugly to read, at least to me, and… Read more

4 comments, 796 reads

Posted in The Voice of the DBA on 12 May 2011

Patch Week

My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices, be sure you are aware of the patches that came out. The May Bulletin on Technet shows 2 issues, one critical, one important.

I tend to apply patches late, probably… Read more

0 comments, 394 reads

Posted in The Voice of the DBA on 11 May 2011

Networking and Connections

This quote says it all:

It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe the names in particular places.

That could easily be applied to your career as well. The connections you have, with people that know you, respect you, like your work,… Read more

0 comments, 286 reads

Posted in The Voice of the DBA on 11 May 2011

T-SQL Tuesday #18 – My CTE

It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half since Adam Machanic (blog | @AdamMachanic) thought of the idea. I’ve participated in most and it’s something I look forward to each month. This month Bob Pusateri… Read more

2 comments, 352 reads

Posted in The Voice of the DBA on 10 May 2011

My 2011 PASS Summit Submissions

I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle and decided that this was something I should do. If I get selected it will save my boss some $$ and it’s part of what I should be doing for… Read more

3 comments, 304 reads

Posted in The Voice of the DBA on 6 May 2011

A row has no row number

It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s get one thing clear from the start: there are no "row numbers" in a table.

You can assume that the first row you inserted is row number one, but it’s… Read more

13 comments, 1,283 reads

Posted in The Voice of the DBA on 5 May 2011

T-SQL Tuesday #18 Coming Next Week

Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I caught Bob’s Twitter announcement about #18. The topic this month is CTEs, so you have a week to get things ready.


Filed under: Blog Tagged: syndicated, T-SQL Tuesday

Read more

0 comments, 291 reads

Posted in The Voice of the DBA on 3 May 2011

Foreign Keys Help Performance

I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have FKs, or any RI in place and it was always a nightmare when the application broke down or there were enhancements that allowed duplicates, orphans, or other data integrity problems. Read more

1 comments, 489 reads

Posted in The Voice of the DBA on 2 May 2011