-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The SQL Professor

Chris Yates is a Database Administration Manager with over thirteen years of experience in the SQL industry. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions accompanied by a strong development background. He enjoys helping others in the SQL Server community and does this by contributing on several SQL forums, creating “The SQL Professor”, and speaking at several SQL functions. His passion and focus is not only with technology but also helping others along their way and career path.

SQL Saturday Louisville–Bout That Time

SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this event by some great organizers and volunteers. It has been awesome to be part of the journey with them. You can check out the event homepage here and if your… Read more

0 comments, 130 reads

Posted in The SQL Professor on 16 July 2018

180 – Is It Time For A Turnaround?

What needs to change? The challenge to explore is are there things in your current day to day that needs to change? Maybe there are some habits, things, processes that need to be turned around. One of the most difficult things about turning around in my mind is acknowledging the… Read more

0 comments, 418 reads

Posted in The SQL Professor on 26 April 2018

Interview With Matt Gordon

I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I reached out to him to see if he’d be up for an interview for the blog. As is usually the case he was happy to oblige. I’ve known Matt for,… Read more

0 comments, 774 reads

Posted in The SQL Professor on 29 March 2018

What The Doctor Ordered

I recently went to our local pharmacy to pick up some prescriptions. There was one for my boy and one for me; at the time I didn’t think much of it to check. I had seen the last name on the slip for both and moved onward with the business… Read more

0 comments, 282 reads

Posted in The SQL Professor on 19 December 2017

Eliminating Hassles

It is easy for me to fall into the trap of the “who” versus the “what”. If we are not careful we can get caught up in a web entangled mess. I often get asked how do I go about handling each day and staying organized. Let me be the… Read more

0 comments, 1,240 reads

Posted in The SQL Professor on 20 November 2017

TSQL Tuesday #96: Folks Who Have Made a Difference

I was intrigued by this month’s T-SQL Tuesday topic presented by Ewald Cress (b|t) “Folks Who Have Made a Difference”. Digging a bit deeper the comment of “Who has made a difference in your career?” was made.

I’ve stopped and restarted typing this blog post several… Read more

1 comments, 293 reads

Posted in The SQL Professor on 14 November 2017

Pass Summit 2017

It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many data professionals will be heading out to one of the biggest SQL related events of the year. There is excitement for many along with a sense of being overwhelmed for… Read more

1 comments, 360 reads

Posted in The SQL Professor on 26 October 2017

Thank You–#PASSElections

This week has been a whirlwind; as the results came in earlier this week on the election I wanted to take a moment and say Thank You. It is with great honor and privilege to be elected to a seat on the PASS Board.

This position is one that… Read more

0 comments, 451 reads

Posted in The SQL Professor on 28 September 2017

Four PASS Questions–My Take #PASSElections

As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer four questions. While I did put together a short two-minute video for PASS that will be published soon on the election site regarding these questions; I felt it prudent… Read more

0 comments, 360 reads

Posted in The SQL Professor on 19 September 2017

Running for the PASS Board of Directors #PASSelections

This year I decided to take “someday” to heart and do something that has been on my mind for awhile – submit my application to run for the PASS Board. Going through the process so far has been a humbling experience; one that I’ve learned a lot from. I’m excited… Read more

0 comments, 1,623 reads

Posted in The SQL Professor on 14 September 2017

SQL Saturday Louisville Re-Cap

And like the wind another SQL Saturday Louisville has come and gone. This past weekend seemed to be a huge success, but it didn’t come with some take-away’s and that is okay. I think every time we put on an event like this we are always looking for ways to… Read more

3 comments, 426 reads

Posted in The SQL Professor on 9 August 2017

SQL Summer Vacation–SentryOne

We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL Summer Vacation coming into town. SentryOne’s Kevin Kline (B|T) will be rolling into town for a fun filled 2-hour event on Wednesday the 25th. This is… Read more

0 comments, 364 reads

Posted in The SQL Professor on 24 July 2017

PAC Community Ambassador – SQL Sentry

Last week Aaron Bertrand (b|t) published a post regarding five new PAC Community Ambassadors for SentryOne. I am privileged and honored to be a part of this journey with some stellar data professionals:

  • Andy Mallon (b|t)
  • John Morehouse (b|t

Read more

0 comments, 294 reads

Posted in The SQL Professor on 17 July 2017

T-SQL Tuesday #92, Lessons Learned The Hard Way

Wow, hard for me to believe it has been a little bit since the last T-SQL Tuesday block party. This month Raul Gonzalez (b|t) has chosen the topic of what lessons one has learned the hard way. Before we get into the story, however, let’s take… Read more

0 comments, 435 reads

Posted in The SQL Professor on 11 July 2017

Built My Presentation, Now What?

Over the course of several years, I have given many technical and non-technical presentations. It is fun for me to put a new slide deck together, but it also requires a lot of hard work and can be time-consuming. I’ve had a few mistakes, to say the least, over the… Read more

0 comments, 401 reads

Posted in The SQL Professor on 7 June 2017

QA, Utility Databases, and Job Executions

Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation are different; there will always be several different ways in most cases that you can arrive at a solid solution.

 

This post has a few intentions behind it:

  • It…

Read more

0 comments, 367 reads

Posted in The SQL Professor on 26 April 2017

Can a Data Professional Be Organized?

“One of the advantages of being disorderly is that one is constantly making exciting discoveries.”  While this quote is true it is often times too late to act on an opportunity therefore it is missed. If you are a leader at your respective shop it can then be conceived that… Read more

0 comments, 1,358 reads

Posted in The SQL Professor on 25 April 2017

SQL Doc by RedGate

I recently was on a call where a technical unit indicated they did not receive any form of documentation around the vendor database that was created. Now, seeing that I fall into the database profession it sparked my fancy. I began to ask a few questions to the individual who… Read more

0 comments, 1,214 reads

Posted in The SQL Professor on 19 April 2017

T-SQL Tuesday #89 Invitation – The times they are a-changing

This month’s topic by Koen Verbeeck (B|T) is based around times that are a changing. To break it down somewhat it was inspired by a blog post that Kendra Little (B|T) put together around Will the Cloud Eat My DBA Job.… Read more

0 comments, 311 reads

Posted in The SQL Professor on 11 April 2017

Don’t Duck On Responsibilities

Being a data professional you assume a certain amount of responsibility. It often requires having the right attitude and an action plan in place for finding the solutions to our problems at hand. Too many times we attack the symptoms causing the issue, but overlook the root cause. The quick… Read more

1 comments, 1,344 reads

Posted in The SQL Professor on 10 April 2017

Older posts