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

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, 290 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, 314 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, 323 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, 436 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, 190 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, 265 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, 448 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, 253 reads

Posted in The Voice of the DBA on 6 November 2013

One day in the office

I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling and speaking this week. Today I’m in the office, but only today.

Tomorrow I’m outside.

I have more vacation scheduled tomorrow, along with Monday and Tuesday. Given the nature of… Read more

0 comments, 187 reads

Posted in The Voice of the DBA on 31 October 2013

Time Off

I’m booking vacation. I know I recommend balance, and tell people to take vacation, and that I’m bad at it. My wife is right there with me. I’m not sure who’s worse, but we both struggle to make time away from work. It’s good and bad. We enjoy our careers,… Read more

1 comments, 189 reads

Posted in The Voice of the DBA on 18 October 2013

It Still Happens – Full Transaction Log

Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again recently. I don’t have an exact count of threads, but rough searches show this to have 70,000+ results, when most other searches I run show many, many fewer results… Read more

0 comments, 299 reads

Posted in The Voice of the DBA on 17 October 2013

Getting Started with CI and Databases

It’s fairly easy. At least, I think it is if a salesperson can do it.

Alex Yates, salesman extraordinaire at Red Gate Software, spent a lunch hour recently setting up a CI system so he could better understand how hard, or easy, it can be for customers. He wrote about… Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 16 October 2013

Two Weeks to SQL Intersection

If you haven’t made it to a conference this year, you’ve still got a great one to think about: SQL Intersection. The second installment of this conference, run by SQLskills (Kimberly Tripp and Paul Randal) takes place in two weeks. Come to Las Vegas and learn a ton about… Read more

1 comments, 175 reads

Posted in The Voice of the DBA on 14 October 2013

One Down

Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3 talk and a keynote that I needed to integrate and work with two others on. We practiced 3 or 4 times on Tuesday and Wednesday morning, trying to get our… Read more

0 comments, 199 reads

Posted in The Voice of the DBA on 10 October 2013

T-SQL Tuesday #47 – SWAG

It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular topic. This month Kendal Van Dyke has invited us to take a break from technical topics and have a bit more fun. This month’s topic is asking about the swag… Read more

0 comments, 129 reads

Posted in The Voice of the DBA on 8 October 2013

My Busy Weekend

This weekend is the fall camporee for my middle son’s Boy Scout troop. He’s one of the senior scouts in the group, and he’s committed to help run some of the training sessions and competitions for younger boys. He asked if I’d go along on the trip and help out,… Read more

0 comments, 98 reads

Posted in The Voice of the DBA on 7 October 2013

The SQL in the City Tour is Almost Here

Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for the 2013 US SQL in the City tour! Once again the crew from Red Gate is traveling around the country, putting on our one day, free, educational SQL in the… Read more

0 comments, 104 reads

Posted in The Voice of the DBA on 4 October 2013

DevConnections Slides and Code

I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of other events, but a good time. I presented two sessions and both went well. I had some good questions from the audience and people seemed to enjoy the talks. In… Read more

0 comments, 95 reads

Posted in The Voice of the DBA on 3 October 2013

Networking at the PASS Summit: First timers

The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many… Read more

1 comments, 147 reads

Posted in The Voice of the DBA on 3 October 2013

Encryption and Full Text Search at The Mandalay Bay (DevConnections)

It’s just a week until Dev Connections.  This is one of the great conferences for the hybrid technology person, with a variety of technologies being talked about, all for a single admission price. I’ll be speaking at SQL Server Connections, but wandering over to the development side at… Read more

0 comments, 144 reads

Posted in The Voice of the DBA on 23 September 2013

Newer posts

Older posts