Category Archives: Whats New

AG without WSFC SQL 2017 and more…

Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has a limitation as : It cannot have listener configuration This would … Continue reading

Posted in Disaster Recovery, High Avaliability, Others, SQL Server 2017, SQL Server 2019, Webcast, What I learned today, Whats New | Tagged , , , , , | Leave a comment

MAXDOP and Tempdb – SQL 2016

Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication and AlwaysOn for better performance. ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP … Continue reading

Posted in Others, Performance Tuning, sql 2016, What I learned today, Whats New | Tagged , , | Leave a comment

SQL Server 2019 GA

Yes, Finally SQL Server 2019 is Generally Available yesterday Nov 4th 2019. It has many great features great videos: https://channel9.msdn.com/Niners/dutchdatadude   https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/ https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/    

Posted in Others, SQL Server 2019, Webcast, What I learned today, Whats New | Tagged , , , , | Leave a comment

Smart Tlog Bkp

another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the tlog backup and ensure to have tlog backup consistency and same … Continue reading

Posted in Backup and Restore, Others, SQL Server 2017, Transaction Log, Troubleshooting, Whats New | Tagged , , , | Leave a comment

Resumable online index rebuild

continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT RESUMABLE = {ON | OF } MAX_DURATION — can specify the … Continue reading

Posted in Others, Performance Tuning, SQL Server 2017, Whats New | Tagged , , | Leave a comment

SQL Server 2019

I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to release 2019 early next  year at , same as Oracle 2019. I would be writing more on it in future. … Continue reading

Posted in Others, SQL Server 2019, Whats New | Tagged , | Leave a comment

MySQL 8.0 and NDB 7.6

Oracle announced MySQL ndb Cluster 7.6 : in June 2018. Oracle Announces General Availability of MySQL Cluster 7.6 – June 2018 Oracle also announced MySQL 8.0 latest version of MySQL in Oracle Announces General Availability of MySQL 8.0 – April 19, 2018. … Continue reading

Posted in Database System, MySQL, News, Others, What I learned today, Whats New | Tagged , , , | Leave a comment

Oracle Atonomous

Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already introduced Autonomous on OLAP system in early this year. This way it is shows that Oracle on Cloud can … Continue reading

Posted in Cloud, Future DBA, News, oracle, Others, RDBMS, Whats New | Tagged , , , , | Leave a comment

What is MemSQL

yeah, MemSQL for me its a combination of RDBMS and NOSQL and more of flexibility of both per our choice, most of the RDBMS going with such concept. NOSQL is compromise with ACID property and flexible for developers it has … Continue reading

Posted in Future DBA, NoSQL, Others, RDBMS, What I learned today, Whats New | Tagged , , , | Leave a comment

New – News on Database System

This month i will try to write whats new going on in the market, as i could see many new things are coming, new releases new concepts. things are change with respective with data and database technologies. its getting interesting … Continue reading

Posted in Database System, News, Others, What I learned today, Whats New | Tagged , , | Leave a comment