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.
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.
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 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.
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().
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.
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.
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.
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.
Atlanta Code Camp is the largest developer community event in Atlanta. This is a great opportunity to hear from the best speakers around, including many Microsoft MVPs and networking with the awesome developer community in and around Atlanta.
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.
We bumped into a Performance issue last week for one of our web application in Production. After doing some research and looking at Logic Monitor reports for web servers and database servers, we figured out that the Deadlocks and Lock Timeouts in the Database have increased considerably.
Your application is bound to grow over a period of time. Sometimes it is critical to test your changes with a bigger workload than your current table size to identify any performance bottlenecks, well ahead of time. Leveraging automated tools to generate a workload for you to test your application makes your lives much easier.
Blocking in SQL Server occurs when a transaction in a database session locks resources that another transaction requires to read or modify. If your application has long term blocking, then you have a problem in your hands to resolve.
Having an effective Database Indexing Strategy is a key to your application performance. When we think about optimizing SQL query performance, generally the first thing which comes to our mind are ‘Indexes’. And rightly so, because Indexes tremendously help in fetching your data faster from SQL Server.
“Lock Escalation” is an optimization technique used by SQL Server and it is basically how it handles locking for large updates. When SQL Server is going to modify a large number of rows – it is more efficient for the database engine to take fewer, larger locks (table lock) instead of dealing with a large number of individual locks (row locks).
SQL Saturday Chattanooga was held on 24th June at UTC Chattanooga EMC Building. I have been to multiple SQL Saturdays earlier, but this was my first time in SQL Saturday Chattanooga. I was humbled to get the opportunity to present two sessions during this event.
I am excited to announce that I have been selected to speak at SQL Saturday Pensacola on 3rd June, 2017. I have heard so many good things about this event from my peers, that I feel humbled to be part of the event this year. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.
One of the events which I was lot excited to attend was the pre-Build event – ‘Microsoft AI Immersion Workshop’. The event promised to be a great opportunity for developers to learn about building intelligent applications using Microsoft and open source technologies. Now that the event is over, I must say that it did live up to its expectation.
During my SQL Saturday Birmingham Presentation on SQL Tips and Tricks, one of the productivity feature which got lot of love from most of the attendees was the use of custom colors to differentiate between SQL environments. SSMS provides us with an ability to set different colors for connection to separate environments.
SQL Saturday Birmingham 2017 was held on 18th March at Samford University. This was my first SQL Saturday as an Organizer. I also presented on Productivity Tips and Tricks in SSMS.
On 14th January, 2017 I attended SQL Saturday Nashville held at Middle Tennessee State University (MTSU), Murfreesboro. I have been to multiple SQL Saturdays before, but this was my first SQL Saturday as a Speaker.
As a developer, when you are working in a project, you tend to have a number of servers which you need to constantly shift between. What can you do to manage or organize these frequently accessed servers in a better way?
A year back on this very day, I decided to start my own blog and that’s how dotnetvibes.com came into existence. Today on 1st January, 2017 – exactly a year later – I must admit that it has been an eventful journey with lot of excitement, learning, challenges and acquaintances.
SQL Server Management Studio provides a cool feature called ‘Code Snippets’ which can help you to considerably increase your coding speed. Code Snippets are ready made snippets of code, which you can insert into your T-SQL code. As a result, you can type less and generate more code.
In this article we will evaluate the Performance Impact of searching data in SQL Tables. We will understand how the Query Optimizer processes such queries and things we need to be aware of, from a performance standpoint, by using any toolset.
In this article, we will go through one of the features in SSMS 2016 – ‘Quick Launch’. Quick Launch greatly helps in making the developers productive in the IDE by helping them to search features and options inside SSMS.
On 15th October, 2016 I attended the Atlanta Code Camp held at the Kennesaw State University, Marietta, GA. I was quite humbled to get an opportunity to be a speaker this year and presented in the Database Development category on ‘Making developers lives easier with SQL Server 2016’.
Since the initial release of SQL Server 2016 in May 2016, there has been monthly updates to SSMS which includes enhancements, new features and bug fixes. This has been a big step in ensuring that the SSMS IDE is up to date and provides a superlative user experience. But how do you know that a new version of SSMS has been released?
SSMS does not provide any tools/utility to search for a value/data inside a particular database.This kind of surprises me a bit, since it is a needed functionality and would be a very popular feature to be built into the SSMS IDE. So the question is, how do you search for a particular value/data in your SQL Database?
Working as a .NET Developer in the Southern City of Birmingham, I feel the last 6 weeks has been pretty awesome for the Birmingham Technology community. There were 3 excellent full day tech events – starting with Sloss Tech held by TechBirmingham, dotNetConf and then devdataDay held by Steel City SQL Group and BHM .NET Meetup.
In this video session, we will learn about the rich set of capabilities of SQL Server 2016 and the new & improved features relating to Performance, Productivity and Security.
Currently one of the most irritating things in SQL, is to explicitly check if an object exists before dropping it.The DROP IF EXISTS is a simple T-SQL Enhancement in SQL Server 2016, but I am sure it would be one of the most frequently used syntax in a T-SQL developer’s day to day life.
From a security standpoint, sensitive data in the database needs to be protected against unauthorized access. Personal information of an individual like phone number, email, credit card details, bank account number, social security number needs to be stored safely in a database table.
In this article, we will look at a new security feature in SQL Server 2016 called as ‘Dynamic Data Masking’, which will now provide a database driven technique to mask sensitive data.
Historical data are a key source for trend analysis and are considered critical to business success. Traditional databases don’t provide insights into how data has changed over a period of time.As a developer, imagine if SQL Server provides this information out of the box, and there is no need to write any custom code to achieve this functionality. Wouldn’t it be awesome?
Lot of web services and Web APIs are using JSON these days, primarily as their data interchange format. The inability of the current versions of SQL Server to parse, store and process JSON data has been a hindrance. This makes the integration of JSON into SQL Server as one of the most awaited feature of SQL Server 2016.
Sometimes we might need to populate our SQL tables with reference/ look-up data. There are other scenarios when we need to copy table data from one environment to another. In both these cases, we require to create bulk scripts for Inserting data into our destination table. In this article, I will mention about a quick way to generate the SQL Insert Scripts using SQL Server Database project with just 2 clicks.
With technology evolving this fast, I hate that we still have to deal with manually comparing execution plans. Things get worse when we have big plans. While working on a SQL Performance issue, it is often required to compare execution plans, before and after making a change. Wouldn’t it be nice to have a tool which would compare execution plans side-by-side and automatically present to you the similarities/differences?
How many times have you tried to troubleshoot a TSQL performance issue and wished you had more statistical/historical information on how the query ran over a period of time?
How many times have you faced performance issues after server/application upgrades? How many times have you bumped into a temporary performance issue with a TSQL and you wonder what is causing the query to run slow all of a sudden?
How many times have you come across a scenario when you execute a TSQL Query and it just runs and runs, without displaying any results and you wonder what’s going on – and finally end up cancelling the executing query?