Tag Archives: Future DBA

Powershell : Desire State Configuration -DSC

Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain that state for compliance and standardization of our environment. this can … Continue reading

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

POWERSHELL -SQL Assessment

June/July 2019 Microsoft – powershell is providing another great feature with SMO and SQL Server module as SQL Assessment. This is a great feature where Microsoft- SQL Server is providing the assessment for your sql server with general recommendation on … Continue reading

Posted in Future DBA, Others, Powershell, SQL Server 2019, SQLonLinux, What I learned today, Whats New | Tagged , , , , | Leave a comment

Next Powershell 6+ (CORE) and 7

Powershell is no longer been installed or delivered with windows bundle after 5.x and new powershell would be independent of windows/operating system. powershell would be a separate system /world and would be available on gethub Early this year we got … Continue reading

Posted in Open Source, Others, Powershell, What I learned today, Whats New | Tagged , , , , | Leave a comment

Azure Data Studeo- Nov 2019 Release

SQL Server Management studio is now can be installed separately not part of SQL Server package. with this enhancement SSMS has several features and version is getting updated and new versions getting release which we can install separately. in addition … Continue reading

Posted in Azure, Future DBA, Others, SQL Server 2017, Tool | Tagged , , , | Leave a comment

MongoDB 4.0.2 release

As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable we generally call this for RDBMS systems BASE, which is typical for NoSQL systems, stands for Basically Available, Soft State, … Continue reading

Posted in Future DBA, NoSQL, Others, RDBMS | 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

Happy New Year… Late:)

Yeah I know its new year and i am back from quite some time. during these days i was learning things but could not able to make time to blog about it. This year would like to write more on … Continue reading

Posted in Future DBA, General, Others | Tagged , | Leave a comment

Future DBA – Big Data -MongoDB 2

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a concept called sharding with replication, so here using sharding it uses a cluster like configuration and data will be load-balance- equally … Continue reading

Posted in BIGDATA, Future DBA, Others | Tagged , | Leave a comment

Future DBA – Big Data -MongoDB 1

We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution and can be used for data warehousing. can manage big data/heavy data There is another BIG Data system called MongoDB, … Continue reading

Posted in BIGDATA, Others | Tagged , | Leave a comment