Why go to a (technical) conference?

Conferences cost a lot of money.

Many are in the USD 2000-4000 range!  How can anyone afford that! No Budget! Boss doesn’t want me to take a week off!

Let’s turn that thinking around.

Is there something you saved for, worked hard for, and then bought? And that thing helped your life immensely?

In my life, it was a car. I lived out in the woods, away from employment and opportunity.  To get TO the opportunity, I had to get a car.  Having a car meant getting a chance at freedom and opportunity.

Once I had the car, I then could get to a job, where I could learn more and be trained. That earned more money, I then went to school, spent a LOT of money there, got trained, and got a better job! Rinse and repeat!

Rare today do we find ourselves in a job which allows us to grow with no training. Face it, many companies are short on training budgets, and they tend to want you to spend nothing.

In the free to minimal cost, I do have recommendations, such as Microsoft Virtual Academy and Pluralsight that have training.

One deficit with those options is interaction with peers, and the ability to get questions straight from the source.  That is where a conference can help.

I spent a full week in Seattle recently at an internal conference.

Many of the same actors at this conference present the top tracks at Microsoft public conferences such as Ignite or Build!

My SQL and Data Platform people will of course tout, rightly so, PASS Summit, put on by the Professional Association for SQL Server.

I know of friends who also put on the IT/Dev Connections conference, and there are smaller ones as well.  I mention this one, because I attended IT connections in 2005, met the great Kimberly Tripp, and it inspired me that SQL Server could be FUN and I could do a lot with it.

A few years after attending that conference, with some experience mixed in, I am a technical seller at Microsoft! I also speak at smaller venues, and had the privilege of speaking at our internal technical conference last year!

Why go to a conference?

You will learn a lot, you will meet the experts, and you can take that knowledge and networking with others to help you move forward and up in your career.

It helped me. It can help you. And later on, you can then help others.  That is the best reward.

Thank you!

Posted in Conferences, Data | Tagged , , , , , , , | Leave a comment

Oh No! I need to learn Azure!

Some of you out there are either too busy to ramp up, or too fearful of prodding your company’s IT department with a cloud strategy.  Maybe you recently got offered a job at Microsoft!  Note: We’re hiring!

As part of Microsoft’s technical sales force, we were advised to ramp up on Azure, and to get certified.  This is not news: In 2007, Microsoft required technical sales people to get certified.

To ramp up quickly on Azure, I took the road of self-study.  Microsoft virtual academy has wonderful video courses, with quizzes, to help teach you.

I also worked through a few virtual online labs, to gain some hands-on experience.

At the end of that, I took the 70-534 Azure architecture exam and passed!

More courses are coming out as the cloud and our on-premises products keep evolving.

Take this moment to act, and take some small amount of time each day to nibble through this training.  You will be better prepared when the time comes to know it.

Once you do the above training, get a trial of Azure to play hands-on!

As always, feel free to reach out to me on twitter!

 

 

Posted in Azure | Leave a comment

The time has come, SQL 2005

It’s time we sat down and had a chat, people.

SQL Server 2005.  You run it? Your company runs it?  It’s over 10 years old.  If this is on top of Windows 2003, that is already out of date.

Microsoft has published its timelines for software support lifecycles here.  SQL 2005’s end of life is April 12, 2016.

One of the important things as an IT professional, is to reduce risk in your environment.  Running 10 plus year old software should, in this day and age, be considered a risk.

Modern hardware, and modern applications do demand more from our software.  Also, the security vectors that hackers exploit have changed a lot over time.

Microsoft’s SQL Server team published a good blog with reasons for migration, and with links to various tools that can help you.

To help you get started around SQL 2005, Microsoft has published a few videos, specific to SQL 2005 and express, around how to upgrade.

To get educated around what SQL 2014 offers, follow this playlist.

Maybe you need a one page list of what has changed? This is a list of changes from 2012 to 2014, 2008r2 to 2014, 2008 to 2014, and 2005 to 2014.

Suffice it to say, there has been a lot of improvements.  Spin up some test machines, and run through upgrades before it is time to cut over.

Feel free to reach out to me on LinkedIn or Twitter to discuss this further!

 

 

 

Posted in Uncategorized | Leave a comment

Minecraft on Azure!

Who needs a minecraft server? You do! On Azure!

Yes, we had our own minecraft server in-house a couple years ago. My wife and I enjoyed playing minecraft with our son and his friends on it!
When that PC died, minecraft was neglected.  I decided we should do something different than a pc box burning electricity in our house.
Many gallery images of virtual machines are in Azure, ready for fast deployment.

Continue reading

Posted in Fun | Leave a comment

Infrastucture for Data Science, intended for the data professional

Data science is the hot topic nowadays.  Customers are looking to get more value out of their data.  This world includes a large skillset that may not intersect with more traditional relational databases.

The world of data science has now intersected squarely with the Microsoft data platform.  The first example I can think of recently is Machine Learning Studio in Azure.  This is a web based area for building and testing machine learning models.

Recently, Microsoft acquired Revolution Analytics, who develop robust tools for the open-source R language.  R is one of the languages that work inside of Azure Machine Learning.  This language will be integrated into SQL Server 2016 when it releases.

In my role with Microsoft, I need to articulate the newer features that exist, or are coming, with the Microsoft Data Platform.  How do I bridge that gap, understand our offerings, and how can you gain hands-on experience with these new tools?

Within our Azure platform, we have a premade virtual machine released recently, called the Microsoft Data Science Virtual Machine.

Inside of this virtual machine you can find the following tools, ready to use:

  • Revolution R Open
  • Anaconda Python distribution
  • Visual Studio Community Edition
  • Power BI desktop
  • SQL Server Express edition
  • Azure SDK

I encourage you to spin this environment up in Azure, and play around.

Let me know what you think of this, and where you feel Data Science will land in your data world.

Thank you!

Posted in Data | Tagged , , , , | Leave a comment

A community for Boston’s Microsoft, SQL, and Azure technologists

The greater Boston, Massachusetts area is rich in technology and people.

The technology space I have been involved with for around 18 years is Microsoft, SQL Server, and Windows.  In recent years, Azure has been added, and advanced analytics as well.

I have had the pleasure of getting more involved in these groups, and I will testify to the friendly nature of the people involved.  Technology does not have to be a scary thing to get involved with!

One question I get from customers is, “Where can I go to learn more about SQL Server and Azure?”

Fortunately, we have a wonderful set of communities full of experts, who volunteer their time to share knowledge.  Both technical and nontechnical people should consider attending to better the understanding and skills in these areas.

Here is my short list for SQL Server, Business Intelligence, Windows, and Azure within Boston and Cambridge MA.

The SQL Users group in Boston meets in the Microsoft Office at 255 Main street, Cambridge, MA:

http://www.meetup.com/NESQLUG/

The Boston Azure users group meets at Microsoft’s 1 Memorial Drive, Cambridge, MA community area.

http://www.meetup.com/bostonazure/

The Windows users group meets in the Microsoft Office at 255 Main street, Cambridge, MA:

http://www.meetup.com/WindowsBoston/

The Boston BI group meets in the Microsoft Office at 255 Main street, Cambridge, MA:

http://www.meetup.com/Boston-Business-Intelligence/

Further out, in Rhode Island are two great Microsoft SQL Server and Business Intelligence groups:

The Rhode Island Business Intelligence User Group meets at Bryant University in Smithfield, RI:

http://www.meetup.com/The-RI-Microsoft-BIUG/

The Rhode Island SQL Users Group meets in East Greenwich, RI:

http://www.meetup.com/Rhode-Island-SQL-Server-Users-Group/

I welcome comments for your own favorite user groups.  Thank you!

Posted in Data | Leave a comment

Getting Started with Relational Databases

Are you in the mood to learn more about data? Perhaps you’re a server or desktop admin, but the DBA seems to have a cool job? Do you want to get connected to the data your company uses?

Why do companies care about that data? They care because we are moving to a data-driven economy.

Good data can help companies earn more, and understand their customers better, if used properly. The skills needed to handle this data tend to start with storage and maintaining that valuable data.

To break into the field, perhaps start with some of these courses on Microsoft Virtual Academy. They will help you understand the concepts, see some of the work in action, and help you decide to go further.

To help you decide where to start: SQL Server is rated the top operational database system as rated by Gartner, a highly respected research firm.

Anything you learn in the following courses can generally be applied to other relational database systems. So let’s get you started!

Database Fundamentals

https://mva.microsoft.com/en-US/training-courses/database-fundamentals-8243

How to query with Transact-SQL (The language used to get and push data into Microsoft SQL Server)

https://mva.microsoft.com/en-US/training-courses/querying-with-transact-sql-10530?l=TjT07f87_9804984382

Administering Microsoft SQL Server 2012 Jump Start

https://mva.microsoft.com/en-us/training-courses/administering-microsoft-sql-server-2012-jump-start-8259

Posted in Data | Leave a comment