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

Powershell in a Month Day 18–Variables

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’m slightly behind here after holidays and some travel. Apparently my pop-up reminder for my own studies bears about as much… Read more

1 comments, 259 reads

Posted in The Voice of the DBA on 28 February 2014

Virtual Lab – Setting up a new VM

This is part of a series where I set up a virtual lab for testing and misc. work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.

I have my disks set up, now it’s time to create my virtual machines. I’m going to… Read more

1 comments, 256 reads

Posted in The Voice of the DBA on 27 February 2014

Virtual Lab – Creating Differencing Disks

This is part of my series on building a virtual lab for use with SQL Server and Windows. You can see the entire series here: Building a Virtual Lab with Hyper-V.

The whole point of virtualization is better use of resources. Whether it’s CPU, storage, networking, power, etc., we… Read more

1 comments, 330 reads

Posted in The Voice of the DBA on 20 February 2014

Powershell in a Month Day 17 – Security Alert

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.

Security. It’s important, and I was thinking this chapter would show us more about changing security. Instead, this chapter is really…

Read more

1 comments, 256 reads

Posted in The Voice of the DBA on 14 February 2014

Building a Virtual Lab with Hyper-V

I needed to get this one on Hyper-V, so I decided to document the process. I’ve put together a series that looks at the steps I took.

This… Read more

4 comments, 265 reads

Posted in The Voice of the DBA on 13 February 2014

Powershell in a Month Day 16 – Working with many objects

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.

One of the great powers of T-SQL is that we can owrk with many rows at once. We use a query…

Read more

1 comments, 258 reads

Posted in The Voice of the DBA on 12 February 2014

T-SQL Tuesday #51 – Place Your Bets

It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas, and with that theme in mind, he calls for you to Place Your Bets.  That’s a time when someone has gambled, or risked something on an application, venture, process… Read more

1 comments, 192 reads

Posted in The Voice of the DBA on 11 February 2014

Virtual Lab – Design and Setup

This is part of a series where I set up a virtual lab for testing and misc work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.

I haven’t had a good lab set up since I moved from VMWare to Hyper-V on my… Read more

10 comments, 380 reads

Posted in The Voice of the DBA on 6 February 2014

SQL Deep Dives at Intersection in April

SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of the 13-16th. I’ll be there speaking, along with an amazing lineup of other SQL Server experts. The SQLskills crew is headline and organizing the event and I’m looking forward to… Read more

0 comments, 860 reads

Posted in The Voice of the DBA on 4 February 2014

Powershell in a Month Day 15 – Jobs

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.

Jobs are important, mostly because running stuff interactively, and manually, is a pain. The real power of PoSh administration, in my… Read more

1 comments, 107 reads

Posted in The Voice of the DBA on 3 February 2014