Category: Beginner

Create a clustered index and a primary key on existing tables

Post author By Jen McCown
Post date December 15, 2014
Categories In Admin, Applied SQL, Beginner, sqlserverpedia-syndication, SSC, Tech and Learning
5 Comments on Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference available. Yes, Virginia, you most […]

Session: Introduction to Powershell Cmdlets for DBAs

Post author By Jen McCown
Post date October 28, 2014
Categories In All Things MidnightDBA, Beginner, Powershell, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, […]

Tip: RECOVERY_PENDING is not the same as RECOVERING

Post author By Jen McCown
Post date September 8, 2014
Categories In Admin, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL
4 Comments on Tip: RECOVERY_PENDING is not the same as RECOVERING

I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING. Definitions RECOVERING means that things are happening, and all may be well. “Database is being recovered. The recovering process is a transient state; the database will automatically become online if […]