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…
5 Quick tips for MSSQL Management Studio
We take a look at 5 quick tips and tricks Microsoft SQL Management Studio that is sure to save your time and will enhance your productivity
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.
SQL Loopidy loops… A case for TSQL loops
What will I read: In this post we will look at TSQL Loops, what they can be used for and at a practical example. This is applicable to MS SQL but I believe it also holds value for other databases.
ETL, what? Why?
What will I read: In this post we will look at the absolute basics of ETL. We will look at a small example and the practical uses of it.
Development Specification – A powerful Coding Tool
A DevSpec (development specification) is a simple, straight forward and short document that can be used to communicate work that needs to be done in an efficient and condensed way. We will look at benefits, a template and an example.