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: September 2012

Full Text Search – CONTAINS

I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators. Part of my talk goes into the CONTAINS operator, which is one of the full text search keywords you need to know.

This operator is only used with full text… Read more

3 comments, 1,735 reads

Posted in The Voice of the DBA on 27 September 2012

Off to the Center of the Universe

“New York City…center of the universe..” – Rent

I’m off to New York this morning for the start of the 2012 SQL in the City US Tour. It kicks off tomorrow in New York City.

As this posts, I’ve just dropped my son off at school early for a… Read more

1 comments, 667 reads

Posted in The Voice of the DBA on 27 September 2012

Transferring Table Types

An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move a table type between schemas?”

Suppose I had two schemas:

CREATE SCHEMA OldSchema
;
GO
CREATE SCHEMA NewSchema
;
GO

In one of them, I create a table type and… Read more

0 comments, 892 reads

Posted in The Voice of the DBA on 25 September 2012

Verify those Backups

It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you need to verify those backups are good.

A humorous short video from Grant Fritchey (b | t) and RedGate on why:

Watch the video

Ideally you verify every… Read more

1 comments, 442 reads

Posted in The Voice of the DBA on 21 September 2012

Join Our Networking Dinner in Seattle

This is the third year that Andy Warren and myself are hosting a networking dinner in Seattle, just before the PASS Summit. If you are new to the Summit, or just interested in meeting some new people, we hope you’ll join us on Monday, Nov 5, at Gordon Biersch,… Read more

0 comments, 593 reads

Posted in The Voice of the DBA on 20 September 2012

Creating a User Defined Table Type

I saw a post about a user defined table type in SQL Server and I was sure it was a typo. I kept thinking the poster meant table variable, but when I searched the term in Books Online, I was surprised to find User-Defined Table Types as an entry.

These… Read more

2 comments, 13,459 reads

Posted in The Voice of the DBA on 19 September 2012

SQL in the City – US 2012 Tour

Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It was a great time and I was hoping we’d do more events this year.

We did, with 2 events in London in July of this year and now we’re about… Read more

0 comments, 734 reads

Posted in The Voice of the DBA on 18 September 2012

The DevConnections Schedule is out

It’s preliminary, but the fall 2012 SQL Server Connections schedule at DevConnections is out. I’ll be speaking Tuesday, Oct 30, 2012, along with Grant Fritchey (b | t), on the SQLServerCentral track.

This is traditionally the “Microsoft day” where sessions are all presented by Microsoft, but this time… Read more

0 comments, 646 reads

Posted in The Voice of the DBA on 14 September 2012

Interesting Culture

A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall I think there are good ideas in here. In fact, a number of them remind me of my time at IQDestination (my thoughts), and some remind me… Read more

0 comments, 536 reads

Posted in The Voice of the DBA on 14 September 2012

Finding DDL Triggers

Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious way to tell that a table has a trigger on it and since most tables don’t have triggers, this is one of the things people often miss when troubleshooting unexpected… Read more

0 comments, 831 reads

Posted in The Voice of the DBA on 13 September 2012

Labor Day Bloopers

The raw footage of all the mistakes I’ve made since the Fourth of July.

Part 1

Part 2


Filed under: Blog Tagged: Humor, syndicated

Read more

0 comments, 476 reads

Posted in The Voice of the DBA on 12 September 2012

Talking Career and Unstructured Data

The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver, and the fifth in the state and I am honored to be able to speak. I have two sessions on the schedule:

Read more

0 comments, 396 reads

Posted in The Voice of the DBA on 11 September 2012

T-SQL Tuesday #34 – Help! I Need Somebody

I couldn’t resist, so here goes….

Help, I need some data,
Help, not just any data,
Help, I was told you need a report, help.
When I was younger, so much smarter than today,
I never needed any query help in any way.
But now these reports are long, I’m…
Read more

1 comments, 460 reads

Posted in The Voice of the DBA on 11 September 2012

Sleepless in Seattle – SQL in the City 2012

A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle son and we spent 3 days wandering around Seattle, seeing some amazing sights. We went to the Museum of Flight and the Underground Tour, along with a few other… Read more

2 comments, 1,014 reads

Posted in The Voice of the DBA on 10 September 2012

This is Big Data

I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.

A day.

That’s serious data. I’ve never had a database that was a TB, must less growth by over a TB a day.

To be fair, lots of the Facebook… Read more

0 comments, 504 reads

Posted in The Voice of the DBA on 6 September 2012

The Charles River – SQL in the City Boston

I once rowed in the Head of the Charles Regatta. I had the 3d seat, starboard, in a 4 man boat and it was quite exciting to come up to Boston and row down the famed Charles River. It was hard, and the river was rough, tossing waves in… Read more

0 comments, 990 reads

Posted in The Voice of the DBA on 4 September 2012

Quick T-SQL Performance Comparison

I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask someone like Jeff Moden or Wayne Sheffield to help me write a solution.

However I have a few tricks to check things out quickly and determine what’s a better solution.… Read more

4 comments, 704 reads

Posted in The Voice of the DBA on 3 September 2012