-->
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: May 2015

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more

2 comments, 600 reads

Posted in The Voice of the DBA on 27 May 2015

Changing NULL to NOT NULL – Dealing with Data

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that you might need to deal with. In this post, I… Read more

0 comments, 546 reads

Posted in The Voice of the DBA on 25 May 2015

Unit Testing in Philadelphia

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your T-SQL code. We’re the day before SQL Saturday #390 in… Read more

0 comments, 568 reads

Posted in The Voice of the DBA on 22 May 2015

DB_Owner Querying for Database Options

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

What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, assign permissions, back up the database, etc). However someone… Read more

0 comments, 890 reads

Posted in The Voice of the DBA on 21 May 2015

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s a simple test built against a user defined function. It works well and when the test is run, it passes.

Here was my code:

ALTER function [dbo]

Read more

0 comments, 5,502 reads

Posted in The Voice of the DBA on 20 May 2015

PostgreSQL v SQL Server

A site that’s a comparison of the platforms.

http://www.pg-versus-ms.com/

Certainly some good arguments being made, but (admittedly) biased towards specific workload items that the author uses.

However, I agree with lots of the items listed. There are quite a few items, such as 1.1 and 1.2. Not having 1.5 is… Read more

0 comments, 668 reads

Posted in The Voice of the DBA on 19 May 2015

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our table. However, since the table could change, and may need to, what’s the value of having a test fail if the table changes?

In my mind, I don’t necessarily want… Read more

0 comments, 528 reads

Posted in The Voice of the DBA on 18 May 2015

Quick Installs with Chocolatey–Screen Capture

I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight and buggy for me. I just need to snag part of a screen for my job and blog. I used Quick Screen Capture, but in Win 8 it didn’t want… Read more

0 comments, 722 reads

Posted in The Voice of the DBA on 15 May 2015

Getting Database Properties – DatabasePropertyEx()

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

I had someone ask me a question about security recently, and while working through the answer, I ran across something I didn’t know well: databasepropertyex(). Here’s a few… Read more

0 comments, 1,844 reads

Posted in The Voice of the DBA on 14 May 2015

T-SQL Tuesday #66 – Monitoring SQL Server

This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure that quite a few people at Redgate Software, my employer, are thrilled with this topic since we have a product that helps you here: SQL Monitor.

T-SQL Tuesday #66… Read more

1 comments, 593 reads

Posted in The Voice of the DBA on 12 May 2015

A Week to SQL Saturday #393 – Redmond

Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This is my first time at a SQL Saturday in Washington, though I’ve been to the area many times. I’m looking forward to the trip up with a couple days in… Read more

0 comments, 648 reads

Posted in The Voice of the DBA on 8 May 2015

PSA: Update Your PASS Profile

I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m not sure why I get two emails to two different email addresses when I’ve only logged into one profile account in the last six or seven years, but I’m sure… Read more

2 comments, 703 reads

Posted in The Voice of the DBA on 7 May 2015

Reframing to Overcome Filtered Index Limitations

I’m continuing on with the Blogger’s challenge in this post.

Turning the Problem Around

In the last post, I wrote about limitations in filtered indexes. I proposed that my table had lots of data with NULL or blank spaces in the gender column, and I wanted to avoid indexing those… Read more

10 comments, 4,144 reads

Posted in The Voice of the DBA on 7 May 2015

Learn tSQLt and Unit Testing in Philadelphia

SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not only am I speaking on Saturday, but I’ll be delivering information on Friday at a pre-con.

My first SQL Saturday pre-con is taking place in Philly. I’m lucky to be… Read more

2 comments, 5,537 reads

Posted in The Voice of the DBA on 6 May 2015