Saturday, February 04, 2017

Upgrades from Earlier Versions to SQL Server 2016

You can upgrade to SQL Server 2016 supports upgrade from the following versions of SQL Server:
•SQL Server 2008 SP3 or later
•SQL Server 2008 R2 SP2 or later
•SQL Server 2012 SP2 or later
•SQL Server 2014 or later
1. Import SSIS Package into SQL Server


2. Connect Integration services using SSMS (SQL Server Management Studio)

3. Select Package Location from “File System”





4 DerivedColumn Package imported into MSDB( where the package is stored)







5 Execute Package Utiltiy to DerivedColumn Package to test to export data into Excel file D:\Temp\DerivedColumn.xls

















6 Create a Job to run the Package at scheduled time











7 SSIS DerivedColumn job has been successfully executed and output on excel file location D:\Temp\DerivedColumn.xls



Sunday, May 29, 2016

SQL Server 2016 coming on 1st June

This new version will be released on June 1st 2016.
SQL Server 2016 is the foundation of Microsoft’s data strategy, encompassing innovations that transform data into intelligent action. With this new release, Microsoft is delivering an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications as well as insights on your data on any device.

Saturday, April 02, 2016

Microsoft SQL Server Developer Edition is now free

Microsoft SQL Server Developer Edition is now free
Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members.


https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

Thursday, February 04, 2016

Free eBooks from Microsoft Press

Free eBooks are available in PDF, EPUB and Mobi for Kindle formats.
Find more books & eBooks at The Microsoft Press Store.

https://mva.microsoft.com/ebooks

Thursday, September 17, 2015

Linked Server Transaction error Msg 7395, Level 16, State 2, Line 273

If you are using nested transaction in your stored procedure you will get the same error. Solution to this error is to SET XACT_ABORT  TO ON;  in your stored procedure.

Tuesday, May 05, 2015

SQL Server 2016 public preview

SQL Server 2016 public preview coming this summer and most important feature Real-time Operational Analytics & In-Memory OLTP

http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx
 

Thursday, July 03, 2014

Error: 17053, Severity: 16, State: 1. Restore failed

When you RESTORE database if you see the below SQL error Operation System 112
Then you must look at the first point to have a enough disk free space on specified drive where database is going to restore.

Message
Error: 17053, Severity: 16, State: 1.

E:\MSSQL \DATA\Adventrueres.mdf: Operating system error 112(error not found) encountered.