[EN] 1Q 2015 and my public speaking and presence (updated)

public-speaking

As I expected, and as I planned – year 2015 should be more busy, more funny, more special than every previous years in my “community area age”. I can split all my public speaking and presence plans for three roles: attendee, speaker and trainer. And here are my plans for first three months of current year.

Attendee:

Sometimes I’m going for user group meetings, conferences, public debates or just exhibition just for attending. To hear someone, to see something, to be inspired. I have plans for attending for events below:

User Group Meetings in series of #GeekWeekWro

    User Group Meetings

      • Information Security Division|Wroclaw, Poland|16th Jan {SITE|FACEBOOK}
      • Leicester Speakers Club|Leicester, England|9th Feb {SITE}
      • Leicester SQL Server User Group|Leicester, England|18th Feb {SITE|TWITTER}
      • British Computer Society|Leicester, England|19th Feb {SITE|HEADSITE}|cancelled by me
      • Oxford SQL Server User Group|Oxford,England|26th Feb {TWITTER}|cancelled by me
      • SharePoint User Group UK|Leicester, England|12th Mar {SITE}
      • Polish Information Processing Society Board Meeting|Warsaw, Poland|21 Mar|
      • SharePoint User Group UK|Cambridge, England|24th Mar {SITE}

      Conferences

        • SharePoint Saturday Sweden|Stockholm,Sweden|14th Feb {SITE|TWITTER}
        • SQL Saturday No #374|Vienna, Austria|28th Feb {SITE|TWITTERHASH}|cancelled by me
        • SharePoint Saturday AbuDhabi|Abu Dhabi, United Arab Emirates|14th Mar {SITE|TWITTER}|cancelled by me
        • Cloud Expo Europe|London, UK|11-12 Mar {SITE|TWITTER}
        • Data Centre
        • SEMAFOR 2015. Security Management Audit Forum|Warsaw, Poland|26-27 Mar {SITE}

        Speaker:

        Speaking is one of the favourite part of my life. I love speaking and sharing knowledge. Even sometimes I failed (based on some reasons) I always try to do my next session better and better. And I will try to get as many sessions as possible this year, because only live experience is the right way to the top. My speaking in this quarter is limited but bigger than I expected on New Year’s Eve:

        User Group Meetings

          • Sweden SQL Server User Group|Stockholm, Sweden|12th Feb {SITE|FACEBOOK}|session: TBA
          • Sweden SQL Server User Group|Malmö, Sweden|13th Feb {SITE|FACEBOOK}|session: TBA
          • SQL Cardiff User Group|Caerdydd, Cymru|31tst Mar {SITE|FACEBOOK}|Battle of the Beards > session: SQL Azure Tips and Tricks for beginners

          Conferences

            • PASS SQLRally Nordic 2015|Copenhagen, Denmark|2nd-3rd Mar {SITE|TWITTERHASH}|session: SQL Security in the Cloud
            • XIV SQLBits SuperHeroes Edition|London, England|4rh-7th Mar {SITE|TWITTER|FACEBOOK}|session: AD2015. 2AM A Disaster just Began…
            • 7th Enterprise Cloud Computing and Virtualization|London, England|18th Mar {SITE|TWITTER}|session: Trust. The Primer and will be Cloud Security Panelist
            • Cluj Innovation Days|Cluj-Napoca,Transylvania|19-20 Mar {SITE|FACEBOOK}|session: Data Cloud Innovation
            • CEE MVP Open Days|Belgrade, Serbia|29-30 Mar {SITE|TWITTER|FACEBOOK}|session: You’re MVP? Go To Travel!

            Trainer:

            Actually is basement for my surviving. I have some training scheduled, and I’m working on other which I can put into my calendar. As independent trainer I can choose any training for/from any company and I have no barriers. I’ve scheduled my authored MasterClass: SharePoint 2013 for ITPro with CQURE Academy {TWITTER|SITE} another courses with The Knowledge Academy {TWITTER|SITE}, and I’m writing now two new authored courses, which should be available from beginning of second quarter. Locations? Nothing in Poland, just in United Kingdom, The Netherlands, East Midlands and Scandinavia.  I’m also open for consultancy, implementation and audits project, definitely more in this year than in previous decade.

            [EN] SQL Server 2014 RTM Cumulative Update #6 is available!

            LOGO__SQLServer2014downloadIn February Microsoft released only one package for SQL Server. And it is for SQL Server 2014 RTM. In this Cumulative Update No 6 {build no 12.0.2480.0} Microsoft resolved over sixty bugs and problems, so it’s another one very big update. They solved many problems for Reporting Services, Analysis Services, MDS, SQLOS, and Setup. Most interesting from my perspective are below and of course list of all fixed problems are later in this post. 

            FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
            FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
            FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode
            FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
            FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
            FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
            FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
            FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014
            FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014
            FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014
            FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days
            FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking

             

            VSTS bug: 3720641 | KB: 2840657
            FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014
            Master Data Services (MDS)

            VSTS bug: 3720632 | KB: 2994082
            FIX: Error when you edit models for some groups or users in MDS for SQL Server 2012 or SQL Server 2014
            MDS

            VSTS bug: 3720667 | KB: 2995211
            FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 or 2014 report
            Reporting Services

            VSTS bug: 4067294 | KB: 2995622
            FIX: “Specified cast is not valid” when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014
            Integration Services

            VSTS bug: 3720645 | KB: 2997020
            FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012 or 2014
            Reporting Services

            VSTS bug: 3720652 | KB: 3000494
            FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
            Reporting Services

            VSTS bug: 3720673 | KB: 3000562
            FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
            Reporting Services

            VSTS bug: 3720674 | KB: 3001713
            FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012 or SSRS 2014
            Reporting Services

            VSTS bug: 3720679 | KB: 3003102
            FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012 or SSRS 2014
            Reporting Services

            VSTS bug: 4067278 | KB: 3006838
            FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time
            Analysis Services

            VSTS bug: 3720692 | KB: 3008135
            FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
            SQL service

            VSTS bug: 3720693 | KB: 3008416
            FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 or SSRS 2014
            Reporting Services

            VSTS bug: 4067279 | KB: 3010148
            FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS
            Analysis Services

            VSTS bug: 3720691 | KB: 3010773
            FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode
            SQL service

            VSTS bug: 4067280 | KB: 3011465
            FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 is under memory pressure
            SQL service

            VSTS bug: 3720661 | KB: 3013551
            FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
            SQL service

            VSTS bug: 3720668 | KB: 3013553
            FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014
            Integration Services

            VSTS bug: 4067265 | KB: 3016165
            FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server
            SQL service

            VSTS bug: 4067285 | KB: 3016384
            FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
            Analysis Services

            VSTS bug: 4067289 | KB: 3017544
            FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently
            Analysis Services

            VSTS bug: 4067291 | KB: 3019110
            FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013
            SQL service

            VSTS bug: 4067300 | KB: 3021757
            FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function
            SQL service

            VSTS bug: 3989801 | KB: 3023634
            FIX: Conversion error occurs when you use a business rule in SQL Server 2012 or SQL Server 2014 MDS
            MDS

            VSTS bug: 4067301 | KB: 3024790
            FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
            Setup & Install

            VSTS bug: 3986465 | KB: 3024815
            FIX: Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014
            SQL performance

            VSTS bug: 4067305 | KB: 3025408
            FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014
            Analysis Services

            VSTS bug: 3915402 | KB: 3025845
            FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014
            SQL service

            VSTS bug: 4067260 | KB: 3026082
            FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
            SQL service

            VSTS bug: 4067263 | KB: 3026083
            FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014
            SQL service

            VSTS bug: 4067310 | KB: 3027214
            FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014
            Management Tools

            VSTS bug: 3967105 | KB: 3027847
            FIX: Date conversion error when you use German SQL Server 2014 MDS in a German Windows operating system
            MDS

            VSTS bug: 3916894 | KB: 3027860
            FIX: Error 17066 or 17310 during SQL Server startup
            SQL service

            VSTS bug: 4067313 | KB: 3028216
            FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014
            Analysis Services

            VSTS bug: 4067302 | KB: 3028226
            FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 or SSRS 2014
            Reporting Services

            VSTS bug: 4067275 | KB: 3028322
            FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014
            Reporting Services

            VSTS bug: 4067296 | KB: 3029126
            FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube
            Analysis Services

            VSTS bug: 3856439 | KB: 3029762
            FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014
            SQL service

            VSTS bug: 4067312 | KB: 3029825
            FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014
            SQL performance

            VSTS bug: 4001583 | KB: 3029977
            FIX: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014
            SQL service

            VSTS bug: 3885366 | KB: 3030041
            FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014
            Setup & Install

            VSTS bug: 3921521 | KB: 3030325
            FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh
            Analysis Services

            VSTS bug: 3891407 | KB: 3030326
            FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013
            Analysis Services

            VSTS bug: 3749961 | KB: 3030619
            FIX: Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014
            SQL service

            VSTS bug: 3745645 | KB: 3032067
            FIX: Access denied when a newly added user browses to an MDS website in SQL Server 2014
            MDS

            VSTS bug: 3891762 | KB: 3032068
            FIX: No MDSTrace.log file is generated after you enable tracing in the MDS 2014 web.config file
            MDS

            VSTS bug: 4098462 | KB: 3032087
            FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014
            Management Tools

            VSTS bug: 3859399 | KB: 3034297
            FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days
            Management Tools

            VSTS bug: 4072235 | KB: 3034615
            FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014
            SQL service

            VSTS bug: 4045776 | KB: 3034679
            FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
            High Availability

            VSTS bug: 4084380 | KB: 3035071
            FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command
            Management Tools

            VSTS bug: 4084413 | KB: 3035077
            FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking
            Management Tools

            VSTS bug: 4050736 | KB: 3035165
            FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014
            SQL service

            VSTS bug: 3894942 | KB: 3036328
            FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014
            SQL service

            VSTS bug: 3988942 | KB: 3036330
            FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005
            Management Tools

             

            This update could be applied to applies to

            – Microsoft SQL Server 2014 Developer

            Microsoft SQL Server 2014 Enterprise

            Microsoft SQL Server 2014 Express

            Microsoft SQL Server 2014 Web

            Microsoft SQL Server 2014 Standard

            SQL Server 2014 Reporting Services

            Microsoft SQL Server 2014 Business Intelligence

            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 6

            You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: (1) Install the service pack on the passive node (2) Install the service pack on the active node (This step requests service restart).

            If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

            • SQLServer2014_RTM_CU6_3031047_12_0_2480_x64 (641 MB)
            • SQLServer2014_RTM_CU6_3031047_12_0_2480_x86 (384 MB)

            Enjoy!

            [EN] PowerShell? Few free lessons.

            It’s always good time to learn Powershell. Even you (or me) don’t really interesting now about it, soon we will be. Because technology is changing, because new systems and application from and for Microsoft technology is more, and more focused on ‘this kind of management’. So why nnot start to learn how it works, what we can do, where we can do and what we can do with Powershell version 4.0

            I got advert (probably on right side of Facebook page), but advert and link is not as important as free material. One PDF  short book and free extra videos, slides, codes and samples from Veeam. Here is the list of extra materials:

            Kickstart your PowerShell experience {LINK}
            The first episode we will focus on taking your first steps into the PowerShell world:
            Understanding CMDlets
            Storing Values
            Looping
            The Pipeline

             
            Getting stuff done with PowerShell {LINK}
            The second episode we will focus on some simple scripts and useful available options unique to PowerShell:
            Reporting
            Job Scheduler
            Creating your Own Scripts
            Remote Execution

            Automate your Veeam Experience {LINK}
            The last episode we will focus on Veeam integration with PowerShell:
            Custom Reporting
            Creating Jobs
            Mass Job Updates
            Custom Scheduling

            If you want to learn, go to page http://go.veeam.com/powershell-study-guide-ty/ register and start to play with PowerShell.