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

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality.

I wrote recently about Windows 8 and what I consider to be poor design in the update system. Today I want to look at another aspect that troubles me.

Programs

I’ve gotten used to the… Read more

0 comments, 102 reads

Posted in The Voice of the DBA on 17 May 2013

Not My Google Reader Replacement

Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign up, so I decided to give it a try.

The import from Google Reader caught my attention, so I clicked it. It asked for an authorization from Google, and then… Read more

1 comments, 153 reads

Posted in The Voice of the DBA on 15 May 2013

T-SQL Tuesday #42–The Long and Winding Road

It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding Road. Wendy asks us to talk about your job, your road map to the future, and what might be in store for you.

T-SQL Tuesday is a monthly blog… Read more

0 comments, 157 reads

Posted in The Voice of the DBA on 14 May 2013

Schizophrenic Windows 8

I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back, which has only had Windows 8 installed on it. My new laptop arrived about 4 weeks ago and a week later I finally abandoned my Macbook Air and moved fulltime… Read more

2 comments, 176 reads

Posted in The Voice of the DBA on 10 May 2013

Starting with Git for Database Development

One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that allows you to hook your database up to version control. I’ve used it a few times in the past in conjunction with Subversion to demo the product. However I hadn’t… Read more

1 comments, 628 reads

Posted in The Voice of the DBA on 8 May 2013

Donating for a little kid

One of my authors sent me this note:

I know you only know me as a writer for SQLServerCentral, but I have a friend whose son is really bad. He is at the hospital and the cannot pay it. It is very expensive. The family is desesperate. They live… Read more

2 comments, 92 reads

Posted in The Voice of the DBA on 6 May 2013

Adding Data to Filestream with T-SQL

I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact on your tables. This post will look at the table side of Filestream and how you get your binary data into the database.

Let’s assume you have a filestream… Read more

0 comments, 170 reads

Posted in The Voice of the DBA on 25 April 2013

Does TDE really work on MDF files?

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:

-- create a database
CREATE DATABASE TDE_Primer
;
GO
-- create and populate a table
USE TDE_Primer
go
CREATE TABLE MyTable
( myid INT
, myname VARCHAR(20)
, mychar VARCHAR(200)…

Read more

1 comments, 1,348 reads

Posted in The Voice of the DBA on 22 April 2013

Doing Your Job

I wish this were the mantra of all people, but certainly those in technology:


Filed under: Blog Tagged: career, syndicated

Read more

1 comments, 223 reads

Posted in The Voice of the DBA on 19 April 2013

SQL Saturday #175–Fargo

One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I used to chat about how long it would be before we had 12 events in a year, or one event a month, or an event in every state. Karla Landrum… Read more

0 comments, 148 reads

Posted in The Voice of the DBA on 18 April 2013

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing.

As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many… Read more

2 comments, 116 reads

Posted in The Voice of the DBA on 15 April 2013

Disabling Resource Governor

I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the operation of the SQLOS, though it can’t be used to do anything unless it is enabled.

You can read more about it if you have Enterprise Edition, and I’ve… Read more

0 comments, 213 reads

Posted in The Voice of the DBA on 8 April 2013

Thirty Hours at Home

This is a busy travel week for me, and one of those times that stresses out everyone in the household. I attended SQL Saturday #197 – Omaha over the weekend, arriving home Sunday morning from my trip. I had a good time at the event, my first time to Omaha,… Read more

0 comments, 141 reads

Posted in The Voice of the DBA on 8 April 2013

Reminders and Rehearsal

I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by my count, I’ve been to 21, with 4 or 5 more coming this year.  I have no idea when I’ll get to 50, but I hope I do.

That’s… Read more

0 comments, 176 reads

Posted in The Voice of the DBA on 2 April 2013

The Great Laptop Search of 2013

It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a couple years ago. Rather some requirements for work, mainly Hyper-V, have come up and I can’t meet them with the Macbook Air. Even a 2013 summer refresh of this platform… Read more

10 comments, 1,995 reads

Posted in The Voice of the DBA on 28 March 2013

The DBA Team #1–Code and Slides

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again.

In the meantime, we didn’t make a separate site for this series of events,… Read more

2 comments, 314 reads

Posted in The Voice of the DBA on 27 March 2013

SQL Saturday #187–Richmond Recap

I’m late writing this, and I did mean to get to it earlier, but life got in the way.

TL;DR: It was a great event, lots of fun, and I’d love to do it again.

When I first heard of a SQL Saturday coming back to Richmond (from Carlos Chacon Read more

2 comments, 171 reads

Posted in The Voice of the DBA on 26 March 2013

A Week from Omaha–SQL Saturday #197

Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never been to Omaha, and only been to the state once, in the far SW corner to Oshkosh for a horse race. I’ll arrive Friday and have a short time to… Read more

0 comments, 206 reads

Posted in The Voice of the DBA on 25 March 2013

Macbook Air v Surface Pro

I love my MacBook Air. It’s small, light, and it works well as a traveling laptop for me. It starts and stops instantly, and the only complaint I have is that my 2011 version only has 4GB of RAM and no USB 3.0. The 2012 version improves, and I’d upgrade,… Read more

0 comments, 358 reads

Posted in The Voice of the DBA on 22 March 2013

Customizing SSMS – Bigger Queries

This is a short series on some customizations in SSMS to make it visually more appealing.

As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen on a projector. I had wrongly assumed that so many… Read more

0 comments, 360 reads

Posted in The Voice of the DBA on 21 March 2013

Older posts