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

SQL Server Thumbnail Metrics – OS Memory

I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to run a SQL Server. This is a series of posts that I’m making to gather these metrics up for easy access later.

Host Memory

The short metric is:

Leave 4GB… Read more

1 comments, 1,772 reads

Posted in The Voice of the DBA on 29 November 2012

The Last DBCC CHECKDB Date and Restores

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For those of you that don’t know this, you can run this command on your instance (in a database)

DBCC DBINFO WITH tableresults;

This returns a lot of information, but… Read more

1 comments, 1,510 reads

Posted in The Voice of the DBA on 28 November 2012

The Encryption Primer Resources

I delivered my Encryption Primer talk this past Tuesday at the Boulder SQL Server Users Group and last night at the Denver SQL Server Users Group. Great questions and discussions, and I hope those of you that attended found it interesting.

I’ve updated my deck and code samples, and here… Read more

0 comments, 458 reads

Posted in The Voice of the DBA on 16 November 2012

Better Secure Hashing – SHA3

I’ve been giving an encryption talk over the last year, focusing on educating DBAs on the various features and capabilities available in SQL Server. One of the things I note in the talk is that SHA1 is not considered secure. You should avoid SHA or SHA1 if you are… Read more

0 comments, 509 reads

Posted in The Voice of the DBA on 15 November 2012

Speaking at the Denver SQL Server User Group – November

I’m scheduled to give “The Encryption Primer” at the Denver SQL Server Users Group on the November 15 meeting. It’s a basic look at the encryption features in SQL Server, updated for SQL Server 2012. The meeting is in the Denver Tech Center and we usually have a… Read more

0 comments, 399 reads

Posted in The Voice of the DBA on 7 November 2012

Speaking at the Boulder SQL Server Users Group – November

I’m scheduled to give “The Encryption Primer” at the Boulder SQL Server Users Group on the November 13 meeting. It’s a basic look at the encryption features in SQL Server, updated for SQL Server 2012. This meeting is at the Confio office and will have a short presentation… Read more

0 comments, 416 reads

Posted in The Voice of the DBA on 6 November 2012

Professional Development on PASS TV

I’ll be live on the PASS TV broadcast on Wednesday, Nov 7, at 11:40am PST. The Professional Development group asked me to do a short (15 minute) talk, and I’ve put together a set of quick blogging tips with a few slides.

If you’re not at the PASS Summit, you… Read more

1 comments, 579 reads

Posted in The Voice of the DBA on 5 November 2012

SQL in the City Slides

I’m making the slides available from my SQL in the City 2012 talks. You can download them here

If you attended, you’ll get an email with links to videos to watch soon.


Filed under: Blog Tagged: disaster recovery, encryption,…

Read more

0 comments, 444 reads

Posted in The Voice of the DBA on 5 November 2012

Friday at Red Gate

Looks like I’m not the only one enjoying Friday.

Some of the staff at Red Gate had a Hawaiian day. Nice shirts, though perhaps I need to take a few over when I go since I think mine at much cooler


Filed under: Blog Tagged: Humor, syndicated

Read more

0 comments, 499 reads

Posted in The Voice of the DBA on 2 November 2012