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.

Microsoft Community Connection Charlotte 2017

Last weekend I attended the Microsoft Community Connection event at the Microsoft Office in Charlotte, NC. It is primarily an event for MVPs, RDs, few Microsoft Employees and Community Influencers to get together and connect with each other. I was lucky enough to get a chance to participate in this event as a Community Influencer.

Recent Posts

  • The Rise of NoSQL Databases

    Is your database a bottleneck to your application performance? Is your relational database slowing you down? Do you need to make changes to your data structure frequently? Are you working with huge amount of unstructured data? These are few of the… Read More ›

  • Homebrew – The package manager for macOS

    Homebrew is a free package manager for Mac OS and helps you to manage software in your Mac. You can install the software you need through command line in no time. It makes the process of installing and uninstalling software so muck easier and faster.

  • SQL Operations Studio – Using Custom Color to differentiate between environments

    The initial January release insiders build of SQL Ops Studio focuses on bug fixes and minor feature improvements. One thing which caught my attention was the ‘SQL Editor Tab Color’ to differentiate between query tabs inside the IDE.

  • SQL Operations Studio – Improvements to Connection Dialog

    In the January Release, there is a new tab called as ‘Saved Connections’  – which displays the list of saved server connections you have. This is a nice add-on to the Connection window and will give incentive to the user to be organized inside the SQLOps Studio interface by leveraging the ‘Server Group’ feature.

  • IntelliJ IDEA Error – Cannot run program – No such file or directory

    For developing applications in JAVA, most developers typically use an Integrated Development Environment to leverage built-in features to improve productivity. The most popular JAVA IDEs are NetBeans, Eclipse, Android Studio and IntelliJ IDEA. Researching over internet, I was quite impressed… Read More ›

  • PASS Summit 2017 Session Recording

    One of the benefits of being a PASS Summit Speaker was that PASS gifted us with the download version of the PASS Summit 2017 session recordings.

  • Celebrating 2 years of DotNetVibes

    2 years ago, on this day I decided to start my own blog – https://dotnetvibes.com and I must admit that it has been an awesome journey with lot of excitement, learning, challenges and acquaintances.

  • Speaking Engagements in 2017

    2017 was a phenomenal year for me and I feel humbled to have got the opportunity to present in a number of events – SQL Saturdays, Code Camps, Tech Conferences and User Groups.

  • SonarQube – Setting up Quality Gates in your application

    Quality Gates are the best way to ensure that standards are met and regulated across all the projects in your organization.Quality Gates can be defined as a set of threshold measures set on your project like Code Coverage, Technical Debt Measure, Number of Blocker/Critical issues, Security Rating/ Unit Test Pass Rate and more.

  • T-SQL Tuesday #97 – Setting learning goals for 2018

    This month T-SQL Tuesday topic – ‘Setting learning goals for 2018’ is an apt and timely one. It is the perfect time to look back & identify things which you could have done differently – and most importantly set targets and goals for the year ahead.

  • Tracking SQL Server Database Permission Changes

    The default trace provides lot of information about the security and health of your SQL Server instance. It is a great resource to track changes made to your SQL instance and can be used for auditing purpose.

  • 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.

  • SonarQube – Rejecting Code Check-in when Quality Gates are not met

    SonarQube has a collection of rules to analyze your source code at compile time to identify potential vulnerabilities, bugs, anti-patterns, refactoring and poor coding practices. The earlier we identify issues, the easier and cheaper it is to address them. By leveraging the power of Static Code Analysis, developers can get an early feedback for their code changes.

  • 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.

  • 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.

  • It’s time for my first PASS Summit experience

    The buzz in twitter says it all. The #SQLFamily is all pumped up for a great PASS Summit experience 2017, and so am I. I would highly recommend you to follow @sqlpass and #PASSsummit in twitter for all the latest happenings, if you are not already.

  • STRING_SPLIT function in SQL Server 2016

    As a developer, have you ever written your own customized string splitting function in your code? Do you still have comma separated values stored inside your database columns? If the answer to any of these questions in YES, then you will be happy to know that with SQL Server 2016, we have finally got a built-in function which takes care of this overhead.

  • Compress/Decompress Functions and Performance considerations

    With SQL Server 2016 Service Pack 1, a number of Enterprise only features were made available in the Standard and Express editions of SQL Server. Compression/Decompression is available across all editions of SQL Server with 2016 SP1.

  • Troubleshooting long running queries in SQL Server

    Diagnosing performance issues with long running queries is challenging. Generally for troubleshooting a query performance, we look at the execution plan generated by the T-SQL query and then identify the expensive operators. However for a long running query, where we have to stop the T-SQL execution prior to its completion, there is no execution plan generated. Live Query Statistics in SQL Server 2016 comes to our rescue in such scenarios.

  • Dynamic Data Masking – Altering the masked column

    There might be scenarios where you might need to alter the masked column after the initial implementation. Wondering if it is possible? Yes it is. You can alter/drop an existing masked column as per your requirement by just writing a simple T-SQL query.

  • Built in XEvent Profiler in SSMS v17.3

    With the release of SSMS v17.3, Microsoft has introduced the all new XEvent Profiler in the Object Explorer right inside SQL Server Management Studio which displays a live viewer of Extended Events. XEvent Profiler is built on top of the Extended Events technology and is an honest attempt by Microsoft to move the developers still using SQL Profiler to adopt the new XEvent Profiler.

  • SonarQube 6.5 – Code Coverage Result is not displayed

    If you are trying to install SonarQube in your project or planning to upgrade it to a newer version, you might have bumped into multiple issues during the setup process. In this article, I will show you how you can display the Code Coverage Results in SonarQube and troubleshoot any issues related with the same.

  • SonarQube SQL Error – String or binary data would be truncated

    The SonarQube Scanner for MSBuild – Begin Analysis task contacts the SonarQube server to retrieve the quality profile, and dynamically produces rulesets to be applied during the static analysis. If there are issues in the process, I would recommend to go the Administration section in your SonarQube server, and navigate to the background Tasks tab to find the error log.

  • SonarQube Error – End of Central Directory record could not be found

    I have my SonarQube server up and running. I added a SonarQube Service endpoint and associated it while configuring the SonarQube Begin analysis task.
    However when I trigger the build, it failed throwing the below error – ‘Unhandled Exception: System.IO.InvalidDataException: End of Central Directory record could not be found.’

  • Dynamic Data Masking – Tracking all masked columns in your database

    Once you have implemented Dynamic Data Masking across multiple tables in your database to protect your sensitive data, how do you track all the masked columns in one place?

  • DevSpace Conference 2017 Recap

    DevSpace is an annual developer’s conference that takes place in Huntsville, Alabama.  DevSpace offers talks on a variety of languages, offering attendees the ability to improve their skills within their daily technology of choice and the ability to become familiar with new technologies.

  • Menace of Trim function usage in Entity Framework

    When a column is wrapped around in a function call in the WHERE clause, the query processing speed can be extremely low because of the potential resultant scan operation. We should avoid using functions on columns in predicate. Especially on large tables, it can create a noticeable performance overhead by preventing the Query Optimizer to use available indexes.

  • Import Flat File Wizard in SSMS 17.3

    Couple of days back on 10th October, the Microsoft SQL Server Team announced the release of the next version of SQL Server Management Studio 17.3. I downloaded the latest version and started playing around with the new features. One thing which I was interested to check out was the new ‘Import Flat File’ wizard which promises to improve/simplify the import experience of flat files to SQL Server.

  • SonarQube 6.5 – Issues while configuring SQL Server Database

    SonarQube is a great tool for identifying anti-patterns in your code base and help you improve Code Quality. However while installing the tool, you might come across a number of issues. In this article, I have explained issues which I encountered while configuring my SQL Server database instance and the resolution.

  • Speaking at Gulf Coast Code Camp 2017

    The Gulf Coast Code Camp is a free one-day code camp being held at the University of South Alabama, Mobile, Alabama. This will be Mobile’s largest technical event in 2017 and a great networking opportunity. There will be quality talks on Web Development, Cloud Technologies, DevOps, Database, Front end technologies and more. If this interests you, make sure you register and also help spread the word in social media.

  • Attach to Process in Visual Studio 2017 not working

    I started seeing a weird issue while working in Visual Studio 2017 few days back. I was not able to attach to running processes with the Visual Studio debugger. The IDE used to freeze/hung each time I tried to do so. The ‘Attach to Process’ window used to come up but it was blank and all I saw was the spinner – eventually the screen became unresponsive after some time.

  • JSON_MODIFY FUNCTION IN SQL SERVER 2016

    There might be scenarios where you might need to manipulate/modify the JSON string. In SQL Server 2016, there is a new function named JSON_MODIFY which will assist you to modify the value of a property in the JSON string and return the modified string.

  • JSON_QUERY FUNCTION IN SQL SERVER 2016

    JSON_QUERY is used to extract an object or array from a JSON string. JSON_VALUE function returns a scalar value whereas JSON_QUERY returns an object or an array from the JSON data.

  • JSON_VALUE Function in SQL Server 2016

    SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Sometimes you might need to just extract one scalar value from the JSON data, instead of parsing and returning the entire data. In such cases, you can effectively use a new function in SQL Server 2016 called JSON_VALUE().

  • ISJSON Function in SQL Server 2016

    SQL Server 2016 provides built-in support for storing, managing and parsing JSON data. Lot of web services and Web APIs are using JSON these days, primarily as their data interchange format. The inability of the older versions of SQL Server to parse, store and process JSON data has been a hindrance. This makes the integration of JSON tinto SQL Server as one of the most popular features of SQL Server 2016.

  • Increasing your Coding Speed in SQL Server Management Studio 2017

    I had a great time speaking at Atlanta Code Camp 2017 yesterday. Thanks to all who came to my session. This was my 2nd time speaking at Atlanta Code Camp and I hope to be back next year. Thanks to the entire Organizing Team for making this event possible.

  • Searching in SQL Execution Plans – SSMS 17

    SQL Server Management Studio 2017 gives us the ability to search on execution plans. If you want to look at say a particular table, index, index scan/seek operation in the execution plan, you can now just search for those operators in the execution plan.