Have you ever gone to learn from a presentation, communicate at an ask the experts session or explored an environment through a hands on lab and felt that a little input from you could have turned the information provided into more contextual knowledge for you?
Have you ever felt too intimidated to ask the important question in front of a large crowd?
Well this year Solid Quality Mentors are offering you the chance to schedule a consultancy session with their mentors about anything that you intend to learn, communicate about or explore during the conference. Being Solid Quality Mentors this means that you can ask about just about anything SQL Server that you would like to find out more about.
Just pop over to our stand and book an available session that suits you, for a relaxed chat with one of our mentors present at TechEd.
Come and communicate with us, we can help you explore what you need and learn from what we know.
Look out for our mentors in the Exhibition Hall, B14 the first week and B21 the second week.
Look out for our mentors at ask the expert sessions.
Look out for our mentor' presentation sessions including :-
Maciej Pilecki: Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management
SQL Server, like any other database, can be very memory-intensive but how is all that memory used. Is it just the data that is cached? What other objects can be chached to make the system more efficient? This session goes deep under the covers of SQL OS to see how SQL Server manages its memory. We will look at the dynamics of memory usage within SQL Server and the competition between different cache types. Special attention will be afforded to the procedure cache and how it is utilised. We will also examine how SQL OS interacts with the host operating system and other applications running on the same machine. After this session you will have a good understanding about the SQL Server memory architecture and how to optimise SQL Server by configuring memory usage optimally. You will also learn how to diagnose and troubleshoot memory related issues.
Greg Low: Answering the Queries your users really want to
ask, with Full-Text Search in SQL Server 2008
Business users today are less prepared to be constrained by technology than they may have been in the past. They don't want to hear that you cannot search on such and such because it is not in the right field or that it has not been isolated from other elements so it cannot be retrieved fast enough or will have a negative impact on other users. The full-text search capabilities in SQL Server 2008 will give you the power to deal with these loosely constrained queries.
This session will familiarise you with the full-text search subsystem. It will show you why it is important, what can be done with it and how to implement and manage it.
The subsystem is not new but it has been optimised for delivery within the latest version of SQL Server. The benefits will be communicated during the session as will issues that you may experience if you are upgrading a previous version of the subsystem.
Whether you are new to FullText search or you have tried it previously and were frustrated by the limitations of the earlier version, you will gain a full appreciation of why you should be considering it as a new flexible way of meeting your business users needs.
Greg Low: Using Dynamic Management Views To Improve Your Development
Although Dynamic Management Views have been available as objects in previous releases of SQL Server, they have been extended and made much more Functional in SQL Server 2008. However, it appears that the majority of developers have tended to ignore the fact that they are available.
In this session you will be introduced to these management object types, both views and functions, and aquainted with those that are considered most useful to the developer. You will learn how they can be valuable when monitoring and troubleshooting as well as general management of SQL Server, hands up if you have worked on a project without a DBA!.
As well as showing you how you as a developer can benefit from these objects, you will also learn how you can help your team, those that perhaps don't manage to make it to TechEd. To this end you will learn how these objects can be used to develop customised reports which can be run from inside SQL Server Management Studio.
Greg Low: Avoiding Stored Procedure Recompiles in SQL Server 2008
In this session, Greg will describe the process by which SQL Server executes stored procedures and how it decides whether or not recompilations are necessary. He will discuss how to monitor recompilations and explain in detail the specific triggers that cause recompilation. Greg will then discuss techniques to be used when writing database code to help avoid the need for recompilations and to help keep systems performing well.
By the way, we will be giving away copies of Itzik Ben-Gan’s latest book, http://www.sql.co.il/books/tsqlfund2008/, to some of the lucky visitors to our booth within the exhibition hall..
