Monthly Archives: November 2014

Kimberly Tripp is going to visit PLSSUG in January (online meeting)

Paul Randal has recently proposed that SQLSkills could give sessions on the user groups meetings. I emailed him immediately and – making the long story short – the PLSSUG (Polish SQL Server Users Group) will be hosting Kimberly Tripp on 29 th January at 6PM local time. Please visit the  community webpage 

Here are some details:

Stored Procedure Optimization
Techniques

Presenter: Kimberly L. Tripp

Abstract: Kimberly will discuss stored procedure caching and the potential for
performance problems due to a problem known as parameter sniffing. There are
some common solutions and while they can drastically improve performance, they
can also cause other problems. Sometimes a hybrid solution is needs, from this
session, you’ll know the best way to write procedures so that stable requests
are cached and unstable requests are not (giving you the most optimal
performance without wasting resources).

 

Bio: Kimberly L. Tripp, President / Founder, SQLskills.com

Kimberly has been a Microsoft
SQL Server MVP and a Microsoft Regional Director for over 10 years; she’s an
author, consultant, and top-rated speaker having spoken at PASS, TechEd,
SQLintersection, and numerous other events around the world. She has over 20
years of experience designing and tuning SQL Server solutions with a focus on
optimizing procedural code, indexing strategies, statistics, and partitioning.
When she’s not tuning SQL servers, she’s diving and photographing all sorts of
underwater critters such as frogfish with her husband, Paul S. Randal.

I hope that this is great news.

And I promise – this will not be the only meeting :).

More details will follow on the community webpage (as well as information how to participate in that meeting) – http://plssug.org.pl/

Cheers,

Damian

  

 

 

Mission Critical Performance Enhancements in SQL Server 2014 on DBTA.com

Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.” Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and data integration. Read the rest of my article at http://www.dbta.com/Columns/SQL-Server-Drill-Down/Mission-Critical-Performance-Enhancements-Coming-in-SQL-Server-2014-92530.aspx…(read more)

In The Cloud: Manually Migrating a Hyper-V VM to Azure

Azure is great for sharing reproductions on difficult problems. I managed to reproduce an application problem in a virtual machine on my laptop. It’s really not reasonable to ask for others to help me after following a long set of steps to build a matching test environment. Besides, something could go wrong. I had the perfect test case, but only in my local Hyper-V environment. I realized this is a perfect use case for migrating a vm to Azure. I learned a few things along the way that may be of interest….(read more)

A Biml Case Study

Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine. A Story of Productivity A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts between customers and enterprise reporting needs. They contacted a friend who contacted me. When we spoke they asked, “Can you help?” “Yes,” I replied, “I can help.” We scheduled a three-day visit. On Day…(read more)

Put Your New Leadership Knowledge Into Practice

Have you ever tried to hit a golf ball toward the pin, toss a dart at the bull’s-eye, or chuck a fly at a trout? If you’re like most people, your first attempt didn’t come anywhere close to hitting the mark. Your golf ball may have found the woods, your dart may have sunk into the wall, and your fly may have slapped the back of your head. These activities are skills that must be acquired through practice and discipline. You can read a book about all of them and you can study the mechanics of motion,…(read more)

Some Thoughts on Event Speaker Selection

I write this from the perspective of experience. I’ve helped organize dozens of events over the past ten years. Feel free to take the parts of this advice that help and discard the parts that don’t. Enjoy! Planning an event is hard work. If you’ve never volunteered to help your local User Group or SQL Saturday, I encourage you to get involved. You will work hard and put a lot into it. But I promise you will get more out of it than you put in. Every organizer is free to organize their event in whatever…(read more)

Mastering Execution Plan Analysis – Melbourne 6 Feb 2015

Over the years I have spent working with SQL Server, the personal time investment that has repaid itself more than any other is becoming intimately familiar with execution plans and how they can be used to diagnose and correct performance problems. There is nothing I enjoy more than talking about execution plans, the query optimizer, and how internals knowledge can be applied to solve real problems. Living in New Zealand, I don’t get to speak on this topic as often as I would like, primarily due…(read more)

SQL Saturday #356 Slovenia Registrations

SQL Saturday #356 Slovenia is practically full. OK, actually we have already reached the expected number of registrations (200). We have raised the number to 220, and we are close to that number as well. Therefore, we (the organizers, Matija, Mladen and me) need to ask all of you who are registered and already know that you will not be able to attend: please unregister and make room for those who would like to attend, but did not register yet. And you who would like to register, please do it as soon as possible, in order to get the confirmation immediately or to be at least at the top of the waiting list.

We would like to make an appeal to all of you who are registered: please come. Please remember that this conference was made possible because of the speakers, who are using their time and come on their own expenses to give you state of the art presentations, because of the sponsors, who are giving us and financing the venue, the food, the raffle awards, and more, and of course, because of many volunteers who spend their free time to help with the organization. We are also paying a fixed number of meals to the catering company; therefore, we would throw the money away for those who are registered and would not come. In short: all you need to do is to wake up, get out of bed, get into a good mood, and come to the event to get top presentations, good food and meet friends!

Thank you all!