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: January 2014

Powershell in a Month Day 14 – WMI

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

Day 14 introduces us to Windows Management Instrumentation (WMI). Since many people might not be familiar with WMI, the chapter spends… Read more

1 comments, 284 reads

Posted in The Voice of the DBA on 31 January 2014

Starting to Use Powershell

I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of anything. It looked cumbersome, I didn’t always understand how sample scripts worked, and it was just easier to use the various other Windows tools to accomplish tasks.

However as… Read more

0 comments, 357 reads

Posted in The Voice of the DBA on 30 January 2014

Just use Version Control

There are free systems out there. If you have no budget, and want to get started, download one of these:

There are good ones to pay for as well, and some of them have other features and integration you may like:

  • Team Foundation Server…

Read more

10 comments, 1,982 reads

Posted in The Voice of the DBA on 28 January 2014

Powershell in a Month Day 13 – Remote Control

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

Remoting. It sounds complex, and intimidating. It isn’t, and it’s powerful. It’s also essential, allowing you to access commands on remove… Read more

1 comments, 265 reads

Posted in The Voice of the DBA on 27 January 2014

Powershell in a Month Day 12 – A Practical Interlude

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

This chapter is a practical one. Build a scheduled task that removes all jobs from a certain printer. Not that hard,… Read more

1 comments, 178 reads

Posted in The Voice of the DBA on 22 January 2014

Using multiple CTEs in one query

This is a fairly simple thing to do, but I had to look it up the other day and thought it would make a good blog. This is a good example of a blog that everyone should write to show they know a particular skill.

TL;DR: Use a comma between… Read more

1 comments, 315 reads

Posted in The Voice of the DBA on 22 January 2014

Powershell in a Month Day 11 – Filtering

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

I’ve learned that the dash (-) is going to be my friend. Filtering and comparisons are the backbone of SQL. We… Read more

1 comments, 253 reads

Posted in The Voice of the DBA on 20 January 2014

Counting the Existing, and Missing, Rows

I saw this as a problem recently from someone and thought it would make a good post. As I was building a quick solution, someone else posted theirs, but I decided to save mine as a blog post. It was a good, quick, T-SQL exercise for me to work on. Read more

0 comments, 188 reads

Posted in The Voice of the DBA on 20 January 2014

Powershell in a Month Day 10 – Formatting

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

Not an exciting chapter for sure. This chapter deals with the formatting of results, or objects, for display (or saving to…

Read more

0 comments, 266 reads

Posted in The Voice of the DBA on 15 January 2014

Cleveland Rocks! (and does SQL Server)

My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak at SQL Saturday #241. Both are free events, taking place on February 7th and 8th, respectively, and it’s a great chance for you to improve your SQL Server skills,… Read more

0 comments, 165 reads

Posted in The Voice of the DBA on 15 January 2014

SQL in Albuquerque

It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and the beautiful state of New Mexico. I rarely get there now that my brother moved away, but’s always neat to visit.

I was lucky enough to get chosen… Read more

0 comments, 136 reads

Posted in The Voice of the DBA on 14 January 2014

T-SQL Tuesday #50–Automation

I missed last month and I was a bit sad, but I was traveling the week before and speaking, and then was on vacation. No time to write a post, and it was a tough topic from Robert Davis. However I’m back this month, and I’m thrilled to participate in… Read more

0 comments, 140 reads

Posted in The Voice of the DBA on 14 January 2014

The Powershell Challenge–Day 9 The Pipelines, deeper

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

The authors note this is an optional chapter, one that isn’t necessarily one you need to read. After going through it,… Read more

0 comments, 263 reads

Posted in The Voice of the DBA on 13 January 2014

Powershell in a Month – Day 8 Objects: data by another name

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

What are objects? I’ve always found that to be a hard question to answer if I’m talking to someone that doesn’t… Read more

0 comments, 271 reads

Posted in The Voice of the DBA on 9 January 2014

Lemonade and Life

I’ve got a torn ACL. I found out yesterday at a visit with a surgeon that gave me the results of his exam and an MRI I had last week.

Don’t feel too bad for me. I’ve had this for (I’m guessing) eleven years. In that time I’ve

  • run…

Read more

5 comments, 206 reads

Posted in The Voice of the DBA on 9 January 2014

Powershell in a Month – Day 7 Adding Commands

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

Post holidays, day 7 looks at the shell itself and adding in snap-ins and modules. I have to say that the… Read more

0 comments, 330 reads

Posted in The Voice of the DBA on 7 January 2014

The Powershell Challenge–Notes and Observations

It’s been a month and a half in real time since I started the Powershell Challenge. In that time, I had a business trip and 9 days of vacation and the holidays that impacted the event. After a week of working on the book, I ended up sporadically getting back… Read more

0 comments, 276 reads

Posted in The Voice of the DBA on 3 January 2014