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

Question what you think

0 comments, 578 reads

Posted in The Voice of the DBA on 26 October 2012

Windows 8 First Impressions

I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few months for me, so I haven’t bothered to mess with any of the previews. My Win 7 desktop works well for me, and I haven’t bothered to think about doing… Read more

0 comments, 647 reads

Posted in The Voice of the DBA on 25 October 2012

Trace Flag 2371 and Statistics

One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, and you should understand the basics of how they… Read more

4 comments, 2,681 reads

Posted in The Voice of the DBA on 22 October 2012

On Source Control

A mention today from Jamie Thomson in his blog on source control. I left a comment, but it was long, so I thought I’d repost it here.

My comment

Thanks for the note, Jamie, and it’s interesting, but I don’t see any respondents that aren’t using VSC. I’m guessing… Read more

0 comments, 790 reads

Posted in The Voice of the DBA on 18 October 2012

Important Alerts for SQL Server

One of the things that I think is extremely important for DBAs and really anyone that has to administer a SQL Server instance is a set of alerts on various items that might occur.

I ran across Glenn Berry’s article on Provisioning SQL Server and there’s a section in there… Read more

0 comments, 1,345 reads

Posted in The Voice of the DBA on 18 October 2012

Thirteen Years Old

A very cool shot of our company at 13.

I first heard of Red Gate back in 2001 and they were our first advertising customer at SQLServerCentral.

A few years ago they bought the company and I now work for them. It’s a great company, and a fun one. Things… Read more

0 comments, 515 reads

Posted in The Voice of the DBA on 16 October 2012

(Mis)Using DBCC Page

In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t always possible or practical, so I noted that if you don’t have resources on your production server, or enough spare hardware, you should at least run it on every… Read more

0 comments, 767 reads

Posted in The Voice of the DBA on 15 October 2012

Windows Server 2012 and Hyper-V

I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t) showed quite a few demos and there’s a number of demos and notes from the talks on his blog.

I haven’t looked much at the Windows… Read more

2 comments, 682 reads

Posted in The Voice of the DBA on 11 October 2012

Comments on the SQL in the City Tour

There’s still an event in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New York, Austin, San Francisco, Chicago and Boston, I’ve met a lot of people and shaken a lot of hands. There have been lots of questions as well as, I… Read more

1 comments, 597 reads

Posted in The Voice of the DBA on 9 October 2012

T-SQL Tuesday #35 – Soylent Green

This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I haven’t seen. This month he asks what the most horrifying thing you’ve seen in SQL Server. It’s been a long few weeks for me, so I‘ll… Read more

2 comments, 502 reads

Posted in The Voice of the DBA on 9 October 2012

Database Maintenance Essentials – Resources

I told people in New York at SQL in the City that I’d post some resources on the blog from my talk. My apologies for not getting it done over the weekend, but during a little downtime in Austin I’m getting it done.

Checklist

From the last slide, a checklist… Read more

1 comments, 629 reads

Posted in The Voice of the DBA on 1 October 2012

SQL in the City

That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US SQL in the City tour.

I arrived Thursday, getting into the city in time to go running in Central Park. A solo #sqlrun, but one I enjoyed on a beautiful… Read more

0 comments, 586 reads

Posted in The Voice of the DBA on 1 October 2012