Search results matching tag 'Customer Contact'

A SQL Saturday in Cambridge – Buck Woody’s Ragtime Database Workshop

BuckWoody — Mon, 30 Jul 2012 20:49:00 GMT

The SQL Server community is really engaged. They are an active bunch on Twitter, Facebook and LinkedIn, they help each other on forums, they attend conferences. But that isn’t enough interaction – the community started a grass-roots effort to hold local conferences on a Saturday. Free conferences. Odds are there’s one near you… http://www.sqlsaturday.com/default.aspx … and if not, you can start one.

Sessions at SQL Saturdays are all over the map, and there’s something for (almost) everyone, from Business Intelligence to Database Administration and Development. Some of these events have “training days” associated with them – longer, more in-depth training that has a fee. I’ve taught quite a few of these, and of course I’ve done my share of other presentations at the events as well.

I’m honored to be presenting at the Cambridge, UK SQL Saturday this year (http://www.sqlsaturday.com/162/eventhome.aspx) in September. For one thing, I used to live near there and plan to take the family with me to show them my old stomping grounds. For another, I’m excited about the sessions I get to present.

The Training Day

Friday I’ll be leading one of those training days – and I’ll be delivering a very important workshop, where I’ll cover SQL Server – all of it. OK, maybe not *all* of it, and maybe you won’t be a complete PhD after the class, but we’ll do a complete immersion in learning SQL Server as a product from the ground up. It’s a workshop format, so no sitting and listening to someone droning on and on for hours. You’ll be asked to bring a laptop, and do actual work on the product from the first few minutes of the 8-hour day to the last of the workshop. You’ll be jumping in from the very start, and in deep until the end of the day.

But wait – this is kind of a “beginner” thing, isn’t it? Shouldn’t I be doing something on the internals of the locking mechanism of the hashing system in memory on x64 architectures, with complete code diagrams? Shouldn’t you be able to snatch the T-SQL pebble from the master’s hand when you’re done, or be able to shoot the wings off of an XML fly when you’re done?

No.

We need this kind of session. For one thing, you can get that depth in other sessions. For another, we need to have a place for someone that wants to learn SQL Server but doesn’t have a lot of time to do that. We need something relatively inexpensive that a boss can send a developer, administrator or new employee to learn how to take over the SQL Server, or augment the DBA team. We need a place where good habits are formed, and where someone can branch out into a new part of technology, into one of the best places in tech to be – data.

After you’re done with this session, stick around for Saturday – now all those presentations will make more sense. And you’ll be able to network with a lot of folks that already do what you learn about on Friday, and who knows – find out where to look for work in this amazing career field.

What will you learn?

You’ll start with knowing that SQL Server is a database product by Microsoft. That’s all the pre-requisite you need, other than being the technology industry. From there we’ll cover:

The Data Professional Career
Installing, setting up and configuring the right Edition of SQL Server for the job (including SQL Azure)
Database engine fundamentals – How does the engine work, what are the components, what can you configure and tune
Transactions, Locking and Blocking
Creating and managing databases
Database options and their impact
Database Objects including Tables, Views, Stored Procedures, Functions and more
General maintenance including backups and recovery
Security fundamentals including users, roles, and object security
Performance tuning fundamentals including indexes and query research tools
Multiple resources to help you get to the next level

In 8-hours. Come ready to learn. You’ll need a laptop, and complete focus for a few hours. You’ll leave with the ability to manage and work with a SQL Server system – and you’ll learn what to do next.

Who should go?

If you’re new to Relational Database Management Systems (RDBMS’s) but not technology, and you’re looking to expand your technical reach, coming from another platform (to be sure, there will be some repeat info here), want to explore a new tech career area, want to learn more about developing against an RDBMS or know someone who does.

The registration for the training day is here: https://www.regonline.co.uk/?eventID=1120017&rTypeID=242030

What else are you doing whilst (I love saying whilst) there?

I’m also pleased to be providing the keynote on Saturday. (I can’t wait to see what I’m going to say), as well as two other sessions – more on those soon. My daughter wants to be a Zoologist, so while we’re there we’ll be visiting the Zoology museum at one of the colleges, I’ll probably eat too much and potentially go punting. I’ll also mingle with you, my SQL Family, and we’ll just generally have a good time.

If you’re not busy in September, and even if you are, make plans to come check all this out. It promises to be awesome. (Americans think everything is awesome)

See you there.

Preparation is key to a successful cloud deployment

BuckWoody — Tue, 01 May 2012 13:09:16 GMT

If you want to be wise, watch the actions and outcomes of others. Emulate the successful actions, and avoid the actions that cause failure. That’s true in life in general - and in technology projects in specific.

I’ve worked with several clients who have created or migrated an application to “the cloud” - meaning using Microsoft Windows Azure or another provider. Although the statement in the title of this post is trite, I cannot over-emphasize how accurate it is. In every case of those who had a great experience with a distributed computing environment (which is thankfully the vast majority of my projects),

What kind of preparation do you need to do? Here are some tips I’ve learned in the successful (and not-so-successful) deployments I’ve seen:

Follow standard recommendations for successful projects in general

You and your organization have probably done a few projects before - this one should have the same general attributes: a well-defined goal, a small, motivated team, a realistic timeline, and an adequate budget. I know, I know, you *never* seem to get those things - but if you don’t, you’ll fail. Simple as that.

Educate yourself

Computing technology started out on a single set of hardware for a single purpose - and realizing the limits of the hardware at hand, systems designers quickly realized that scale-out and virtualization was key. No, that’s not new - mainframes almost always worked on the concept of scale-out and virtual machines. But we switched in the 1980’s to single-user systems again, and we’ve been there ever since. By that I mean you install an OS on the things you work on. Now we move back to distributed system concepts, and there are some real differences. You’ll need to learn how those work, and do things a new way. Hey, we’re IT - we LOVE learning new things, right?

Get a partner if needed

There are a few of us white-haired Gandalf’s around that remember how to work in a distributed system, but if it’s new to you, that’s completely OK. You can save yourself a world of trouble by working with someone who’s done this before - a partner you hire, someone from Microsoft Consulting, whatever.

And don’t forget support - who will handle each issue, what is the escalation model, who are your contacts at Microsoft, and what is your “light’s out” strategy?

“A new broom sweeps clean”, the old adage goes, but the old brooms know where the dirt is.

Build a model

Take some time to do a Proof of Concept on your local system and using your Azure hours from your MSDN account if you have one. Going through this build - and being willing to throw it away and try it a different way - is invaluable.

Test your theories

Three statisticians are walking in a field. They see a rabbit - the first guy raises his gun, firing far in front of the rabbit. The second guy simultaneously raises his gun and fires far behind the rabbit. The third guy yells “We got him!”

Not every theory is correct - not every attempt is the right one. Build in your success tests while you’re building your model. Then check them - don’t leave this step out.

Rinse, lather, repeat

This is advice from a shampoo bottle - which I’ve never used (I don’t really have that much hair - especially now). But in a “Cloud” project, it’s important. It’s an evolving system, that gains new improvements at an amazing rate. As soon as you deploy and stabilize you need to start the process over again. If you created your system in a Services model, with contracts for the APIs and abstracted code, this is far easier.

It’s not hard to do a cloud project right. But it’s really simple to do it wrong. Follow these guidelines and you’ll learn from the successes - and mistakes - of others.

How I Prepare For Presentations, And My Speaking Schedule For This Quarter

BuckWoody — Tue, 16 Aug 2011 14:04:45 GMT

I do a little speaking here and there and I’ve been asked about the method I use to get ready for a talk. I thought I might share the method I use, although as you read through this remember that not everyone has the same style, processes and procedures they use. As long as you feel prepared when you speak and the audience learns something from you, you’re doing it right. Still and all, it can be useful to see what someone else does to tune your process even further. Whatever makes your speaking better helps us all, including me, as I sit through quite a few presentations myself.

I do several types of presentations, from working with my direct clients at Microsoft in a very targeted and interactive discussion all the way to a full semester of classes at the University of Washington that lasts for several weeks. I also speak at technical events, and in all of these the audience size an participation levels vary. Even so, I still follow roughly the same process:

Develop The Concepts
Create Animations
Develop A Slide-A-Day
Practice
Tuning And Feedback

Develop The Concepts

When I’m asked to speak on a topic, I try and boil that down to one over-riding goal, such as “The listener should know how large-scale data sets can be handled”. Then I do a work-back outline of how that would happen - introduction, terms, define the problem, explain the options, provide specifics, detail references might be one example. Then I try to make that even tighter, until I start losing fidelity in the talk.

This is where the duration of the talk and the audience makeup is most critical. The shorter the period of time I have to talk, the lower I set the goal. I’ve seen people try to cram a complex set of information in an hour, complete with demos. At the end I certainly have an exposure to the information, but I don’t know that I have retained it. I would rather the speaker focus on one specific part of that deep topic or simply provide an overview and then point me to relevant resources I can study in detail later.

The key is what the audience retains when the talk is over. If they think “wow - that speaker is really smart” that’s actually a failure. They should think “wow - I’m really smart, and now I know how to do that thing the speaker talked about”.

Each of these concepts then becomes a logical flow of mini-goals, and many times, these map to a slide or whiteboard graphic.

Create Animations

It doesn’t matter what tool you use - somehow you need to convey your information to the audience. In some cases, I can draw “word pictures” simply by talking, but technical topics often lead themselves to graphics. I’ve used whiteboards, Power Point (don’t make that face) and even Microsoft Paint with a Wacom Tablet. I try to show a start-to-finish process, or layer components to slowly cement in the listener’s mind what I want them to know.

The rule of thumb I use is to show one piece of a system at a time, to show a larger more complex whole. To show how that system interacts with another, I use animations. All of these are done as simply as possible, using the least flashy animation I can. Any technology I use should be to get the point across, not to show how many fonts and explosions I can cram onto a screen.

I find that almost every concept I developed in the previous step warrants it’s own slide or drawing. If I have too many, say more than 8 or so for a one-hour presentation, then I have too many concepts for a single presentation, or I’m making it too complex. If I have lots of lists on the screen and not many graphics, then I’m reading notes and not setting up a dialog with the audience. Creating a graphic per concept keeps me from many of these errors.

Develop A Slide-A-Day

Speaking isn’t my full-time job, so I have lots of “real” work to do. So after I’ve gotten the concepts down and turned them in to graphics, I take one slide each day when I can and work through the detail of the concept I’m talking about. If I’m using Power Point, I use the “Notes” view to put down the text I want to cover, the references I find on the web, in magazines and books, and the other speakers I credit during the presentation. I give that out electronically after the presentation, since I don’t want people focusing on my notes while I’m talking - I would much rather they listen carefully and take their own notes. Even so, sometimes there are processes or procedures that I need to show. When I don’t show it on the screen, I show it in the Notes view. If I’m using some other medium like a whiteboard, I usually blog the information and then show the link to my blog.

Practice

This is probably the most skipped step I see in new presenters. Yes, you have to sit in front of a mirror. Really. And yes, you have to say what you’re going to say, and time yourself. Really. It feel awkward, and it should. And you need to do this. Really.

I use the “Presenter View” in Power Point. It has the slides (so that you can see the next one coming), the Notes you made, and a timer. It’s a great tool even if you aren’t going to use Power Point in your talk.

But you have to practice. I try to practice my talk at least five times. Interestingly, this isn’t so I’ll say the same thing the same way every time. In fact, it’s quite the opposite. It helps me feel more confident in the information, and allows me to “wander” slightly during the talk and be more dynamic, because I know what I need to get across - I’ve practiced it.

Tuning And Feedback

If time permits, I try to deliver the talk at work or to my wife. I give the audience a feedback sheet with what I want to know, so that they will be critical without being mean. I try to do this with as many different audiences as I can. Based on what I hear back, I may adjust or tune a section to ensure that I get the information across.

So what’s on that sheet? Well, things like “How was the speed? Did it seem like I knew what I was talking about” and so on - but there’s one part that is pretty interesting. I give them a test. I make questions that I should answer during the talk, and at the end I hand out the paper and see if they get those answers. If they don’t it’s my fault. End of story. I either picked people that don’t care about the topic, or don’t listen, or who aren’t interested in helping me. All of those are my bad. If I do an effective presentation, I move the knowledge of the topic from my head to theirs. That’s success.

Speaking Schedule

If you’re interested in seeing the result of this preparation style, I ‘d love to have you join me. I enjoy meeting the folks that read this blog, so if you’re near any of these events then stop by and say hello!

09/23-24/2011 - Orlando, Florida

SQL Saturday 85 - http://www.sqlsaturday.com/85/eventhome.aspx

I have two presentations at this event:

SQL Server Performance Tuning Using Application Path Analysis

There are a lot of resources, products and features you can use to tune the performance of your SQL Server system. Many assume you’re familiar with 400-level concepts, others don’t consider the whole stack of the client, the network, the operating system, platform and the database server. Buck Woody, Microsoft’s real-world DBA, will explain a simple, repeatable process you can follow to tune your entire application – from the client to the server. All of the tools we’ll cover are included with Windows and SQL Server:

In this pre-conference session you’ll cover not only the process, but also review a real-world evaluation. You’ll take home a system and a spreadsheet you can use to monitor and tune your applications, in a simple, easy-to-understand session.

The Saturday event is:

Cloud Computing De-mystified

The cloud! Move everything to the cloud! No, wait, the cloud is awful! Don’t move anything to the cloud! Wait – what’s “the cloud”? Buck Woody, Microsoft’s “Real World DBA” will show you how to figure out where your data should live, based on actual decision points. You’ll learn about Windows and SQL Azure, and when it makes sense to put data locally or remotely.

10/08/2011 - Portland, Oregon

SQL Saturday 92 - http://www.sqlsaturday.com/92/eventhome.aspx

Hybrid Database Systems

With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work.

10/11-14/2011 - Seattle, Washington

Professional Association for SQL Server (PASS) Conference - http://www.sqlpass.org/Events/PASSSummit.aspx

Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications

Despite all the hype, it’s rare for a business to actually “move” an application directly to the cloud. The cost, risk and effort aren’t usually worth the benefit of what you gain. Security considerations, performance, and control are just a few of the reasons that many applications need to stay in your datacenter. But there are times when including a function from the cloud makes a ton of business sense, either to extend part of your internal applications to remote workers, customers or partners, or to act as a HA/DR solution.

In this session, Buck Woody (Microsoft Senior Technology Specialist on Distributed Computing) will talk about how you can embrace Cloud on Your Terms through SQL Server Code Name "Denali" and Windows and SQL Azure architectures, and the considerations for creating a hybrid architecture across on-premise databases and cloud technologies. You’ll learn:

How to create a decision matrix for which elements can be extended to the cloud

A Windows and SQL Azure technology overview, code name Juneau, and DAC Fx

Component options for hybrid solutions, including:

SharePoint

Biztalk

.NET applications

Non-Microsoft languages and technologies

Other RDBMS’s

You’ll receive references, whitepapers and other resources you can use to evaluate your own architectures to see how you can use a secure, high-performance system that expands and contracts as needed.

10/11/2011 - 12/14/2011 - Seattle, Washington

University of Washington - http://faculty.washington.edu/woodyg/

SQL Server Essentials

This course will introduce the student to Microsoft’s SQL Server database management system. Topics included are relational database concepts for production database applications, SQL programming, and SQL Server tools. This course will introduce advanced topics -- at an overview level -- that will be presented in more detail in subsequent courses. The course involves instruction, course studies, and a project that will be completed from requirements to delivery.

During the course you will design a relational database structure from a set of business requirements, developing a graphical Entity Relationship Diagram (ERD), writing Transact-SQL code for the creation of all database tables, views, stored procedures, security, indexes and maintenance scripts for a sample system. Your final project will be the entire system creation, delivered as a series of scripts, along with the ERD and pertinent conceptual documents in a SQL Server Management Studio (SSMS) Solution.

The Conundrum of Cloud Computing Evidence

BuckWoody — Tue, 26 Jul 2011 12:56:08 GMT

“Who is using Windows Azure? How are they doing it?”

I get asked this all the time as I speak to our clients when we mention Windows or SQL Azure as a possible solutions to an architectural problem the company has. I completely understand the question. I’ve worked far longer outside of Microsoft than here, and one of my roles as a Systems Architect was to select solutions from a range of possibilities. When you’re faced with a decision like that, it saves a ton of time if you can find out where others have done the same thing and what problems and successes they had with this or that approach. I’m not a marketing person, so I work with clients directly all the time, and so folks know I’ve seen the way others do things. And they want to know what someone else has done before they try it.

But therein lies the rub.

Most folks aren’t willing to talk about their internal infrastructure much. We talk about how we do things here at Microsoft quite frequently, and if you’re not using this resource, definitely go research what we’ve done. In fact, I don’t think I’ve seen many other technology companies with this depth of information. For instance, here’s a quick list of the areas we talk about on our internal systems:

Microsoft Desktop Optimization Pack

Office System

System Center

Windows

And yes, Azure as you can see is part of that list - we’ve implemented it everywhere. But when I point out that we’re using IT resources just like any other company, I hear “yeah, but you’re Microsoft. You have lots of people to handle the systems, and you can just have the developer who wrote the software come over and fix it if it breaks.” Well, that’s not the way it works at all. When I got here, I met with some folks from Microsoft IT, and I was absolutely shocked at how few people manage our systems. From Systems Administrators all the way to the DBA’s, the ratio of technical resource to machines is really extraordinary, and I had far more folks managing systems for me in my other companies than we have here. And no, we don’t send developers to fix production systems “just for us”, although we will do that when we are using a beta of something that we haven’t even released to CTP yet.

But even with this evidence of ourselves, clients want to “see how others are doing things with Azure”. We do have the customer evidence site, and we have lots of case-studies there. But many of these lack technical details, again, because folks aren’t always willing to share that. That’s understandable - for instance, even though Microsoft does it, I’m not sure I would have the Visio diagrams for my company’s applications posted in a public place. There may even be legal or competitive reasons not to do that. So as you peruse that list, keep in mind these are only the companies that are willing to talk in public about their experience - we have far more on Azure than this list.

J.D. Meiers has a good blog post entry of a rundown of the companies that have released case studies on Azure. And be assured that we have a patterns and practices group that works with the teams here at Azure to make sure we apply what we learn as we help each client. And many of our partners that you use to help you implement technology are here at Microsoft this week, sharing customer stories (with permission, of course), which allows us to learn from them on how you’re doing things - what works and what doesn’t.

As time goes on I think you’ll see more patterns emerge from the engagements we’ve done. Right now those are sometimes a competitive advantage, so you’ll see us generalize the patterns into content we can release. For now, check out those case studies, and do make use of the Internal Microsoft IT sites. They really are quite detailed, and have a lot of information you can use.

SQL Saturday 27 (Portland, Oregon)

BuckWoody — Mon, 24 May 2010 13:49:00 GMT

I’m sitting in the Seattle airport, waiting for my flight to Silicon Valley California for the SQL Server 2008 R2 Launch Event. By some quirk of nature, they are asking me to Emcee the event – but that’s another post entirely.

I’m reflecting on the SQL Saturday 27 event that was just held in Portland, Oregon this last Saturday. These are not Microsoft-sponsored events – it’s truly the community at work. Think of a big user-group meeting – I mean REALLY big – held in a central location, like at a college (as ours was) or some larger, inexpensive venue like that. Everyone there is volunteering – it’s my own money and time to drive several hours to a hotel for the night, feed myself and present. It’s their own time and money for the folks that organize the event – unless a vendor or two steps in to help. It’s their own time and money for the attendees to drive a long way, spend the night and their Saturday to listen to the speakers. Why do all this?

Because everybody benefits. Every speaker learns something new, meets new people, and reaches a new audience. Every volunteer does the same. And the attendees? Well, it’s pretty obvious what they get. A 7Am to 10PM extravaganza of knowledge from every corner of the product. In fact, this year the Portland group hooked up with the CodeCamp folks and held a combined event. We had over 850 people, and I had everyone from data professionals to developers in my sessions.

So I’ll take this opportunity to do two things: to say “thank you” to all of the folks who attended, from those who spoke to those who worked and those who came to listen, and to challenge you to attend the next SQL Saturday anywhere near you. You can find the list here: http://www.sqlsaturday.com/. Don’t see anything in your area? Start one! The PASS folks have a package that will show you how. Sure, it’s a big job, but the key is to get as many people helping you as possible. Even if you have only a few dozen folks show up the first time, no worries. The first events I presented at had about 20 in the room. But not this week.

See you at the Launch Event if you’re near the San Francisco area tomorrow, and see you at the Redmond SQL Saturday and TechEd if not.

How to get Microsoft to speak at your event

BuckWoody — Mon, 22 Feb 2010 14:35:36 GMT

If you’re holding a special event, such as a SQL Saturday or a user group, one of the challenges is to get speakers for the event. Now, the best speakers come from the community – people who use the product day-in, day-out. They have a wealth of expertise, and many of them are really great presenters.

But from time to time you might want to get a Microsoft person to speak at your group or event. Microsoft is a big company, and you can get everything from Marketing (yes, there’s a place for that) to deep technical topics in that skillset. But how can your group get Microsoft to speak for you?

It might be easier than you think.

Microsoft has three or four main areas that you might be able to pull from, starting with the folks that are closest to you: Sales.

Don’t make that face, there is sales and then there is sales. Within the sales team are four kinds of folks – your account manager, who owns the relationship between Microsoft and your company, the Sales professional, who owns the revenue and licensing for your account, the Account Technology Specialist (ATS) who knows about multiple Microsoft products, and the Technology Specialist (TSP or TS) that has a deep knowledge in a single technology, like SQL Server. These last two folks are the people who could deliver technical talks, especially around the newest products. And many of them are willing to do it. They are tied to a geographical area, so if your group has people in it that work at a company that is headquartered in that geography, the TSP and ATS might be willing to come out and chat with your group. And you might even want a Salesperson to come. Ever have a licensing briefing? Ever have questions? Ask them!

How to find them: Call your local Microsoft Office (the building, not the software). Find yours here: http://www.microsoft.com/worldwide/

The product group. If you live in the Redmond area, you should be coming to the PASS chapter monthly user group meetings here. It’s held at the Microsoft campus, it’s free, and it has a Microsoft product group member speaking just about every month. When I ran a user group for five years, it was impossible for me to get this kind of attention from the product group. It’s amazing.

Wait – you don’t live next to Microsoft? Not to worry. If you have a projector and a good set of speakers, the product teams can set up a LiveMeeting and present. I’ve done this several times myself.

How to find them: Twitter, Facebook, LinkedIn. Lurk on forums and see what the signature blocks say. Let’s see….oh, how about blogs like this one. You can find lots of blogs from Microsoft folks here: http://www.microsoft.com/sqlserver/2008/en/us/community.aspx

There are other groups at Microsoft that are willing to speak, and all you have to do is ask around. From “evangelists” to marketing, from training to even the documentation group, folks are out there that have really deep knowledge in just about every area of the product.

How to find them: TechEd, PASS and other conventions. Give them your card, get their e-mail addresses.

Here’s something to keep in mind: Microsoft works us pretty hard. In fact, sleep is really a luxury most of us aren’t granted; I think you get to do that when you’re a president or something. Maybe. So the folks you contact will be busy – really busy – just like you. I have traveled out of my district to present from time to time, but I have to take vacation time to do it, and Microsoft doesn’t pay my flight, hotel, food, anything like that. Any time we give you is “out of our own pocket”, so travel and late nights should be taken into account. So don’t abuse them, don’t always expect the invitation to be accepted. Most of us don’t get paid by Microsoft to do the extra presentations any more than you do, so keep that in mind and be polite and understanding. But do ask – most of us are really enthusiastic about this technology, and we love to help others learn, and to learn from the folks we meet.

The SQL Server Health Check

BuckWoody — Thu, 11 Feb 2010 14:16:05 GMT

My friend Brent Ozar, who is a top-notch SQL Server Professional, mentioned on his blog (http://www.brentozar.com/archive/2007/04/sql-server-health-check/comment-page-1/#comment-17520) that he brought in Microsoft Support to do a “Health Check”. There were some questions about what this actually entails – so I thought I would post that description here.

A SQL Server Health Check from Microsoft is an offering provided through our support and consulting branches. If you’ve purchased a Premier support agreement, you can use the hours you pay for to have someone come out and check out your systems using two basic vectors: standard best practices, and the best practices for your environment. Let me explain that a little further.

Microsoft Consulting Services (MCS) has an advanced set of tools and techniques to reach deep into your systems to evaluate them against a set of criteria that we establish for the best performance, safety and reliability for SQL Server. But your SQL Server Instances will be different than someone else’s, so the consultant will also spend some time in an interview with various teams to find out how you’re using the system. They’ll consult with experts in that area back at Redmond, and at the end of the engagement you get what I feel is the most valuable part of the exercise – the report. The report shows what was done, how it was done, what the findings are and what recommendations the consultant makes. It’s a thing of beauty.

You don’t have to have a Premier agreement to get a SQL Server Health Check, and companies other than Microsoft have versions of this as well. The prices vary, so if you want a Microsoft person then contact your local Microsoft office and ask for the Consulting Manager for your area. They will get you to the right person and you can work out the costs from there. If you take a hard look, most of the time the cost is well justified.

On a related note, I think it’s fantastic that Brent has the foresight to bring in “another pair of eyes” on his systems. Brent is actually in the program to gain a SQL Server “Master” certification – something only a few people in the world have. He works for a software development firm that creates fantastic products for – wait for it – SQL Server! He could evaluate his own systems, and of course he does. But he realizes that there’s always something more to learn, and someone out there may know one more little detail that he doesn’t. This is the mark of a very bright person.