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.
SQL Server
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.
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.
Getting started with Microsoft SQL Server 2017
It’s been a week since PASS Summit 2017. It was a great conference with lot of informative sessions. Special mention to the awesome sessions by the Microsoft Tiger Team on SQL Server 2017. I tried attending most of these sessions… Read More ›
My PASS Summit 2017 Experience
All the excitement and countdown for attending PASS Summit is finally over, and I must say I had a great time attending my first PASS Summit this year. Three cheers to everyone in #SQLFamily who directly/indirectly contributed towards the success… Read More ›
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 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.
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?
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.