Showing posts with label What's New with SQL Server. Show all posts
Showing posts with label What's New with SQL Server. Show all posts

Monday, 29 April 2019

SQL Server Management Studio 18.0 is available now.


SSMS 18.0 is available for download now.

 Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL Server to Azure SQL Database.

SSMS 18.0 Supported Operating Systems :

Windows 10 (64-bit) *
Windows Server 2016 *
Windows Server 2012 R2 (64-bit)
Windows Server 2012 (64-bit)
Windows Server 2008 R2 (64-bit)

Can be downloaded from the link below:

Download Here

Posted by at No comments:
Labels:

Friday, 27 October 2017

Cumulative Update #1 for SQL Server 2017 RTM


The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.

Posted by at No comments:
Labels:

Saturday, 16 April 2016

What's New in SQL Server 2016 Release Candidate 3


Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations


Benefits of SQL Server 2016 Release candidate 3:

  • Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
  • Built-in advanced analytics– provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
  • Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology
  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner  without application changes
  • Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure

For download, Microsoft reference: [Click Here]


For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com


Posted by at No comments:
Labels:

Monday, 7 December 2015

What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)

What's New in SQL Server 2016


Benefits of SQL Server 2016:

  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes.
  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes.
  • Built-in advanced analytics provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database.
  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android.
  • Simplify management of relational and non-relational data by querying both with T-SQL using PolyBase.
  • Faster hybrid backups, high availability and disaster recovery scenarios to back up and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.


Microsoft reference: [Click Here]

For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com
Posted by at No comments:
Labels:

Friday, 3 October 2014

SQL Server 2008 SP4 released


SQL Server 2008 SP4 contains fixes to issues that have been reported internally, through our customer feedback platforms, and Hotfix solutions provided since SQL Server 2008 Service Pack 4 up to and including Cumulative Update 17. It also includes the MS14-044 update. It is primarily a roll up of Cumulative Updates as it is the last Service Pack for SQL Server 2008. We will not release Cumulative Updates for SQL Server 2008 SP4

 You can download it from here.

 Below are the list of Service packs release till date. Click on the version number to get redirected to the microsoft download page.

SQL CODE SQL Version RTM (Gold, no SP) SP1 SP2 SP3 SP4
    Katmai  SQL Server 2008 10.00.1600.22 10.00.2531 10.00.4000 10.00.5500 10.0.6000.29




Microsoft SQL Server 2008 Builds

BuildFile versionKB / DescriptionRelease Date
10.00.60002007.100.6000.0SQL Server 2008 Service Pack 4 (SP4)September 30, 2014*new
10.00.58692007.100.5869.02977322 MS14-044: Description of the security update for SQL Server 2008 SP3 (QFE)August 12, 2014
10.00.58612007.100.5861.02958696 Cumulative update package 17 (CU17) for SQL Server 2008 Service Pack 3May 19, 2014
10.00.58522007.100.5852.02936421 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 3March 17, 2014
10.00.58502007.100.5850.02923520 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 3January 20, 2014
10.00.58482007.100.5848.02893410 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 3November 18, 2013
10.00.58462007.100.5846.02880350 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 3September 16, 2013
10.00.58442007.100.5844.02863205 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 3July 16, 2013
10.00.58412007.100.5841.02834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (updated)June 13, 2013
10.00.58402007.100.5840.02834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (replaced)May 20, 2013
10.00.58352007.100.5835.02814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3March 18, 2013
10.00.58292007.100.5829.02799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3January 23, 2013
10.00.58282007.100.5828.02771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3November 19, 2012
10.00.58262007.100.5826.02716435 Microsoft Security Bulletin MS12-070October 9, 2012
10.00.57942007.100.5794.02738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3September 21, 2012
10.00.57882007.100.5788.02715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3July 16, 2012
10.00.57852007.100.5785.02696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3May 19, 2012
10.00.57752007.100.5775.02673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3March 20, 2012
10.00.57702007.100.5770.02648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3January 16, 2012
10.00.57682007.100.5768.02633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3November 22, 2011
10.00.57662007.100.5766.02617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3October 18, 2011
10.00.55202007.100.5520.02977321 MS14-044: Description of the security update for SQL Server 2008 SP3 (GDR)August 12, 2014
10.00.55122007.100.5512.0Microsoft Security Bulletin MS12-070October 9, 2012
10.00.55002007.100.5500.0SQL Server 2008 Service Pack 3 (SP3)October 6, 2011
10.00.54162007.100.5416.0SQL Server 2008 Service Pack 3 CTPAugust 22, 2011
10.00.43712007.100.4371.0Microsoft Security Bulletin MS12-070October 9, 2012
10.00.43332007.100.4333.02715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2July 16, 2012
10.00.43322007.100.4332.02696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2May 20, 2012
10.00.43302007.100.4330.02673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2March 19, 2012
10.00.43262007.100.4326.02648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2January 30, 2012
10.00.43232007.100.4323.02617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2November 21, 2011
10.00.43212007.100.4321.02582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2September 20, 2011
10.00.43162007.100.4316.02555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2July 18, 2011
10.00.42852007.100.4285.02527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2May 16, 2011
10.00.42792007.100.4279.02498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2March 11, 2011
10.00.42722007.100.4272.02467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2February 10, 2011
10.00.42662007.100.4266.02289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2November 15, 2010
10.00.40672007.100.4067.0Microsoft Security Bulletin MS12-070October 9, 2012
10.00.40642007.100.4064.02494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011June 14, 2011
10.00.40002007.100.4000.0SQL Server 2008 Service Pack 2 (SP2)September 29, 2010
10.00.37982007.100.3798.0SQL Server 2008 Service Pack 2 CTPJuly 7, 2010
10.00.28502007.100.2850.02582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1September 19, 2011
10.00.28472007.100.2847.02555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1July 18, 2011
10.00.28212007.100.2821.02527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1May 16, 2011
10.00.28162007.100.2816.02497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1March 22, 2011
10.00.28082007.100.2808.02467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1February 10, 2011
10.00.28042007.100.2804.02413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1November 15, 2010
10.00.27992007.100.2799.02279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1September 21, 2010
10.00.27892007.100.2789.02083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1July 21, 2010
10.00.27872007.100.2787.02231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8July 30, 2010
10.00.27752007.100.2775.0981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1May 17, 2010
10.00.27662007.100.2766.0979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1March 26, 2010
10.00.27572007.100.2757.0977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1January 18, 2010
10.00.27462007.100.2746.0975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1November 16, 2009
10.00.27402007.100.2740.0976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"November 24, 2009
10.00.27342007.100.2734.0973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1September 22, 2009
10.00.27232007.100.2723.0971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1July 21, 2009
10.00.27142007.100.2714.0970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1May 18, 2009
10.00.27122007.100.2712.0970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'"July 21, 2009
10.00.27102007.100.2710.0969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1April 16, 2009
10.00.25732007.100.2573.02494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011June 14, 2011
10.00.25312007.100.2531.0SQL Server 2008 Service Pack 1 (SP1)April 7, 2009
10.00.25202007.100.2520.0SQL Server 2008 Service Pack 1 - CTPFebruary 23, 2009
10.00.18352007.100.1835.0979064 Cumulative update package 10 (CU10) for SQL Server 2008March 15, 2010
10.00.18282007.100.1828.0977444 Cumulative update package 9 (CU9) for SQL Server 2008January 18, 2010
10.00.18232007.100.1823.0975976 Cumulative update package 8 (CU8) for SQL Server 2008November 16, 2009
10.00.18182007.100.1818.0973601 Cumulative update package 7 (CU7) for SQL Server 2008September 21, 2009
10.00.18122007.100.1812.0971490 Cumulative update package 6 (CU6) for SQL Server 2008July 21, 2009
10.00.18062007.100.1806.0969531 Cumulative update package 5 (CU5) for SQL Server 2008May 18, 2009
10.00.17982007.100.1798.0963036 Cumulative update package 4 (CU4) for SQL Server 2008March 17, 2009
10.00.17872007.100.1787.0960484 Cumulative update package 3 (CU3) for SQL Server 2008January 19, 2009
10.00.17792007.100.1779.0958186 Cumulative update package 2 (CU2) for SQL Server 2008November 19, 2008
10.00.17712007.100.1771.0958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008October 29, 2008
10.00.17632007.100.1763.0956717 Cumulative update package 1 (CU1) for SQL Server 2008October 28, 2008
10.00.17502007.100.1750.0956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008August 25, 2008
10.00.16002007.100.1600.22SQL Server 2008 RTMAugust 7, 2008
10.00.14422007.100.1442.32Microsoft SQL Server 2008 RC0June 5, 2008
10.00.13002007.100.1300.13Microsoft SQL Server 2008 CTP, February 2008February 19, 2008
10.00.10752007.100.1075.23Microsoft SQL Server 2008 CTP, November 2007November 18, 2007
10.00.10492007.100.1049.14SQL Server 2008 CTP, July 2007July 31, 2007
10.00.10192007.100.1019.17SQL Server 2008 CTP, June 2007May 21, 2007



Appreciate your suggestions. Please comment your feedback and reach me out at email

Regards,
Ganapathi varma
Posted by at 2 comments:
Labels:

Sunday, 16 June 2013

SQL Server 2014 product guide released by MS

Hi folks, Check out the sql server 2014 product guide information released by 2014,

you can download it here:

Here is the list of the white papers:
  • Mission-Critical Performance and Scale with SQL Server and Windows Server
  • Faster Insights from Any Data
  • Platform for Hybrid Cloud
  • SQL Server In-Memory OLTP Internals Overview for CTP1
  • SQL Server 2014 CTP1 Frequently Asked Questions for TechEd 2013 North America
Here is the list of slide decks:
  • SQL Server 2014 Level 100 Deck
  • SQL Server 2014 Mission Critical Performance LEvel 300 Deck
  • SQL Server 2014 Faster Insights from Any Data Level Level 300 Deck
  • SQL Server 2014 Platform for Hybrid Cloud Level 100 Deck
Appreciate your suggestions. Please comment your feedback and reach me out at email

Regards,
Ganapathi varma
Posted by at No comments:
Labels:

Sunday, 9 June 2013

Microsoft announces sql server 2014


Microsoft announces sql server 2014. The release date of Trial of SQL Server to be believed later this year.

 Find the below link for more information.

 http://visualstudiomagazine.com/blogs/data-driver/2013/06/microsoft-announces-sql-server-2014.aspx

New features of Sql server 2012
  • Always On supports now 8 secondaries instead of 4
  • Online Indexing at partition level – this is a good thing as now index rebuilding can be done at a partition level
  • Statistics at the partition level – this will be a huge improvement in performance
  • In-Memory OLTP works by providing in-application memory storage for the most often used tables in SQL Server. (Read More Here)
  • Columnstore Index can be updated – I just can’t wait for this feature (Columnstore Index)
  • Resource Governor can control IO along with CPU and Memory
  • Increase performance by extending SQL Server in-memory buffer pool to SSDs
  • Backup to Azure Storage
Appreciate your suggestions. Please comment your feedback and reach me out at email

Regards,
Ganapathi varma
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)