Little Things That Count: Copying Names in Management Studio
Category:
database-administration
This post is about a really little detail that isn’t a big deal.
Category: database-administration
SQL 2008 Agent Jobs - Tokens work in PowerShell!
Category:
database-administration
I have been working away building out servers in our new prod test environment, and automating as much as possible along the way with PowerShell. I have to say that it’s been really fun and PoSH has brought back that loving feeling that I always had for Perl. If a programming language can be friendly, PowerShell manages it.
Automating SQL Local Security Policy Rights: PoSH and NTRights
Category:
database-administration
, sql-server
There are a couple of local security policy rights that are not granted by default in SQL Server setup that I’ve been setting manually for a few years now:
Are you Slipstreaming? The Very Best Way to Install SQL Server!
Category:
database-administration
, sql-server
Somehow, I didn’t know about slipstreaming installations of SQL Server until last week. I heard about them at SQLPASS in Allan Hirt’s session on installing SQL Server 2008 on Windows 2008 clusters.
The Case of the Undroppable Database
Category:
database-administration
Once Upon A Time there was an Orphan Database…
I needed to drop a formerly-logshipped database on our warm standby server. When attempting to drop it, I found that it failed because it was a logshipped database from a replication publisher. Hmm.
Using Last Backup Date to Switch Between Full and Differential Backups
Category:
database-administration
Today I was glancing at once of my servers and noticed the backup job was running later than normal. I haven’t been working with this server for long, so I glanced to check where the backup was writing to and checked the output directory. I found that a differential backup was being written, and that the differential backup from the day before was much larger than normal.
Replication - Updates that Do Not Flow Through
Category:
database-administration
This past week at work we found an instance where a replicated table (transactional push) was out of sync on the subscriber. In evaluating how to address the situation, we did some testing in pre-production and discovered the following (using profiler).