How to Tell When SQL Server Started?

finger_trap_2010_04_28.jpg

As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to me by the client. They don’t mean any harm, but different people in the organization have different perspectives and different memories. Sometimes it is difficult to know what is really happening.

When I’m working with systems like SQL Server, it is always good to gather as much information from the system itself as I can and not rely too heavily on someone else’s memory. Trust but verify as President Ronald Reagan once said.

When was the server restarted?

SQL Server maintains a lot of information about how it’s doing and when certain events ocurred. Much of this information resides in the Dynamic Management Views (DMVs) of SQL Server 2005 and 2008.

For example, let’s say we want to know when the SQL Server instance was last restarted. When can easily collect this information using a quick query. There are several other methods as well but this one is my preferred way.

SELECT
Login_Time
FROM
sys.dm_exec_sessions
WHERE
Session_Id = 1;

server_restart_dmv.jpg

Additional Resources

SQL Server Books Online has more information about this and other DMVs. Additionally there are some other great resources on the web.

And there are many, many more. Just use your favorite search engine and begin using the DMVs to make your job a little easier.

Question:

  • What’s your favorite DMV?

Consulting and the MBA

The year is 1991. Nirvana’s Smells like teen spirit is the must-have album of the year. And everyone who is anyone has seen Silence of the Lambs.

It’s the economy, stupid.” is getting more airplay than The New Kids on the Block.

And although it doesn’t seem like that long ago to me, 1991 is the year I graduated from college with a degree in Electrical Engineering. It’s also the year that I decided to postpone my entrance into the real world for a while longer.

Getting an MBA

I decided to go straight through and get a Masters in Business Administration (MBA). I reasoned that an MBA would be good for me in the long run and there’s no better time than the present to do it. So I went through the application process and dove in.

calculus_2010_04_21.jpg

A recipe for a headache

Coming from an engineering background with ump-teen advanced mathematics classes under my belt, I was accustomed to equations with more Greek letters than English numbers. So naturally I thought accounting would be a piece of cake. After all, it’s just adding and subtracting, right. How hard could counting beans really be? Ha! Was I wrong!

The same could be said for some of the other classes as well. In the MBA program I had to learn a whole new way to study. Gone were the days of learning to solve types of problems and receiving partial credit for my work. The new curriculum required a new way of learning. I adjusted pretty quickly though and did well.

After taking some heavy loads in an accelerated program, I graduated from the program in 1992.

Fancy Wall Paper

Now, fast forward almost twenty years. Has having an MBA helped me in my journey? Would I do it again? I get asked that question from time to time.

It may surprise you to hear me say this, but frankly in the days since I graduated, just having an MBA hasn’t really helped me all that much. It’ll really surprise my parents, who supported me financially, emotionally, and spiritually during my college years. But given the path I’ve chosen, it’s true.

Perhaps if I’d have joined a large company with a tall corporate ladder that has many rungs on the way to the top, having an MBA to frame and hang on the wall behind my desk would have mattered more. Maybe it would have gotten me promoted faster than my peers. I’d hope so, but I don’t know.

Instead I’ve chosen for the past fifteen years to run my own small business. So there isn’t really anyone to impress with a piece of paper on the wall.

But that’s not to say that my time in the MBA program was a wasted effort. Not at all!

The Value of an MBA

The knowledge and skills I gained while going through the MBA program have been invaluable to me as I’ve managed my own company and as I’ve served in volunteer roles for organizations.

Although I didn’t truly appreciate it at the time, classes in organizational behavior, marketing, corporate finance, and yes even accounting, have helped me tremendously over the years.

Whether I was serving as Executive Vice President of PASS or on the Budget Committee of my local church, having a good understanding of business administration has helped me to appreciate more, understand more, and contribute more.

This is especially true for technical consultants. We, on the whole, tend to focus on technical skills while almost ignoring the non-technical side of things. We increase our technical prowess while neglecting the soft skills and business acumen. When we do this, we do ourselves and our clients a huge disservice.

If you’re a consultant considering an MBA for purely the destination, that is if you’re looking to get an MBA just so that you’ll have an MBA, then you’re missing the point. Just having an MBA may help somewhat in the corporate world, but that perspective is still short-sighted.

It’s not about the paper on the wall; it’s about what you learn while earning the piece of paper. It’s about the journey, not the destination.

So, was it worth it? Absolutely. Would I do it again? You bet.

Giving Back

LunchWithAubie.jpg

Lunch with Aubie at a recent Board meeting

This is one of the reasons I enjoy giving back to the MBA program that taught me so much.

The College of Business regularly seeks input and feedback for how to make the program better and for the past three years, I’ve served on the MBA Advisory Board for Auburn University. We provide real-world insight and perspective that the program can use to adapt to the changing world.

And it’s worked. In the years since I’ve graduated, many good changes have been made to even further enhance the curriculum of the MBA program. I’m glad to see that happening.

And I’m glad to contribute.

Book Review: Crush It!


41kI+CJCGGL._SL160_.jpg
Not long ago, I read a review of Gary Vaynerchuk’s book, Crush It! The reviewer, Michael Hyatt (Twitter | Blog), liked the book so much that after listening to the audio version, he bought the printed version so he could read it and make notes. This is significant because Michael Hyatt knows a good book when he reads it. He’s the CEO of Thomas Nelson and this is not one of Thomas Nelson’s books. As a regular reader of Michael Hyatt’s blog I thought “If he likes it, I’ll probably like it.” So I bought the book.

As I began reading the book, my expectations were high. In addition to Hyatt’s glowing recommendation, the subject of the book is right up my alley, so to speak. Although I had initially resisted getting involved with social networking sites such as FaceBook and Twitter, over the past couple of years I’ve come to embrace the concept.

We Need to Talk

One of the first things many people tend to think of when asked about social media is the amount of time you can easily spend just idly chatting away with friends from around the world. And that’s certainly true. You can waste a lot of time doing that if you are not careful. But in moderation, a bit of water cooler type conversation can be healthy, particularly for those of us who regularly work from a home office.

But despite the potential time sink that these social networking sites can become, I believe that they can be of great benefit when used properly.

On many occasions, I’ve used Twitter to help SQL Server professionals from around the world who have reached out to the SQL community 140 characters at a time. I’ve even hooked up a PowerPoint slide deck to my Twitter account to have it automatically tweet key points during presentations I’ve delivered at conferences and user groups.

And it’s a two-way street; I’ve learned a ton from following Twitter conversations from the likes of Paul Randal (@PaulRandal), Buck Woody (@BuckWoody), Brent Ozar (@BrentO), Jonathan Kehayias (@SQLSarg), and Aaron Bertrand(@AaronBertrand) to name but a few.

It’s Social Networking with a Purpose

And that is Gary Vaynerchuk’s point. When used with intention and focus, social networking sites can be used to find and generate interest about most anything your passionate about.

In Crush It!, he proposes that anyone with “hustle” can take something they are passionate about and turn that into a revenue generating business using social networking sites and blogs. He outlines a pretty straightforward approach. In short (and I’m doing a bit of a disservice by distilling the book down to just these five points):

  1. Find something you are passionate about.
  2. Create a blog about it (audio podcasts, videos, or the written word.)
  3. Generate good content daily.
  4. Promote it by participating in the social networks.
  5. And finally monetize your blog through advertizing.

He doesn’t suggest that this is easy. In fact he repeatedly writes that this will be a lot of hard work and long hours.

A Good Primer

Gary Vaynerchuk comes across as a very dynamic individual with a big personality. He shares some of his background and how he created a very popular wine tasting site with lots and lots of visits each day.

The book starts out by outlining how social networking has changed the way business is done, how it levels the playing field for small businesses with limited promotional budgets.

He then lays out the five points that I’ve already mentioned, encouraging the reader with each step.

The book also provides some specifics about which online services will help you to more easily spread your reach. For instance, Ping.fm, will automatically distribute your status updates to a multitude of different social networking sites, eliminating the need to update each one individually. The same exists for video blogs as well.

Parting Thoughts

Overall, I enjoyed reading the book and would recommend it. It was a short and easy read and really reinforced some of the concepts I had already learned from other sources on the internet. If you’re just getting started with social networks or you have a penchant for starting an online business, this book is well work its cost.

But to provide an honest and complete review, I’ll share a few minor negatives I had with the book.

Unfortunately in my case, my prior experience with social networks combined with my high expectations for the book left me wanting more. The book was very much premised on how Gary Vaynerchuk built his successful wine tasting site and didn’t explore other related topics.

For example the book did not touch on how to balance being personable in your online approach with staying focused and on subject. It also didn’t consider ways to monetizing your social networking without advertising. And finally I didn’t discuss how and when to create multiple online accounts for specific purposes.

At times during the book Gary Vaynerchuk came across like many of the late night paid advertising shows. “Using my system, you too can make $218,000 a month and live the life you deserve.” (That’s not an actual quote from the book by the way.)

Now some questions for you:

  • Have you read the book? If so, what are your impressions?
  • What other social networking resources have your found worthwhile?

Data-Driven Subscriptions at OPASS

ledger_notes.jpg

Six months ago, I spoke at a SQLSaturday in Orlando, Florida. I had a great time. Andy Warren (Blog | Twitter), Jack Corbett (blog | Twitter), and the rest of the team from the Orlando SQL Server User Group, OPASS, did a great job putting together a fantastic event. My hat’s off to them for the effort and results. And I’m glad to see that they’re already working on this year’s event.

And speaking of Orlando, next Tuesday, the 13th of April 2010, I’ll speak at the OPASS User Group meeting. I’m delivering a session on Reporting Services. Here’s the abstract.

Creating Data-Driven Subscriptions in SQL Server Reporting Services

Providing information to those that need it when they need it is key for many businesses. But, being able to automatically disseminate critical information in a timely fashion can be a challenge. In this session, we will discover how data-driven subscriptions in SQL Server Reporting Services can be used to effectively deliver reports to a varying list of subscribers.

You can join me from the comfort of your own living room via LiveMeeting. We’ll start at 6:45 EDT.

Follow

Get every new post delivered to your Inbox.