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

T-SQL Tuesday #52 – Arguments

It’s time for T-SQL Tuesday, this month hosted by Michael J Swart, our artistic DBA in the community. I love Michael’s pictures, and enjoy the time I get to chat with him at events.

His invitation this month for #52 is to argue against a popular opinion. He asking us… Read more

3 comments, 138 reads

Posted in The Voice of the DBA on 11 March 2014

Virtual Lab – Adapter 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.

Once I had the machine up and running, I knew I needed to get the networking setup.… Read more

6 comments, 149 reads

Posted in The Voice of the DBA on 6 March 2014

Powershell in a Month – Day 19 – I/O

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 the I/O that we think of in T-SQL, but more the I/O that’s a part of many programming languages. This… Read more

1 comments, 191 reads

Posted in The Voice of the DBA on 3 March 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

0 comments, 176 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, 148 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, 222 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

0 comments, 178 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, 172 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

0 comments, 185 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, 112 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, 266 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, 770 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

0 comments, 53 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

0 comments, 212 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, 293 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,875 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

0 comments, 212 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

0 comments, 142 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, 216 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

0 comments, 194 reads

Posted in The Voice of the DBA on 20 January 2014

Newer posts

Older posts