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

SQLBits in Space

It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to Liverpool on May 4-7.  With a fun theme.

Check out the launch video here: SQLBits XV

Update (Mar 24): The agenda is live. I’m speaking Saturday at 2:30pm.

There… Read more

0 comments, 1,034 reads

Posted in The Voice of the DBA on 22 March 2016

SQL Data Generator –Specific Domains for a Column

I was mocking up some test data and wanted to limit my list of values to specific items. In this case, I was modeling the game, Rock Paper Scissors. In my modeling, I had a field for the value played by someone. In this case, I used a text… Read more

0 comments, 1,131 reads

Posted in The Voice of the DBA on 21 March 2016

What Database am I in?

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

I saw someone trying to get the database context recently and they were confused. They had some code referencing @dbname, but received an error with this code.… Read more

0 comments, 260 reads

Posted in The Voice of the DBA on 17 March 2016

SQL Source Control v5.0 Beta–First Migration Script

I joined the beta program for SQL Source Control recently. I know, I work for Redgate, I should be in all beta programs. However I present on our various products, and I need those presentations  to work reliably. As a result, I rarely get ahead of our RTM products because… Read more

0 comments, 281 reads

Posted in The Voice of the DBA on 16 March 2016

Working on the Road

I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50 nights in hotels for work. That’s a fair amount, and it can be challenging to get everything I need to accomplish done in those situations. I’ve gotten good at ensuring… Read more

2 comments, 257 reads

Posted in The Voice of the DBA on 15 March 2016

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, 244 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, 587 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, 488 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, 374 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, 517 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, 383 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, 357 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, 310 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,413 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, 334 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, 304 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, 429 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, 844 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,074 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, 278 reads

Posted in The Voice of the DBA on 10 February 2016

Newer posts

Older posts