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

SQLEspresso

I am Monica Rathbun. I’m currently a Sr. Database Administrator/BI Architect at Massimo Zanetti Beverage, USA in Virginia. I’ve been a Lone DBA for 15 years, working with all aspects of SQL Server and Oracle. I am currently the co-leader for the Hampton Roads SQL Server User Group and can be found on Twitter daily as @SQLEspresso. I am passionate about SQL Server and the #SQLFamily, doing anything I can to give back to such a wonderful community. As a new speaker at SQL Saturdays and a new blogger, I hope to earn my place as a valued member. When I’m not busy with work, you will find me playing taxi to my two daughters back and forth to dance classes.

TIL: Microsoft Azure Part 2

Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure.  This is part two of what I am learning in Azure.

Today’s topic is simply about Tenants, Subscriptions, Subscription Roles, Resource Groups, and Tags.

It’s Always Good to Start with Pictures

Here is a glimpse… Read more

0 comments, 388 reads

Posted in SQLEspresso on 24 May 2017

TIL: Microsoft Azure Part 1

I thought maybe it would be a good idea to start a multi-part series on Today I Learned (TIL) about Microsoft Azure. As part of my new job I am currently learning as much about Azure as possible. As I learn things, I will blog to share what I am… Read more

1 comments, 292 reads

Posted in SQLEspresso on 17 May 2017

Blogging at SQLPerformance.com

I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC) I will be writing occasionally for the site. You can catch my first blog post It’s Not You It’s Me (I/O Troubleshooting) through simple changes.

SQLPerformance.com is about providing… Read more

0 comments, 171 reads

Posted in SQLEspresso on 18 April 2017

Time for a Change

I am ecstatic to say I have joined Denny Cherry and Associates Consulting.

Lone No More

I am happy, excited, and nostalgic to announce that I am hanging up my Lone DBA hat and becoming a consultant. Yep, you read that correctly, I’ve decided after 16 years that I… Read more

1 comments, 160 reads

Posted in SQLEspresso on 17 April 2017

Among Giants

Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field.  I never once thought I could be among them. I am very humbled to be recognized as a Microsoft Data Platform MVP for 2017. Thank you to those that deemed me worthy enough… Read more

1 comments, 152 reads

Posted in SQLEspresso on 5 April 2017

Lone DBA Podcast

I recently had the pleasure of being a guest on a Podcast episode with the SQL Data Partners Carlos Chacon (B|T) and Steve Stedman (B|T).  If you haven’t had a chance to attend one of my sessions on Survival Tips for the… Read more

0 comments, 139 reads

Posted in SQLEspresso on 3 April 2017

Trouble Shooting Little Jewel

I didn’t know about this little gem, so I shared it with my team and they didn’t know about it either. Then I tweeted about it and found others who didn’t know about it, so I decided I should write a short little blog.

Denny Cherry (B|T Read more

1 comments, 259 reads

Posted in SQLEspresso on 29 March 2017

Ooops! Was that me? (Blog Challenge)

We have all made mistakes in our careers, I thought I’d share one of mine as a quick tip to others so that you don’t make the same one.

Everyone has their SQL Alerts setup right? If not, I have included the script below and here is the MSDN link… Read more

5 comments, 295 reads

Posted in SQLEspresso on 10 January 2017

Run Book, Run!!!

How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and SSIS packages. In addition, I preference mine with all key elements someone might need, like where passwords are stored, architectures, backup times, where… Read more

9 comments, 319 reads

Posted in SQLEspresso on 21 December 2016

Hide and Group Columns in SSRS Using a Parameter

Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like have multiple versions of the same report out there. So, I got a little fancy with the… Read more

1 comments, 110 reads

Posted in SQLEspresso on 9 December 2016

T-SQL Tuesday #84 – Helping New Speakers

Ok everyone; here goes my first crack at replying to a T-SQL Tuesday. For those that don’t know what it is, it’s a Monthly blog topic hosted by a member of the SQL Community. It was started originally by Adam Machanic (t | b)

This month’s topic hosted… Read more

1 comments, 71 reads

Posted in SQLEspresso on 8 November 2016

Challenge Accepted

My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting this resolved as my top priority.

Let’s see how I tackled the problem…

Symptoms:

  • Very High Disk Latency as high as 300,000 milliseconds (ms) is…

Read more

10 comments, 76 reads

Posted in SQLEspresso on 14 September 2016

This Idera ACE Has Been Busy

This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what that is …

What is an Idera ACE? (According to Idera)

“ACEs (Advisors & Community Educators) are active community members who have shown a passion for helping the community… Read more

0 comments, 99 reads

Posted in SQLEspresso on 23 August 2016

Summit Submission Feedback Response

I’m It Survival Tips for the Lone DBA – Level 100

(Not Accepted: Higher rated session selected)

Track: Professional Development

As others have done I also will share my feedback from my submission to speak at PASS Summit in hopes it will lend some more insight into the process. Read more

8 comments, 80 reads

Posted in SQLEspresso on 28 June 2016

SSRS Report Won’t Render in VS Preview

I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying. Last week, I was lucky enough to get a new one and spent two days getting it setup just right. At least so I thought…. once I started working on… Read more

0 comments, 101 reads

Posted in SQLEspresso on 12 April 2016

The Shield

How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are always saying no or they have to wait? I know many DBAs that have this reputation. To avoid this, I use my manager as a shield and suggest you do… Read more

4 comments, 95 reads

Posted in SQLEspresso on 11 March 2016

SQL Family: The Wonder Years

Last week, Bill Wolf aka @SQLWareWolf and I somehow got onto the topic of High School pictures. So in jest, I decided to post mine and hash tagged it with #SQLHSPics on Twitter. I challenged others to do the same, only really expecting @SQLWareWolf to respond in kind.  I was… Read more

0 comments, 81 reads

Posted in SQLEspresso on 11 February 2016

Back to Basics: Why not parameterize?

I think sometimes those of us that have been doing database administration/development for a while take it for granted that everyone knows the basics. One such basic is parameterizing stored procedures. This allows us to potentially consolidate multiple stored procedures into a single procedure.  It’s as simple thing to do… Read more

0 comments, 80 reads

Posted in SQLEspresso on 23 December 2015