-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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

Archives: June 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, 842 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, 2,335 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, 445 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, 447 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, 600 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, 603 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, 640 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,545 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,792 reads

Posted in The Voice of the DBA on 3 June 2015