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