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

Disabling SQL Server Network Protocols

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

I ran across a question on network protocols recently, which is something I rarely deal with. Often the default setup for SQL Server is fine, but there are… Read more

0 comments, 442 reads

Posted in The Voice of the DBA on 18 January 2016

Chips and Margaritas at SQL Saturday #461

It was a few years back that my wife and I planned a trip to the Austin City Lights music festival to see Stevie Wonder. This was a bucket list item for us, and we thoroughly enjoyed a long weekend in the city. I’ve been for SQL in the City… Read more

0 comments, 282 reads

Posted in The Voice of the DBA on 15 January 2016

Rebuilding a Heap–Don’t Do It

I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but when I looked in BOL, I saw that indeed you can run this on a heap. That’s interesting, in that you can now move the pages in a heap around… Read more

3 comments, 289 reads

Posted in The Voice of the DBA on 14 January 2016

T-SQL Tuesday #74–The Changes

It’s T-SQL Tuesday time, the monthly blog party on the second Tuesday of the month. This is the first T-SQL Tuesday of 2016, and all you have to do to participate is write a blog post. It’s supposed to be today, but write one anytime you can and look for… Read more

5 comments, 248 reads

Posted in The Voice of the DBA on 12 January 2016

Hash Tables in PowerShell–Advent of Code Day 3

I continue to work on solving the Advent of Code puzzles in both PowerShell and T-SQL after completing them in Python.

When I hit day 3 in PowerShell, it was a few new tricks to learn, one of which was reading a large string from a file. However the interseting… Read more

0 comments, 270 reads

Posted in The Voice of the DBA on 12 January 2016

Advent of Code Day 1, Puzzle B

As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6 of them in Python before moving on to other languages, and this is my chance to catch up with both PowerShell and T-SQL. I likely won’t post all solutions, but… Read more

0 comments, 288 reads

Posted in The Voice of the DBA on 8 January 2016

Advent of Code Day 1, Puzzle A

I have been working my way through the Advent of Code series across the last few weeks. This is a side project, allowing me to use some Python skills to solve the various puzzles. I also started to use PowerShell to solve the puzzles, mostly becauase this means I practice… Read more

1 comments, 259 reads

Posted in The Voice of the DBA on 7 January 2016

Multiple CTEs – #SQLNewBlogger

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

One of the techniques that I find very handy in solving SQL problems is the CTE. This is much easier to read, for me, than embedding code… Read more

1 comments, 1,180 reads

Posted in The Voice of the DBA on 5 January 2016

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, 298 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, 299 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,249 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,287 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,556 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, 267 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,285 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,485 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, 982 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, 277 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, 276 reads

Posted in The Voice of the DBA on 1 December 2015

Python Command Line Calls

There was a time I worked in a company any we lived in the command line. This was in the early 90s, prior to Windows v3.1 being released and we primarily used DOS on a Novell network.

We also had paper phone books on every desk for the 1,000+ people… Read more

2 comments, 320 reads

Posted in The Voice of the DBA on 27 November 2015

Newer posts

Older posts