-->
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.

Contained Database – No more need for Server Level Logins

Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL Server that hosts the database including the master database–theoretically this makes a database much easier to move… Read more

0 comments, 2,249 reads

Posted in SQLEspresso on 5 July 2018

Congrats to DCAC Staff on MVP Renewals

 

July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and over again waiting to find out if they have been renewed for the upcoming year. I am proud to announce that Denny Cherry and Associates once again have FOUR… Read more

0 comments, 120 reads

Posted in SQLEspresso on 2 July 2018

Replication Max Text Length

Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce it to those that had not.

Error Description: Length of LOB data (65754) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum… Read more

2 comments, 1,718 reads

Posted in SQLEspresso on 20 June 2018

Respectfully Responding

I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets. Last week, I tweeted about  Stack Exchange and my thoughts on the lack of respect in the responses to those who take the time ask questions in… Read more

5 comments, 1,743 reads

Posted in SQLEspresso on 14 June 2018

How to get started with Always Encrypted for Beginners Part 4: Change is Coming

A few weeks ago, I wrote Part 12 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part 4, I am going to talk about the changes that are coming in vNext of SQL Server.

As I discussed in part 3 there… Read more

4 comments, 1,983 reads

Posted in SQLEspresso on 13 June 2018

Importance of Statistics

Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and play a part in execution plans. The cardinality estimator relies heavily on statistics to get the answer to selectivity (the ratio of distinct values to the total number of values)… Read more

1 comments, 217 reads

Posted in SQLEspresso on 30 May 2018

Query Predicates

Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was ranting on and on about how the predicates were written when the person stopped me and asked a very simple question. Like a light bulb going off, it reminded me… Read more

0 comments, 191 reads

Posted in SQLEspresso on 24 May 2018

5 Ways to Examine Cardinality Metrics

In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics to get the answers and calculate a cost estimate. It takes the #of Rows to Satisfy a Predicate/Total # of… Read more

1 comments, 173 reads

Posted in SQLEspresso on 2 May 2018

Live, Learn, and Grow

Ever look back at old work and wonder what was I thinking when I did that? Or even better you mock and get disgusted over some code you stumble upon and then realize you wrote it?

Today is one of those days.

Lucky for me one of my clients is… Read more

1 comments, 161 reads

Posted in SQLEspresso on 25 April 2018

Free Training 24HOP

In my sessions, I always talk about how to build your skill set when you don’t have a budget for training. Well next week April 25-26 is one of those free opportunities I take advantage of each year. 24 hours of PASS, affectionately referred to as 24HOP, is an online… Read more

0 comments, 252 reads

Posted in SQLEspresso on 18 April 2018

Template Explorer Gold Mine

Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold mines that are within the product that help you be a better DBA or Developer. Template Explorer is one of those. To get to it go to VIEW from the… Read more

0 comments, 259 reads

Posted in SQLEspresso on 27 March 2018

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

3 comments, 371 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

2 comments, 210 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, 207 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, 200 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,529 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, 517 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, 535 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, 248 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,496 reads

Posted in SQLEspresso on 13 December 2017

Older posts