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

Back from DevConnections

I spent a few days at DevConnections this week and really enjoyed the conference. The location was Aria in Las Vegas, where I’ve never been, but it was a new, really nice hotel and there was one amazing thing:

The wi-fi worked.

Not on and off, pretty much the entire… Read more

0 comments, 112 reads

Posted in The Voice of the DBA on 19 September 2014

DevConnections 2014

It’s time for Devconnections again, and I’m back in Las Vegas for the conference. This is a great conference if you work with a variety of Microsoft technologies, or want to learn about something in addition to SQL Server. We have some great SQL Server talks, but if you want… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 16 September 2014

We’re On

We crossed the $10k mark for the Argenis Without Borders campaign, meaning that Brent, Grant, Adam, Gail, and myself will join Argenis in dressing up in colorful costumes at the PASS Summit. I’ve already purchased a few things, and I’m ready.

I’d like to thank everyone that donated, as… Read more

0 comments, 152 reads

Posted in The Voice of the DBA on 16 September 2014

Better Presentations–Zoom

This is part of a series of tips for speakers on how to make your presentations better.

I’ve given around 30 presentations a year for the last few years, and easily a dozen a year for a number of years before that. I visit events all over the US and… Read more

0 comments, 84 reads

Posted in The Voice of the DBA on 16 September 2014

Untested

The 2014 Apple keynote was today, with the announcement of the iPhone 6 and iWatch taking center stage. I was excited, with an aging iPhone 4S that needs to be replaced. I tuned in, expecting to watch the announcements while taking care of some busywork on the other monitor.

At… Read more

0 comments, 137 reads

Posted in The Voice of the DBA on 9 September 2014

The BBQ Crawl at SQL Saturday #300

This weekend is SQL Saturday #300 in Kansas City. I’ll be traveling Friday for the event, hoping to arrive in time to go on the pre-event barbeque crawl that the organizers set up every year. It’s hard to believe it’s been 4 years since I was last in KC.… Read more

0 comments, 104 reads

Posted in The Voice of the DBA on 8 September 2014

Better Presentations–Fonts

This is part of a series of tips for speakers to make your presentations better.

Please, please, please, learn how to set up your machine to look good on screen.

I saw Brent Ozar write a few notes on how to make your presentations better recently. This was primarily for… Read more

0 comments, 105 reads

Posted in The Voice of the DBA on 8 September 2014

Silicon Valley is a different world

I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing their organizations with continuous delivery and design, and lean product development.

It does some of that, but it wasn’t what I expected. The attendees for the most part were people… Read more

4 comments, 153 reads

Posted in The Voice of the DBA on 5 September 2014

Off to Flowcon 2014

With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on, I thought it would be instructive to go see how the software developers build their product better. A few months ago I noticed that FlowCon 2014 was coming to San… Read more

0 comments, 111 reads

Posted in The Voice of the DBA on 3 September 2014

Crosstabs over Pivots

I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data into columns. That’s handy, and lots of people have a need for it. However I’d never used PIVOT in production code. I’ve always written a crosstab query instead.

If I… Read more

2 comments, 1,271 reads

Posted in The Voice of the DBA on 2 September 2014

I did my part – Helping others

Let’s raise some money, people.

TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.

What started out as a joke has grown, and we’re really looking to raise some money for this charity. I did my part

I started shopping, and I’ll be rainbow decked for the… Read more

0 comments, 3,762 reads

Posted in The Voice of the DBA on 28 August 2014

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better.

I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, and that might mean the difference between someone learning… Read more

8 comments, 5,643 reads

Posted in The Voice of the DBA on 26 August 2014

The ALS Ice Bucket Challenge

A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver SQL Server User Group meeting, Todd Kleinhans was ready to take the challenge and asked if I’d participate.

I was speaking, but happy to do it afterwards. Here we… Read more

1 comments, 745 reads

Posted in The Voice of the DBA on 22 August 2014

Updating tsqlt

I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s logic and planned on using the FakeFunction procedure available in tsqlt.

I wrote my test, using a template from the Pluralsight course on tsqlt and the documentation. I tried to… Read more

0 comments, 149 reads

Posted in The Voice of the DBA on 20 August 2014

SQL in the City 2014

It’s official, we have a couple 2014 SQL in the City events scheduled, covering two countries this fall. Both events are packed into a short time (less than two weeks), so Grant and I have quite a bit of travel ahead of us.
 
Once again we’ve divided up the…

Read more

0 comments, 260 reads

Posted in The Voice of the DBA on 19 August 2014

Playing with Pivot

I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT operator. This is a T-SQL construct that helps you turn row data into column data. It’s part of the SELECT query, and comes about in the FROM clause. There… Read more

2 comments, 6,858 reads

Posted in The Voice of the DBA on 18 August 2014

MS14-044–Security Alert for SQL Server

I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL Server. Here’s the bulletin:

MS14-044

There are QFE and GDR patches for versions since 2008, but you need to read carefully to determine which one to install on your systems. Read more

0 comments, 106 reads

Posted in The Voice of the DBA on 12 August 2014

T-SQL Tuesday #57–SQL Family and Community

It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.

The topic this month is hosted by Jeffrey Verheul and it is SQL Family and Community. That’s a topic near and dear to my heart, and I’m glad to participate this month. Jeffrey asks: How… Read more

2 comments, 83 reads

Posted in The Voice of the DBA on 12 August 2014

Do We Care?

Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog, twitter), and I think it’s worth a few minutes of your time to read.

It’s aimed more at executives, and certainly talks about the disconnect… Read more

0 comments, 36 reads

Posted in The Voice of the DBA on 11 August 2014

Quick Tips–SQL Prompt Custom Aliases

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

0 comments, 7,202 reads

Posted in The Voice of the DBA on 24 July 2014

Older posts