Category Archives: SQL Server

PASS Summit Live Keynote – Release 3

pass_2016_website

 

Justin Silver, Scientist Pros, takes the stage……

Taking data science out of the lab settings and placing it into real world scenarios.

Azure has tremendously been able to allow enhanced functionality into the realm of data science bridging the gap 100x faster with SQL Server 2016.

Microsoft is the only vendor that has the depth and breathe to handle the capacity the Pros company needs in order to succeed.


Sneak preview after Just leaves the stage……HTAP solution scaled out.

What can we do to solve a data visualization problem within SQL server and how can we expand its capabilities. SQL Server 2016 shipped with Polybase to  help provide this type of solution….the always on functionality can replicate 10 times the data from where we were in the past.


Intelligent Database Service – machine learning to capture behaviors for intelligent capabilities.

Better together with Windows Server – unparalleled SMP capability

_________________________________________________________________

Yes folks…just saw a restore onto SQL Server running on Linux…..installed SQL; restored backup from windows…..keeps getting better.

22,000+ registrations >50% of fortune 500

 

 

PASS Summit 2016 – Live Keynote

pass_2016_website

Good morning from PASS Summit 2016!

Today will be the first keynote session at 8:15 a.m. with Joseph Sirosh. I’ve found myself back at the bloggers table this year during the keynotes so check back here for updates and highlights.

In addition to these updates (plan on sending 4-5 mass live updates throughout the keynote) I will also be live tweeting with the hashtag #SQLSummit.

Have a great day and enjoy the time we have here.

T-SQL Tuesday #83: We’re still dealing with the same problems

tsql2sday-300x300It’s about time I got back into participating in the T-SQL Tuesday block parties that are hosted by community members each month. First, let’s take care of some house keeping rules.

Who Is Hosting?

This month Andy Mallon (b|t) is hosting and has chosen a topic of We’re still dealing with the same problems. This topic can have very many avenues to go down; with that said Andy….great topic sir. I suggest you stop by Andy’s blog when you get a chance; he has some great posts along with Shortcut’s Cheat Sheet that I ran across the other day.

So what are some of the same problems?

Again, we can take this path down several different roads. We can get extremely technical or we can get extremely general. For the sake of time and having you in mind as I type I may sprinkle a little of both into this post.

Professional Level

From all different levels of a database professional’s life one can see repetitive things being done:

  • Resume fluff – by this I mean interviewees having a little to much fluff on the resume that has to be weeded out.
  • Dev/DBA/Infrastructure – do I need to expound? The age old silos that are often built with blame moving to and from each unit.
  • Overworked personnel – being in management my team is key. It’s time to look at the people as that, people, and not just a number.
  • Routines – we all get stuck in a routine at times; how do we get ourselves out of so called “ruts” and light the fire that we once had?
  • Meetings – this topic can have its own blog and how to handle them. These are important in some cases and in some cases they aren’t, but the fact remains I still see a lot of shops with an endless supply of meetings.

SQL Level

Up next are the SQL scenarios I still see as ongoing battles:

  • Max Memory Setting – when installing SQL please check this setting.
  • SA – every vendor wants SA for their app; it’s how the world goes round.
  • Backups – yes I take backups….that is great news; have you ever restored any? Nope…..you see where I’m going with this.
  • Trace Flags – I see a lot of people not taking advantages of these across all SQL platforms.
  • SQL Versions – a lot of shops are not keeping up to date with their SQL versioning as often as they should.

Automation

You may ask why I put this topic in a section all by itself? I learned earlier on from John Sansom (b|t) that automation is key to becoming a successful DBA. I don’t see enough of it really? There are a lot of new tools and methods that are available to data professionals that, if taken the time, can be set up to automate a lot of the mundane tasks I see small to medium shops experiencing. Heck, even some bigger shops still struggle with the art of automation.

Professional Development

Anyone who knows me knows I like to challenge myself. Each and every person has their own set of goals and desires as they move through life and no one else can define that. I see over and over again where we tell people that they need to do this and need to do that. No, I’m not talking about mentoring or leadership. Those are separate entities; this section is meant to encourage the readers of this post that you control where you want to go in your career and not the other way around. Some knew technology comes out and you want to learn it then go for it.

What Is T-SQL Tuesday Anyway?

Well, I’m glad you asked. Adam Machanic (b|t) started this party about (I’m approximating here) 7-8 yrs ago. Each month a new blogger is chosen to host the party and they in turn get to pick the topic. If you blog about SQL and have been keeping up to date with it for a while now then drop Adam a line and let him know you are interested.

Conclusion

As you can see there are still items that occur all around us on a daily basis in the same manner. I challenge you to see, if what, can be changed. Where can you make a difference? Time to get after it ~ Let’s Roll.

Thanks Andy for taking the time out of your day to host this month.

SQL Sentry Does It Again–Plan Explorer 3.0

planexplorer-logo-300x78Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry on upcoming changes around their product.

In case you missed this news you can check out Greg Gonzalez’s (B|T) post at http://blogs.sqlsentry.com/greggonzalez/plan-explorer-pro-goes-free/

So, what does this mean for you, the readers and community members?

  • All features are completely FREE
  • There is one SKU now
  • Registration is still not required ( I’ll give you an added hint here; if you register there are some other benefits, so why not?)
  • You ready for this one – – two powerful features have been included in Plan Explorer 3.0:
    • Index Analysis
    • Performance Profiling

Now, for an added benefit SQL Sentry’s very own Aaron Bertrand (B|T) will be hosting a webinar on Friday, September 9th at 11:00 a.m. EDT. You can register for this webinar at https://attendee.gotowebinar.com/register/6543832890155002369

Why Plan Explorer?

I can tell you from personal experience that having Plan Explorer in your tool belt gives the data professional some added fire power on a daily basis. For a full listing of these features check out http://www.sqlsentry.com/products/plan-explorer/sql-server-query-view and see for yourself what you are missing.

My Favorite Features

One of my favorite features is the SSMS add-in; however there are several more features that might tickle your fancy such as:

  • History and comments – did I just hear some cheers? As you go through tuning and optimizing these queries you can keep notes and comments along the way.
  • Statistics Analysis with Histograms
  • Expressions
  • Tree Statements
  • Query Columns
  • Table/IO

Conclusion

SQL Sentry has hit a home run with this new release. The product continues to build out nicely; the team there gets a “job well done” in my book

Ten Essential Traits for DBA Success


Hard-Work_thumb.jpgThere is greatness within you whether you believe it or not. Over the years there are certain skills that have helped me along the way that, in turn, may help you along your journey. These traits are by no means written in stone and some will not agree that these are important and that’s okay; what I can say is that these traits are at the backbone of some exceptional DBAs I’ve met along the way.

 

 

Technical Traits

Backups – Think about this a moment if you will. A backup is pretty much the most fundamental aspect of database administration one could do. Let’s put this into more general terms; I view database administration as a service ( I thank Grant Fritchey (B|T) for that – Database Administration as a Service). Now, with that said whether you are new to database administration or not it is imperative to find out what the backup strategy requirements are for your business units and get your backups aligned accordingly. Let’s take this a step further and ask this question;  if you are taking good backups then are you restoring/testing these backups?

Automation Yes folks; I am a key advocate for automating as much as you can. This relates back to making database administration tasks run as efficient as possible. By doing this it will free you up to do even more types of database administration tasks. Some things to consider automating are:

  • Code Deployments
  • SSIS Deployments
  • Job tasks
  • Alerts
  • Health Checks
  • Patches
  • Server Level Changes
  • SQL Installations
  • Unit Tests

Sysadmin Rights – I think this one speaks for itself. If you don’t know who has sysadmin rights on your servers than you are doing it wrong. Find out who has this type control on your SQL Server if you haven’t already done so.

Disaster Recovery – Organizations and businesses that do not have a plan in place could fall into a few categories. The categories that I’ve seen which seem to be more prevalent, outside budget concerns, are realizing the importance but not knowing how to get there, and not knowing that a disaster recovery plan can even exist. Whatever the case may be laying out a good plan in case of disaster should be a must for any data professional.

Monitoring – This is an integral part to any DBA related job. You have to be monitoring your daily processes, policies, and procedures. Whether you are utilizing home grown coding or monitoring utilities by third party affiliates it is an absolute must that the data professional is aware of processes that may go awry before they happen; or for that matter knowing that things are going smoothly as well.

Non Technical Traits (a.k.a. Soft Skills)

Communication – One of the keys to becoming a great communicator is not becoming a great talker – big difference. These are some of the ways that can help become a better communicator where you are:

  • Earning Trust – you earn it with right acting, thinking, and ability to make decisions.
  • Become personal – I was taught early on that most of the time people really don’t care about how much you know until they discover how much you truly care.
  • Be Specific – one of the lessons learned over time is the need to be specific when communicating with a team, business unit, and executives.
  • Keep an Open Mind – want to limit a group trying to become innovative? if so then keep a closed mind. Use this as a utility to learn and grow; it’s okay if someone’s opinion is different than yours.
  • Shut-up and listen – sounds harsh I know but not really sure how else to get that point across. Becoming a great communicator you have to know when to dial it up, dial it down, and yes even dial it off. Knowledge is not always obtained by flapping your gums but rather listening and understanding situations.
  • Check Ego at the Door – over the years I’ve seen it time and time again. When you can put arrogance aside and check it at the door some great things begin to happen in shops, teams, corporations.
  • Read Between the Lines – I’m continually amazed at some of the mentors I’ve looked up to in the DBA realm and their conscious ability to read between the lines. Keep your eyes and ears open.

Listening – Just like communicating and talking I think there is as vast difference between listening and hearing. Next time you are in a conversation don’t just hear the other party but listen to them, and by listening don’t just judge but rather show you understand what is being discussed.

Work Ethic – two words have never been so important in my own life and journey. If you know me at all you know that having a strong work ethic is near and dear to me. A strong work ethic will result in respectfulness, dependability, dedication, accountability, determination, and humility. No one can do it for you; it has to be from within.

Character – can be defined as what determines how we respond to the situations and circumstances of life. One of the first jobs I had after my ball playing days was a position at a local sports store. A regional manager had made his way in and as he walked back into the back room (which I admit was not always the cleanest place due to inventory etc.) there were several pieces of paper laying in various places on the floor. Now, he didn’t know anyone was behind him but he stopped at each piece, picked it up, and threw it away. You may ask what does that have to do with character? It left an impression on me that how you work when someone is not watching you does in fact make a difference.

Do Not Compare Yourself – It is easy to get caught up in trying emulate oneself as others. Just ask Michael Jordan how many people tried to emulate him or some other renowned celebrity. I’m here today to tell you that while you can take traits from some of the best in the business; you will not be them and that’s okay. Your journey is just that; your journey – no one else’s. Own it and make it yours and along the way keep learning.

Conclusion

Focus on your greatest sphere of influence; it’s time to tear down the walls between teams, business units, and organizations. These 10 traits mentioned don’t even come close to representing any complete package of skill sets, but what it is intended for is to provoke some thought around even the basic essentials of what makes up a successful data professional.

Are SQL Saturday’s Worth It?

VenueThis past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you can check out their site here.

Now to put on an event like this is nothing short of an incredible effort from volunteers, sponsors, speakers, and attendees. Being able to help co-organize the one here in Louisville has been a humbling yet gratifying experience. Let me see if I can break it down a different way for you, the reader, who may not have had the opportunity yet to volunteer or attend such an event.

Volunteers

You can see these people usually with matching shirts on and a lanyard with their name and a ribbon that only says “volunteer.” In the past when I’ve attended such events I knew people helped out to put something like this on, but never in my wildest dreams did I envision all that it took until I volunteered.

Volunteering is not for glitz, glamor, or glory. Instead volunteering is what helps the cogs in the wheel move to get the steam engine running down the track. It is the staple of helping afford the opportunity for free learning to attendees and colleagues in our field.

Many, many, and many hours go into planning and organizing an event; if you attend one of these events make sure you seek a volunteer or organizer out and say thank you for their time; they are doing this for free and on their own time away from their families.

Mala Mahadevan (B|T) as a founding organizer of our event I thank you for allowing me to be a part of it these past few years.

Sponsors

Over the years, SQL Saturday Louisville has been blessed with some great sponsors. For the previous two years, John Morehouse (B|T) and I have taken great pride in working with some stellar companies. Without them, we would not be able to do what we do which is concentrate on the attendees and helping people learn.

Our Gold sponsors this year were:

Gold

  1. EMC
  2. Farm Credit Mid-America
  3. Imperva
  4. Microsoft
  5. Republic Bank
  6. Pyramid Analytics

 

Our Silver and Bronze sponsors this year were:

SilverBronze

  1. Idera
  2. PASS
  3. PureStorage
  4. Tek Systems
  5. Click-IT Staffing
  6. Homecare Homebase
  7. Datavail
  8. SQLSentry

A major thank you for all of their contributions and it is always a pleasure to work with all of you.

Speakers

It always amazes me at the number of speakers we have who send in sessions to our event. These speakers are people from all over the U.S. who are willing to travel and give their time so attendees can learn. Getting to spend time with each of them is not always an easy task, but always thankful to catch up with many friends at the speaker dinner.

It was awesome to see the attendees interacting with the speakers asking their questions and getting insight into the variously presented topics. And, because of so many good sessions to choose from, there was a buzz in the air.

As is the case with the volunteers mentioned above, speakers also travel on their own dime, away from their families – a simple thank you goes a long way. Also, for these sessions, I do want to point out that feedback cards are provided; please please please take a moment and make sure you provide good insightful feedback to the speakers. Each speaker uses this feedback to improve their sessions or have take-a-ways on what may or may not have worked. Yes, folks, these are important!

I won’t list every speaker we had; that is not the intent of this topic. But I will take a moment and say to each and every speaker who attended SQL Saturday Louisville 531 we thank you.

Attendees

Two words – – THE PEOPLE. As I have stated, these last two years has been nothing short of amazing. Seeing light bulbs go off with attendees who are learning from some of the best, and having discussions with attendees is why we do what we do.

When individuals come to us stating it was their first time at the event, and they had no idea that there is a local Louisville SQL User Group opens the doors to help reach people in our tech community.

Steve Jones (B|T), who is part of my Fab Five, talks about Dreaming of SQL Saturday. If you have not had a chance to read his post, check it out. Attendees travel from quite a distance. Which tells me the people are eager to learn.

Conclusion

So, the question I opened with “Is SQL Saturday Worth It?” Considering what I know now versus what I knew then the answer is yes. Personally, being a product of these types of events, I am living proof of what can grow from the SQL Community.

Whether you volunteer, speak, sponsor, or attend, all of these make the wheel turn. It’s a team effort with a lot of hard work. So, next time you attend one of these events, please don’t take them for granted.

Here is to continued learning, as we move forward to grow this community!

T-SQL Tuesday #080–Round Up

TSQL2SDAY-150x150The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month with many returning participants along with some newcomers.

We had a wide range of topics with many great insights from everyone, but don’t take my word for it. Check out the links below and see what your colleagues from around the SQL Community had to say:

 

Jason Brimhall – SQL Server Desired Enhancements

Riley Major – The Gift that Keeps on Giving

Jon Morsi – SQL Server 2014 Service Pack 2

Melissa Connors – DBCC CloneDatabase

Aaron Bertrand – Create Or Replace

Lori Edwards – SQL Server R Services

Robert Davis – SQL Birthday Present

Allen Kinsel – SQL Server’s Birthdays

Matt Gordon – Change Always On Endpoint Ports

Bjorn Peters – My Open Points for SQL Knowledge

Chris Bell – The Gift of the Basics

Andy Yun – Give Yourself a SQL Gift

Kenneth Fisher – Default Database File Sizes

Dave Mason – SQL Server Shutdown Event

Shane Eillis – Can Powershell Get What T-SQL Cannot

Raul Gonzalez – Using the Query Store For Read Only Database

Rob Farley – Finally SSMS Will Talk To Azure SQL DW

Kennie Nybo Pontoppidan – I want DBCC ConeDatabase Available on all (supported) Versions of SQL Server

Ginger Grant – SSIS Projects, Packages, and Deployments

Mike Walsh – Happy Birthday Chris, Have Some Changes

Wayne Sheffield – SQL Gifts

As you can see we had a great turnout and everyone continues to share their knowledge daily, weekly, and monthly basis. Thank you again for all who participated, and a big thank you to Adam Machanic (B|T) for allowing me to host another block party. Hope you all have a good one and look forward to next month.

images

The Next Chapter ~ A SQL Journey

 

Journey

The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”. I never cease to be amazed by the many outstanding data professionals we have in the PASS community.

For me, this ride has been a great learning experience. In addition, I am very thankful for the sacrifice of time that Chris Shaw (B|T) made in my behalf so many years ago. He was kind enough to take a willingly motivated individual under his wing and show him the ropes. He could have very easily said that he didn’t have the time. But the willingness that he expressed epitomizes what I have come to appreciate and expect from the SQL Family.

Along this journey I’ve witnessed a “closeness” rarely experienced in other communities.

A group rallies around someone in need, searching for an answer to their problems.

Fund raisers are organized for causes that benefit the individuals.

Intimate conversations are encouraged between peers – especially at large events and major conferences.

Words of experience and wisdom are freely exchanged when real-world battles make the road difficult.

These continual acts of kindness and sacrifice often leave me in awe.

It is not a perfect journey. It is not always an easy journey. And I have yet to see a bed of roses along the way. But my, oh my, it can be a rewarding journey.  The fruits of knowledge, friendship, bridging of gaps, experience, and opportunities are priceless.

Given my current position at “the shop”, leadership has been on my mind a lot lately.  Along with having aspirations in the SQL community, these are some important traits that I hold close to the heart:

  • Authenticity
  • Integrity
  • Concern
  • Restraint
  • Humility

At the same time, I strive to gain and exhibit:

  • Confidence
  • Vision
  • Composure
  • Resonance
  • Practical Wisdom

With these things in mind, I am today pleased to announce that I, along with my good friend John Morehouse (B|T), will be serving as Co-Chapter Leads for the Louisville SQL User Group. John and I were introduced to each other by Chris Shaw, and his influence has been tightly intertwined with our respective journeys since their beginnings. Little did I know, after a simple handshake at a PASS Summit, John would someday move to Louisville and a new friendship be forged. I will go to battle with John on any day, at any time, and anywhere, and I look forward to what the future will hold.

I do appreciate all of the hard work that Dave Fackler (B|T) has put into this community. While he is a stellar data professional in his own right, he has also helped to provide us locally with an avenue of opportunity and growth. Ideals to which he has been dedicated. It is my primary desire to help cultivate our local user base. To bringing forth new leaders, new innovators, and new SQL family members.

For those that know me, I have a reputation for using this saying … “Let’s roll.”

So, without further ado…Let’s roll.

Time Management–Leadership

TimeLeadershipTo many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails that may flow in without prioritizing will leave individuals searching for what is needed to be worked on now.

Organize or Agonize

Face it, we all influence someone. Whether you are a sole DBA out in the field or a leader of many there will be times when one will have some form of influence. There will be times when a data professional needs to juggle a multitude of tasks; being a leader in this area is key – either you organize or you will agonize over what all has to be done.

Here are some tips in how to organize and become better at time management:

  • High Importance / High Urgency – tackle these projects first
  • High Importance / Low Urgency – set deadlines around completion dates and work these into your daily routine
  • Low Importance / High Urgency – find quick and efficient ways to get this work completed without much personal involvement
  • Low Importance / Low Urgency – this is busy or repetitive work (think about automation if possible)

Too Many Priorities Can Paralyze You

The papers on the task keep growing, emails keep coming in, automated jobs are failing, on call is ringing off the hook, and you suddenly get that “frozen feeling” of what in the world am I going to do? If you’ve been in this business long enough than you know what I am talking about. If you are feeling this way go ahead and get the tasks organized then approach your boss about how best to approach them and what their advice may be. True leaders want to help their employees as much as they can and this is one of the areas that all of us can work on. All good leaders have learned to say no to the good and yes to the best, and one of the keys to success is keeping that line of communication open with your boss.

Monica Rathbun (B|T) has a great post on The Shield. I suggest after you finish reading this post you go check hers out; a superb written post that provides insight into a lone DBA’s world.

Leader or Follower

A person is either an initiator or a reactor when it comes to planning. In my past dealings I’ve found that these hold true; note the difference:

Reactors

  • React
  • Listen and wait for the phone to ring
  • Spend time living day-to-day reacting to issues
  • Fill the calendar by requests
  • Spend time with people

Leaders

  • Initiate
  • Lead; pick up the phone and make contact with people
  • Spend time planning and anticipate problems
  • Invest time with people
  • Fill their calendar by priorities

Often times we see that when people lack ownership of an idea, they usually are hesitant to change. It affects routine, causes a disruption, and at times creates fear of the unknown. Uncharted territories cause insecurities to rise; four important cycles that will stand out around effective change are create, conserve, criticize, and change.

As a data professional there will be times when you are faced with bringing about change; here is a checklist that you may be able to garner some ideas from and assist you in helping you to bring forth implementing or requesting changes.

  • Will this change benefit others?
  • Is this change compatible with the purpose of the organization?
  • Is this change specific and clear?
  • Is it possible to test this change before making a total commitment to it?
  • Are physical, financial, and human resources available to make this change (what else is on the plate?)
  • Is this change reversible?
  • Is this change the next obvious step?
  • Does this change have both short and long-term benefits?
  • Is the leadership capable of bringing about this change?
  • Is the timing right?

The wrong decision at the wrong time = disaster

The wrong decision as the right time = mistake

The right decision at the wrong time = unacceptable

The right decision at the right time = success

Closing Thoughts

The above are methods that I’ve picked up over the years that have helped me not only become a better data professional, but a leader. I’ll leave you with a few insights into what a solid foundation could be built on; it will be up to you to become the leader that you want to be; along with honing in your time management skills.

The definition of leadership is influence.

The key to leadership is priorities.

The most important part of leadership is integrity.

The most ultimate test of leadership is creating positive change.

An extra plus in leadership is attitude.

What is your most appreciable asset – people.

The indispensable quality of leadership is vision.

The price tag of leadership is self-discipline.

May we never lose sight or focus of our dreams and goals. Obstacles will occur, but they are just that obstacles with solutions waiting to be had. Take the hard knocks as lessons that can be learned. There will be many, life’s journey is full of them – what kind of impact will you have?

T-SQL Tuesday #75 Invitation: Jump into Power BI!

SqlTuesday_thumb.pngThis month the talented Jorge Segarra (B|T) hosts the T-SQL Tuesday block party, and he has chosen the topic of Power BI.

So, what exactly is this thing called Power BI? I admit, I have several friends and colleagues who have dove into this type of technology, but I have not done so in great depth yet.

I think Jorge pretty much summed me up in his first paragraph when he says, “If you’re reading this and thinking ‘crap, I’m not a BI person!’, don’t you fret. My intention is to make folks who normally don’t use BI on a day to day basis try their hand at creating cool new visualizations and reports with Power BI and seeing how the other side lives.”

So what did I do? I think the below tweet sums it all up:

image

I downloaded the Power BI Desktop from Jorge’s link and was immediately amazed by the simplicity of ease in working with the utility. I had some dummy data laying around for drive space so decided to hook up to the data source and start messing around with it.

The data set populated through some clicks and a query provided by me led to the data set being available. Great; next what caught my eye was the visualization section; which it would, right? Everyone likes a good picture with analytical data attached.

image

Now, in my data set I am capturing dummy data, because we would never use prod data for a post, right? I have 5 drive letters (C,E,F,G, and H); I immediately went for the filters for the visual effects:

image

Once my filters were in place for the given time period I could quickly tell what I was dealing with from a visualization form of view:

image

In my short amount of time using this product I can definitely see a lot of usefulness that I could get from it. I am beginning to look at ways to incorporate this into some current presentations both in the shop and out of the shop that will better define my data sets to different groups (know your audience).

So Jorge, thank you for motivating me to dive into this a little bit. While I have only just scratched the surface with it, I see glimmers of how powerful this could be in my data professional journey.

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was founded by Adam Machanic (B|T). You can take part by posting your own participating post that fits the topic of the month and follows the requirements below. Additionally, if you are interested in hosting a future T-SQL Tuesday, contact Adam Machanic.