Category Archives: SQL Server 2017

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

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

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

SSMS – Docker SQL Server

once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server on Linux to SSMS on you local system, in my case it is windows Pro 10. I have installed SSMS … Continue reading

Posted in Kubernetes/Docker/Container, Others, SQL Server 2017, SQL Server 2019, SQLonLinux | 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

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 … Continue reading

Posted in Azure, BI, Cloud, SQL Server 2017, vNext | 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 … Continue reading

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     https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/sql-server-2017-community-technology-preview-2-0-now-available/ Cooooool.

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