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

Holiday

Taking some of my own advice. I’m off today and tomorrow, as well as Monday for Labor Day. Across this 5 day weekend, I have a number of chores to tackle, including trying to build another horse shelter before winter.

However I will look to recharge and relax a… Read more

0 comments, 569 reads

Posted in The Voice of the DBA on 30 August 2012

The Field Museum – SQL in the City 2012 – Chicago

Chicago is a neat down. My first PASS Summit was in Chicago, back in 1999. My wife joined me with an infant son, and we took in the last baseball game of the season that year at Comisky Park. This year I was hoping to take in a game… Read more

3 comments, 1,164 reads

Posted in The Voice of the DBA on 29 August 2012

Enable Transparent Data Encryption

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do, and it’s rather mechanical, so I just show the image that has the steps from MSDN and leave it at that.

However there are a few things I wanted to… Read more

1 comments, 1,697 reads

Posted in The Voice of the DBA on 28 August 2012

The Embarcadero – SQL in the City San Francisco

I love San Francisco. It was one of the cities that I thought I might live in someday. My kids have all been there multiple times, exploring museums, crossing the amazing Golden Gate Bridge, visting Muir Woods and more. When I heard SQL in the City was coming to S.F,… Read more

0 comments, 495 reads

Posted in The Voice of the DBA on 27 August 2012

Amazing Margaritas in Austin – SQL in the City US Tour

The last time I was in Austin was last year, for a weekend trip with my wife to see Stevie Wonder and Kanye West (on separate days) at the Austin Music Festival. My wife and I have been trying to see Stevie Wonder for over ten years, and we… Read more

3 comments, 975 reads

Posted in The Voice of the DBA on 23 August 2012

Learning about Driving with Big Data

This is nice, a year long safety pilot from the University of Michigan. Quite extensive, using 3,000 cars to gather data. I don’t know what they’ll get out of this, and if you read the comments, there’s all kinds of speculation, but it’s a good idea, in my opinion. Read more

0 comments, 405 reads

Posted in The Voice of the DBA on 23 August 2012

Disabling DDL Triggers

Suppose you want to stop using a DDL trigger for a short period of time, such as the login trigger I created recently. If you want to disable an index, you use

ALTER INDEX xxx DISABLE

That doesn’t work for triggers. The ALTER TRIGGER syntax is used for changing code. Read more

5 comments, 1,238 reads

Posted in The Voice of the DBA on 21 August 2012

Running in Central Park at SQL in the City New York

I just booked my tickets for New York City. I’m coming into the city on Sept 27, at 2pm, with just enough time to get to my hotel, drop my bags, and then hit Central Park for a run. I love to run, and Central Park is great. It’s on… Read more

3 comments, 938 reads

Posted in The Voice of the DBA on 20 August 2012

Home Backup for the DBA

I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed to get you to think about problems before they happen and take steps to mitigate issues. It’s important at work, but it’s also important at home.

If you read the… Read more

4 comments, 881 reads

Posted in The Voice of the DBA on 17 August 2012

Where’s My Certificate Backup?

If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner, and if I need to move the instance somewhere else, all my code works. No pathing issues.

A certificate backup might look like this for me:

USE master
;
go…

Read more

0 comments, 1,041 reads

Posted in The Voice of the DBA on 16 August 2012

The Home Server is Back

After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of a monitor cord. We’d given a monitor to a friend recently, which was the one rarely used for the Home Server. It wasn’t a big deal since we always log… Read more

2 comments, 320 reads

Posted in The Voice of the DBA on 15 August 2012

T-SQL Tuesday #33 – Trick Shot

It’s T-SQL Tuesday time again, and this is my post for #33. The host is Mike Fal and his topic is Trick Shots, which is an interesting one. I’m not a tricky guy, and I tend to lean towards common, practical approaches to problems. I’m not sure this post… Read more

2 comments, 484 reads

Posted in The Voice of the DBA on 14 August 2012

Standing Desk – Flooring

My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowly found places for my coffee, water, phone, and other things that I use at my desk. I still need to work on the keyboard/mouse stand, but that’s a future project. Today I… Read more

2 comments, 490 reads

Posted in The Voice of the DBA on 10 August 2012

Excluding Schemas in SQL Compare

I saw this question posted the other day and thought it was a great idea.

I haven’t been a big schema user in the past, but I see the value of excluding some schemas. CDC for sure, but I know some people have an ETL schema, which is much nicer… Read more

0 comments, 831 reads

Posted in The Voice of the DBA on 9 August 2012

Removing a DDL Trigger

In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d run this:

DROP trigger CatchLogins

That returns me this nice message:

Msg 3701, Level 11, State 5, Line 1

Cannot drop the trigger ‘CatchLogins’, because it does not exist… Read more

0 comments, 408 reads

Posted in The Voice of the DBA on 7 August 2012

Identity Insert and Table Variables – CONNECT issue

I was running some code the other day and was surprised by the result.

DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))

INSERT INTO @tmp(MyChar) Values('Apple')
INSERT INTO @tmp(MyChar) Values('Peach')
INSERT INTO @tmp

Read more

4 comments, 1,245 reads

Posted in The Voice of the DBA on 3 August 2012

Who’s Responsible

This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I certainly think that downloading stuff that’s a copyright violation shouldn’t be mainstream as in Amazon giving away movies for free without compensating owners of the copyrights.

Setting that aside,… Read more

0 comments, 440 reads

Posted in The Voice of the DBA on 3 August 2012

Startup Jobs

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you can run a job when the Agent starts?

I haven’t often used this, but there are cases where it was handy. In one system I administered, we wanted very fast… Read more

2 comments, 1,541 reads

Posted in The Voice of the DBA on 2 August 2012

Forty Five Minutes

Excellent: Dilbert on data analysts

The best part is the last quote: I like how you punctuate your ignorance with certainty.


Filed under: Blog Tagged: Humor, syndicated

Read more

0 comments, 415 reads

Posted in The Voice of the DBA on 1 August 2012