[EN] SQL Server 2012 SP1 Cumulative Update 8 is available

LOGO__SQLServer2012SP1Second package released last week os for SQL Server 2012 Service Pack 1. Of course this Cumulative Update no 8 {build number: 11.0.3401.0} Microsoft resolved more errors, more than for SQL Server 2008 (wrote about it in my previous post). Here is the list of fixed bugs – thirty four bugs:

VSTS BUG: 1852083 | 2297709
FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1664715 | 2864930
FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server 2008 R2 BIDS or in SQL Server 2012 SSDT

VSTS BUG: 1664721 | 2875949
FIX: VSS backup operations are not successful when the auto-recovery option is enabled in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664729 | 2878377
FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664727 | 2878807
FIX: System.NullReferenceException is thrown when an SSRS 2008 R2 or SSRS 2012 report or subscription is opened in SharePoint integrated mode

VSTS BUG: 1664733 | 2885565
FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1852085 | 2888996
FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server 2008 R2 or SQL Server 2012 by using the SA account and then run DBCC CHECKDB

VSTS BUG: 1664739 | 2890095
FIX: Interrupted distributed query may return partial result set without any error in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1664719 | 2890818
FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS 2008 R2 or in SSAS 2012

VSTS BUG: 1852087 | 2891115
FIX: "The search text was not found" error when you search for numeric data that contains nonbreaking spaces in SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1852089 | 2891489
FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1758070 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1602236 | 2896903
FIX: You cannot perform any administrator actions on the databases when a data model corruption occurs in SSAS 2012

VSTS BUG: 1629110 | 2899939
FIX: Error messages when you create a project level SMO connection manager together with a password for an SSIS 2012 project

VSTS BUG: 1769272 | 2901714
FIX: Server crashes when you import a Windows Azure SQL database to a local SQL Server 2012 database

VSTS BUG: 1640232 | 2901757
FIX: Minute is overwritten by second in XML data after you migrate from SQL Server 2005 to SQL Server 2012

VSTS BUG: 1852102 | 2904010
FIX: A small number of rows are sampled in SQL Server 2008 R2 or in SQL Server 2012 when table statistics are updated automatically or together with specified sampling rate

VSTS BUG: 1852110 | 2911026
FIX: Access violation may occur when you query sys.dm_server_memory_dumps in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1852106 | 2911385
FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1683049 | 2912928
FIX: SQL Server 2012 PowerPivot for SharePoint 2010 cannot create databases when SharePoint server name is FQDN

VSTS BUG: 1852112 | 2912949
FIX: SSAS crashes when more than one thread tries to access an SSAS 2008 R2 or SSAS 2012 cube at the same time

VSTS BUG: 1636271 | 2913102
FIX: Validation of service accounts takes a long time when you set up SQL Server 2012

VSTS BUG: 1798224 | 2915611
FIX: Left arrow key does not work in Expression Editor of SSDT for Visual Studio 2012

VSTS BUG: 1811621 | 2916827
FIX: "Invalid URI: The Uri string is too long." error message when you render a SSRS 2012 report

VSTS BUG: 1812447 | 2916934
FIX: The option ‘Center map to show an embedded map element’ of tab ‘Center and Zoom’ for a map does not work in SSRS 2012

VSTS BUG: 1818080 | 2917636
FIX: SQL Server Agent cannot forward events to a different server in SQL Server 2012

VSTS BUG: 1861773 | 2918791
FIX: The system function sys.fn_hadr_backup_is_preferred_replica does not work correctly after you have CU7 for SQL Server 2012 SP1 installed

VSTS BUG: 1853069 | 2919584
FIX: Incorrect result in a PDF file when you use expressions that contains Lookup function in a SSRS 2012 report

VSTS BUG: 1814392 | 2923460
FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012

VSTS BUG: 1910328 | 2923838
FIX: Error messages when you use the AMR tool for SQL Server 2014 CTP2 on SQL Server 2012

VSTS BUG: 1912914 | 2923839
FIX: Oracle CDC service shows aborted status when you use CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1788041 | 957823
FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 2008 or SQL Server 2012

 

This update could be applied for: Microsoft SQL 2012 Service Pack 1, when used with:

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Standard

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 08

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 platforms: 32-bit and 64-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x86

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleSer_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_RSShrPnt_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_AOrcleDes_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU8_2917531_11_0_3401_x64

  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU8_2917531_11_0_3401_x64

Enjoy!

[EN] SQL Server 2008 SP3 Cumulative Update 15 is available

LOGO__SQLServer2008SP3Few days ago Microsoft published two group of pudates for SQL Server. In this post I’m writing about package for SQL Server 2008 with Service Pack 3. In this Cumulative Updates No 15 {build number: 10.00.5850.00} Microsoft fixed last three updates? Why last three? Go to Glenn Berry’s blog post {LINK}– I totally agree with him. back to CU, here is the list of fixed bugs:

VSTS BUG: 1527664 | 2919611
FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3

VSTS BUG: 1913272 | 2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008

VSTS BUG: 1769685 | 2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008

 

This update could be applied for: Microsoft SQL Server Service Pack 3, when used with:

  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Express

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 15

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 all three platforms: 32-bit, 64-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 | SQLServer2008_SP3_CU15_2923520_10_00_5850_x86

  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU15_2923520_10_00_5850_x64

  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU15_2923520_10_00_5850_IA64

Enjoy!

[EN] First date with Killer ApexSQL Tools

New year started few weeks ago. For me one of my personal goals is to be more active blogger than last year. Especially with this interesting (in my – ond not only – opinion) special series: The Sunday Market. Name (genesis is too big word) of this series is simple. In many countries You cannot buy something interesting for Your environment, because Financial Department are close in Your company. But You always can get something for free from the web. Get-Test-Check > put into your budget.

Captura_ApexSQL_killer

Last Wednesday I presented short (introduction type) session at my local SQL User Group (Polish SQL Server User Group in Wrocław LINK) about free tools from ApexSQL. Some of my folks talked about it few times on previous meetings. It was first session, second will be presented soon with more funny experiments. In this blog series I want show few moments from “dating with Apex”.  In this post I will just introduce about installation of three tools. All are free:

ApexSQL Complete | LINK http://bit.ly/1i3IeV3 | size 7MB | in few words: SSMS and VS integration,   SQL syntax checking, SQL object descriptions, SQL code completion, SQL code visualization, Snippet management

ApexSQL Refactor | LINK http://bit.ly/1i3IjrC | size 8MB | in few words: SQL parameter management, SQL formatting, Consistent code layout, Database object refactoring, Batch formatting, One-to-many relationship replacement

ApexSQL Search | LINK http://bit.ly/MkFvvR | size 7MB | in few words: Smart renaming, Text search, Database object search, Easy SSMS tab navigation, SQL code cleaning, Graphical dependencies

 

Phase one: installation

Captura_ApexSQL_Complete01 Captura_ApexSQL_Refactor08 Captura_ApexSQL_Search08

Pic.01 | Three tools, same installation interface – I really LOVE it. Ordnung muß sein!

All screenshots below (till phase two) are the same for all tools.

Captura_ApexSQL_Complete02

Pic.02 | Reading – yes read it – and accepting license.

Captura_ApexSQL_Complete03

Pic.03 | Choosing installation folder – for me as alway it is ‘non default folder’ *

Captura_ApexSQL_Complete04

Pic.04 | We can integrate these tools with all part of environment which is installed on machine: in this case I have SSMS for SQL 2008 & 2012, anf VisualStudio for 2005, 2008, 2010 & 2012 versions. It’s interesting because I don’t heve Visual Studio 2013 and installer is prepared for instalaltion (suppose that last row will be un-grayed when I install VS2013). But I have SQL Server 2014 on my miachine and this installer is not ready for this version.

Captura_ApexSQL_Complete06

Pic.05 | Choosing (or not) selected Start Menu – even on Windows 8.1 **

Captura_ApexSQL_Complete07

Pic.06 | Ready to install with summary.

Captura_ApexSQL_Complete08

Pic.07 | installation in progress.

Asterix:

* in this case I got several problems with using non defaul folders, but not only – I had not vell functional addins from other software vendor – these addins figting for place and acces for dll’s.

** definitely too much, really too much links in start menu by default:

image

Phase two: result

Capturaerror6

Pic.08 | First execution of SQL Server management Studio 2012 and I got this error, next: SSMS crash. I tried again and again and again.

Capturaerror7

Pic.09 | More interesting error I got when I run Visual Studio 2012 (of course add-ons hasn’t been installed).

I didn’t enought time for full investigation, becaus it happener just few hours befor my user group meeting. So I executed my disaster repair (not recovery) procedure in few steps:

  1. deinstallation al ApexSQL addins
  2. deinstallation all other vendor add-ons
  3. cleaning reistry (by wise registry cleaner)
  4. cleaning folders (by wise dick cleaner)
  5. restart physical machine
  6. installation all three ApexSQL tools again

 

Phase three: final result

Finally I got all tools in my SQL Server Management Studio:

image

Pic.10 | ApexSQL Complete integrated with SSMS 2012.

image

Pic.11 | ApexSQL Refactor integrated with SSMS 2012.

image

Pic.12 | ApexSQL Search integrated with SSMS 2012.

 

Next date with Apex on Sunday.

ps: to kill or to be killed…