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

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, 306 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, 239 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, 250 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, 241 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, 176 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, 364 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, 846 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, 97 reads

Posted in The Voice of the DBA on 3 February 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, 301 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, 368 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, 2,003 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, 277 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, 189 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, 330 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, 259 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, 193 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, 280 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, 171 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, 145 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, 147 reads

Posted in The Voice of the DBA on 14 January 2014

Newer posts

Older posts