SQL Server 2017

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.

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.

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.

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.

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.

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.

SSMS 17: Built-in Performance Dashboard Reports

SQL Server Performance Dashboard Reports are used to monitor and resolve performance issues in your Database Server. They are generally targeted towards a Database Administrator, and enabling them to quickly identify any performance bottlenecks in the system, gather diagnostic information that can potentially help to resolve the issue.

SSMS 2017 – Number of affected rows

SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS 17.2 is the latest version of SQL Server Management Studio. It provides support for almost all features on SQL Server 2008 through SQL Server 2017.