I expected that August 2012 will be free of the community, conferences, meetings – and have some free days. I was wrong. As always. Except wedding party (not mine fortunatelly) and three days near Baltic Sea Coast with fantastic ladies I’m going to my first MVP Summit. Wait! In August? Easy. It’s not full MVP Summit (held as always in Feb/Mar in Redmond). Inside one of the biggest south European community conference: KulenDayz 2012 I’m going to MVP CEE & Italy Summit 2012.
KulenDayz 2012 is prepared by Microsoft Community Osijek together with Microsoft Croatia with support from INETA, Hupro, MIC Varaždin and Mreža. Conference is bringing together leading IT Experts from the region with local IT Community and giving them a chance to spend a weekend filled with attractive sessions presented by top speakers and relaxing at Kopacki Rit Nature Park and enjoying unspoiled nature.
MVP CEE & Italy Summit is more like a social event, an opportunity to meet other MVPs from the Region, networking and mingling with each other, and get to know the Microsoft vision for the next Fiscal Year (FY13, which started on July, 1st).
My trip for this event is not easy: by bus from Wroclaw to Warsaw, next night train from Warsaw to Budapest and after by daily train form Budapest to Osijek. I’m happy to stay one day in Budapest (for my lovely sightseeing) on Thursday. On Friday we have day for MVP’s and on Saturday many great sessions in seven tracks: Office 365, Development,Database, Private Cloud, Windows Phone, Project Management, Chalk & Talk
Amazing, isn’t? But of course sessions are not most important. For me the community, old friends and new faces are most important. Sharing knowledge, experiences and ideas. Hope to meet a lot of my friends from European community. So…
Let’s get, let’s get, let’s get, let’s get rocked Let’s get, let’s get, let’s get, let’s get rocked Let’s go all the way Get it night’n’day Come on, let’s get, let’s get, let’s get, let’s get rocked
September 2012. The Holidays (for some peoples) just over. First time ever, in the United Kingdom, exactly (from my perspective) in the center of England, SQL Server Peoples under flags: SQL Cambs and SQL PASS will meet in two days on the way of learning – with the brand: SQL Saturday. What is this? Based on SQL Saturday Home Page, the definition is simple: PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you’re attending a SQLSaturday or thinking about hosting your own, we think you’ll find it’s a great way to spend a Saturday – or any day.
Based on my previous experience (SQL Saturday in Dublin) I think that this will be really multicultural event. I expect few hundreds SQL Server fans from many different countries, such as UK, Germany, Ireland, Poland, Italy, The Netherlands, United States, Portugal, Brazil and more… The schedule for this event looks fantastic:
Friday, 7th September – The PreConf Workshops Day:
Data Visualisation Deep-Dive using SQL Server 2012 with Jen Stirrup (MVP)
Buck Woody’s Ragtime DBA Workshop with Buck Woody (Microsoft)
A Deep-Dive into the depths of the SQL Server storage engine and MDF file format with Mark Rasmussen (SQL Internals expert)
Saturday, 8th September – The Community Conference Day:
Conference Keynote by Buck Woody
Over thirty technical sessions in all levels – from beginner to advanced users
Special sponsors sessions
Super Special Prize Draw Session
List of speakers are really impressive – I have no idea how the organizers do that:
Jen Stirrup | Mobile Business Intelligence for Everyone, Now! Neil Hambly | Extended Events – New Age of Profiling David Peter Hansen | Layered Partitioning – (re)load your data fast Mark Pryce-Maher | Creating SSMS 2012 Add-ins for Crash Test Dummies Aaron Bertrand | T-SQL : Bad Habits and Best Practices Andrè Kamman | Practical PoSh – Design and build larger scripts Tobiasz Koprowski | 2 AM. A Disaster just began… Chris Testa-O’Neill | Understanding Microsoft Certification in SQL Server Andy Leonard | Designing an SSIS Framework David Morrison | Query Plan Operators Deep Dive Niko Neugebauer | Inheriting a database for Developers Gavin Payne | I want to be a better architect Dave Ballantyne | What’s new in SQL Server 2012 – TSQL Duncan Sutcliffe | The Magic of SQL Server 2012 BI in SharePoint Martin Cairns | Partitioning Design for Performance and Maintainab Bob Duffy | SQL 2012 Always On-Deep Dive Hugo Kornelis | Make Your Queries Fly With Columnstore Indexes Peter Baddeley | I work with SQL why should I care about SharePoint Allan Mitchell | SQL Server 2012 SSIS Change Data Capture Mark S. Rasmussen | Optimizing Storage and Performance Using Page and Rob Volk | Tame Your Unruly Data…With Constraints! Tobiasz Koprowski | Welcome to the Licensing Nightmare Chris Webb | Intro to Tabular Model in Analysis Services 2012 Laerte Junior | Troubleshooting SQL Server with PowerShell Alex Whittles | Merge-tastic: a better way of loading dimensions Phil Quinn | XML: The Marmite of SQL Server Chris Testa-O’Neill | Notes on SQL 2012 Highly Available BI Environments Bruno Basto | SQL Internal Storage Gavin Payne | NUMA Internals of SQL Server 2012
As You – probably – see above:
This SQL Saturday No 162 will be my first (and not last this year) SQL Saturday where I have big opportunity for speaking. And – THANK YOU ORGANIZERS – I will be speaker twice:
2 AM. A Disaster just began… | Level: Intermediate | Room 3 | 09:20 AM | ABSTRACT
Welcome to the Licensing Nightmare | Level: Intermediate | Room 4 | 02:35 PM | ABSTRACT
So, after: SQL Bits 9 Query Across Mersey in last year, SQL Saturday No 105 (Lightening Talks) & SQL Bits X in this year – this event will be my fourth speaking and second full session in foreign language. I am really, really exciting. I You want to learn a lot of facts, myths, half-truths about SQL Server for administrators, developers, architects and managers, from real experts from different companies, from many Microsoft Certified Professionals (on every levels), from Microsoft Certified Trainers, Microsoft Certified Masters and finally from Microsoft Most Valuable Professionals just save the DATE: 7th & 8th September; PLACE: Cambridge, UK; PRICE: £190 + VAT (at 20%) for PreConfs and FREE for Saturday Conference. And of course register here: SQL Sat #162.
Post Scriptum: please follow us and share Your availability on social networks:
One week ago, and two weeks after releasing Service Pack No 2 for SQL Server 2008 R2, Microsoft published first Cumulative Update for this environment. Let’s look for a moment for this update.
In this Cumulative Update 1 [version build: 10.50.4260.0] Microsoft resolved a lot of requested issues for:
SQL Server Analysis Services SQL Server Reporting Services SQL Server SQL Engine SQL Server Client Tool SQL Server Connectivity
If You read my previous posts about Cumulative Updates (all You can find here) You probably see the differences between previous posts and current post. I decided to not listing number of fixed bugs, based on conversation with Abhishek Sinha (from Microsoft SQL Server Team) and my friend Aaron Bertrand (from SQL Sentry). But of course I will publish official list of fixed bugs. See below:
VSTS BUG: 956227 | 2511963 FIX:Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session
VSTS BUG: 956228 | 2543687 FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2
VSTS BUG: 956225 | 2554905 FIX:"File error: Data may have been lost" error message when you use Excel 2010 to open an Excel report file that was exported from SSRS 2008, from SSRS 2008 R2 or from SSRS 2012
VSTS BUG: 969181 | 2618676 FIX:Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2
VSTS BUG: 980532 | 2625768 FIX:A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2
VSTS BUG: 956212 | 2637802 FIX:Pages of an SSRS 2008 R2 or an SSRS 2012 report are delivered incorrectly if you use the ReportExecutionService.Render method to render the report in image format or in EMF format
VSTS BUG: 980515 | 2658474 FIX:Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012
VSTS BUG: 969183 | 2661644 FIX:Access violation in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2
VSTS BUG: 956226 | 2665649 FIX:"bufferLen >= colLen" assertion when you run a parallel query in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012
VSTS BUG: 969185 | 2667037 FIX: "The connection string format is not valid" error when you try to create a maintenance plan for a SQL Server 2008 R2 server
VSTS BUG: 980534 | 2673997 FIX:"The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012
VSTS BUG: 980525 | 2674636 FIX:The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2
VSTS BUG: 956218 | 2675233 FIX:Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2 or in SSAS 2012
VSTS BUG: 956213 | 2675522 FIX:Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 or in SQL Server 2012
VSTS BUG: 956224 | 2678796 FIX:You cannot search a Word document or an Excel workbook that is exported from an SSRS 2008 R2 or an SSRS 2012 report by using a keyword in the content of the document or of the workbook in SharePoint 2010
VSTS BUG: 956221 | 2679342 FIX:The field list of the dataset disappears unexpectedly when a report uses a query as a dataset that includes named parameters in SQL Server 2008 R2 or in SQL Server 2012
VSTS BUG: 956229 | 2682819 FIX:SQL Server 2008 R2 may stop responding when you perform many Update Cube writeback transactions on multiple cubes that belong to different SSAS 2008 R2 or SSAS 2012 databases
VSTS BUG: 956204 | 2685132 FIX:The log shipping restore job restores a corrupted transaction log backup to a secondary database when you run a log shipping backup job on an instance of SQL Server 2008 R2 or an instance of SQL Server 2012
VSTS BUG: 956230 | 2689903 FIX:A non-convergence occurs when you run a merge replication publication that uses web synchronization if the value of a column is NULL in SQL Server 2008 R2 or in SQL Server 2012
VSTS BUG: 980517 | 2696161 FIX:Error message when you try to view a report in SSRS 2008 R2: "Different query parameters resulted in a same hash"
VSTS BUG: 969189 | 2697983 FIX:An incorrect value is stored in the TIME_ZONE column of the BACKUPSET table in SQL Server 2008 R2
VSTS BUG: 956215 | 2698639 FIX:Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2
VSTS BUG: 969191 | 2699013 FIX:SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged
VSTS BUG: 956206 | 2700227 FIX:Error message when you try to create a data service document in a data feed library from a sub-site collection in SharePoint 2010 to publish Atom feeds: "There is no file with URL"
VSTS BUG: 980529 | 2703152 FIX:Access violation when you call a CLR stored procedure that references a user-defined table type parameter in SQL Server 2012 or in SQL Server 2008 R2
VSTS BUG: 969193 | 2703214 FIX:SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert and an OS error occurs
VSTS BUG: 969195 | 2706519 FIX:An exception occurs when the SqlCommandBuilder.DeriveParameters method is used to retrieve parameter information from a CLR stored procedure in SQL Server 2008 R2
VSTS BUG: 969197 | 2706601 FIX:Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services
VSTS BUG: 969199 | 2707015 FIX:rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2
VSTS BUG: 969201 | 2708027 FIX:"An error has occurred during report processing" error message when you try to preview an SSRS 2008 R2 report after you set the dataset collation to Greek or Greek_100
VSTS BUG: 969203 | 2708726 FIX:Performance Monitor .dll files in the system32 folder are not updated after you apply updates to SQL Server 2008 R2
VSTS BUG: 969207 | 2713501 FIX:A deadlock occurs when you alter a partition and run a statement against the partition at the same time in SQL Server 2008 R2
VSTS BUG: 969209 | 2714634 FIX:SQL Server 2008 R2 takes a long time to generate scripts for a partitioned table that uses the data compression feature
VSTS BUG: 969213 | 2715289 FIX: Incorrect results when you convert a datetimeoffset column to a smalldatetime column in SQL Server 2008 R2 when there is an index on the datetimeoffset column
VSTS BUG: 969211 | 2715312 FIX:Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2
This time I have another interesting information. Before You start upgrade go to Abhishek’s post on MSDN blog to looking for important information:
Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 1
You may have to restart the computer after you apply this cumulative update.
If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for 32-bit, 64-bit and Itanium). This release is prepared as multilingual package.
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.