Blogs

The Art of Abstraction: SQL PASS Submissions

The Art of Abstraction: SQL PASS Submissions

on June 3, 2010 • 3 min read

I have been plotting sessions that I’d like to present at SQL PASS for a little while now, and the June 5 deadline is approaching. Since I’m on vacation this week, I took some time to write up my abstracts. Man, oh man, that was more work than I thought! Condensing ideas into 1000 characters or less and still saying all you want to say isn’t as easy as it seems.

Continue reading

What is Filling up Your System Drive? Why I Still Love SpaceMonger 1.4.0

What is Filling up Your System Drive? Why I Still Love SpaceMonger 1.4.0

on April 17, 2010 • 3 min read

As for all posts on this blog, this post provides no guarantees for the tools described: use at your own risk, and make sure to test all functionality. This came to mind recently just because I wondered– is there any other free tool that does this better?

Times change, but some things stay the same.

Continue reading

Little Things That Count: Copying Names in Management Studio

Little Things That Count: Copying Names in Management Studio

on December 4, 2009 • 3 min read

This post is about a really little detail that isn’t a big deal.

Continue reading

SQL 2008 Agent Jobs - Tokens work in PowerShell!

SQL 2008 Agent Jobs - Tokens work in PowerShell!

on December 2, 2009 • 2 min read

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.

Continue reading

Automating SQL Local Security Policy Rights: PoSH and NTRights

Automating SQL Local Security Policy Rights: PoSH and NTRights

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:

Continue reading

Are you Slipstreaming? The Very Best Way to Install SQL Server!

Are you Slipstreaming? The Very Best Way to Install SQL Server!

By Kendra Little on November 10, 2009 • 2 min read

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.

Continue reading

SQLPASS Day 2- Optimization Timeouts and All about TLogs

SQLPASS Day 2- Optimization Timeouts and All about TLogs

on November 5, 2009 • 3 min read

SQLPass unfortunately can’t last forever, but happily it’s still going strong. Here’s some highlights from my Day #2.

Continue reading