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.
I am delighted to be speaking at SQL Saturday Jacksonville 2019. This will be my first time speaking at this event.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
In this article, we will quickly learn about the difference between Continuous Integration, Continuous Delivery and Continuous Deployment.
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.
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 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.
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 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.
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.