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

Start SQL Server in Single User Mode

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

I saw someone recently ask how to reset the sa password, and myself (along with a few others) suggested starting SQL Server in single user mode as an… Read more

0 comments, 107 reads

Posted in The Voice of the DBA on 3 August 2015

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was testing some type of deployment scenario, and didn’t want to drop the database, but rather just remove objects and redeploy.

I know SQL Compare could do this, so I mocked… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 3 August 2015

Using the DAC

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

The DAC is a really important tool for anyone managing a SQL Server. You might not use it often, but when you need it, you really need it.… Read more

0 comments, 85 reads

Posted in The Voice of the DBA on 3 August 2015

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

1 comments, 149 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, 496 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, 177 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, 70 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, 30 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

6 comments, 25 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, 155 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, 191 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, 167 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, 161 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, 204 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,466 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, 313 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,553 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, 179 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, 189 reads

Posted in The Voice of the DBA on 16 June 2015

Older posts