The Azure Data team at Microsoft has recently launched new ways for you to learn Azure SQL. There are many free resources available to the community in the form of YouTube videos, blogs, learning paths in Microsoft Learn, GitHub content, hands-on workshops, and live Azure SQL Bootcamp.
SQL Server
SQL Saturday Birmingham 2019
SQL Saturday Birmingham 2019 was held at the Brock School of Business – Cooney Hall – Samford University on 27th July. The event was a huge success. We had close to 200 folks registered to the event and had a final turnaround of around 150.
Speaking at SQL Saturday Jacksonville 2019
I am delighted to be speaking at SQL Saturday Jacksonville 2019. This will be my first time speaking at this event.
My Favorite Feature in Azure Data Studio
Azure Data Studio provides a lot of Extensibility options and its Extension Model is actually my favorite feature of this tool. There is no need of huge software installs and in the process getting tools/functionalities which you don’t require. The base install of Azure Data Studio is very small & lightweight. With Azure Data Studio you can customize your environment with the tooling you need. Extensions provide an easy way to add more functionality to the installation.
Flyway Error: Found non-empty schema(s) without schema history table
We bumped into a Flyway error while trying to deploy new schema changes against an existing database. In this blog, I will explain how to identify and resolve this Flyway error so that you can successfully deploy your schema changes through an automated pipeline.
Friend of Redgate 2019
I am happy and honored to be a Friend of Redgate 2019 — my 2nd year in a row. The Friends of Redgate program is an exclusive group of influential and active community members, such as popular blog writers, speakers, consultants, as well as Microsoft Data Platform MVPs.
Speaking at SQL Saturday Pensacola 2018
It’s almost time for SQL Saturday Pensacola and I am excited to be speaking at this fun filled event this weekend. I had lot of fun last year during this event & I am looking forward to have an awesome time this year too.
Speaking at SQL Saturday Atlanta 2018
I am excited to be presenting at SQL Saturday Atlanta this weekend. This will be my 2nd year speaking at this awesome conference. I am looking forward to meet lot of folks from the Tech community and have a good time with friends and SQLFamily.
Continuous Delivery with Blue-Green Deployments
Blue-Green Deployment is a software pattern to deploy and release your application with minimal downtime and risk. This is achieved by maintaining multiple production-ready environments at the same time – termed as Blue and Green.
It’s time for CodeStock 2018
I am super excited to be presenting at CodeStock tomorrow. This will be my 2nd year speaking at this awesome conference. I look forward to meet lot of folks from the Tech Community and have a good time.
Database Delivery – State based vs Migration based
For database development and deployment there are primarily 2 delivery mechanisms — State based and Migration based approach. In this article, we will understand in details about these 2 approaches and identify use cases in real world & scenarios where they fit and not.
Handling Rollback of Database Deployments with a single click
Performing Database rollbacks is complex and cannot be an after thought. In this article, we will learn how to make your Database Rollbacks a non-event and have the luxury of one click rollbacks.
Handling Database Drifts in State based vs Migration based approach
Database Drifts can be termed as any change to the database schema or reference data that was made directly in the database environment – outside of the normal automated delivery pipeline. In this article, we will understand how to handle it in State based and Migration based approach.
Continuous Delivery Is Not Continuous Deployment
In this article, we will quickly learn about the difference between Continuous Integration, Continuous Delivery and Continuous Deployment.
Continuous Database Integration with Flyway
Data is hard to manage and databases are hard to test. Database deployments are far more complicated than application deployment, since you cannot redeploy your code from scratch every time. In this article, you will learn about an open source tool called Flyway and how it makes database migrations easier.
SQL Operations Studio – Connection Dialog Improvements
I am glad that the Connection Dialog improvement has been now incorporated in the February Public Preview of SQL Operations Studio. The database name is now dynamically populated based on the selected server.
SQL Operations Studio – Automatic Check for Updates
SQL Ops Studio now has a built in notification system to alert users when there are updates for new releases. Whenever you start SQL Ops Studio, it automatically checks for updates and pops up a toast notification to the user on the gear icon on the bottom left informing that an update is required.
IDERA SQL Superstar 2018
I am super excited to be named as an IDERA SQL Superstar 2018, along with an awesome group of folks from the SQL Family. IDERA’s SQL Superstars are recognized as enthusiastic members and leaders of the database and data professional community who go above and beyond for others.
The Rise of NoSQL Databases
Is your database a bottleneck to your application performance? Is your relational database slowing you down? Do you need to make changes to your data structure frequently? Are you working with huge amount of unstructured data? These are few of the… Read More ›
SQL Operations Studio – Using Custom Color to differentiate between environments
The initial January release insiders build of SQL Ops Studio focuses on bug fixes and minor feature improvements. One thing which caught my attention was the ‘SQL Editor Tab Color’ to differentiate between query tabs inside the IDE.
SQL Operations Studio – Improvements to Connection Dialog
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.
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.