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

SQLEspresso

Monica lives in Virginia and is a Microsoft MVP for Data Platform. She has over 15 years of experience working with a wide variety of database platforms with a focus on SQL Server. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips.

SQL Server Updates Tricked Me for Years

When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you had already stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer… Read more

2 comments, 173 reads

Posted in SQLEspresso on 21 February 2018

Bloggers Should Have Reach

One of my goals for 2018 is to expand the reach of my blog.

As a blogger starting out I had my own site I posted to, but my blogs only reached those who followed me on Twitter, Facebook, Google + and LinkedIn. My blog automatically posts to these three… Read more

1 comments, 135 reads

Posted in SQLEspresso on 14 February 2018

Expanding My Reach

I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted.  Simple- Talk is technical journal and community hub from RedgateIt in I discuss my passion for my work as a Lone DBA.

 

You can find the full article using… Read more

1 comments, 133 reads

Posted in SQLEspresso on 7 February 2018

Can You Hear It Now?

Here is a quick blog to show you something I discovered that I didn’t know existed.

I was on a Skype call and noted that the presentation I had been watching was no longer audible. I tried messing with my volume, I made sure my sounds weren’t muted and played… Read more

1 comments, 104 reads

Posted in SQLEspresso on 31 January 2018

Maintaining Balance

Last week, I got the chance to give my I’m It Survival Tips for the Lone DBA  in a webcast for the first time thanks to the PASS Women in Technology Virtual Chapter. This is by far my favorite session to give because it’s real life and can pertain… Read more

4 comments, 1,422 reads

Posted in SQLEspresso on 24 January 2018

How to get started with Always Encrypted for Beginners Part 3: One Two Punch

A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the… Read more

2 comments, 338 reads

Posted in SQLEspresso on 17 January 2018

It’s All in the Name, Index Naming Conventions

Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing. The process was to determine duplicate indexes and consolidate them or discard the unneeded ones. My ranting was not about the duplicates per se it was about the index names.… Read more

1 comments, 195 reads

Posted in SQLEspresso on 10 January 2018

AHHH I need a Blog Topic!!!

One of the hardest things you can do as a blogger is to come up with a post topic. Do you make it simple for newbies, technical, or something personal?  After figuring out a topic, now you have to write.  However, there is a difference in what you say and… Read more

3 comments, 185 reads

Posted in SQLEspresso on 20 December 2017

How to Get Started with Always Encrypted for Beginners Part 2

In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so.

Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or… Read more

1 comments, 1,288 reads

Posted in SQLEspresso on 13 December 2017

How to get started with Always Encrypted for Beginners Part 1

Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server has made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. Unlike Transparent Data Encryption (TDE) which only encrypts… Read more

4 comments, 364 reads

Posted in SQLEspresso on 29 November 2017

Thankful DBA

This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what I am thankful for as a DBA. These are in no particular order and feel free to respond with something you are thankful for. I’d love to hear it.

  1. Glenn…

Read more

1 comments, 257 reads

Posted in SQLEspresso on 22 November 2017

Do Not Pass GO!

What is the GO statement and why is it so important to use? When do I have to use it? When do I not use it? These are questions that have passed through my head from time to time while writing T-SQL within SQL Server.

First What Is It and… Read more

1 comments, 505 reads

Posted in SQLEspresso on 15 November 2017

What Are These Backup Settings All About?

I ran across a client the other day that had these Backup and Recovery options set like the picture below because it is defaulted this way. The Database Administrator didn’t know what they should configure them as so he left them alone. I find this is the case with a… Read more

1 comments, 493 reads

Posted in SQLEspresso on 8 November 2017

Quick Model Database Tidbit

Are you using your Model Database to its full potential?

I am finding more and more that Database Admins are not using the Model database to its fullest potential and some not at all.

What is that Model Database for?

The model database is basically the default setup (template) for… Read more

5 comments, 433 reads

Posted in SQLEspresso on 30 October 2017

Synchronous VS Asynchronous Statistics Updates

One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously. It’s a simple change that can have a big impact when implemented in highly transactional OLTP environments. Notice I said OLTP not OLAP, since data in… Read more

5 comments, 1,477 reads

Posted in SQLEspresso on 25 October 2017

Does Your Code Have a Preamble?

Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a block of code I refer to as a preamble. If yours doesn’t I strongly recommend you start adding it. It drives me crazy when I see code with no documentation… Read more

1 comments, 190 reads

Posted in SQLEspresso on 18 October 2017

Why I Go to Summit Each Year?

This year will be my 6th PASS Summit that I will have attended. Some people have asked me why I still go, and what I get out of Summit that I don’t get from attending and speaking at SQL Saturdays. That’s an easy one for me to answer,… Read more

0 comments, 201 reads

Posted in SQLEspresso on 11 October 2017

SQL Sequence vs Identity Column

Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever… Read more

2 comments, 436 reads

Posted in SQLEspresso on 4 October 2017

Just Check ALL the Boxes

Today I ran into something on a client server I unfortunately see too often.  The DBA goes through the trouble of configuring and setting up alerts\operators but doesn’t really understand what the options in the configurations mean. So unfortunately, that means they take the CYA (cover your ass) approach and… Read more

3 comments, 1,310 reads

Posted in SQLEspresso on 27 September 2017

Hmmm… What’s This?

OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do… Read more

2 comments, 1,883 reads

Posted in SQLEspresso on 20 September 2017

Older posts