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: