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

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, 60 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, 46 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, 182 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, 211 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, 186 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, 182 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, 237 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,509 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, 196 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, 355 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,639 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, 192 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, 200 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, 249 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

3 comments, 253 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

4 comments, 251 reads

Posted in The Voice of the DBA on 10 June 2015

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland on Extended Events. You can read the invite, and whether you can participate today or not, write your blog and leave a comment for Jes on her blog.

If… Read more

0 comments, 1,052 reads

Posted in The Voice of the DBA on 9 June 2015

FORMATing Dates

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.

FORMAT is a function that was introduced in SQL Server 2012. It is designed to format dates and numbers as date/times. It was added… Read more

3 comments, 2,178 reads

Posted in The Voice of the DBA on 3 June 2015

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more

2 comments, 238 reads

Posted in The Voice of the DBA on 27 May 2015

Changing NULL to NOT NULL – Dealing with Data

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that you might need to deal with. In this post, I… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 25 May 2015

Newer posts

Older posts