DBAs Needed on Microsoft Connect
Update from Kendra (2018)** - Microsoft Connect has been retired. The current feedback system is here: https://feedback.azure.com/forums/908035-sql-server
SQL Server 2008/2008R2: My Favorite Feature
1. My New Crush: PowerPivot When it comes to R2, PowerPivot is the big charmer for me. It’s as much fun as my spiralizer, and that’s saying a lot. If you don’t know what a spiralizer is, it’s a magical little piece of plastic with a few blades that lets you turn a zuchinni into super long curly strands of veggie pasta, which makes it suddenly more than normal squash. You can also make curly fries, slice onions, and do all sorts of crazy cool things a normal person can’t make with an ordinary kitchen knife.
The Art of Abstraction: SQL PASS Submissions
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.
What is Filling up Your System Drive? Why I Still Love SpaceMonger 1.4.0
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.
Little Things That Count: Copying Names in Management Studio
This post is about a really little detail that isn’t a big deal.
SQL 2008 Agent Jobs - Tokens work in PowerShell!
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
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!
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.
SQLPASS Day 2- Optimization Timeouts and All about TLogs
SQLPass unfortunately can’t last forever, but happily it’s still going strong. Here’s some highlights from my Day #2.
SQL PASS Day 1: To Free or Not To Free the Proc Cache?
Yesterday was day 1 of SQL PASS 2009. I am attending a variety of sessions on execution plans this year, and along the way I heard three very different opinions yesterday on managing the procedure cache in presentations.