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.
Month: October 2017
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.
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.
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.
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.’
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 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.
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.
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.
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.