kendra little

Developer Seeks DBA Career (Dear SQL DBA, Episode 13)

By Kendra Little on August 18, 2016

Category: career

A C# developer wants to be a DBA, but is having a hard time landing a job. Should they take a pay cut and go for a Junior level job? Or could there be another path?

Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?

By Kendra Little on August 16, 2016

Category: backup-recovery

Tags: dbcc-checkdb , corruption , noindex

The NOINDEX option does change the behavior of DBCC CHECKDB (even if you’re already using PHYSICAL_ONLY). Here’s how the two options compare to one another, and how to see the difference yourself in a simple example.

Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)

By Kendra Little on August 4, 2016

Category: database-administration , sql-server

Tags: alter-table , dear-sql-dba , error-8115 , identity , minimal-logging , msg-8115 , running-out-of-ints , schema-changes , size-of-data-operation , transaction-log

You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.

Free Poster: Cat DBA Says Not Right Meow

By Kendra Little on July 19, 2016

Category: database-administration

Tags: posters

You’ve got 99 problems, and the request coming in ain’t one.

Maybe you need to channel your inner Cat DBA, just for a moment.

Coming to SQL Saturday Portland? Plan a Vacation, too!

By Kendra Little on July 15, 2016

Category: database-administration

Tags: portland , sql-saturday , travel

SQL Saturday Oregon will be held on Oct 22, 2016 this year– the weekend before the SQL PASS Summit.

As a Portlander, I love it when people come visit my town! Please consider taking a few extra days to enjoy checking out PDX before or after the event.