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: April 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, 424 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,768 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, 365 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, 289 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, 310 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, 390 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, 287 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, 341 reads

Posted in The Voice of the DBA on 2 April 2013