SQL Server 2019 overview and installation October 15, 2018 by Rajendra Gupta On September 24th, 2018, Microsoft launched SQL Server 2019 preview version (SQL Server vNext 2.0) in the ignite 2018 event. As you know, SQL Server 2017 is still being adopted by the organizations, we are now ready with this preview version. Read more »
SQL Interview questions and answers on Installation and Upgrades – II October 1, 2018 by Rakesh Patil The following is a collection of SQL interview questions and answers on installing SQL Server as well as installation of service packs and cumulative updates Read more »
SQL Interview questions and answers on Installation and Upgrades – I October 1, 2018 by Rakesh Patil The following is a collection of SQL interview questions and answers, the second in this series, on installing SQL Server as well as installation of service packs and cumulative updates Read more »
SQL Server installation and upgrade troubleshooting interview questions September 21, 2018 by Rakesh Patil 1. Can a Service Pack or Cumulative Update be uninstalled to roll back in case of failures? We cannot uninstall a service pack or Cumulative Update on SQL Server 2005 or lower. Starting with SQL Server 2008, we can uninstall a service pack or Cumulative Update from control panel Add or remove programs a view installed updates window. Read more »
Step by step installation of SQL Server 2017 May 23, 2018 by Daniel Calbimonte Introduction The new SQL Server 2017 comes with new features in the installation. It now supports Machine Learning Services that support R and Python. It also includes SSIS Scale Out Master and Scale Out Worker. It also includes scale out options in PolyBase. Read more »
OpenQueryStore for SQL Server – Installation and configuration January 24, 2018 by Marko Zivkovic The OpenQueryStore is an Open source implementation of the popular Query store functionality introduced in SQL Server 2016 CTP2. The OpenQueryStore was first introduced in June 2017. Its main contributors are William Durkin and Enrico van de Laar The OpenQueryStore collects query runtime execution statistics, wait statistics information against a specific database. This information helps identifying performance problems and troubleshooting by quickly finding performance differences. The main difference between the OpenQueryStore and the Query store feature is that the OpenQueryStore supports SQL Server 2005 to SQL Server 2014 while Query Store supports only SQL Server 2016 and higher. Also, the OpenQueryStore is open-source which means that the OpenQueryStore code can be changed whenever you like. Read more »
