-->
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: February 2016

The Jarvis–Standing Desk Update

I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of my coworkers standing and using boxes of books to lift their keyboard and mouse. I tried that.

My first desk from 2012.

It worked OK, and I found myself… Read more

8 comments, 1,035 reads

Posted in The Voice of the DBA on 26 February 2016

Grabbing Fitbit Data

Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.

I saw Rob Farley build a dashboard based on his Fitbit data. That was intriguing, so I went to get my data. I’ve worn a Fitbit for a couple years, recently having lost it.… Read more

2 comments, 693 reads

Posted in The Voice of the DBA on 24 February 2016

SQL Saturday Headshots

This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I was at the first two, missing last year with another event. It was good to go back, and carpool down to Taos for a day of skiing beforehand.… Read more

2 comments, 496 reads

Posted in The Voice of the DBA on 23 February 2016

Adding Minutes in Excel

A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out each day. It’s not my choice to do this, but the service I use requires this to not manually set time for each event.

Tl;dr: Add minutes/1440 to the date. Read more

0 comments, 1,616 reads

Posted in The Voice of the DBA on 22 February 2016

The Easy Phone Restore

This is hardware week for me, with a new phone coming in the mail. This was a warranty replacement for one whose battery is dying. I can start the morning at 7am with 100% charge and by noon my iPhone is asking to go into Low Power Mode at less… Read more

1 comments, 500 reads

Posted in The Voice of the DBA on 18 February 2016

CONVERT and HEX

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

In working through the Advent of Code and solving some of the problems in SQL, I found that I needed to take hex values and convert them… Read more

0 comments, 493 reads

Posted in The Voice of the DBA on 17 February 2016

T-SQL Tuesday #75–Power BI

This month’s host is Jorge Seggara, the @sqlchicken, who works for Microsoft. A busy schedule caused a slight delay, so we’re posting the third Tuesday of this month, but that is OK. This is a great topic for T-SQL Tuesday.

Power BI Data

While Power BI is a… Read more

6 comments, 644 reads

Posted in The Voice of the DBA on 16 February 2016

Quick Tests–Function Returns

I ran across a neat piece of code recently from Gail Shaw. She answered a question on returning the base path from a path in a string. Meaning if I had this string:

c:\Users\Sjones\Documents\text.txt

I’d want to return this:

c:\Users\Sjones\Documents

Her code looked like this, which is a nice, simple,… Read more

0 comments, 1,138 reads

Posted in The Voice of the DBA on 15 February 2016

Limiting Database Permissions for DLM Dashboard

I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren’t sure what was wrong. As a result, I decided to dig in a bit and see how limited I could be with permissions for the login/user that… Read more

0 comments, 1,303 reads

Posted in The Voice of the DBA on 11 February 2016

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no good way to do this without brute force. The problem… Read more

0 comments, 515 reads

Posted in The Voice of the DBA on 10 February 2016

Loading a Text File with a Line Feed

Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but there are times that you might want to automate this without using SSIS. In those cases, it’s nice to know how to load data from a programmatic standpoint.

I had… Read more

2 comments, 879 reads

Posted in The Voice of the DBA on 4 February 2016

Loading a Text File from T-SQL

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

One of the interesting things I’ve had to work on with the Advent of Code puzzles is loading files into SQL Server. Some of the inputs are large… Read more

0 comments, 2,630 reads

Posted in The Voice of the DBA on 1 February 2016