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

Finding Strings

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

A quick one today, just looking for strings. I wrote an article on this, so there’s more detail there, but here’s a bit of code you… Read more

0 comments, 220 reads

Posted in The Voice of the DBA on 11 March 2016

Converting SQL Backup Files to MTF

I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup installed on all my instances. It’s not a big deal to install it, but since this is a one-off, I decided to just decompress the files.

The documentation for SQL… Read more

0 comments, 532 reads

Posted in The Voice of the DBA on 8 March 2016

Restoring a Striped Backup–#SQLNewBlogger

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

Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended up with multiple files in my file system,… Read more

2 comments, 426 reads

Posted in The Voice of the DBA on 7 March 2016

PowerShell–Don’t Use Write-Host

I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return output. To me, it’s been like “Print” in various languages where I can get output of a program. Often I’ll use a method/function to get info and then use print… Read more

2 comments, 330 reads

Posted in The Voice of the DBA on 4 March 2016

Quick Folder Size with PowerShell

This is a fairly simple idea, and one I’m sure many people have done in the past. Personally, I have tended to just hover a mouse over a folder when I want a size. That seems to work fairly well, but not only is it slow, it’s not programmatic.

I… Read more

2 comments, 382 reads

Posted in The Voice of the DBA on 2 March 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, 318 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, 301 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, 255 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,353 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, 304 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, 263 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, 395 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, 780 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,027 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, 249 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, 316 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,288 reads

Posted in The Voice of the DBA on 1 February 2016

Creating a Database Snapshot

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

I’ve rarely dealt with database snapshots, outside of lab experimentation. They didn’t exist when I did most of my DBA work, and since then we haven’t seen the… Read more

1 comments, 1,500 reads

Posted in The Voice of the DBA on 25 January 2016

Push Button Deployments

I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over 18 months. That was about the length of time I was involved before the small startup failed, but not for lack of technology. In fact, I managed a few weeks… Read more

0 comments, 109 reads

Posted in The Voice of the DBA on 21 January 2016

Advent of Code–Day 2

I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it was tricky in SQL I decided this one was worth a post, since I had to futz around a few times to solve it, and I managed a slightly different… Read more

0 comments, 222 reads

Posted in The Voice of the DBA on 20 January 2016

Newer posts

Older posts