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