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

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.

Here’s a short example. I’ve… Read more

0 comments, 110 reads

Posted in The Voice of the DBA on 25 March 2015

The Basic TRY..CATCH

Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then acting on that result. 

However I’m trying to do better,… Read more

0 comments, 145 reads

Posted in The Voice of the DBA on 24 March 2015

Speaking at SQL Saturday #389 – Huntington Beach

I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM training session run by Ike Ellis. I’m assisting Ike in running a Database Continuous Integration class. It’s a paid for event, but you’ll learn how to set up and… Read more

0 comments, 115 reads

Posted in The Voice of the DBA on 23 March 2015

Career Ratings

I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give you some thoughts to take away about how you might rate your career.

These are some suggested areas, with a note or two in there. I’m not saying any of… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 20 March 2015

Measuring My Career

I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.

I saw Brent Ozar write a post on measuring your career. In it, he talks about the fact that many people measure their career as a function of their salary. He… Read more

2 comments, 905 reads

Posted in The Voice of the DBA on 19 March 2015

ALTER SCHEMA TO ADD PERMISSIONS

I’m sure some of you have wanted to do this:

ALTER SCHEMA Steve AUTHORIZATION Steve

You realize this doesn’t work, and you can’t grant the user Steve, rights to his schema after it’s created. You can do this:

CREATE SCHEMA Steve Authorization Steve

UPDATE: Someone pointed out this works after… Read more

0 comments, 155 reads

Posted in The Voice of the DBA on 18 March 2015

The Demo Setup–Attaching Databases with Powershell

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.

TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at the end.

The Issue

We have a lot of demo… Read more

1 comments, 302 reads

Posted in The Voice of the DBA on 16 March 2015

Allowing a User to Create Objects in a Schema

I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues.

I want to give a developer rights to create objects in a schema. In this case, I’ll stick with… Read more

1 comments, 202 reads

Posted in The Voice of the DBA on 12 March 2015

Altering a Column with NOT NULL

A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely done this in the past, usually specifying NOT NULL when I create the table. Often in future changes, I’ve been wary of not allowing NULLs since I’ll always find an… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 12 March 2015

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents in a folder based on a pattern.

This time I… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 25 February 2015

Missing Full Text Extensions in Express

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set up the VM I was using wasn’t sure what to… Read more

0 comments, 154 reads

Posted in The Voice of the DBA on 23 February 2015

Powershell Quick Parameters for Scripts

I was working on a script recently to manage a particular process and wanted to make it generic by allowing the user to pass in a parameter. I have seen lots of examples, especially those that work with SQL Servers, using text files and other items as parameters, but in… Read more

0 comments, 262 reads

Posted in The Voice of the DBA on 19 February 2015

Parsing SQL Saturday Data – Looping Through And Loading All XML Files

After my last post on parsing the XML, I decided to continue forward and get ready to put the data in a database. For that, I’m really looking for this data:

  • event ID
  • session title

With this, I can easily insert data into a table. I’ll have separate tables for… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 18 February 2015

The Vacation Conundrum

Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum time off, or perhaps an allowance, with the tracking and offer to work with employees that need more. There are problems with unlimited vacation, and it’s often because… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 17 February 2015

tSQLt – SQLCop – Checking Naming Conventions

I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for code. I’ve been using a framework on top of tSQLt called SQLCop. These are a series of tests written to look for specific things. One of the items I… Read more

0 comments, 6,218 reads

Posted in The Voice of the DBA on 12 February 2015

Detecting Encryption

I ran across an article recently from MSSQLTips by my friend, Brian Kelley. It talks about the ways you can detect encryption in use in your database. Brian’s approach, which is one I agree with, is that you can look for symmetric keys, asymmetric keys, and certificates in the system… Read more

2 comments, 411 reads

Posted in The Voice of the DBA on 11 February 2015

T-SQL Tuesday #63 – Security

It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic for February and you can read his invite here. There are lots of choices on what you write about, and I’m looking forward to reading what people choose.

You… Read more

3 comments, 6,088 reads

Posted in The Voice of the DBA on 10 February 2015

Parsing SQL Saturday Data – Getting the Titles

I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to parse this data. You can look at a sample XML file from the site with this link, and examine the structure.

Essentially, it’s something like this:

<event>

 … Read more

0 comments, 236 reads

Posted in The Voice of the DBA on 2 February 2015

I May Not Shake Your Hands

I’m traveling next week to the SQL Konferenz in Germany, and then on to Red Gate in the UK.

However, I may pull a Wil Wheaton at the event and the office and not shake hands. I haven’t had issues with this in the past, with lots of handshakes, hugs,… Read more

0 comments, 220 reads

Posted in The Voice of the DBA on 30 January 2015

Changing File Associations in Windows 8

A quick post, and a good reminder of something that can be a pain. I had to do a quick search for the solution, and wanted to write about it in the hopes it will help me remember the issue.

Opening the wrong program

I was working with some XML… Read more

0 comments, 155 reads

Posted in The Voice of the DBA on 29 January 2015

Older posts