Azure Data Studio – Cool Snippets
Some cool Azure Data Studio Snippets
Regex – Cheat Sheet – Basic – Anchors
All the examples below have been tested in Notepad++. Notepad++ can be found here. These examples can also work in other platforms with some minor syntax changes to them. Anchors Types Of Anchors ^ used to denotate the start of a string or line $ used to denote the end of a string or line Use Case for ^ Let’s say we have the list below and we want to add the letter G to the start of all the strings below. Press Ctrl + H to bring up the replace window in Notepad++ or your set shortcut key for it. In order for this to work you have to set the following: Ensure that the text cursor is at the start of the list or that all the text is selected (by using Ctrl + A). ^ in Find what section. G in Replace with section. Ensure that the…
Azure Data Studio My New Muse (Part 1)
What you can expect Brief explanation of Azure Data Studio followed by some tips and tricks to optimize your coding experience in Azure Data Studio. What is Azure Data Studio Azure Data Studio is Microsoft new SQL Server Management studio that is solely focused on development. Azure Data Studio does not have all the functions of SQL Server Management studio and it does not seem like they are going to change that at the time of writing this. However, the features and tools it provides are amazing. We are going to look at some of them in this post. SQL Snippets These functions are similar to SSMS (SQL Server management Studio) Boost’s auto replacements and are quite easy to setup. In Azure Data Studio hit Ctrl + Sift + P and type snippets Now type SQL to select the SQL option You will end up here To create a snippet,…
SQL – CTE – Basics
Brief explanation of what a CTE is and how to use them to optimize your queries.