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: January 2013

SQL and Skiing – SQL Saturday #183

This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a relatively short drive from Colorado. Six hours from my house, S of Denver, and a nice city. My brother used to live there, and I made a few trips to… Read more

0 comments, 1,472 reads

Posted in The Voice of the DBA on 30 January 2013

Granting Permission to Grant Permissions

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users.

It’s not a weird edge case, but it’s just not one I’ve normally… Read more

0 comments, 2,534 reads

Posted in The Voice of the DBA on 28 January 2013

If You Need To Fix Database Filename Extensions

In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however, and you might wish to “fix” the filenames to conform to the proper extension. How can you do this?

Well, to change a file name, or location, you need to… Read more

1 comments, 1,529 reads

Posted in The Voice of the DBA on 24 January 2013

Full-Text Search – Thesaurus

I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication.

Full-text search in SQL Server includes a thesaurus that you can customize for your searches. As with… Read more

0 comments, 5,183 reads

Posted in The Voice of the DBA on 21 January 2013

Does the SQL Server Database Filename Matter?

Do you know the basics of how to create a database? Hopefully you do and can do so without the GUI. However do you know the extensions are for database files? As of SQL Server 2012, these are the extensions:

  • Main data file – .mdf
  • Secondary data files – .ndf

Read more

1 comments, 2,643 reads

Posted in The Voice of the DBA on 17 January 2013

Regression Testing before CUs and Service Packs

Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this to encompass Service Packs since these are almost CU rollups… Read more

0 comments, 1,437 reads

Posted in The Voice of the DBA on 15 January 2013

Full-Text Search – Word Breakers and Stemmers

There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to queries. Full-text Search is a little complex, and as I’ve been working with the system in an effort to learn more about it, I decided to document how a few… Read more

0 comments, 4,452 reads

Posted in The Voice of the DBA on 14 January 2013

sp_Blitz, v16, on SQLServerCentral

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and give you a quick, comprehensive report of the state of the instnace. It’s a great script, and if you have the chance to see Brent present on the script,… Read more

0 comments, 1,384 reads

Posted in The Voice of the DBA on 10 January 2013

A Learning Experiment

I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but at a higher level it’s teaching people. That was the goal of SQLServerCentral, to help people learn about SQL Server and become better at their jobs.

Last summer I was… Read more

4 comments, 1,144 reads

Posted in The Voice of the DBA on 9 January 2013

T-SQL Tuesday #38 – Standing Firm

It’s T-SQL Time again, and this time it’s #38, from Jason Brimhall (b | t | li). The topic this month is Standing Firm. You are supposed to look at any of these words, and write something that fits with one of them.

  • resolve
  • resolution
  • resolute

This… Read more

1 comments, 1,172 reads

Posted in The Voice of the DBA on 8 January 2013

The Default Fillfactor for an Index

I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL Sentry blog on trimming the transaction log, then went to his video on log analysis. I also glanced at the posts on index cleaning and what index stats… Read more

0 comments, 1,170 reads

Posted in The Voice of the DBA on 7 January 2013

Speaking at SQL Saturday #183 – Albuquerque

I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first SQL Saturday in New Mexico, and I’m excited to drive down and meet the SQL Server pros down there.

My brother used to live in Albuquerque, and I’ve been there… Read more

0 comments, 1,150 reads

Posted in The Voice of the DBA on 4 January 2013

Checking the Instance Fill Factor

I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill factor. I agree, and you shouldn’t alter it. However if you aren’t sure if it’s been changed on any of your instances, here’s how to check it.

I’ll show both… Read more

0 comments, 2,347 reads

Posted in The Voice of the DBA on 3 January 2013

Vote for my SQL Bits sessions

“Rob? Tsk tsk tsk. That’s a naughty word. We never rob. We just sort of borrow a bit from those who can afford it. “

- Robin Hood

SQL Bits XI is coming to Nottingham forest, home of Robin Hood and Sherwood Forest in Nottinghamshire. This is a fun three… Read more

5 comments, 1,584 reads

Posted in The Voice of the DBA on 2 January 2013