[EN] SQL Server 2005 SP3 Cumulative Update 15 is now available

LOGO_SQLServer2005Today Microsoft released a series of updates for SQL Server. This and next three post are focused on this releases.

Cumulative update package no. 15 for SQL Server 2005 SP 3 [version build: 9.00.4325] fixed eight issues in total:
* five issues for SQL Server Engine
* three issues for SQL Server Integration Services

Below You can find short information about fixed bugs:

VSTS BUG: 674478| KB Article: 2481274
FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 674481| KB Article:  2490920
FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008

VSTS BUG: 676906| KB Article:  2498818
FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

VSTS BUG: 669725| KB Article:  2510788
FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package is aborted

VSTS BUG: 676769| KB Article:  2515286
FIX: "There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005

VSTS BUG: 674497 | KB Article:  2511151
FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005 or in SSIS 2008

It’s very important!! Before You trying to install this cumulative updates, You must:

  • SQL Server Install Service Pack 3 – get it HERE
  • enable SMO (SQL Server Management Object) extended stored procedures
  • enable SQL-DMO (SQL Server Distrubuted Manajement Object) extended stored procedures

More information about this release You can find with the article: Cumulative Update 15 for SQL Server 2005 Service Pack 3

If You want to go directly to download seccion go to Request Hotfix Download Site, where You can choose language (English, Spanish, Chinese, French, German, Italian, Russian, Korean, Japanese)   and version (for 32-bit, 64-bit, itanium).

[EN] 14 Hours of free Critical Path Training

LOGO__CriticalPathTrainingBased on succesfull series of free webinars on demand, the Great Team from Critical Path Training (with collaboration form worldwide friends and SharePoint experts) decided to prepare new cycle of training. This time it will be “14 SharePoint Thursday’s” Each Thursday – starting at 7th April you should reserve one hour for SharePoint. It will be interesting? Read more information below (copied from Critical Path Training site):

Building Silverlight Applications for SharePoint
Andrew Connell | REGISTER HERE
Thursday, April 7, 2011 2p-3p EDT (6p-7p GMT)
SharePoint 2010 introduced numerous capabilities available to developers for building rich Silverlight applications. In this session we’ll take a look at what is available to you specifically in the Client Object Model & REST services. We’ll also look into some tips and tricks to improve the performance of your Silverlight application and how to leverage the very popular MVVM design pattern when building applications for SharePoint 2010.
   
Using InfoPath 2010 and SharePoint Designer 2010 to manage SharePoint List Forms
Asif Rehmani
| REGISTER HERE
Thursday, April 14, 2011 2p-3p EDT (6p-7p GMT)
SharePoint Designer has been a great tool to customize SharePoint list forms for a long time. Now in SharePoint 2010, you can use InfoPath 2010 to customize the forms as well. What’s the difference? Why should you use one tool over the other for this purpose? This session shows how each functionality works and explores the pros and cons of using each method to customize your SharePoint list forms. 
 
SharePoint Ribbon Customization Deep Dive
Andrew Connell
| REGISTER HERE
Thursday, April 21, 2011 2p-3p EDT (6p-7p GMT)
SharePoint 2010 introduced a new paradigm in the user experience: the ribbon. This user friendly control contains all the controls and tools available to users when interacting with SharePoint to get their job done. Developers can customize and extend the ribbon for custom solutions. In this session we’ll examine the different components of the ribbon as well as how to create page components, asynchronous callbacks and prompt the user with intuitive dialogs.
 
Data Access Shoot-out
Ted Pattison
| REGISTER HERE
Thursday, April 28, 2011 2p-3p EDT (6p-7p GMT)
When developing for SharePoint 2010, there are many different was to access items in a list. When writing server-side code you can use the SPQuery class or the SPSiteDataQuery class. You can optionally use the new LINQ  to SharePoint Support which enabled you to write LINQ query statements against SharePoint Lists. When writing client-side code in JavaScript or Silverlight you can use the CamlQuery class provided by the new client-side object model. You also have the option of using the new REST-based Web service built into SharePoint Foundation or creating your own custom Web Service. This means there are different 6 ways for you to query and update items. This sessions examines each of these techniques in depth and reveals their strengths and weaknesses in terms of performance, productivity and maintainability.
 
SharePoint ALM (TFS and unit testing in SharePoint projects)
David Mann | REGISTER HERE
Thursday, May 5, 2011 2p-3p EDT (6p-7p GMT)
SharePoint has long since moved into the realm of "business critical applications" and yet most SharePoint development is still done without the benefit of modern, robust tools and practices. This needs to change. NOW. As practitioners of our craft, we need to improve our ability to deliver solid, robust solutions on the SharePoint framework. But how exactly do we do that? This session will demonstrate topics and tools to help us improve our processes and deliver more reliable, high-performance code in less time. Taking your SharePoint development skills to the next level is not a matter of working harder; it is a matter of working smarter.
 
Customizing the Appearance of External Lists
Scot Hillier | REGISTER HERE
Thursday, May 12, 2011 2p-3p EDT (6p-7p GMT)
The External List is the primary user interface element for presenting External Data through Business Connectivity Services (BCS). While creating External Lists can be done easily through the SharePoint Designer, you will often want to customize the way data appears. Common issues include no support for date-only columns, no support for complex values, handling unsupported data types, data validation, and error reporting. In this session, we’ll examine how to overcome these issues using techniques ranging from simple to advanced. Attendees will exit the session ready to customize the appearance of External Data in SharePoint. 
 
Incorporating Managed Metadata in Custom Solutions in SharePoint 2010
Andrew Connell | REGISTER HERE
Thursday, May 19, 2011 2p-3p EDT (6p-7p GMT)
The Managed Metadata Service application in SharePoint 2010 allows users to create and utilize taxonomies in various ways. Microsoft has included a robust taxonomy API in SharePoint 2010 that can be leveraged in custom solutions. In this session we’ll explore how you can import taxonomies programmatically and create custom solutions that leverage taxonomies in various ways.
 
Cram session: SharePoint Certification Exam prep
Ted Pattison | REGISTER HERE
Thursday, May 26, 2011 2p-3p EDT (6p-7p GMT)
In this action-packed session, Ted Pattison will discuss preparing for Microsoft’s two developer-oriented certification exams for SharePoint 2010 which include Technical Specialist Exam 70-573 and Professional Exam 70-576. In this session Ted will discuss the format of each exam and cover the important developer topics that you need to know to pass both exams. Be forewarned. There is a lot of information to cover, so be prepared to absorb a great deal of content in a short time frame.
 
Office 365
David Mann | REGISTER HERE
Thursday, June 2, 2011 2p-3p EDT (6p-7p GMT)
Office 365 is a game changer. It is a freight train barreling towards us without brakes. If we aren’t ready for it, we’ll be left in its wake wondering what just roared past us leaving all of our hard-earned skills by the wayside. This session will start with an overview of Office 365 and then drill in on development opportunities, gotchas and limitations of SharePoint Online that are important to know if you want to catch a ride on the next big thing in the IW/Collaboration space.
 
Developing & Extending SharePoint Server 2010 Enterprise Content Management
Andrew Connell
| REGISTER HERE
Thursday, June 9, 2011 2p-3p EDT (6p-7p GMT)
Microsoft made considerable investments in the Enterprise Content Management capabilities in SharePoint 2010. While SharePoint 2010 includes many OOTB features, Microsoft has provided many extensibility points for developers to create robust and custom solutions for ECM scenarios. This session you will demonstrate how to create document sets declaratively to promote reuse across multiple SharePoint environments. In addition you will see how to introduce custom business logic into the creation of document IDs and interacting with managed metadata programmatically.
 
Create Powerful Pages Without Code!

Wendy Henry | REGISTER HERE
Thursday, June 16, 2011 2p-3p EDT (6p-7p GMT)
SharePoint 2010 gives Power Users and Administrators alike the ability to create powerful, interactive web pages without writing any programming code! Join us in this webinar to learn all of the different ways you can give site users an interactive interface to manipulate the business data exposed on a SharePoint web page. SharePoint 2010 gives site administrators, designers and even power users many tools for creating custom pages from connecting web parts via a web browser application or SharePoint Designer 2010. This webinar will demonstrate various solutions for connecting web parts on a web page and controlling their exposure to site visitors.
 
Examine Business Information in SharePoint from the Best Point of View
Wendy Henry | REGISTER HERE
Thursday, June 23, 2011 2p-3p EDT (6p-7p GMT)
SharePoint 2010 offers information workers as well as list managers and site administrators the ability to sort, filter, and format the business information exposed on a SharePoint web site page. Join us in this webinar and learn how to boost your own personal productivity by taking advantage of SharePoint 2010 personalization features. If you are a list manager or site administrator, learn to enhance your site visitors’ experience when viewing SharePoint business data via a web browser application. This webinar will demonstrate various solutions for creating and exposing custom views of lists, libraries and pages.
 
Extending the SharePoint 2010 Newsfeed
Matt McDermott, MVP
| REGISTER HERE
Thursday, June 30, 2011 2p-3p EDT (6p-7p GMT)
The SharePoint 2010 Newsfeed is the new My Site home page. This presentation demonstrates a centralized approach to building applications that publish activities to the newsfeed. In this session you will learn how to create a custom Activity Application and publish Activity Items from external events. This session will also address best practices and pitfalls of working with Activity Events including multilingual considerations and custom Event Types.
 
SharePoint Development in the Cloud
Wouter Van Vugt
| REGISTER HERE
Thursday, July 7, 2011 2p-3p EDT (6p-7p GMT)
An important emerging trend for SharePoint is to make use of cloud based offerings. SharePoint 2010 brings new capabilities that allow hosting and customization to play nice together. In this session you will learn about these capabilities and how you can take your code-based solution to the next level without diminishing important functionality. Making your solution ready for deployment into the cloud!

More information You can find at Critical Path Training site.
  
 

[PL] 24 godziny z SQL, tym razem z WITkami – dzień drugi

Druga odsłona marcowej edycji 24 Hours of PASS juz za nami. Drugi dzień to kolejne dwanascie godzin sesji, poświeconych zagadnieniom zarządzania i programowania  baz danych oraz inteligencji biznesowej (DBA, DEV, BI). Dwanaście sesji, z których kilka utkwiło mocniej w pamięci:

Session 13 (BI) | Presenter: Jes Borland (340)
Reporting Services 201: the Next Level
Session 14 (DBA) | Presenter: Wendy Pastrick (420)
Replication, Log Shipping and Mirroring: Oh My!
Session 15 (Dev) | Presenter: Julie Lerman (330)
Entity Framework: Not as Evil as You May Think
Session 16 (DBA) | Presenter: Vyshnavi Thota (550)
All about SQL Server Memory Settings for DBAs
Session 17 (BI) | Presenter: Pam Shaw (450)
Tips & Tricks for Dynamic Reporting Services Reports
Session 18 (Dev)
| Presenter: Audrey Hammonds (720)
T-SQL Awesomeness: 3 Ways to Write Cool SQL
Session 19 (BI) | Presenter: Jyoti Gupta (460)
Intelligent ETL with SQL Server
Session 20 (BI) | Presenter: Erika Bakse (360)
Clever Queries: Crafting MDX Queries to get the Most out of SSRS
Session 21 (Dev) | Presenter: Karen Lopez (560)
Five Physical Database Design Blunders and How to Avoid Them
Session 22 (BI) | Presenter: Kathi Kellenberger  (480)
What You Don’t Know about SSRS 2008R2
Session 23 (DBA) | Presenter: Michelle Ufford (400)
Index Internals for Mere Mortals
Session 24 (DBA)
| Presenter: Lynn Langit (390)
TwitterData on Azure (end-to-end demo) – How We Did It

A które były bardziej interesujące? Świetnie poprowadziły swoje sesje Julie Lerman, choć zaskoczyło to niektórch uczestników, że mało osób na tej sesji było. Doskonałe sesje Audrey Hammonds i Karen Lopez, oraz bardzi ciekawe Jyoti Gupty i Wendy Pastrick. Zupełnie do mnie nie dotarła sesja Vyshnavu Thoty – tutaj akurat zupełnie się zdziwiłem. Z ciekawej sesji prowadzonej po hiszpańsku dzień wcześniej, ponad sto pięćdziesiąt osób uciekło ze względu na barierę językową. Tymczasem podczas tej sesji to ja miałem barierę – angielski w narzeczu hindi jest kompletnie niezrozumiały. Prelegentka mówiła tak, że trzeba było, albo koncentrować się na jej zdaniach, albo na slajdach (ja wybrałem to drugie rozwiązanie).

Za niedługi czas sesje mają być dostępne do obejrzenia, będzie więc można je sobie powtórzyć (na przykład podczas nudnego lotu samolotem).