Tag Archive: pass2008

Wanna go to #SQLPass? Send this to your manager.

Dear Mr. or Mrs. Manager,

Someone’s sending you this because they want to go to the PASS Summit in Seattle.

I’m Brent, a guy who’s active in the community and I’ve been to a couple of summits, and they want me to explain why it’s worth the money.

What’s the PASS Summit and How Much Does It Cost?

It’s a weeklong conference in Seattle run by the Professional Association for SQL Server. It costs around $2,500 plus airfare.

Your employee usually won’t have to pay for breakfast, lunch, or dinner. PASS provides breakfast and lunch during the day, and vendors like Quest host dinner events each night. Since your employee is savvy enough to find my blog entry, they’ll know where the parties are, because I post ‘em on my blog in an effort to save them money and get them out of their hotel rooms at night.

Will They Be Reachable if Something Breaks?

Your employee will be surrounded by thousands of SQL Server professionals. You might HOPE that something breaks this week, because they’ll get the best SQL Server support possible at any time of the year! They’ll be able to turn to their left and right and get amazing advice.

How Does The Company Benefit?

Make a list of the toughest SQL Server problems your company is facing – whether it’s how to design a solution, how to make a query faster, how to implement a new architecture, you name it. Think in terms of things you’d love to hire expensive consultants to do, but you don’t have the money.

Make your employee document each of the problems in writing, and put each problem on a separate page. If applicable, show schema designs, diagrams, or queries. Print out several copies of each problem.

Your employee can take these issues to some of the brightest minds in the SQL Server industry like:

Microsoft has an area in the exhibit hall dedicated just to customer issues. Anyone can come in, sit down, and start talking with Microsoft developers, support engineers and architects about the issues they’re having or things they’d like to implement. Bringing documentation of these problems helps make it easier to get detailed answers: the DBA can scribble down thoughts about the problem while the discussion is going on, and they’ll be more likely to remember every aspect of the issue.

Brilliant SQL Server minds come to the PASS Summit to give presentations. Tjay Belt said it best when he said, “I could walk into any SQL Server person’s office in the world, point at books on their bookshelf, and say that I’ve talked to the authors in person at the PASS Summit.” Some of them consult for hundreds of dollars per hour, and your employee can get face time with them for free at the PASS Summit.

Vendors like Quest Software have a big presence at the show, and it’s not just sales and marketing. Vendors send their best technical minds to network with customers, other vendors and with Microsoft. I personally look forward to the PASS Summit because I get to spend some face time with my own coworkers that I don’t get to see too often! While it’s not the right place to bring support questions, it’s a great time to ask architecture or implementation questions.

If you really want to take it to the next level, have your employee set up a lab environment on their laptop with SQL Server and a copy of the databases they need to work with. I’ve seen users pop open their laptop, hand it to a SQL Server expert and say, “Here’s what my database looks like, and I need to find a way to do _______. Have you seen something like this before?”

Who Goes to the PASS Summit?

It’s for SQL Server professionals: developers, database administrators and business intelligence people. PASS tries to balance the content across those disciplines.

At a DBA-focused breakfast panel at PASS 2008, I asked for a show of hands to see how many instances each DBA managed:

  • 0-10 instances – about 10% of the attendees
  • 10-50 instances – about 40% of the attendees
  • 50-100 instances – about 40% of the attendees
  • Over 100 instances – about 10% of the attendees

Can They Just Watch Videos Online?

First, the company won’t benefit as much because your employee won’t be able to ask questions to help with your specific environment. Maybe you’ll get lucky and someone else will have asked the same question during the session – but probably not. The speakers have to leave the stage quickly after each session so that the next speaker can set up, so the speakers tend to walk out into the hallway and spend 15-20 minutes answering questions from attendees. Those questions aren’t videotaped.

Second, your employee won’t build personal relationships with the experts that can help solve their problems. At each summit, I meet dozens of people that ask me for help later through the year. I’m more likely to drop what I’m doing and help them if I know them personally, whereas if it’s someone I’ve never seen before, I probably won’t spend as much time digging into their questions. The experts get more questions than they can handle. Sending your employee there in person gets them to the front of the queue all year long.

Is There a Way to Go for Free?

Yes: their registration fee is waived if they present a session, although they still have to pay for hotel and airfare.

Only about 1 out of 4 presentation submissions are accepted (and yes, I was turned down.) There’s a ton of top-notch talent competing for slots. If you want your employee to make the cut, they need to build up their presentation skills first by presenting at their local PASS chapter and at regional SQL Server events.

Each presentation will take them a day or two to build. If you want to help them get a speaking slot, you can help by dedicating one day per month to building a presentation.

Building these presentations forces them to get better at their job because they have to document something in a way to educate others. You want your employees to be better at documentation and cross-training, right? This sounds like a two-for-one deal: they get better at documentation, and they save you money toward their PASS costs.

There’s another way to get registration fees waived, and it’s a sure bet instead of a risk: become a PASS chapter leader. The downside is that it requires significantly more time, because it takes 4-5 hours a week to lead a PASS chapter. They have to entice speakers for the monthly meetings, promote the group, talk to other chapter leads, and so on. It takes more commitment out of their workday time, but if you want them to attend for free, that’s a sure way to save money.

Why Don’t They Pay Their Own Way?

Some attendees do. As their manager, though, there’s something you need to think about before you let an employee go on their own dime.

Your employee will be networking with other SQL Server professionals – folks who are working for other companies who picked up the tab. During the summit, everyone talks to each other about their jobs, their companies and their bosses. A lot of these SQL Server people will be trying to hire more help, and they’ll be talking about their benefits.  Benefits like the ability to go to the PASS Summit for training.

I’m not sayin’, I’m just sayin’ – you might want to write this into the 2009 budget as a part of their benefits and training package.

Update 5/2009: More Reasons from Steve Jones

Steve Jones of SQLServerCentral adds more reasons why you should go to #SQLPass.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit Keynote Notes (#sqlpass)

Updates

It’s Friday, it’s 8:30 AM, and it’s time for another keynote.

8:30 AM – Bill Graziano just rode out on a trike!

8:40 – Two sessions will be repeated today due to high demand. At 10:45 in room 604 they’re repeating the clustering session, and 2:30 in room 6E is SQL Server on SAN.

8:45 – The PASS Board Election results are in! The new board members are Douglas McDowell, Lynda Rab and Andy Warren! That means Tom LaRock, Pat Wright and Louis Davidson didn’t make it. Here’s some blog links from each candidate’s experiences:

8:47 – now announcing winners of the SQL Heroes contest.

8:50 – The winner: BIDS Helper with a perfect score of 55! I wish I could tell you the rest, but the slides rolled off the screen within 30 seconds. Damn. Update: thanks to Adam Machanic, they’re:

  1. BIDS Helper – I’ve heard this mentioned repeatedly over the week by presenters
  2. Extended Events Manager
  3. SSISUnit
  4. CDC Helper
  5. QPee tools by Jason Massie! Woohoo!

8:55 – Dell reviewing the Microsoft BI platform reference architecture with the entire BI stack including PerformancePoint.

9:00 – Bill Graziano back up onstage to introduce Dr. David DeWitt from Microsoft.

9:03 – David’s great – he’s identifying all the reasons why his presentation will suck: he doesn’t have a motorcycle, he doesn’t have new presentations, etc! Hilarious. Love it.

9:10 – He’s going through the basics of why linear scaleup is a good solution, and how the numbers work.

9:12 – Ebay has a couple of >1 petabyte warehouses with 85 disk drives for storage. As a former SAN guy, I’m guessing I heard those numbers wrong, because that sounds ridiculously impossible. (Update – that numbers is 8500 disk drives, which also sounds ridiculous but on the other extreme, hahaha.)

Dr David DeWitt Onstage

Dr David DeWitt Onstage

9:15 – DATAllegro works because it’s shared-nothing: no shared memory, no shared SAN, etc. Runs with commodity gear like a bunch of rackmount servers connected via gigabit networks or Infiniband. This same hardware model is used by all the major search engines.

9:20 – Interesting – he’s getting ready to talk about design alternatives to shared-nothing cluster approaches. I like it when a vendor is honest and says, “This is another way to do it other than what we’re talking about.” He’s covering horizontal partitioning now.

9:23 – Brilliant. He’s using animated pictures to show how the different partitioning methods work when they’re loading data. As he shows round-robin partitioning, the loaded rows populate onto the different visual database servers. It occurs to me that he’s never really left education – he understands how to convey complicated information to a wide audience.

Dr David DeWitt Explains Partitioning

Dr David DeWitt Explains Partitioning

9:30 – He’s explaining about how you scale out joins in shared-nothing systems and how relational operators affect the joins. This is amazing stuff.

9:32 – With Project Madison, reading execution plans is going to be a lot more interesting: we’re going to need to pay more attention to how each individual thread works, because the load really needs to be balanced. Right now, if you have a parallel operation broken out across 8 threads, for example, you’re not too concerned whether one thread finishes faster. When each thread is running on a separate machine, each with a separate set of data, you need to pay close attention to what kinds of data you’re putting on each machine. This is mesmerizing for engine guys like me.

9:38 – He’s talking about the role of indexes. I’m not even going to try to blog this from here on out. If you’re into query execution plans, if you’re into data warehousing or if you’re into scale-out architectures, you definitely want to watch the recording of this presentation. He’s brilliant and it has a lot of impact on people who will use Project Madison.

9:47 – I said I wasn’t going to keep blogging, but man, this is really, really important. Your indexing strategies, especially your clustered index strategy, is going to be dramatically different. There’s some similarities with OLTP partitioning – scenarios where you partitioned in order to gain concurrency benefits – but man, you gotta be paying attention. I can easily see where a Project Madison implementation will benefit from having a person specifically dedicated to determining the correct partitioning keys for a month or more, just testing and benchmarking. Schema changes will also require careful planning to make sure the data lands on the right nodes for querying speed.

9:52 – When the engine has to join two large tables that are partitioned in different ways, it’s called Table Repartitioning. Each node splits its part of the table out into N parts (N being the number of nodes) and then splits that data out to all of the other nodes. It’s done by splitting, shuffling and combining. Networking is fast enough that it’s not a bottleneck, they say. Can’t wait to see that part in action – technologically impressive!

9:55 – Thinking about concurrency problems, I’m amazed that this stuff works. It’s shuffling data between nodes in order to recombine for a query, and yet you could have inserts/updates/deletes going on at the same time too. I’d love to play with benchmarks to see when Madison starts to pay off: for example, if you have a 16-core box with 128gb of memory, how many Madison nodes would you need to keep up when there’s heavy insert/update/delete activity going on? I’m not saying Madison doesn’t pay off – I’m sure it will – but it’s a neat theoretical question to ask. (But it depends on the activity and the schema, of course – it’d cost a lot to find the answer, and the answer would only be valid in limited scenarios.)

9:57 – This has awesome backup implications. It’s been said before, but it bears repeating: on a scaled-out Madison system, the dimensions will be copied across all of the nodes, but fact tables will be spread out and not copied everywhere. Now, for the new part: I wonder how backups will work. With data spread out so far, the amount of throughput coming from Madison to the backup system will be insanely, screamingly fast. Toss in a compression product like LiteSpeed, and wow, I bet I could back up terabytes in minutes. I’m going to need a lot of storage speed on the target end just to keep up!

10:00 – Partition skew = an unbalanced amount of data in specific partitions (now nodes). The engine can either has functions (almost random) or range partitioning (manual setup). Since the node with the most data has the slowest response time, and that determines the query’s total execution time, then you have to pay attention to partition skew or your queries will slow down.

10:02 – DeWitt’s Gray Systems Lab is working with the DATAllegro team to build a new “world-class parallel optimizer” to make it easier to work around partition skew, among other things. Wow – brain power. “Microsoft intends to become the premier supplier of scalable database systems for data warehousing.” Interesting – that wouldn’t appear to put them in competition for lower-end scale-out systems.

10:03 – Done. Wow, he was awesome for engine guys like me! Off to the sessions…

Other bloggers took some great notes during the keynote:

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Thursday Recap (#sqlpass)

PASS Board Election Results Dribbling In

Andy Warren is in!  He talks about it on his blog, and I got a huge chuckle out of this part:

I didn’t have any idea what my chances were, I really didn’t do a lot of campaigning (hard to figure out a way to do it that didn’t seem icky given the constraints) other than my blog, so I attribute tit to my PASS related blog posts resonating some with those that were voting, and probably more so the relationships I’ve built over the years.

PASS makes it almost impossible to campaign: they choose candidates days before the election starts, and the election runs during a short few days where the voters AND the candidates are at their most busy time of the entire year!  I wasn’t running for the board, and I didn’t have enough time to do everything I needed to do for my JOB here, let alone run a campaign.

To be more fair to the candidates, it’d be great if the candidate list was determined, say, one month before the election.  That would allow the candidates more time to build a message, get that message out to the voters, and let the voters understand each candidate.  Otherwise, it’s a popularity party – “Oh, I’ve read that guy’s book.”

Don’t get me wrong, though: I’m glad Andy won, because his ideas for PASS resound with me, but it bums me out because Tom LaRock didn’t make it.  I like how he calls himself the Susan Lucci of the PASS Board elections.  When he runs next year, I’ll be tempted to campaign for him by saying, “This is Tom LaRock, but don’t vote for him because it’ll break the trend.”

And even though he didn’t win, he fulfilled his end of the deal anyway: Tom LaRock got a tattoo.  I promptly emailed the photo to Congress (his wife).  Expect to see that photo surface around this time next year just before the voting starts.

Focusing on BI

I got the chance to interview Tom Casey yesterday, and we focused on BI because frankly, that’s where the action is right now.  I’m still digesting everything going on in BI, and I’m going to write my blog post about that on the plane ride home tomorrow.  Plane rides, plural, I guess.

The one thing that keeps resonating with me is a single line on one of Tom’s slides: “You are on your way to becoming a BI expert.”  Whether you came to the PASS Summit to learn about the engine, about development or about something else, you were learning things that were directly applicable to building a BI solution.  Jeremiah Peschka said that he’d originally come to the summit to dive deeper into development, but with the other sessions available, he realized he’d rather broaden his expertise and see other subject areas that he wouldn’t ordinarily have a chance to access.  I agree – I get the most value out of sessions that are way outside my comfort zone, like the one by Andy Leonard and Jessica Moss about SSIS scripting.

Jamie MacLennan blogged about his BI Power Hour demo: he used analytics to determine which foods to buy for his picky kids.  It’s a really funny read:

“So, I decided to make a worksheet listing foods they these kids will eat and won’t eat.  I used attributes of Color, Type, and Processed, along with a column indicating whether or not they will actually eat the food.  Of course, I had to answer to myself disturbing questions such as “what color are hot dogs?”, but I got through it.”

It’s always good to see that vendors like Microsoft eat their own dog food.  Wait – that doesn’t sound right…

PASS Reception

It was just awesome – the Flock of SQLs sounded way better than a bunch of SQL Server people have the right to sound, and the room was chock full of fun stuff to do.  It was a little loud, which made it tough to play the video games scattered through the room, but you can’t have everything.

Rather than describe the madness, I’ll just link to my PASS Summit 2008 photoset on Flickr.  Be advised that some of the photos contain men getting tattoos.  And one is a tramp stamp.  ‘Nuff said.

Wednesday Recaps Around the Web

This morning, I’m heading out for breakfast and then nonstop sessions.  I had to do a lot of work-related stuff the first couple of days, and now it’s time to get my learn on.  I don’t know how PASS volunteers keep their skills up: all of them spend so much time volunteering, helping the community, and they don’t even get to go to 2-3 sessions!  I’m really looking forward to these sessions:

  • 1pm – Donald Farmer on integrating analytics with your data.  You know Donald by now from the keynote demos.
  • 2:30pm – Linchi Shea on server benchmarking.  If you use storage area networking or if you want to wring the most performance possible out of your servers, watch his session even if you have to see it later on DVD.  He does great work, and reading about his experiments will help you perform your own testing in-house.  His work helped me get started with SAN testing.
  • 4pm – Michael Ruthruff on SQL Server in Hyper-V.  I’ve dabbled in Hyper-V but haven’t gotten too deep.  I managed VMware farms, so I’m more comfortable with that, but I’m interested to hear about the results in Hyper-V.

See you around the summit!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit Keynote by Tom Casey (#sqlpass)

I’ll be liveblogging this morning’s keynotes at the PASS Summit.  Refresh this page for the latest news.

10:02 – Tom’s focusing on the ROI of BI, and suddenly I get it.  The database engine works great.  Now we’re bolting things on top of it to make every end user in the company see the value of using SQL Server as their engine.  Before things like this, you could have swapped back ends with MySQL, Oracle, whatever.  Now, end users will get real value out of using SQL Server as the engine.

10:01 – Kilimanjaro will include the self-service analysis in Gemini, plus the self service reporting, collaboration and management inside Sharepoint.  Interesting – that’s like the SQL 2005 SP2 approach they took with SSRS integration in Sharepoint!

10:00 – Donald just joked about how Gemini isn’t Jim and I, and he said, “Thanks to Joe Webb for that one.”  Holy cow – what a funny use of Twitter to bond with your audience.  Andy Leonard said, “I got goosebumps!”

9:59 – showed an absolutely unbelievable time lapse graph in Sharepoint to show application popularity,  The more popular it got, the graphs moved around and showed interest.  Totally stunning.  That one graph will sell deployments.

9:55 – Donald’s showing Sharepoint as the consumer tool for SQL Server Analysis Services the same way it became for SSRS in SQL 2005 SP2.  One thing to manage.  Absolutely beautiful graphs.  I don’t use Sharepoint enough (nothing against it at all), but if it looks this good, I’ll be all over it.

9:53 – The promise of Gemini is two-fold: end user empowerment, and tracking and management for IT.  Bringing control and accountability into the system so that we can embrace it with the right management and control.  Gemini refers to the twins, and we’re about to see the second half of the twin.

9:48 – Talking about putting BI in context, delivering it as a smaller piece of a bigger application.  I’m thinking of Amazon’s “people who bought this also bought” and I like that approach.  Now wrapping up and going to spend 10-15 minutes with Donald Farmer.

9:43 – Think bigger about BI, they say: bigger deployments, bigger data volumes, better TCO, end user empowerment, etc.  This plays right into the Excel deployment of BI.  If you want to grow the BI deployment rate, you make it a part of a really common tool like that.

9:40 – Tom’s slide made a great point about SQL Server DBAs: “You are on your way to becoming a BI expert.”  Great point because it’s the same toolset we use for tiny OLTP systems versus huge BI systems.  All of your skills are applicable.

9:37 – Donald Farmer pointed out that she’s building reports against a nearly 2 terabyte cube.  Yes, but that doesn’t make it any more exciting.  It’s still watching a report being built.  If you want excitement, just show the report run, like the DATAllegro demo yesterday.

9:34 – Watching someone else build a report is like watching paint dry.  Carolyn’s a good presenter, doing a good job of showing it, but – jeeez, this is some boring content for this audience.  Well, for me anyway.

9:28 – SSRS 2005′s Report Builder started to democratize the development of reports, but Carolyn Chau is now on stage to show us how Report Builder 2.0 is easier.  Designed around the Office 2007 ribbon UI.

Tom Casey Onstage

Tom Casey Onstage

9:27 – Focusing on large data warehouse tools and benchmarks, like the Unisys load of 1.1 terabytes in under 30 minutes.  Oracle and Informatica’s record was 45 minutes for 1tb.

9:25 – Tom is talking about the scale-up story.  5% of data warehouses are 25tb or more, and SQL Server 2008 focused on that.  Those job skills are safe, he says, despite the DATAllegro acquisition.

9:22 – Donald Farmer is sending tweets live during the keynote, responding to the community.  I really applaud that – it makes the keynote so much more interactive and personal.  Plus, keep in mind that Twitter isn’t a Microsoft tool.  That kind of personal commitment is awesome.

9:20 – Tom explains that these tools make BI more continuous and interactive so that BI isn’t done by specialized professionals, it’s done by everyone.  I would agree, but I would clarify that end users are CONSUMING it, not “doing” it.  Otherwise, this is great.

9:17 – Demoing PerformancePoint-based dashboards, Live search integrated with a map, communication between management to set expectations.  This screams consulting dollars.

Bruno Aziza and Tom Casey

Bruno Aziza and Tom Casey

9:13 – While Tom talked about BI for everyone and BI being pervasive, the demo is clearly not built by end users.  They can slice and dice, but we’re still talking about an application that’s set up and modeled by BI professionals.  Whew.  Our jobs are safe.

9:10 – Bruno’s showing a single web browser with his contacts, his email, his My Documents, his dashboard, etc. It’s like a collapsed version of Office that centers on you and your work, NOT which application you’re in.  Interesting.

9:08 – Bruno Aziza, Business Architect in Enterprise Marketing is showing off Contoso Oil & Gas BI demo with Sharepoint, search, BI, PerformancePoint and more.  He’s playing operations manager of oil rigs in North America.

9:05 – Tom’s talking about BI for everyone, specifically giving people actionable information.  They’re going to talk about the second half of the twin (Gemini) that relates to us IT professionals.

9:03 – Tom Casey is onstage talking about the 136 chapters of PASS with 32,500 members in 38 countries.

Kathi Kellenberger wins 2008 PASSion Award

Kathi Kellenberger wins 2008 PASSion Award

9:00 – PASSion Award Winner of 2008 is Kathi Kellenberger!

8:56 – You can try out SQL Server 2008 at http://www.sqlpass.org/hostedtrial.  Get a free account and play around with it without installing anything.  Powered by Dell, MaximumASP and Microsoft.

Rushabh Mehta

Rushabh Mehta

8:55 – Announcing PASSPort, a new tool in the virtual SQL Server community that helps you connect, share, learn and be recognized by other SQL Server professional.  Rushabh’s showing it and it looks pretty interesting.

8:52 – The new SQLPass.org site is out of beta.  It features hundreds of hours of presentation content.  I love this.

Rushabh Mehta and his Vespa

Rushabh Mehta and his Vespa

8:50 – 92% of the revenue comes from this conference – 72% from the summit, 14% from the expos & sponsorship.  Despite a bad economy, they’re projecting a pretty hefty growth – from $2.6m in FY 2008 to $4.3m in FY 2009.

8:45 – Rushabh’s going through housekeeping stuff about PASS – the parties tonight, financial statements, etc.

8:40 AM – Rushabh Mehta just arrived onstage on a Vespa.  Carrying on a conversation with an offscreen narrator about being jealous of Donald Farmer’s hair.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Wednesday Recap (#sqlpass)

Aside from my liveblog of Ted Kummert’s keynote this morning and Jimmy May’s presentation on partition alignment, a few other things caught my eye today.

I talked to JC Cannon about his SQL Server 2008 Compliance Guide.  I’ve written here about it before, but it bears repeating.  If you’re not here at PASS, and you wish you were, you can get a taste of the educational experience by going through that guide.  It’s extremely well-written, and like I told JC, when I think of an example about how whitepapers should be written, that one leaps immediately to mind.  You can learn a heck of a lot from that, and it’s f-r-e-e.  Go read it.

Keynote DBA Star Ayad Shommout’s SQL 2008 Experiences

I talked to Ayad Shommout, lead DBA for CareGroup Healthcare Systems, to get more information about his SQL Server 2008 upgrade experiences that he’d discussed during the keynote.  He uses clusters in conjunction with database mirroring, so he used a rolling upgrade process: fail over to the mirror, upgrade the cluster, and fail back.  The whole process involves less than a minute of downtime.  I’d heard that before from sales & marketing, but this was the first time I’d heard someone who’d done it on a wide scale in production.  Ayad’s environment is a perfect fit for 2008: healthcare, mission criticality, encryption needs, you name it, there’s a 2008 feature for him.

Ayad was also in on the server management tools that were covered in today’s keynote because he’s a part of a Microsoft early adopter program.  We talked a little about our hopes and dreams for the future of SQL Server management.

The Future of SQL Server Management

Based on what we saw today, I would really encourage DBAs to start looking closer at virtualization.  The DAC concept – packaging databases, dependencies and connection name into a single deployable package – means that it will be easier to move database applications from one server to another without changing the application.  In a sense, that’s virtualization, much like the instance concept is to some degree virtualization.  We’ve got virtual servers from Hyper-V and VMware, virtual storage from tools like IBM SVC, virtual databases from HP PolyServe and now SQL Server itself is moving towards abstracting away the underlying hardware.

Cloud-Based Business Intelligence

I gave a very sparsely attended presentation on using cloud-based BI to interpret Profiler and Perfmon results,and I mean sparsely.  I knew I was up against a lot of great competition – heck, ***I*** wanted to leave and watch Donald Farmer’s BI Power Hour – but I pitched in to help cover a speaker who couldn’t make it.  There was some mild interest in the technology, but the audience really grasped the security issue.

BI in the cloud, or even just databases in the cloud period, is one hell of a tough sale to professional database administrators.  They make their livings wrestling with tough issues like good security, compliance, auditing and disaster recovery.  They know how difficult these things are to implement, and they won’t just take someone’s word that it’s implemented.  They’re just not interested in using it for private data, period.

The analysis on the vendor side is that sooner or later, the cost will get so cheap that it will be a business decision, not a technology decision.  Maybe executives will mandate the use of cheaper resources, or maybe mid-level managers will just whip out their credit cards and handle BI projects on the sly.  Whatever it is, DBAs are not begging for the ability to do stuff in the cloud yet.

It’s a tough sell to DBAs, so who’s it an easy sell to?  Who wants this stuff?  I’ve had this discussion a few times with different folks this week, and there’s an apparent barrier to entry that’s pretty high.  People don’t understand how analytics works – real predictive analytics, data mining and whatnot.  I know – I’ve picked up data mining 101 books and put them down a few days later feeling like an idiot.  Analytics is really powerful, analytics is really enabling, but how do you wrap it in an experience that end users will embrace?  I dunno.  I’m just a guy who writes blogs and Twitters.

SSIS Task for Twitter

Andy Leonard and Jessica Moss gave a great presentation on using SSIS to send and receive Twitter messages.  (That CodePlex code is awaiting approval as of this writing, but will be live shortly.)  I was on the edge of my seat, along with fellow Tweeps Jason Cumberland and Paul Waters.

The rest of the class was, ah, shall we say, reserved.  The room was absolutely packed, standing room only, but people were practically mute.  Jason and I busted out clapping at a couple of points.  Wayne Snyder’s remarks this morning about it not being a zombie conference weren’t entirely accurate.  I think the DBAs only light up after 5pm when the drinks start flowing, like at the…

SQLServerPedia.com Launch Party

I talk up our marketing team a lot, and here it goes again.  The SQL Server marketing team at Quest are rock stars.  The party was a ton of fun, and packed in a lot of really good people with great conversations. I talked to a bunch of people I’ve met online over the years, people I’ve never had the chance to meet in person, and way more people than I can even list here.  My brain is fried!

We talked shop, we talked hobbies, we talked politics, and more.  Especially politics.

You, dear reader, have probably not voted yet.  Get your lazy rear over to a voting kiosk at PASS and take just a couple of minutes to vote.  Seriously, it’s important.  It may not be important to you, but it’s ridiculously important to the people who are running.  I’ve endorsed Douglas McDowell and Tom LaRock, and these guys are just biting their nails.  Go get to a kiosk and cast your vote, because they really want your help in getting elected.  Even if it doesn’t mean anything to you, it means a lot to them, and it means a lot to me.  These guys really do care.

Don’t believe me?  Go watch the PASS Board candidate videos.  These people want your vote.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Jimmy May explains Partition Alignment (#sqlpass)

Before attending this session, I’ve always gone to KB article 929491 article on partition alignment.  I thought I kinda sorta understood what was going on, but Jimmy’s presentation drew on the best graphical illustrations to show it.  Not to mention his audio stylings like, “Holy correlated wait stats!”

Get your binoculars out

Get your binoculars out

Partition alignment is one of those hidden performance tweaks that makes a big (10-20-30%) performance impact.  Windows 2008 (and Vista) fixed this, but only for new partitions – if you upgrade an existing Windows 2003 server and don’t blow away the partitions, you’re still affected.

How much will you really be affected? Jimmy’s experiments with unaligned and aligned raid 10 arrays had a 6-disk aligned array outperforming an 8-disk default array.  Whoa – that’s a 30% cost savings.  He’s a hilarious presenter, which was great because he ended up sounding like a weight loss salesperson.

Partition alignment used to be all about the mechanics of hard drives, but today it’s all about RAID stripe sizes and SAN cache.  You can’t just align your partitions at 32kb.  While that might have worked in the days of locally attached physical hard drives, it doesn’t line up with common RAID stripe sizes.  It even matters for virtual machines, Jimmy says, because the virtual hard drive file lines up with the hard drives on the host.

If your vendor says partition alignment doesn’t matter, you have the wrong contact person at your vendor.  I back him up 100% on that.  No exceptions.

For basic disks – disk alignment is performed with diskpart, but you can’t use that for reporting alignment. He gave a WMI script to grab the partition offsets, but again, only for basic disks.

For dynamic disks – For Windows dynamic disks, use dmdiag.exe -v (which means verbose).  The v is required.  For Veritas dynamic disks, use the Veritas tools.  He didn’t drill into this in the presentation.

He also touched on the importance of stripe sizes and file allocation unit sizes.  He didn’t recommend rebuilding just because of 4kb cluster sizes, but if you’re redoing a partition from scratch, use the size your vendor recommends.

The bad news: you can’t fix any of this online. You have to back up your data, blow away the partitions, align them, and restore the data.  But hey, good things come to those who wait.

Jimmy May’s blog on SQL Server storage is a great resource to check out.  I hadn’t seen it before, so I subscribed because he kept swearing that he’s going to write more entries about it.  I’ve gotta hit this guy up to do video podcasts, because he’s hilarious.

To learn how to align partitions, check out my SQL Server setup checklist.

There’s probably some other valuable in there that you might be missing!  I cover a lot of easy ways to get more performance out of your SQL Server.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Wednesday Keynote (#sqlpass)

I’m liveblogging the keynote this morning on here and on my Twitter feed.  Go to this page and refresh it periodically to get the latest news as it happens.  Updates are at the top of the page to make reading easier during liveblogs, and I’ll reverse it tonight for easier reading later.

10:08 – And that’s it!  Done.  See you at PASS!

10:06 – Donald got a great reaction from the attendees.  Kummert’s thanking the DBAs.  Kilimanjaro (with Gemini) and Madison will be coming in the first half of calendar year 2010.  Next major release of SQL Server will be coming 24-36 months from the release of SQL 2008.

10:03 – Judging by the reaction from bloggers and Twitterers, they’re genuinely surprised by the Project Gemini stuff.  Hello, welcome to last month.

10:00 – Donald Farmer walks onstage with fairy wings as part of the fairy tale.  He’s showing the 10-million-row demo of Gemini, sorting instantly on a laptop machine.

9:57 – Talking about enabling the SSAS-style experience inside Excel, and why end users don’t want to learn star schemas or dimensional models, they just want to get the job done. Amen – that’s my session today at PASS.  Kilimanjaro runs on a column-based storage (fast fast fast).  BI utility hosted within Sharepoint.

9:52 – Ted replayed the “Once Upon a Time” story he gave at PASS.  I’ll forgive him because it’s so good.  It basically talks about how IT can’t answer end user needs fast enough.  Donald Farmer coming out to demo managed self-service BI, aka Project Gemini, next.

9:50 – He’s bringing developers up to speed on the Azure announcements from PDC.  Will be exposing all of the data services over time, and will be moving forward very rapidly.  The first CTP of SQL Data Services is now available. (Could have sworn this was out at PDC.)

9:47 – DAC demos over, and Kummert’s talking about deploying databases to the cloud.  “You should be able to leverage your knowledge and investments to deploy in the cloud.”  It’s a statement about tools and about capabilities.

9:46 – Applications will get a “friendly name” for a connection string – somewhat like DNS.  That means you can move DACs around without breaking applications.

9:45 – They’re suggesting (but not specifically saying it) that there’s some change management inside the DAC process.  Admins can specify requirements of a DAC of things like SQL Server versions & editions, performance needs, etc.  A data warehouse would have different requirements than a small OLTP app, for example.

9:44 – SSMS can connect to an existing database, reverse engineer it into a DAC Pack and include the schema, plus things outside the database like logins.  Didn’t mention code, of course.

9:42 – Inside SQL Server Management Studio, there’s a new view called the Fabric Explorer that connects to a Fabric Control Point to show a dashboard of your instances.  you can see the utilization, health, trending, and more for each instance.  Helps you decide where to deploy DACs, and see which DACs need to be moved to other parts of the fabric.  There’s a build system in Visual Studio to build the DAC Pack.

9:41 – The DAC is a package of deployment requirements: schema, prereqs, things the application needs from the fabric in order to get deployed.

9:40 – Dan talks about how we manage instance by instance right now, not as an enterprise.  Need the ability to manage our servers in pools: the SQL Server Fabric.

9:39 – Talking about the ability to deploy applications as a package, along with its prerequisites.  The “down payment” will be released as a part of Kilimanjaro.  Welcoming Dan Jones to cover it.

9:37 – Demo over.  Switching to management: discovery, transparency, deployments based on policy, improved utilization in Kilimanjaro.

9:33 – Demo uses SSRS querying the cluster and the nodes go crazy.  Some nodes take longer to complete than others.  Says “It takes a minute for the tubes to warm up.”  HAHAHA, good one.  Nobody here got it though.

9:31 – Showing 7-table star schema.  Fact table has 1 trillion rows, 6 dimension tables, 150tb of data.  Tables are replicated across the nodes.  The dimension tables are copied to all nodes so that joins happen faster. Showing the system monitor with CPU/IO metrics they showed at PDC.  I love this demo visually.

9:30 – Showing a Dell 2950 reference architecture with one active/passive control node and a bunch of 2950 compute nodes, EMC on the back end.  Says they’re also working with HP gear too.

9:27 – DATAllegro will be integrated with the Microsoft BI stack. Now bringing Jesse Fountain, Principal Group Program Manager, Data and Storage Platforms Division to demo DATAllegro.

9:20 – Covering internal Microsoft implementations of 2008.  Couple of 1tb SSAS cubes, big 30+tb data warehouses.

9:19 – Ted’s saying they’re seeing unprecedented adoption of SQL Server 2008.

9:16 – Ted brought on Ayad Shommout, lead DBA for CareGroup Healthcare Systems, to talk about their experiences with the SQL 2008 upgrade.  He’s a great customer for that – they have HIPAA needs, which is a good fit for SQL 2008′s features: auditing, encryption, policy-based management, etc.

9:12 – Talking about the new features of SQL 2008 based on the four pillars – enterprise platform, beyond relationship, dynamic development and pervasive insight.  This slide was cool when I first saw it in, when was it high school, but now…

Ted Kummert Keynote

Ted Kummert Keynote

9:08 – New version of DATAllegro will ship in first half of 2010.

9:06 – If you interact with Microsoft folks in the official MS shirts, they’ll give you SQL Server Bucks.  You can redeem those at the end of the conference for a free car.  Okay, well, for something maybe.

9:04 – Ted: “We shipped SQL 2008 in August.  And I’m glad, otherwise you might be listening to someone else speak up here.”

9:03 – Video playing about how the PASS community helps build the product.  Donald Farmer talking about Gemini as the future of business intelligence.  I’m psyched, and Ted Kummert just walked onstage.  Walked?  What, no Vespa?

9:01 – Wayne introducing Ted Kummert, Corporate VP of Data and Storage Platform Division from Microsoft.  Forgives him for working for Apple.  (Between that and Wayne’s jokes about tweets, I think he needs to get some schooling on social media, but I’ll forgive that!)

Wayne Snyder Keynote

Wayne Snyder Keynote

9:00 – Wayne says to support the vendors because they’re supporting you, and they have tools to make your life easier.  I say to support the vendors because I want a Porsche 911.  The choice is yours.

8:55 – Registration up 60%.  Summit at 2,445, up from 1,528.  Precons at 1,143 up from 732.  If growth continues we’ll max out this facility next year.  Even though other conferences are having problems attracting visitors, PASS is growing.

8:50 – Wayne thanking the PASS Board and past president Kevin Kline for their tireless efforts. I gotta track down Christoph Stoltz and thank him for being such a kick-ass host when I spoke in Germany.

8:48 – Jeremiah Peschka is also liveblogging the keynote. (I got your name right this time, man.)

8:45 – 2008 accomplishments for PASS included the site relaunch of www.SQLPass.org, hundreds of hours of online video, free members, increased number of chapters.

8:40 – Wayne’s talking about the PASS Board’s mission to facilitate member networking, passing knowledge on from one DBA to another.  Talking about how some conferences are “zombie conferences” where you go from one session to the next, go back to your hotel room alone and be quiet.  PASS is not that conference.

8:37 AM – Born to be Wild music video playing to warm up the crowd.  Wayne Snyder rides onstage on a motorcyle and takes off a leather jacket.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Tuesday Recap (#sqlpass)

PASS Election Update

I’m seeing a theme on the interwebz: lots of endorsements for Andy Warren and Tom LaRock:

Tom has pledged to get a tattoo if he gets elected to the board.  C’mon, folks: do your part to help a DBA come home from a convention with a tattoo.  Give him something to explain to the wife – or as he calls her, Congress.

Stickers Are Here!

New and Improved - Now with More Stickers

New and Improved - Now with More Stickers

I picked up a SQLBatman sticker from Tom LaRock and a SQLServerPedia sticker from Christian Hasker.  If you want a SQLServerPedia sticker, swing by the Quest Software booth at PASS and ask for an invite to the SQLServerPedia launch party tomorrow night.

Thoughts from the Quest Customer Advisory Board Members

We spent all day talking shop with customers, and I obviously can’t blog about everything, but there’s a few juicy nuggets that you might like.  We’ve got a wide variety of customers involved, from shops like Michael Deputy‘s with only one DBA all the way up to global financial companies.  It’s fun to peek into their shops to get ideas about trends like these:

Dev/test SQL Servers on VMware and Hyper-V are very commonplace. Everybody’s doing it for cost savings, space/power/cooling savings in the datacenter, consolidation, etc.  Production servers aren’t quite as common – the DBAs were dead-set against it except for small implementations, like say a standalone Microsoft TFS server.

Remote DBA firms still aren’t catching on. One customer is augmenting his staff with offsite DBA help, but just one.  I think the DBA job lends itself well to remote work, but remote workers outside of the company seems to be a problem.

DBAs get bad products shoved down their throats by project managers. PM’s will go buy crappy applications that violate all kinds of company standards, but by the time the DBA gets handed the CD, it’s too late.  The millions have been spent and the DBA just has to suck it up and live with it.  I’m not surprised at all by this – it echoes my personal experiences.  One DBA team had the ability to kibosh projects because they were involved early enough in the project planning lifecycle, but they were the clear minority.

SQL Server 2008 is finding its way into production. Early adopters talked about problems with third party application compatibility, especially around data modelers.  They also had issues with vendors who said they supported 2008, but they did it by removing features.

SQL Server 2005 training is still in demand. DBAs said they can leverage any newly acquired SQL 2005 skills on SQL 2008 anyway, so why not keep getting 2005 training that they can use against all of their 2005 and 2008 servers?  SQL 2008 BI training is another story, though.

At the risk of sounding sales-y, even our customers don’t know all our features. We came out with LiteSpeed 5.0 a few months ago, and customers were surprised that our object-level recovery works against both LiteSpeed backups and native backups without any tweaks at backup time.  Booyah.

My podcasts are way the hell too long. Tom LaRock told me this a while ago, and boy, did the customers echo that one.  I’ll be breaking up my podcasts into 5-10 minute chunks for easier viewing.

Other PASS Summit News

Recaps have been posted today by:

I’ve noticed a lot of PASS people signing up for Twitter.  That’s a great sign, because if they stick with it, it means more transparency to PASS.  I love the immediacy and the community that Twitter brings, and Jason Massie should be proud of starting his SQL Server Twitter list.  It’s bringing people together, as cheesy as that sounds.

Plus, I think the Twitter buzz is working for positive marketing: I’ve seen people tweet that they wish they were here, or that they’ll be coming next year, or that they’re anxious for more info about the event.  That means we’re doing a good job of conveying how much fun it is to be here.

Tonight, I’m missing out on a ton of good dinners and parties (especially the PASS Quiz Bowl), but I gotta make the donuts.  I’m presenting on how to data mine your Perfmon and Profiler results with SQL Server Data Mining in the Cloud.  I gave a similar presentation a couple of times a few months ago, but I’m going to kick it up a notch for my first PASS session.  BAM!

Tomorrow morning, I’ll be liveblogging the Ted Kummert keynote.  I’ll start a blog entry here and publish it, and save it every minute or two with the latest info.  You’ll be able to reload the page to see what’s going on.  I’ll also be covering it via Twitter, and you don’t have to use Twitter to get the updates.  Just go to my Twitter page and reload it every minute or two when the keynote starts around 9AM PST.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Monday Recap (#sqlpass)

Great SSIS Boot Camp by Brian Knight

Brian’s a fantastic presenter – really funny, really engaging, and can answer questions on his feet.  The one-day presentation was a great way to get started, and I ordered his Professional SSIS 2008 book to answer my questions as I start digging into SSIS.

One indicator of a good presentation style: people follow along and ask questions, and the presenter’s answer is, “I’m glad you asked.  We’re talking about that next.”  That happened again and again in Brian’s presentation.

DBAs asked a ton of questions around SQL Server 2008′s Change Data Capture as the engine implemented it, but they didn’t relate to SSIS.  There seemed to be some basic disbelief about its reliability given that it’s implemented as a SQL Server Agent job: people wanted to know if the job would stop, what would happen if it stopped, what would happen if the log rolled over, etc.  There’s some concern around what happens with schema changes as well: evidently you have to disable CDC, make your schema changes, and then reestablish CDC.

Geeks Roam Seattle with Cameras

A few DBAs did a photo walk: roaming the city looking for interesting subjects to photograph.  Tim Ford’s pictures of Seattle are up on Flickr, and we’ll probably see some more sets emerge over the coming days.  It’s really hard to do photo postprocessing in the midst of a bunch of parties, so I certainly understand why he’s the only one who’s put it together so far.  (Frankly, I don’t quite understand how HE even did it.)

Drinks & Dinner with the Quest Software Customer Advisory Board

As I write this, I’ve spent the last four hours catching up with Quest employees and customers.  Quest is huuuge, spread out all over the world, and it’s so much fun to get a handful of people together in a bar to talk shop.  We had some hilarious stories about customers, vendors, and war stories.  My Twitter stream has been silent for the last few hours, and now you know why.  Wish I could have “OH” tweeted this stuff, but I like my job.  (A lot.)

Douglas McDowell and I had a great discussion about the mechanics of the StackOverflow reputation system.  Online reputations and credibility are going to be a big part of what makes any online community successful: people react differently (and with more maturity) when they know their online reputation sticks with them and is measured in clear, easy-to-define statistics.  I’m all about the Whuffie Factor.

I talked at length with both Douglas and Tom LaRock (SQLBatman) about the PASS Board elections.  I can’t emphasize enough that you should talk to them personally before you cast your vote.  Just walk right up to them and say, “I hear you’re running for PASS.  Why are you doing it, and why should I cast a vote?”  Historically, PASS election turnout has been pretty low, and it’s a shame.  PASS voting isn’t even like political elections in that it doesn’t even require leaving your house – it only involves a few mouse clicks.  Go get clickin’, and tell your friends.

Tomorrow: Quest CAB, a few parties

The Questies are doing an all-day series of meetings at the Hotel 1000, and the evening holds a few choices:

Bookmark Rob Boek’s PASS 2008 event calendar to stay up to date on your party options.  If you know a Solid Quality Mentors person, you might ping them to see what they’re up to tomorrow night too, but you didn’t hear that from me….

Update – Monday Recap from Jeremiah Peschka

Jeremiah, also known as @peschkaj on Twitter, posted his PASS Summit Monday Recap.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

PASS Summit 2008 Sunday Recap

I flew in yesterday and spent some quality time with some other folks who were lucky enough to fly in early, and by “quality time” I mean eating and drinking.  I only got a handful of photos.

Listening In on DBA Conversations

The funnier momentos were the things we overheard.  If you follow me on Twitter, “OH” means “Overheard”, and we type that when somebody won’t want to be identified by the quote.  Some examples:

  • OH: “My wife makes hamburger cake.”    “We call that meatloaf.”
  • OH: “Do you like ginger?”     “The root or the Gilligan’s Island castaway?”
  • OH #sqlpass “I’ve never done it with a real girl before in a room full of people.”

If you want to follow up on the minute-by-minute news from the DBAs gathered in Seattle for the Summit, use search.twitter.com and search for #sqlpass.  You don’t have to use Twitter in order to hit that link – you can just go there and refresh it from time to time to see what’s going on.  If somebody posts a lot of interesting updates, follow ‘em and you’ll probably like their updates outside of the PASS conference too.  Plus they won’t always remember to use the “#sqlpass” tag.

The PASS Board Elections are On

The emails went out last night inviting PASS members to vote.  If you’re in Seattle, I would wait to vote until you’ve talked to a few of the candidates.  They’re going to be all over the place, and if you see one, just start a conversation – “So, what are you going to give me for my vote?” That works.

To find out where they’re at, follow them on Twitter:

Monday’s Activities

I’ll be at Brian Knight’s SSIS Boot Camp today.  Say hi if you see me.  I probably won’t be tweeting as much since I’ll be soaking up knowledge like a sponge.

Tim Ford and a few other photo-savvy DBAs are doing a photo walk around Seattle.  They’re meeting up in the Sheraton lobby at 8:30 AM.  If you’d like to join in, go over there and look for the guys with shooting pictures of everything that moves or doesn’t move.  They’re friendly people, don’t worry.

PASS Volunteers have a welcome reception tonight that starts around 6:30PM – I don’t have the location.  I’ll be at a private Quest Software dinner tonight.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts