Archive for April, 2010

Microsoft Thrive: IT Pro of the Month!

It’s no secret that IT professionals and their organizations have been significantly affected by the downturn in the economy.  Those of us that have been through the so-called “dot-com” days can see how much things can change within a few years.  Fortunately, at least some companies are developing resources to help IT professionals weather the downturn.  I’d go a bit further in saying that these otherwise dismal times can provide significant opportunities for those that are willing to invest in their skills and their profession.

MicrosoftThriveThe Microsoft Thrive web site is a free resource that is designed to help IT professionals in a variety of ways.  For example, the site includes the following goals and areas:

  • Advance Your Career
  • Enhance Your Technical Skills
  • Align IT with Business

Some of the content is Microsoft-focused, but much of it applies to just about any area of IT specialization.

I’m honored to say that I’ve been chosen as the Thrive IT Pro of the Month (see Thrive IT Pro of the Month: Anil Desai)!  I recorded a brief (~9 minutes long) presentation that covers, among other things, some recommendations for IT pros to get ahead, how IT pros can demonstrate their value, details on technology-focused topics and even a mention of the importance of hobbies.

The entire audio presentation is available from download using the previous link.  Here’s an excerpt from the written transcript:

As an independent consultant, I’m fairly diversified in the area of IT. I’m also used to the ups and downs in the IT industry, starting from the dot-com days in the late 1990’s to today. I use a variety of different specializations to fill in the inevitable downtime between projects. So, I’m fairly fortunate in that I’ve been able to maintain my business through the recent crunch.

However, the downturn in the economy has certainly had an impact on my clients, especially in the area of prioritization. Many organizations have focused on cost-cutting and many organizations have removed or scaled-back many of their non-essential projects. Those changes can sometimes translate into lay-offs, increased work for remaining staff, and short-term changes at the expense of long-term gains.

All of this provides some serious challenges (as well as some opportunities) for IT professionals. One change is that it really puts the emphasis on IT professionals’ ability to work as a strategic part of their businesses. I’ve heard it said that people know when IT departments are doing their jobs when they don’t know that IT departments are doing their jobs. The idea here is that IT is traditionally seen as a behind-the-scenes force (or sometimes just as a cost center). Business leaders might feel that IT provides little strategic value to the overall business.

Tough economic environments bring this issue to the forefront: IT professionals must understand overall business goals and must be able to apply the right technical solutions to solve business problems. And, they need to demonstrate their value within and outside of their IT groups. For those IT pros that have been able to focus on just the technical aspects of their skillset, this is a good time to branch out into the rest of the business world.

Feel free to e-mail me if you’d like the entire transcript.  And please post here if you have any questions, comments, or recommendations for your IT peers.

SQL Saturday in Dallas: May 22, 2010

SQLSaturday SQL Saturday is a series of free single-day conferences that’s being held throughout the United States.  Here’s some basic information about the conference from the web site:

We started SQLSaturday in 2007 as a platform for free one day training events for SQL Server professionals. We focus on local speakers, providing a good variety of topics, and making it all happen through the efforts of volunteers. Whether you’re attending one or thinking about hosting your own, we think you’ll find it’s a great way to spend a Saturday.

Events are currently scheduled through October, 2010 (see the site for details on dates and locations).  Also, if you’re interested in speaking at one of the events, be sure to submit your session early.

I’ll be presenting two SQL Server sessions (details below) at SQL Saturday Dallas 2010.  As of this writing, it looks like there are nearly 500 registered attendees.  It should be a great event!

SQL Server Basics for non-DBAs

Despite the importance and value of relational databases, many developers and administrators often have only a basic understanding of how they work.  This session covers the basic architecture of SQL Server, including basic installation and configuration of the server.  The focus will be an overview of the most important topics, including: Managing database storage, performing regular database maintenance, managing security and data protection.  Finally, we’ll conclude with some best practices for managing database schemas and objects.  Attendees are encouraged to bring their server and database management questions.

Reporting Services: Development and Deployment

This session will begin with a brief architectural overview of Reporting Services and details on getting up and running with Reporting Services.  Then, we will look at demonstrations of creating new reports by building connections and data sets using Report Builder and Visual Studio.  Reporting design features including parameterization, dynamic drill-downs, matrix reports, charts, and sorting will be provided. 

MVP Award for 2010

MVP-verticalI’m happy to report that I have again received the Microsoft MVP Award in the area of “Windows Server – Virtualization”!  Thanks to everyone at Microsoft for the recognition and the excellent benefits that are part of the program.

For more details, please visit Anil Desai’s MVP Profile page.  It includes links to my upcoming events, presentations, publications, and related details.  The MVP web site is also a great place to search if you’re looking for an IT pro with a specific area of expertise.

Austin CodeCamp 2010: May 15, 2010

The Austin .NET User Group (ADNUG) is holding it’s free, annual technical event in mid-May.  Austin Code Camp 2010 will include dozens of technical sessions that are focused on programming methodology (such as Test-Driven Development) and practices.  Here’s some basic info from the conference web site:

The Austin .Net User Group is proud to sponsor it’s fourth Annual Code Camp

This is one day FREE conference For The Community, By the community.

The Conference is on May 15, 2010 at St Edward’s Professional Education Center from 8 am to 5 pm. Click the link on the Location Tab for additional information about St Edward’s.

If you’re planning to attend, please be sure to use the site’s Session Voting page.  This will give organizers and speakers some help in planning room assignments and will help speakers tailor their presentations for audience size.

I’ll also be presenting two sessions at this year’s event.  Below are the details.  Feel free to respond here if you have any questions or comments on the topics, and I hope to see you there!

SQL Server Reporting Services: Develop & Deploy Reports

This session will begin with a brief architectural overview of Reporting Services and details on getting up and running with Reporting Services. Then, we will look at demonstrations of creating new reports by building connections and data sets using Report Builder and Visual Studio. Reporting design features including parametrization, dynamic drill-downs, matrix reports, charts, and sorting will be provided.

Next, we’ll look at deployment details, including scheduling reports, configuring caching, creating snapshots, and managing security. Time permitting, the presentation will include a demonstration of using Report Viewer controls within ASP.NET and Windows Forms applications. The session is intended for developers that have basic familiarity with report development (in any technology) and a basic understanding of SQL.

Practical SQL Server Performance Monitoring & Optimization

Developers can dramatically improve performance by monitoring and analyzing real world queries. This session covers SQL Server monitoring at various levels to the most impactful performance improvements. The presentation will start with an overview of different optimization tools and techniques and will be based on practical examples of real-world performance monitoring and troubleshooting. Details include the use of server monitoring tools, SQL Profiler, the Database Tuning Advisor, and analyzing query plans, Dynamic Management Views, and related methods. The overall emphasis will be on solving practical, real-world database performance problems.

This session assumes that attendees have basic familiarity with SQL Server and with writing database queries.