Free scripts and tools for your Production SQL Server

Yes, that is right – FREE scripts and tools, created by Microsoft SQL Server Tiger PM Team (blog | twitter) are now live on Microsoft repository in github.com. So, go to http://github.com/microsoft/tigertoolbox and enjoy the free stuff. Some notes on the solutions I’ve already used on a lot of production environments: – SQL Server Performance…

4

SQL Saturday Sofia 2016 recap

SQL Saturday #538 Sofia just ended. It has been an absolutely great experience!!! The recap of the event, including my slidedeck, you can find HERE. Additionally, I’d like to remind everyone that although the Data loading performance guide has been written back in 2008, it still apply, so if you are doing ETL or you need…

0

Visiting Prague’s PASS BI and SQL Server chapter

Last week I was in Prague working with several customers on SQL Server performance tuning and baselining (and some extra fun with setting up Kerberos authentication for Reporting Services 2016). So it was a week full of joy 🙂 But what made the week special, was that I was given the opportunity to speak in…

0

It’s October, it’s time for SQL Saturday in Sofia

  As a well established tradition, this year’s SQL Saturday #538 Sofia is again in October. Just last week the organizers published the event schedule and as usual, there will be a ton of sessions to choose from and a lot to learn. I had the pleasure to participate in the session selection and I…

0

Estimating storage requirements for encrypted columns–AE learning series part 04

As we discussed in earlier posts and as you might already be aware, AlwaysEncrypted columns require additional storage after they’re encrypted. Of course, that means that you need to plan properly as this might cause effects to your database, such as data file growth, fragmentation, etc. So, how exactly can you calculate the space, that…

0

Why SQL 2016 rocks – the series (part 2)

The second post of the series will be covering all those “small” scalability improvements in the SQL core, that help you run your workloads with even better performance just by upgrading to SQL Server 2016. The following articles are coming from the CSS SQL Server engineering team and its under the “It just runs faster”…

0

Why SQL 2016 rocks – the series (part 1)

SQL Server 2016 rocks! There is no doubt about it. At least not with me! I have so many cases where just by upgrading to the new engine you get performance improvement in the range of 10s of percents. And this is even before we hit general availability. The things that are improved are so…

0

Permissions required to run Query Store in SQL Server 2016

If you wondered what is the minimum permission set you need to have in order to use Query Store in SQL Server 2016, then here is the answer: you need VIEW DATABASE STATE. I tried overcoming it by giving read permissions to all the stored procedures, DMVs and DMFs but to be honest – I…

2

Plan cache pollution or how important it is to properly define parameters in code

Recently I was involved in couple of cases concerning plan cache taking more than 20% of the SQL Server Buffer Cache and although there is no fixed threshold/best practices value, I noticed that there were a lot of identical statements getting cached. Effective plan caching is important for optimal performance on SQL Server and I…

0