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 2013

Powershell in a Month – Day 3 – Commands

This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

Day 3, chapter 4.

This one is about commands, and getting familiar with what a cmdlet is, the naming convention, and… Read more

2 comments, 402 reads

Posted in The Voice of the DBA on 21 November 2013

Backups and Consistency

I wrote about transactional consistency recently. Why do we need this?

Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes information about the items purchased (product, qty, price). Let’s say… Read more

1 comments, 371 reads

Posted in The Voice of the DBA on 20 November 2013

Powershell in a Month – Day 2, Help

This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

Today was Chapter 3, Using the Help System. Another not-so-exciting topic, but one that does matter. There are a ton of… Read more

1 comments, 411 reads

Posted in The Voice of the DBA on 14 November 2013

Powershell in a month – Day 1

I got started on Learn Windows Powershell 3 in a Month of Lunches at lunch one day. Working at home makes this easy as I have a computer and a kitchen near each other. In this case, a salad, a bowl of chili, and the laptop next to the book… Read more

2 comments, 566 reads

Posted in The Voice of the DBA on 13 November 2013

T-SQL Tuesday #48–Cloud Atlas

I never saw the movie, though it’s on my list to watch sometime. I love the Wachowski’s as directors.

This month Jorge Segarra is hosting. He is better known as the SQLChicken, and his theme this month is Cloud Atlas. He’s asking us to write about the… Read more

2 comments, 236 reads

Posted in The Voice of the DBA on 12 November 2013

How SQL Server Full Backups Work

I’m writing this in support of a few talks I give that talk about backups. This is how I see things and it’s based on things I’ve learned over time. Some of this comes from a great explanation on Technet from Paul Randal, but there are misc other sources… Read more

0 comments, 312 reads

Posted in The Voice of the DBA on 11 November 2013

The Powershell Challenge

I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve dabbled in various ways, using it to handle small tasks. However I haven’t really committed to learning a bunch of PoSh.

Last month I was with Grant Fritchey on the… Read more

10 comments, 534 reads

Posted in The Voice of the DBA on 7 November 2013

Transactionally Consistent

What does this mean? I had someone ask me in a session recently, and I think I have a good explanation, but I thought this was worth a blog.

Transactionally Consistent means that there is a snapshot of the database at a point in time that ensures committed transactions are… Read more

0 comments, 319 reads

Posted in The Voice of the DBA on 6 November 2013