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

LOGO__SQLServer2014On June 22nd (about week ago) Microsoft released two packages of updates. First package is the Cumulative Update No 8 {bulid no 12.0.2546.0} for Microsoft SQL Server 2012 SP2 and Microsoft fixed about forty bugs. Released list of bugs are below:

VSTS BUG: 4523243 | 3067826
An “Access Violation” occurs when you connect to an instance of SQL Server 2014
SQL service

VSTS BUG: 4778150 | 3067257
FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 4745322 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4544422 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTS BUG: 4638931 | 3058512
FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014
Integration Services

VSTS BUG: 4719045 | 3064784
FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014
SQL service

VSTS BUG: 4745295 | 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012
Analysis Services

VSTS BUG: 4745316 | 3047538
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 4520890 | 3067896
Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014
SQL performance

VSTS BUG: 4715603 | 3070139
FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014
SQL service

VSTS BUG: 4516100 | 3069488
“Non-yielding Scheduler” error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance
SQL service

VSTS BUG: 4745318 | 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL connectivity

VSTS BUG: 4745324 | 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type
Reporting Services

VSTS BUG: 4745309 | 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server
SQL security

VSTS BUG: 4745305 | 3043889
FIX: The chart in SSRS 2012 or SSRS 2014 report is not updated correctly when you update the parameter in the URL of the report
Reporting Services

VSTS BUG: 4744173 | 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4336261 | 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 or SQL Server 2014 MDS
Master Data Services(MDS)

VSTS BUG: 4638932 | 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014
Management Tools

VSTS BUG: 4838266 | 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014
SQL service

VSTS BUG: 4320465 | 3048734
FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE
SQL service

VSTS BUG: 4319316 | 3048627
FIX: “Cannot access the specified path or file on the server” when you use CSV in SSMS to back up or restore database
Management Tools

VSTS BUG: 4794520 | 3067968
FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014
SQL service

VSTS BUG: 4465182 | 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem
Management Tools

VSTS BUG: 4745307 | 3051993
FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider
SQL service

VSTS BUG: 4488005 | 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014
MDS

VSTS BUG: 4745314 | 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages
Integration Services

VSTS BUG: 4745709 | 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012
Integration Services

VSTS BUG: 4745297 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

VSTS BUG: 4745299 | 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

VSTS BUG: 4729309 | 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014
SQL performance

VSTS BUG: 4745312 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4632737 | 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014
SQL performance

VSTS BUG: 4729310 | 3063054
Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures
SQL service

VSTS BUG: 4745330 | 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder
Setup & Install

VSTS BUG: 4745711 | 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry
SQL service

VSTS BUG: 4728820 | 3067659
FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks
SQL service

VSTS BUG: 4633760 | 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source
Analysis Services

VSTS BUG: 4507041 | 3055646
FIX: Error 35377 when you run a parallel query that contains MERGE statements in SQL Server 2014
SQL service

 

Newest part of updates is published list detailed publishing time and name of all necessary files in the package. The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

x64-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

 

This update could be applied Microsoft SQL Server 2014, when used applies to

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Web
  • 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 8

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: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

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_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x86
    SQLServer2014_RTM_CU8_3067836_12_0_2546_x86
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_x86

     

Enjoy!

[EN] New WinSCP (v.5.7.4) has been released

For many, many years I used FileZilla for all my FTP things. But few months ago installation files are not secure anymore. When You download newest version of FileZilla Clinet you will get special invader to your system: the rootkit. So I decided to switch for WinSCP, and after two months of using I’m very happy for this choice.

Few days ago newest version 5.7.4 has been released.

Three main impovements has been implemented with file – even French or Ukrainian translations are not most important (especially French) vulnerabilities for OpenSSLA are important – winscp574setup.exe
– MD5: d1be56e0748318009f22f8d94188b4e6
– SHA1: c095ad394981110a3b49db0a9421635e32df8ee0
– Installation package
– Includes translations:
   Croatian, Czech, Dutch, English, Finnish, French, German, Italian, Japanese, Korean, Lithuanian, Norwegian, Polish, Romanian, Russian, Simplified Chinese, Slovak, Swedish, Turkish, Ukrainian
– In addition to installing application executable file, it can install public key tools (Pageant, PuTTYgen) and
   create start menu items, desktop icons etc.
– Also includes Windows shell extension for direct drag&drop downloads and console interface tool for running scripts from command-line
– For more details see http://winscp.net/eng/docs/installation

 

More information and files for donland are under links. And You can donate any sum for future improvements:

WinSCP is completely free application, licensed under GPL, and it will remain so in the future. You do not have to pay us anything for downloading and using it. However any donation is appreciated! 

WinSCP Downloads

[Download WinSCP] [WinSCP Release Notification] [Download PuTTY]

WinSCP 5.7.4

Installation package (5.5 MiB; 194,792 downloads to date)
Portable executables (4.7 MiB; 32,738 downloads to date)
.NET assembly / COM library (4.6 MiB; 1,715 downloads to date)
Source code (8.8 MiB; 860 downloads to date)

[Release Notes, Checksums] [What’s New] [Release Notifications]

ENJOY!

[EN] Lawyers, Data Protection, Community

I got question from one member of my network: where I can find good lawyer? Lawyer who understand Information Technology, Internet, Connections, CyberCrimes, Copyrights, Sensitive Data, Privacy and so on? I’m very happy and proud that I know minimum five lawyers which are very close connected with all of these requirements. Have no idea – maybe they are too busy to work for you, but maybe they will have a moment of time to find solutions for your questions. Here are the short list, with short bio and connections links. Hope it will help you. Why those lawyers? I have great pleasure to talk with all of them, and work with some of them. And they understand my geeky questions, then provide right lawyers opinion which I can understand (even decade ago I finished The European Law Course in the field of Public Administration)…

 

BEATA MAREK {Poland} |TWITTER|BLOG|LINKEDIN|
BIO: from Twitter profile: Hi :). I’m active and I love what I do :). I’m interesting in cyberlaw, cybercrimes, copyrights, trademarks, TMT law and personal data – see you on my blog / Łączę biznes z prawem i bezpieczeństwem teleinformatycznym. Pomagam zyskać przewagę na rynku projektom internetowym i firmom technologicznym. Analizuję innowacje e-usług i nowiny dotyczące bezpieczeństwa informacji. Sporządzam regulaminy, umowy, opinie prawne, polityki bezpieczeństwa, wnioski zgłoszeniowe i inne dokumenty.

CLAUDIA JELEA {Romania} |TWITTER|BLOG|LINKEDIN|
BIO: Claudia has wide expertise in commercial law and specializes in intellectual property, entertainment law, IT&C, e-commerce, privacy & data protection and pharmaceuticals law. For over 7 years, she has been advising international and domestic clients on copyright, database rights, IT law, registration, protection and infringement proceedings on trademarks and industrial designs, Internet domain names arbitration, licensing, etc. Claudia is also experienced in cross-border transfers of personal data, in telecom and pharmaceuticals regulations, as well as in any advertising and promotion-related legal aspects. In addition, her work covers drafting and negotiation of a wide range of contracts, participation to legal due diligence investigations and representation of clients in court and before state authorities. Previously, Claudia was a lawyer with two of the largest law firms in Romania, CMS Cameron McKenna and PeliFilip, where she advised many high profile corporations mainly from IT&C, pharma and FMCG industries. She is a member of the Bucharest Bar and of the Romanian Chamber of Industrial Property Attorneys. Claudia is fluent in English. In her spare time, she enjoys painting and piano playing.

DARIUSZ SZOSTEK, ASSOC. PROF. {Poland} |BLOG|LINKEDIN|
BIO: Legal adviser (entry No. KT-3267 in the register of OIRP legal advisers in Katowice) Associate professor at the University of Opole; Faculty of Law. He specializes in information technology law, consumer law and e-government. Committee member for the Jurisprudence and Economics at the Polish Academy of Sciences, Branch in Katowice. Partner of the Research Centre for Legal and Economic Issues of Electronic Communication at the Faculty of Law, Administration and Economics of the University of Wroclaw. Prof. Szostek actively participates in scientific conferences, legislative works on regulations concerning new technologies, he also conducts legal training sessions.

GABRIELA BAR, PH. D. IN LAW {Poland} |BLOG|LINKEDIN|
BIO:
Legal adviser (entry No. WR-2038 in the register of OIRP legal advisers in Wrocław), Faculty of Law, Administration and Economics of the University of Wroclaw graduate. She specializes in civil law, specifically concerning the law of new technologies (electronic communication, e-commerce), intellectual property and commercial law. She has gained many years of experience in the vindication of claims, receivable portfolio evaluation and debt trading by investment funds. Partner of the Research Centre for Legal and Economic Issues of Electronic Communication at the Faculty of Law, Administration and Economics of the University of Wroclaw. She participates in scientific conferences, legislative works on regulations concerning new technologies and conducts legal training sessions.

EDUARDO USTARAN {Spain/England} |TWITTER|BLOG|LINKEDIN|
BIO: Eduardo is a partner in the global Privacy and Information Management practice of Hogan Lovells and an internationally recognised expert in privacy and data protection law. He is a dually qualified English Solicitor and Spanish Abogado based in London. Eduardo is a member of the Board of Directors of the IAPP, co-founder and editor of Data Protection Law & Policy, and a member of the panel of experts of DataGuidance. Eduardo is executive editor of European Privacy: Law and Practice for Data Protection Professionals (IAPP, 2011), and co-author of Beyond Data Protection (Springer, 2013), E-Privacy and Online Data Protection (Tottel Publishing, 2007) and of the Law Society’s Data Protection Handbook (2004). Eduardo has lectured at the University of Cambridge on data protection as part of its Masters of Bioscience Enterprise, and regularly speaks at international conferences.

ANDREW SUTHERLAND {England} |TWITTER|BLOG|LINKEDIN|
BIO: Andrew leads Radiant Law’s outsourcing practice in London. Andrew provides specialist advice on IT, communications and outsourcing transactions. He has particular experience of structuring, negotiating and managing complex business critical outsourcing transactions in the public and private sectors, across all industries, and both in the UK and internationally. He joined Radiant Law in 2014, having previously been a Legal Director at RPC and a senior member of SJ Berwin’s strategic sourcing practice.  Prior to that, Andrew spent several years at EDS (now HP Enterprise Services) where he was a lead lawyer on new business transactions. He has also held senior commercial management positions at GEC-Marconi and British Aerospace.

Don’t be shy. If you need some advices… just contact them!

PS. And if you know more good, geeky lawyers, just print their names in comments.