Partition Alignment and Late Night Infomericals

Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and then slice the most delicate of tomatoes. Add a side of bacon and you’ve got a tasty summertime treat that’s sure to please guests of all ages.”

Ahhh, yeah. Right. Except for the part about adding a side of bacon, I don’t believe it.

There’s an old axiom “If something sounds too good to be true, it probably is.” So it is with those infomercials. It’s Buyer Beware.

But axioms were made to be broken; they can be wrong.

SQLCat White Paper on Partition Alignment

Such is the case with a white paper from the SQLCat team. In it, the authors describe how properly aligning disk partitions can help servers realize an up to 30% boost in disk I/O performance. The relatively short paper discusses the theory behind the findings and give practical steps to ensure your partitions are aligned.

A 30% boost in performance at no cost to you? Sound too good to be true? It’s not.

So what are you waiting for? Download your white paper today for the low, low introductory price of just the time it takes you to read it. Click now!

My Productivity Tools

electric_football.jpg

Ever felt like you’re in a game of electric football? Like you’re one of the players jiggling up and down slightly but never really going anywhere. I have days like that.

One of my goals for this year is to have fewer of those days by making better use of my time, by becoming more productive.

I’ve been a quasi-practitioner of David Allen’s Getting Things Done
Getting Things Done for many years now. I found it to be good in theory but I struggled to put a good process in place to make it happen. Instead I tinkered with my system (something that Allen warns against by the way) trying to find a new tool, a new technique, a new anything to make me more productive with less stress.

Earlier this year, it all began to fall in place. I discovered that my GTD problems were less system-based and more of a discipline issue. I was missing two key components: the concept of context and the discipline to routinely have a Weekly Review. I discovered this while trying out a new GTD tool – OmniFocus.

So I thought I’d share with you my current, and hopefully my lasting, system for Getting Things Done in hopes that you’ll benefit from it. Or maybe you’ll share with me some things you’ve found helpful since I’m always on the look out for something better.

One requirement for me is portability. Whatever software or system I use must be available to me when I need it. For me that usually means desktop or web application that has a mobile counterpart for my iPhone.

InboxZero

One of tenets of GTD is that must have a trusted system for collecting, evaluating, and managing the barrage of requests that come to you throughout the day from many different fronts. Lots of people try to handle this through their email inbox. That didn’t work for me; I tried.

Now I use my email inbox just like my snail-mailbox; things arrive and I take them out. I don’t allow things to accumulate in there for too long. Every email that comes in gets processed (evaluate and either acted up immediately, placed into a to-do item to be handled later, deleted, or filed for future reference).

This doesn’t happen everyday. In fact it usually builds up to 30 or so emails before I make some time to go through them all. Ideally I’d leave the office each evening with InboxZero. I’m still working to get there.

OmniFocus

Omnifocus is the heart of my GTD system. I use it to keep track of my to-do lists for my clients. I can easily view the tasks by project, context, and due date. I can also flag the tasks that I plan to work on each week.

OmniFocus has “Perspectives” that narrow the long list of to-do’s to a more manageable list. One of the built-in perspectives even helps with the Weekly Review, the Achilles Heal of most GTD practitioners.

EverNote

Every GTD system needs repository in which to file information that you may need later. I’ve found EverNote to really good at this. I keep meeting notes, design documents, project planning information, etc in there for future reference. It’s got great search capabilities and can index most anything – documents, pictures, hand-written notes, etc.

TimeSvr

In consulting there are a lot of fairly mundane tasks that must be done – searching the internet for potential training materials to use upcoming class, finding the best hotel and flight bookings, locating funny or clever pictures to use in blog postings, making a trip folder, etc. All of these are required, yet not billable. And they take precious time away from the more important activities.

One way to increase productivity is to focus on the things that only you can do and delegate or outsource the tasks that someone else can do. I learned this from Stephen Wynkoop (Twitter) when he tech-edited my consulting book. It was great advice.

TimeSvr helps me to do that. TimeSvr is not so much an application as it is a service. I can outsource some of my more mundane tasks, allowing me to focus on the ones that only I can do. I’ve written about TimeSvr before so I won’t repeat it here.

Other Productivity Software

Over the years I’ve used other software and techniques in my never ending quest to be more productive, more effective in the way I spend my time.

What about you?

  • What software applications do you use to be more productive?
  • What techniques have you found useful?
  • Is the quest for productivity any easier than that of the Holy Grail?

Learn SQL Server 2008 R2 with 24-HOP

Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for short. What is 24 HOP? It is 24 one-hour SQL Server technical presentations streamed back to back for 24 hours straight. Wow!

The line up was impressive with many of the biggest names in the SQL Server community. If you missed the live feed, or simply just couldn’t make your brain focus for 24 consecutive hours, no worries. The 24 HOP recordings are now available on the PASS web site. You need to be a PASS member to view them, but that’s easy and free.

Let’s have a look at the line up.

24 Hours of PASS Sessions

The Line Up

  • Session 01: Introduction to PowerPivot (Brian Knight)
  • Session 02: Database Development Patterns (Andy Leonard)
  • Session 03: What Exactly is in SQL Server 2008 R2 (Kevin Cox)
  • Session 04: Getting Started with SQL Server Utility in SQL Server 2008 R2 (Glenn Berry)
  • Session 05: Data Tier Applications (Jacob Sebastien)
  • Session 06: What’s Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects (Adam Machanic)
  • Session 07: Filtered Indexes, Sparse Columns: Together, Separately (Don Vilen)
  • Session 08: Solving Common Business Problems with Microsoft PowerPivot (Donald Farmer)
  • Session 09: Exploring SQL Server 2005 and 2008 Security (Don Kiely)
  • Session 10: Using Data Compression with SQL Server 2008 and 2008 R2 (Maciej Pilecki)
  • Session 11: Easier than Ever Report Authoring in SSRS 2008 R2 (Jessica M. Moss)
  • Session 12: High Performance Functions (Simon Sabin)
  • Session 13: Manage Your DBA Career, Don’t Let it Manage You (Brad McGehee)
  • Session 14: Top 10 Mistakes on SQL Server (Kevin Kline)
  • Session 15: Producing Dashboards with PerformancePoint Services (Peter Myers)
  • Session 16: Reporting Services Enhancements in SQL Server 2008 (Greg Low)
  • Session 17: SQL Tuning – Get it Right the First Time (Dean Richards)
  • Session 18: Managing SSIS Package Deployments with Powershell (Sean McCown)
  • Session 19: Multi-Server Management With UCP, MDW and PBM (Chuck Heinzelman)
  • Session 20: Advanced T-SQL Query Tuning Techniques (Rob Farley)
  • Session 21: Implementing MDM Using SQL Server 2008 R2 Master Data Services (Rushabh Mehta)
  • Session 22: SQL 2008 R2 How to Manage CPU’s, Cores and CPU Groups (Thomas Grohser)
  • Session 23: Database Design Fundamentals (Louis Davidson)
  • Session 24: BLITZ! 60 Minute Server Takeovers (Brent Ozar)

Enjoy!

My PASS Session Abstracts

The Dream Team

The 1992 Dream Team

When you hear the phrase “All-Star Lineup”, what comes to mind? The New York Yankees? The 1970′s Pittsburgh Steelers? What about the 1992 USA Olympic Basketball “Dream Team” in Barcelona? Oooooh.

Or maybe it’s simply a bacon, egg, & cheese biscuit?

Well, each year the SQL Server community has one event that attracts the best of the best, the upper echelon of industry experts, Microsoft product team developers, authors, MVPs, Regional Directors, and all manner of other scary smart people. The PASS Community Summit is our community’s version of the “All-Star Lineup”.

This year’s Summit is 8 – 11 November in Seattle, Washington. This is bound to be an event you won’t want to miss.

Once again, I’ve submitted some abstracts and hope to speak at the event. In years past, I’ve primarily spoken in the Database Development track on topics such as Reporting Services, T-SQL tricks, and the since deprecated Notification Services. I occasionally made forays into the Database Administration track with topics on performance monitoring and the like.

Although I did submit a couple of technical abstracts, this year I’ve also reached into the Professional Development track. Here are a list of the abstract I submitted.

Locking & Blocking Made Simple

A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Conducting Effective Meetings

Ever been in a meeting that drones on and on? It starts late, runs long, and doesn’t really accomplish anything. It’s a complete waste of everyone’s time. Worse yet, since nothing was resolved you’ll have to have a follow up meeting. Argh!
In this session you’ll learn some of the keys to conducting an effective meeting. You’ll gain practical tips for making your meetings more productive and dramatically improving one of the most inefficient parts of your day.

Getting Started in IT Consulting

Do you have the expressed goal or the suppressed desire to become an independent consultant? Think it’s too risky? Don’t know where to start? In this session, I’ll help you create a clear transition strategy to go from full-time employee to full-time independent IT consultant with a minimum of risk along the way.

I’ll discuss:

  • The many hats of a consultant
  • Strategies for minimizing risk
  • Setting up your business
  • How to handle sales
  • Low cost promotions
  • Some best practices

The PowerShell Cookbook for the DBA

The best DBAs work hard so that they don’t have to, well, work hard. In this session, we’ll discuss how you can use the PowerShell cmdlets and snap-ins to create scripts that automate the more mundane tasks in your role as a DBA or developer. We’ll create scripts that check the status of SQLAgent jobs, verify the configuration of your servers, and retrieves information from your SQL Server database. You can even store your results in a database table if you’d like. This session is mostly demos with only a few PowerPoint slides to get us started.

The Art and Science of Great Technical Presentation

Have you considered speaking at your local user group, a SQLSaturday, or even a major technical conference? What’s stopping you? Don’t know where to begin? The thought of getting in front of scores of people a bit unnerving? What topic? How many slides? How many demos?

Having great technical skills isn’t enough anymore. The most sought after people in the industry also have great presentation skills. In this session we’ll discuss how to put together an effect and engaging technical presentation. We’ll learn techniques and strategies that will help to give you confidence as you tell your story to peers, colleagues, and even industry experts.

“I got promoted! Now what?”

You were a rockstar DBA. You could leap tall buildings and tune databases in a single bound. Life was grand. And then you got promoted. The skills that helped make a rockstar DBA won’t help you in management. In fact, some of those skills could actually be a hindrance. In this session we’ll discuss the new skills you’ll to hone to excel as a manager like, skills like: managing former peers, delegating to get more done, working more productively, giving effective feedback, and conducting effective meetings.

I certainly don’t expect all of these to be accepted, but I do hope that at least one will be.

Follow

Get every new post delivered to your Inbox.