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

Halloween at PASS–Donate for some fun

This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots of people will have some fun on Friday, though I also suspect we’ll see no shortage of people leaving early to get home to spend the holiday with families.

A… Read more

0 comments, 145 reads

Posted in The Voice of the DBA on 29 July 2015

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.

Security is important for our database servers. One of the loopholes that everyone should be aware of is that the service running SQL Server has complete control over the service and potentially… Read more

0 comments, 349 reads

Posted in The Voice of the DBA on 28 July 2015

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in, so stick with me.

I had to get a tire fixed this morning. I actually owned a replacement tire, so I just needed someone to mount it on the existing… Read more

0 comments, 169 reads

Posted in The Voice of the DBA on 27 July 2015

Get Away from the Heat and Learn some Database Version Control

I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few minutes before an easy drive up the road. However it’s warm, and I can’t ever get my wife or kids to come… Read more

2 comments, 67 reads

Posted in The Voice of the DBA on 24 July 2015

My SQL Server Service Account Philosophy

Recently someone sent me a question about service accounts. They weren’t sure how they should go about setting accounts up for various instances and services in their environments. Specifically they asked me about having domain accounts, or accounts separate for services.

Note that I’ve managed SQL Server for years this… Read more

2 comments, 29 reads

Posted in The Voice of the DBA on 23 July 2015

Argenis Without Borders – v2

Last year at the PASS Summit, Kristen Benzel and Argenis Fernandez put on a fundraiser to raise money for Doctors Without Borders. It was very successful, bringing over $13,000 to the charitable work this organization does.

We had fun with it, with some great rainbow costumes that were displayed… Read more

5 comments, 24 reads

Posted in The Voice of the DBA on 21 July 2015

Azure SQL Database – Link User to Login

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I created a login for an Azure SQL Database, but couldn’t log in. I would get this message, which makes perfect sense.

Just… Read more

0 comments, 151 reads

Posted in The Voice of the DBA on 20 July 2015

Looking Back at a Sabbatical – One Year Later

Last year at this time I was nearing the end of my sabbatical. I’ve been using the Timehop app on my phone to look back at the past and I’ve noticed the tweets and pictures that I had from last year popping up. I decided it was a good time… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 14 July 2015

Database Version Control Workshops

We’ve got more Workshops coming this fall from Redgate Software to help you get the most out of our tools and improve your database development processes. The list of our training schedule is out, and I’ll be at a few of these.

The schedule does changes as we can add… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 13 July 2015

Azure SQL Database – Adding a Login

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I am trying to slowly do a little work in the Azure SQL Database world, building some skills that I can use, and I… Read more

0 comments, 159 reads

Posted in The Voice of the DBA on 13 July 2015

Get a comma separated list

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I was working on a test of sorts and wanted to return multiple values as the output, but as a single variable. In other… Read more

4 comments, 202 reads

Posted in The Voice of the DBA on 8 July 2015

Defining Foreign Keys at Table Create Time

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

How many of you can define a foreign key when you create the table? Probably a few of you, but I bet most of you are like me… Read more

2 comments, 1,460 reads

Posted in The Voice of the DBA on 2 July 2015

Updating Extended Properties on a Table

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I wrote recently about adding an extended property to a table. As part of what I was testing, I also needed to update properties,… Read more

0 comments, 175 reads

Posted in The Voice of the DBA on 1 July 2015

Congrats Summit 2015 Speakers

The PASS Summit 2015 Speaker list has been released and I wanted to congratulate everyone that was accepted. It’s a great honor and I’m proud to be on the list once again.

I also apologize to everyone that submitted and wasn’t accepted. I hadn’t planned on submitted, but part of… Read more

1 comments, 310 reads

Posted in The Voice of the DBA on 26 June 2015

Adding Extended Properties to a Table

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had the need recently to get put an extended property on a table in a database. I could easily have done this in SSMS, and have used… Read more

2 comments, 1,546 reads

Posted in The Voice of the DBA on 24 June 2015

Our Meeting and The Day Out

Last week, Redgate Software had a large company meeting and our annual Day Out, with myself and a few dozen of our US employees in the UK for meetings and the event. It was fun, and a good time. I haven’t been to a company meeting live in 6 or… Read more

0 comments, 178 reads

Posted in The Voice of the DBA on 23 June 2015

The Company Meeting

I’m leaving today for a trip to Cambridge, UK. I do this 2-3 times a year, but this one is a little different. I’m being joined by most of my American colleagues at Redgate, all of whom are being flown over to attend a company meeting and a company day… Read more

0 comments, 188 reads

Posted in The Voice of the DBA on 16 June 2015

See Two Queries at Once in SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

One of the things that I’ve struggled with a bit in SSMS is sometimes comparing the results of two batches. I’m sure many of… Read more

0 comments, 235 reads

Posted in The Voice of the DBA on 15 June 2015

Using the DAC with SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

While troubleshooting another issue, I needed to connect to SQL Server with the DAC. I couldn’t remember the syntax, so I looked it up… Read more

2 comments, 237 reads

Posted in The Voice of the DBA on 11 June 2015

Unexpected Windows 10

This was strange. I noticed a new icon in the taskbar today. When I hovered over it, I saw this:

I downloaded the Windows 10 beta in a VM, but not here. However apparently some update added this. If I click on it, I see this:

I hadn’t been reading… Read more

1 comments, 223 reads

Posted in The Voice of the DBA on 10 June 2015

Older posts