Free Poster: tempdb data files in SQL Server
Category:
database-administration
The tempdb database is a strange place in SQL Server.
Category: database-administration
SSMS Tips: Templates and Control+Shift+M
Category:
database-administration
Templates are extremely handy for tasks that you need to do repeatedly, but with different parameter values. The coolest part is that once you get the hang of them, you can create your own custom templates.
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.
Should I Automate my Windows Updates for SQL Server? (Dear SQL DBA Episode 10)
Category:
database-administration
Your boss wants you to automate patching for your SQL Servers. Is that a good idea? How far should you take it? Find out a DBAs perspective.
Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)
Category:
query-performance
, database-administration
You finally got approval to move to new hardware and a fresher version of SQL Server. After months of work, you do the migration and then… performance gets worse. What can cause this, and what do you look for?
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.