Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: May 2014

Quick Tips–SSMS Select a vertical block

I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool and I’d use it all the time, but I haven’t found many uses. However since I needed to do this recently, this helped.

Imagine that you have this:

A… Read more

0 comments, 210 reads

Posted in The Voice of the DBA on 29 May 2014

Quick Tips–SQL Prompt Qualifying Columns

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

2 comments, 857 reads

Posted in The Voice of the DBA on 28 May 2014

Attaching All Databases with PowerShell–Checking All Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the first time I thought that Powershell might prove more useful than other methods. This series looks at my script, and this part examines the first part that I wrote.

I… Read more

0 comments, 246 reads

Posted in The Voice of the DBA on 27 May 2014

Attaching All Databases with PowerShell–Finding My MDF Files

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the first time I thought that Powershell might prove more useful than other methods. This series looks at my script, and this part examines the first part that I wrote.

The… Read more

0 comments, 258 reads

Posted in The Voice of the DBA on 26 May 2014

A Little Learning with Pluralsight

I’ve been working on a new presentation on testing using the tSQLt framework and was curious how other people are using the framework. I read through the documentation and various articles on Simple Talk. I also went through the Google Group and StackOverflow tags for tSQLt, gathering lots of… Read more

0 comments, 178 reads

Posted in The Voice of the DBA on 23 May 2014

Quick Tips – SQL Prompt Stop the Yelling

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

0 comments, 1,100 reads

Posted in The Voice of the DBA on 21 May 2014

Attaching All Databases with PowerShell – The Overview

TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to a SQL Server instance, if they don’t exist.

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the first… Read more

0 comments, 259 reads

Posted in The Voice of the DBA on 20 May 2014

FileTable– Using GetParent for Inserts

In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically. I used a NEWID() generation process, which mimics the constraint that is coded in the Filetable schema. However there was a comment asking if I could, or rather would, use… Read more

0 comments, 160 reads

Posted in The Voice of the DBA on 19 May 2014

Powershell Tips–PSEdit

I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked better than what I used to do.

Editing files

Suppose I have the ISE open and I want to edit a file. I could easily do this:

Click File –>… Read more

0 comments, 293 reads

Posted in The Voice of the DBA on 15 May 2014

Quick Tips–SQL Prompt Formatting

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

7 comments, 1,772 reads

Posted in The Voice of the DBA on 14 May 2014

T-SQL Tuesday #54–Interviews and Hiring

It’s the May T-SQL Tuesday, and this time it’s a great one. This month the host is Boris Hristov (@BorisHristov) and his topic is one that’s near and dear to me. He’s asking about interviews and hiring, and I have a lot to say on this… Read more

5 comments, 249 reads

Posted in The Voice of the DBA on 13 May 2014

Filetable–Nesting folders and files

In previous posts I showed how to create a folder in a Filetable and also how to the create (and move) files into the subfolder. However I didn’t repeat that and wanted to test the ability to actually nest things further. With that in mind, I’m going to take this… Read more

0 comments, 151 reads

Posted in The Voice of the DBA on 12 May 2014

Getting Local Books Online

One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for me. I often seem to forget to run through the process, and I’ll find myself on an airplane without being able to check documentation. It’s frustrating and while I’ve muddled… Read more

0 comments, 166 reads

Posted in The Voice of the DBA on 8 May 2014

Secure Coding

I was looking recently for some sort of guideline that would help me ensure that code was securely written. I stumbled upon the CERT standards, of which there are few, but one that seemed interesting was this one on Oracle and Java. I thought this first standard was a… Read more

0 comments, 158 reads

Posted in The Voice of the DBA on 7 May 2014

Filetable–Moving files programmatically

I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?

It’s trivial to do this in Explorer. Just drag and drop, and I’d expect that most people using Filetable from the client side would do this. I’d even expect that… Read more

0 comments, 169 reads

Posted in The Voice of the DBA on 6 May 2014

Sabbatical Decisions

My employer, Red Gate Software, offers a sabbatical to their employees, and this year I’m taking mine. I’ll be gone from June 2 – July 14, away from work, but I’ll be blogging here about my experience.

I wrote before that I had a sabbatical coming from Red Gate… Read more

1 comments, 315 reads

Posted in The Voice of the DBA on 2 May 2014

Continuous Delivery Visualization

A good one, one of the better diagrams I’ve seen.

From http://markosrendell.wordpress.com/2014/03/03/practical-benefits-of-continuous-delivery/

Now if we can get tooling and processes to make this work reliably for databases.


Filed under: Blog Tagged: continuous delivery, software development, syndicated

Read more

0 comments, 176 reads

Posted in The Voice of the DBA on 1 May 2014