Month: November 2017

Keeping your Technical Debt in check with NDepend

During the past month, I have been blogging about SonarQube – an open source static code analysis tool. We recently started using SonarQube in our projects to ensure high code quality, automate our code review process and also manage our technical debt. In this article I will provide an overview on another very popular and powerful Static Code Analysis tool – NDepend.

Microsoft SQL Operations Studio – Color Themes and Customization

Microsoft SQL Operations Studio is forked from Visual Studio Code, and hence is extremely light weight, customizable and easy to use. The amount of customization you can do are endless, and once you start playing with this tool you will realize its true potential. In this article, I will focus on a feature which has been one of the topmost request in the Connect site for SSMS – the Dark Theme.

Getting started with Microsoft SQL Operations Studio

Today Microsoft announced the Public Preview of their free lightweight cross platform tool called as ‘SQL Operations Studio’. It runs on Windows, macOS and Linux for SQL Server, Azure SQL Database and Azure SQL Data Warehouse. There was already a lot of excitement about this tool in the community after it was announced during the PASS Summit by Rohan Kumar.

Identifying Unused Indexes in SQL Server

Indexes play a critical role in enhancing your database performance by facilitating faster query execution. Having the right indexes in place can speed up the process of fetching data from your underlying tables whereas having redundant indexes can hurt the performance negatively.

TSQL Tuesday #96: Folks Who Have Made a Difference

This month TSQL Tuesday topic – ‘TSQL Tuesday #96: Folks Who Have Made a Difference’ hosted by  Ewald Cress is an interesting one and comes at a good time – right before Thanksgiving. It is a great opportunity to recognize all the folks in the #sqlfamily who have made positive contributions in your life and help you move forward.

Microsoft SQL Operations Studio

One of the biggest highlights of SQL Server 2017 is its cross platform support – you can run your workloads on not only Windows, but also Linux and Docker containers. This enhances the need of a cross platform tool which can ideally replace SSMS in near future, if not at least assist Developers/DBAs who would require to work on multiple platforms and provide more in-built capabilities.

PASS Summit Day 1 Microsoft Keynote – Recap

The Keynote from Microsoft Team was something which I was looking forward to with an expectation to learn more about Microsoft investment in SQL Server, the latest innovations and see the latest & greatest feature set in SQL Server 2017. There were some nice takeaways for me from this session and I have noted them down in this blog post. If you want to listen to the Keynote, I think it is also available in PASS TV.