HA between Windows and Linux

If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has made SQL Server to work on Linux we have accepted that. It has some Middle OS to interact with Linux to work SQL Server 2017.

Microsoft has made another great achievement to make possible of having high availability between Linux and Windows for SQL Server. here one of our server would be Linux and if it goes down our another Windows server will be take the traffic for SQL Server this has been achived by Always On.. Amazing.

Heads up to Tobias and Slava to make this another thing possible for SQL Server.

WOW!!! Interesting… it is like you ask and we delivered….








Posted in Azure, High Avaliability, Others, SQLonLinux, What I learned today, Whats New | Tagged , , , , | Leave a comment

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :


Count_Big() – BOL:

Returns the number of items in a group. COUNT_BIG works like the COUNT function. The only difference between the two functions is their return values. COUNT_BIG always returns a bigintdata type value. COUNT always returns an int data type value




Posted in BIGDATA, General, Others, What I learned today | 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 Azure and SQL 2017 with other Database technologies.

Things are changing with Cloud, RDBMS, NOSQL, Big Data, Data Scientist, Data science and AI.

And Devops

Future will be different for DBA looks like:)


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

Azure support MySQL & PostgreSQL

After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL database technologies. this shows that no Microsoft is going to lead the industry by making themselves ready for tomorrow where Supporting Linux and Linux supported Database technologies(Open source) … Cool

so you  name it and Microsoft delivers that. that the approach it looks like.


Azure is awarded as a best cloud support after AWS that a great achievement.

BI area Microsoft is leading the industry.

And The way SQL Server 2017 is designed when actually everyone start using it, I would say it will make a big difference. lets see……

Thanks Microsoft!!!


Posted in Azure, BI, Cloud, SQL Server 2017, vNext | Tagged , | Leave a comment

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history shows success but no task/subplans shown.

error code 0x80131500 (Failed to retrieve data for this request)…DTSER_FAILURE

This generally happens when you made changes in the databases(database offline) and other stuff or an old maintenance job.

For now I do not get the root cause for it but simple solution would be to create a new maintenance plan for faster resolution. i think its a BUG for SQL Server 2005.

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

Learning – Webcasts/Video

Learning for this week.






Free Microsoft books:


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

Azure CosmosDB SQL Server

As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External language(R and Phython). now Microsoft is wanted to make sure that it has feasibility for all the environment whichever is available in the market. earlier I blog on MongoDB which is happening and favorable to developers for document store and containers concept, CosmosDB is the similar architecture of MongoDB for horizontal data storage , container and Document with the help of DocumentDB.

Microsoft has introduced many things recently(SQL 2016/17):

SQL Server on Linux

SQL Server – PolyBase (Hadoop Compatibility- data retrieval)

Azure SQL Server – CosmosDB – MongoDB

This indicates that Microsoft do not want to be isolated on Windows platform nor want to restrict to small scale… and Its been proved that Microsoft is doing great on this area… the only thing I believe is the SME for those new concepts which has been introduced unless we do not know how to manage it we may not be expert of doing it so.

Lets See..






Posted in Azure, Cloud, NoSQL, Others, sql 2016, SQL Server 2017, SQLonLinux | Tagged , , , , | Leave a comment

Vnext – Its SQL Server 2017

Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can also work on Windows, MacOS and Linux





Posted in Others, SQL Server 2017, vNext | Tagged , | Leave a comment

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.





Posted in Disaster Recovery, High Avaliability, Others, SQLonLinux, vNext | Tagged , , | Leave a comment

SQL Agent on vNext – Linux

SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on Linux so I think now Microsoft should able to include things which we are doing on Windows Server.

on that note, Now vNext with CTP 1.4 Microsoft has introduce the SQL Server Agent functionality on vNext.




Posted in Others, SQLonLinux, vNext | Tagged , | Leave a comment