[EN] SQLBits XIV – pre-conf, sessions, discount and community

Largest SQL Server conference in Europe. Legendary SQL Bits. In March 2015 fourtheenth edition named: SQLBits SUPERHeroes will back to London {CONFERENCE PAGE}. This edition will be largest than ever, and most interesting ever. With some changes about pre-conf, sessions, and events arround everything sounds exciting. The orginizers team listen the audience, and this is result of it:

Precon Training

Duration: One Day

A full day of immersive content delivered by world class experts in their respective fields. These sessions are designed for you to focus on the subject of your choice. SQLBits XIV has the biggest range of precon sessions to date.

Normal Sessions

Duration: 60 minutes

The traditional format of SQLBits has been to run 60 minutes sessions on a given topic. We still continue to support this format during the course of SQLBits XIV 

Extended Sessions

Duration: 75 minutes

New to SQLBits XIV, and based on feedback by speakers as well who cite that some sessions require 75 minutes to deal with more complex or longer topics.

Double Sessions

Duration: 2 hours with a 15 minute break

When you are able to attract the best speakers in the world, we all want to spend more time with them. The Double session always both attendees and speaker to provide greater insights into the topics they present.

 

LOGO__SQLBits_SuperheroesDo you need more? Start to plan how many days you will spend in London, based on this question: What happens during the days?

  • Wednesday – Is a day dedicated to the Precon session format
  • Thursday    -  Is a combination of all the formats with half of the conference centre dedicated to the precon format, the other to the other formats
  • Friday – Is a combination of normal, extended and double sessions
  • Saturday– Is a combination of normal, extended and double sessions

Hundreds of standard sessions has been submitted and you can vote for those sessions (ten which you want to see) here. And if you are not sure about Pre-Conference seminars, look for the list:

Wednesday 4 March 2015

  • Become an Enterprise DBA with Sean McCown and Jennifer McCown Managing hundreds of servers is difficult if you haven’t been shown how. You need to change the way you think about your environment. Learning syntax isn’t enough. You have to put the different strategies together to be able to exercise your vision.
  • SQL Server Reporting Services with Chris Testa-O’Neill This precon will explore the creation of reports, through to the deployment and management of reports into production. Providing you with the ability to work productively with Reporting Services after completing the precon
  • Mastering T-SQL Querying Fundamentals with Itzik Ben-Gan T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
  • Understanding Execution Plans with Hugo Kornelis Reading and understanding execution plans is key to understanding and fixing ill-performing queries. This full-day seminar will teach you everything you need to know about execution plans. Attend this seminar if you want to hone your tuning skills!
  • Upgrading to Microsoft SQL Server 2014 with John Q Martin With Microsoft SQL Server 2005 going End Of Life in early 2016 it is vital to start planning your migration to a supported version of Microsoft SQL Server. let me help you get ready for this by helping you understand the process and tools available.
  • Storage and Virtualisation for DBAs with Denny Cherry This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution.
  • Optimize “All Data” with a modern data warehouse solution with Adam Jorgensen Most of the world’s data exists in a combination of on premise, cloud and non-relational forms. This session will teach you the options, best practices, and patterns to acquire, store, process and analyze all forms of data in a modern solution
  • A practical guide to using charts & graphs! with Dan Bulos Choosing between the multitudes of chart types can be challenging. The session will cover how to select the right style of chart to accomplish your purpose, whether that is analyzing data to gain insights or producing a dashboard.
  • Better Performance Through Parallelism with Adam Machanic This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
  • Data Wars: The Cloud Awakens with Matt Masson Come to this session to see the forces of business and IT armed with Power BI for Office 365 and Azure Data Services do battle with an increasing number of challenges in the workplace. Who will win?
  • A Day Inside SQL Server with Bob Ward If you want to know the internals of SQL Server then this is the session for you. Prepare to have your brain melt in this deep session from the man who knows.

Thursday 5 March 2015

 

And of course is not all. Pre-conf and standard conference day (Wed, Thu, Fri) are paid. Early bid price for full four days and SuperHero Party is 699 GBP. But as always Saturday is community day – so you are very welcome, even you not have budget for full four days (and You can join for Friday’s SuperHero Party). If you are member of SQL Server Community – doesn’t matter from where (from SQL Server FAQ in United Kingdom, or from Polish SQL Server User Group in Poland, or from different community)  you can get 5% discount from your User Group Leader – just ask.

I will be there, so see you in London ExCel!

[EN] SharePoint 2013 December 2014 CU is available

LOGO__SharePoint2013_bigintoMicrosoft SharePoint Product Group released two important updates packs in December: one for the SharePoint 2010 and one for the SharePoint 2013. In this post I writing about newest SharePoint product. Before you will go to download and install you should remember that this December 2014 Cumulative Update for the SharePoint 2013 (buld no 15.0.4675.1000) require SharePoint Server 2013 Service Pack 1 or March 2013 Product Update (PU) for SharePoint 2013, adnd this cumulative update does not include Service Pack 1, and the SharePoint Server 2013 CU contains the SharePoint Foundation CU, and the SharePoint Server 2013 with Project Server CU contains Project Server CU, SharePoint Server CU and SharePoint Foundation CU. Just be aware.

This time we get four goups of files and four knowledge base articles for all updates:

  • KB 2910945 – about SharePoint Foundation 2013 and few fixed problems
  • Assume that you configure a Security Assertion Markup Language (SAML) token provider for a SharePoint 2013 site. Then, you add the CookieHandler.Domain property to the web.config file of the site. When your session to the site is expired, you may be unable to log on to the site again.
  • When you browse to a SharePoint 2013 page that contains an UpdatePanel control, the page may be refreshed randomly. Therefore, if you type something in a text field on the page, the text field may become empty.
  • This hotfix improves managerial effectiveness in SharePoint 2013 by letting the administrators manage the language settings by using the Client Object Model.
  • Assume that you add an XsltListView Web Part to a SharePoint 2013 page, and the Web Part contains a link to another SharePoint 2013 site. When you click the link, you are redirected to an error page.
  • Assume that you create a subsite in a SharePoint 2013 site collection, then you open the Site Settings page of this subsite. When you try to open the Site columns page, it may take long time than expected.
  • Assume that you add an item that contains a choice field to a SharePoint library or list, and the field contains an ampersand (&) character, and then you save it. When you select the item and then click the View Item button or theView Properties button, the ampersand (&) character in the choice field does not appear correctly.
  • Assume that you send an email message that contains many attachments from an iPhone to a SharePoint 2013 document library. In this situation, the email message that is sent to the document library may contain an empty attachment that has no file name. Additionally, the other attachments may be missing.
  • Assume that you create a Lookup column in a custom list, and the lookup column gets information from a Date and Time type column. Then you create a standard view and set the lookup column in the Group By section. When you display the view in the custom list, the date is displayed in an incorrect format (MM/DD/YY instead of DD/MM/YY).
  • Assume that you open the Schedule page of a project in Project Web App (PWA). When you click the Print button on the Options tab to view the print preview information, the task bar is missing from the Gantt chart in the print preview window.
  • This hotfix improves managerial effectiveness in SharePoint 2013 by letting the administrators configure the SPSite.SecondaryContact property by using CSOM APIs.
  • You may be unable to create sub-folders while you are creating many sub-folders inside a folder in parallel.
  • After you run a content deployment job on a SharePoint 2010 Server, additional thumbnails of the original thumbnails are generated.
  • KB 2910938 – about SharePoint Server 2013 and few fixed problems
  • This hotfix improves crawl performance for SharePoint 2013 when deadlocks occur in the link databases.
  • This hotfix improves the accuracy of the Most Popular Items report by counting the usage event statistics for all documents in a SharePoint 2013 library.
  • This hotfix improves the @Mention feature on My Site pages by displaying the login when you move the pointer over a display name. This improvement helps you distinguish different users who share the same display name.
  • Assume that you configure a SharePoint 2010 farm to consume a Search service application of a SharePoint 2013 farm. Then you configure alternate access mappings for the SharePoint 2010 farm. In this situation, when you search for content in the SharePoint 2010 search center, the URLs that appear in the search result are incorrect.
  • In some cases the "Did you mean" spelling correction feature does not work on a multi-node SharePoint 2013 search farm.
  • In multi-node SharePoint 2013 search farm setup, the restart of the primary indexer node (for example for maintenance or applying updates) may cause a restart of the secondary node which results in a query outage during the restart of the primary node. This fix makes sure that the restart of the primary node does not lead to a restart of the secondary node. Therefore, the search service will still be available.
  • Assume that you sign in a SharePoint 2013 site by using Security Assertion Markup Language (SAML)-based claims authentication. When you search for content in the site, no result is returned.
  • When you use enterprise search in a SharePoint 2013-based server, the Best Bets feature may not work.
  • KB 2910911 – about SharePoint Server 2013 with Project Server and six important problems has been fixed
  • Assume that you add actual work to a task in a timesheet and then save it. Later, the project manager publishes another task, and the new task appears on the same timesheet. You add actual work to the new task and you submit the timesheet for approval. In this situation, the timesheet line for approval of the new task is not displayed in the Approval center.
  • Assume that you change the working time of the enterprise calendar associated with your project to a nondefault working timesuch as 9:00-17:00. Then you publish a task. You go to the Tasks page in Project Web App (PWA), then you change the finish date and the duration of the task and save the change. In this situation, both the finish hour and the task duration are incorrect.
  • Assume that you create a risk or an issue for a project in PWA, then you save it. When you visit a Project Centerview that includes Active Risks and Active Issues fields, the values are always zero.
  • Assume that you have a custom field that is defined to include a lookup table and the table contains many values. In this situation, you may be unable to select lookup table values from the custom field on a Project Detail Pages page that shows this field.
  • Assume that you apply a filter in the Approval Center in PWA. When you refresh the page, or when you go back to the Approval Center after you visit other pages, the filter is not applied though it is already set in the ribbon.
  • Assume that you set a baseline for a project, and then you publish and check in the project in PWA. When you open theSchedule project details page, the baseline value is incorrect. For example, the baseline value should be $1.00. However, it is displayed as $100.00
  • KB 2899574 – about Office Web Apps Server 2013 and just one small problem
  • You may be unable to create sub-folders while you are creating many sub-folders inside a folder in parallel.

You can downolad all necessary files (in total ca 10 GB size) directly from download center (almost directly – ‘cos you have to fill mail address twice uthorization code and next you will get download link on email message). Be aware tahta based on size of updates (eg. for SharePoint Server 2013 size is close to 3.5 GB) Microsoft splitted files for one .EXE file anf two .CAB files which are downloaded separately, but all are necessary for installation process:

After installing the fixes you need to run the SharePoint 2013 Products Configuration Wizard on each machine in the farm.

More related important links (from SharePoint Release Team) are below:

[EN] SharePoint 2010 December 2014 CU is available

Tile_ShrPtSvr10_h_rgbMicrosoft SharePoint Product Group released two important updates packs in December: one for SharePoint 2010 and one for SharePoint 2013. Let’s look for old SharePoint version. Before you will go to download and install you should remember that this December 2014 Cumulative Update (build no 14.0.7140.5000) require installed Service Pack 2 for SharePoint 2010, and is no longer support for Service Pack 2, and installation of base product and language packs are necessary, and SharePoint 2010 CU contain SharePoint Foundation CU (no double installation required).

Three files and three knowledge base articles for all:

  • KB 2899585 – about SharePoint Foundation 2010  and two important problems has been fixed:
  • Assume that you set the default value for a Date and Time column as the current date in a SharePoint 2010 custom list. When you create a new item to the list during 23:00 to 00:00, the date for this column is set as the next day.
  • Assume that you set an alert on a SharePoint 2010 Announcements list. When an alert email is triggered by an Announcements list item that contains many lines of content, the text in the mail body is formatted as strikethrough.
  • KB 2899583 – about SharePoint Server 2010  and few important problems has been fixed:
  • Assume that you start the User Profile Synchronization service on a SharePoint 2010 site collection. When a thumbnail for a profile picture is missing, the profile synchronization may fail because of a stopped-server error.
  • When you try to open a .pdf file from a search result on a SharePoint 2010 site, the .pdf file is opened in Adobe Reader instead of in the browser.
    Improves the integration of SharePoint 2010 and OneDrive for Business by letting administrators be able to add OneDrive for Business links on a SharePoint 2010 installation.
  • KB 2899587 – about Project Server 2010 and another two problems has been fixed:
  • When you change the view of the Project Center page and apply a different filter or grouping, the filter option and the grouping option do not change as expected, and the view may still be filtered or grouped based on the previous view.
  • Assume that you have a resource whose Latest Available date is set, and the resource’s calendar has exceptions. When you call the Resource.UpdateResources method, you may receive the "CalendarUnusedCalendarException" error message

You can downolad all necessary files (in total ca 3 GB size) directly from download center (almost directly – ‘cos you have to fill mail address twice uthorization code and next you will get download link on email message)

After installing the fixes you need to run the SharePoint 2010 Products Configuration Wizard on each machine in the farm.

More related important links (from SharePoint Release Team) are below: