-->
SQL Clone
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: December 2015

Closing Down for the Year

Today is my last day of work for 2015. I’m actually proud that I’ve managed to take almost all my vacation (3 days left), and will be enjoying myself next week with my family, taking our holiday vacation in the mountains.

It’s been quite a year for me. Lots of… Read more

0 comments, 542 reads

Posted in The Voice of the DBA on 24 December 2015

A Few Days Off in Space Country

The new Star Wars film opens today, and while I won’t see it then, perhaps I’ll get to it early next week in the shadow of the US space program.

My middle son is in his last year of high school before he goes off to college and as his… Read more

0 comments, 506 reads

Posted in The Voice of the DBA on 18 December 2015

Tracking Logins with Extended Events

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

I was building a question the other day on Extended Events and needed to build a new session. One of the easier sessions to build is with… Read more

4 comments, 2,808 reads

Posted in The Voice of the DBA on 16 December 2015

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the group receiving the database to read/write the copy, and then… Read more

0 comments, 1,568 reads

Posted in The Voice of the DBA on 14 December 2015

Advent of Code

I ran across this site after reading a post from Jeremiah Peschka. It’s an interesting idea, and since I’m trying to improve my development skills in between the rest of my work, I thought this would be fun.

Advent of Code is a site that has a neat idea.… Read more

7 comments, 1,877 reads

Posted in The Voice of the DBA on 11 December 2015

Open Live Writer

I’m writing this post from the Open Live Writer project software. I’ve used Live Writer for years, but it’s shown its age. Not the least of which is doens’t support OAuth2, so I haven’t been able to use it with my Blogger blogs.

That should change, but we’ll see. Scott… Read more

2 comments, 463 reads

Posted in The Voice of the DBA on 9 December 2015

Running Powershell with Task Scheduler

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

One of the things I needed to do with my SQL Saturday download process was run this automatically. I don’t want to remember to do this, so I… Read more

2 comments, 1,923 reads

Posted in The Voice of the DBA on 9 December 2015

#SQLFamily Feud

I’ve started a new project. Actually, I started this well over a year ago, but I lost track of it and last week, despite the craziness, I was reminded of the effort and decided to get it going.

What is the Game?

A few of us were chatting about fun… Read more

0 comments, 1,735 reads

Posted in The Voice of the DBA on 7 December 2015

Puzzled by T-SQL

Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.

Adam Machanic posted this: T-SQL Puzzle-How many rows will this return? SELECT*FROM(VALUES(1),(2))AS x(i)WHERE EXISTS(SELECT MAX(i)FROM(VALUES(1))AS y(i)WHERE y.i=x.i)

I was in a doctor’s office waiting at the time, but I responded… Read more

8 comments, 1,231 reads

Posted in The Voice of the DBA on 3 December 2015

Ending My Loop in PowerShell Early

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

I was modifying my PowerShell (PoSh) script to download SQL Saturday files recently to not re-download files. However when I did this, I also realized that I didn’t… Read more

3 comments, 571 reads

Posted in The Voice of the DBA on 2 December 2015

Changing Scales and Creating Disappointment

I got an email recently that notified me that session feedback from the Summit was available for my talk. I’d had a lot of people in the room, and was curious how things went. I think the session was OK, a little off on time, a few too many questions… Read more

1 comments, 481 reads

Posted in The Voice of the DBA on 1 December 2015