Free Poster: tempdb data files in SQL Server
Category:
database-administration
The tempdb database is a strange place in SQL Server.
kendra little
Developer Seeks DBA Career (Dear SQL DBA, Episode 13)
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?
Category:
backup-recovery
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)
Category:
database-administration
, sql-server
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
Category:
database-administration
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!
Category:
database-administration
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.
Next Door to Derpton - When Your Fellow DBA is a Danger to Databases (Dear SQL DBA)
Category:
database-administration
What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?