Category Archives: What I learned today

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

Fail to cycle errorlog

sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle the errorlog it will fail.   and we get error that … Continue reading

Posted in Error Log, Others, What I learned today | Tagged | Leave a comment

Read-only Replica -AG

Read only replica is a great concept where we can re-direct all the read only connections to that replica.   Following are some of the great articles for it. How to Configure Read-Only Routing for an Availability Group in SQL … Continue reading

Posted in Disaster Recovery, High Avaliability, Others, What I learned today | Tagged , | Leave a comment

Always On: Troubleshooting Consolidated

Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group listener resulted in an error. ADDITIONAL INFORMATION: Create failed for Availability … Continue reading

Posted in Disaster Recovery, High Avaliability, Installation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Error – Hung Docker

Sometime when you not actively working on Docker and on you are not actively working on the system. it could be possible that Docker services goes into hung State and you will get an error as follows: Starting containers fails … Continue reading

Posted in Kubernetes/Docker/Container, Others, What I learned today | Tagged | Leave a comment

MongoDB – Basic Commands

We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail training about MongoDB. I learned mongoDB and is my Reference for blogging. Today we will discuss some of the basic … Continue reading

Posted in MongoDB, NoSQL, Others, What I learned today | Tagged , | Leave a comment

MongoDB – Basic

MongoDB is a great Database NOSQL and easy to use and learn. if you know java scripting and database concept you can learn MongoDB. Surprisingly  realize that I have not written much about MongoDB so started writing on this very powerful … Continue reading

Posted in MongoDB, NoSQL, Others, What I learned today | Tagged , | Leave a comment

SQL Server on Docker

Started working on Docker and contains Install Docker on the system – please make a note that for windows 10 Home it does not support(we have to use Docker Toll Box for it). please make sure to use Windows 10 … Continue reading

Posted in Kubernetes/Docker/Container, Others, SQL Server 2017, SQL Server 2019, SQLonLinux, What I learned today | Tagged , , | Leave a comment