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
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/
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)
Considering that Natively-Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it’s possible to monitor statement execution. In this tip I will explain how this can be done.
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)
An earlier article discussed ways to Evaluate Recruiters to partner with in your job search. However, a lot of candidates struggle with capitalizing on working with Recruiters once they initiate communication. Read this article to suggestions on how to work effectively with recruiters.
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)
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)
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)
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 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!