May 2015 SQL Server Speaker of the Month

I was honored this morning to see that I was selected by Grant Fritchey ( blog | twitter) as the Speaker of the Month for May 2015.  It feels great to be

May 2015 Speaker of the Month

May 2015 Speaker of the Month

acknowledged by your peers.  Some people might think I am crazy to spend my own money on travel to deliver 30 SQL Server sessions over the past year and they might be right. With that said, every time I attend SQL Saturdays, Virtual Chapters, and User Group meetings I always learn something. I am blessed to be in a community that gives me the opportunity to connect, share and learn.

The following are some upcoming speaking engagements. If you are attending any of these events I look forward to seeing you.

Kansas City Developers Conference
IT/Dev Connection
Austin SQL Server User Group
SQL Saturday Pittsburgh (Assuming I get Selected)

 

 

Converting identifiers into SQL Server table variables in Management Studio

If I had a nickel for every time someone gave me a list of identifiers and asked me to pull a result set for them I would be a very wealthy man. Over the years this is an endless request. I used to use several different tools like excel for example to convert the list of identifiers into SQL Statements. I would then use set based logic to complete my task inside SQL Server.

Being a SQL Server Database Administrator I like to use one consistent tool for working with queries. One day I noticed an interesting feature inside of the search and replace functionality inside Management Studio. I could utilize regular expression as a tool in my tool belt for manipulating text inside of SQL Server Management Studio. This gave me the functionality to stay within my preferred tool for doing SQL Server development work.

If you want to see how you can quickly manipulate the identifiers and convert them into table variable check out the three minute video below.

Microsoft BI Days in Texas (Recap)

This week I had the pleasure to join  Mark Moore my local SQL Server TSP in Austin to deliver two separate events in Austin and San Antonio to help get people up to speed on some of the Self-Service BI tools included in the Microsoft stack. I had a great time connecting, sharing and learning with new friends.

The following are some links I wanted to share on PowerBI and PowerPivot that I talked about during my session.

PowerPivot for DBAs (Slide Deck) -> http://johnsterrett.com/presentations/powerpivot-for-dbas/

Dallas BI Edition SQL Saturday on May 2nd ->https://www.sqlsaturday.com/396/eventhome.aspx

Channel 9 PowerPivot Free Videos -> https://channel9.msdn.com/Search?term=PowerPivot#ch9Search

Channel 9 PowerBI Free Videos -> https://channel9.msdn.com/Search?term=PowerBI#ch9Search&lang-en=en

SQLPASS Virtual Chapters -> http://www.sqlpass.org/PASSChapters/VirtualChapters.aspx

Business Analytics Virtual Chapter -> http://bavc.sqlpass.org/

Business Intelligence Virtual Chapter -> http://bi.sqlpass.org/

Austin SQL Server User Group -> http://cactuss.org/

San Antonio SQL Server User Group -> http://www.salssa.com/

Outstanding PASS Volunteer Award

I am a Outstanding PASS Volunteer!

I am a Outstanding PASS Volunteer!

It is an honor to receive the Outstanding PASS Volunteer Award for February 2015.  It means a lot to be nominated for this award from my peers. My single goal last year was to bring SQL Saturday back to Austin. On January 31st 2015 we had a great day that allowed 280 people the chance to connect, share and learn.  It would have never happened without these key individuals who spent a lot of time helping make the SQL Saturday happen. Thank you Steve Ormrod, Richard Heim, Mike Burek, Jim Murphy and AJ Mendo.

Free Video for Accidental DBA’s

Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills that are necessary for accidental DBA’s to master to become DBA’s with a successful long lasting career.

I wish I had all this advice when I started as a SQL Server DBA.

Resources:

All Resources mentioned in the video to complete the tasks discussed can be found at http://linchpinpeople.com/where

Video

You’re a DBA… Now What?

One of my goals for the year is to do great things with great people.  I will be making my first step at achieving this goal today.  Speaking of firsts, I will also be doing my first vendor focused webinar at the same time. Thank you Embarcadero!

Congratulations, You're A DBA.. Now What?

Today, February 11th 2015 at 1pm CST I will be doing a webinar with my friend Mike Walsh titled “Congratulations, You’re a DBA… Now What?”  If you are a Jr. DBA or even a DBA with just a few years of experience I would highly recommend attending this session.  I look forward to seeing you there!

Extended Event Security Permissions

Recently, I gave my first presentation of the year at Austin .NET User Group on Writing Faster Queries and I got a great question about Extended Events. The question was, “What security permissions are required for creating and modifying Extended Event Sessions?”  I thought it would make a great blog post as I am sure others might be wondering the same thing.

In SQL Server 2008 to create an Extended Event Session you are going to need CONTROL SERVER  and  ALTER ANY EVENT SESSION permission on the instance that you need Extended Events created on. With SQL Server 2012 and 2014 If you want to create and modify Extended Events you are only going to need ALTER ANY EVENT SESSION.

If you like this post check out these other related blog posts:

Austin .NET SQL User Group Presentation

Thank you to everyone who made it out to the first Austin .NET User Group

Austin .NET User Group

Austin .NET User Group

Presentation in 2015. This also was my first of many presentation I plan on delivering in 2015. As promised I have uploaded the slide deck, code example and the Power Point for my session titled, “Making Your SQL Server Queries Run Faster.”

Building Your First Windows Azure Machine

image

Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted out on SQLAuthority.com. This tip was my first one working with Azure.  To me its remarkable how quickly you can spin up an instance to help you build out a proof of concept. In this tip I show you how you can build your very first windows azure box.

Proof of Concepts with Windows Azure

 

Upcoming Presentations

It’s an honor to always be able to give back to the SQL Server Community. I would never be where I am today with out others helping me along the way.  I look forward connecting and sharing with everyone at the following events.