Monthly Archives: March 2020

Azure Data Studio last daily post #25

Posted on March 25, 2020 by martincroft

I have decided to call it a day posting daily, technically I didn’t post every day in March, I made 25 continuous days blogging in some weird and wonderful locations (Belgium trains for one) also hotel room after nights out. … Continue reading →

Posted in Azure Data Studio | Leave a comment

Azure Data studio – PowerShell Command Explorer – Day #24

Posted on March 24, 2020 by martincroft

It’s half 8 again and I am starting the blog. I am not accustoming well to continued home working, I am usually an early riser but the current situation I didn’t sleep and slept into 8.30, by that time I … Continue reading →

Posted in Azure Data Studio, PowerShell, Productivity | Leave a comment

Azure Data Studio – A week to go more short cut keys

Posted on March 23, 2020 by martincroft

I said I would attempt to blog every day in March around Azure Data Studio and it has been a challenge especially the last few days.  I’m now at the point of looking for topics to blog around, so I … Continue reading →

Posted in Azure Data Studio, Productivity | Leave a comment

Azure Data Studio data scripter extension

Posted on March 22, 2020 by martincroft

I thought that I would cover some of the great extensions that make ADS so much more, one that is quite nifty and I can see a use for is the data scripter extension. This extension was written by Sean … Continue reading →

Posted in Azure Data Studio, extensions | Leave a comment

Azure Data Studio – The run book #21

Posted on March 21, 2020 by martincroft

I have just used SQL notebooks today for a SQL migration from SQL Server 2000 database to SQL Server 2016 with many, many updates to code, procedures, configuration changes, linked servers and thought I would share some thoughts on using … Continue reading →

Posted in Azure Data Studio, Markup, Notebooks, Uncategorized | Leave a comment

Azure Data Studio and working from home day #20

Posted on March 20, 2020 by martincroft

Its difficult times we live in at the moment with things going on, like many, I am working from home and sometimes the connection might not be the best it could be.  I remote in using the companies I am … Continue reading →

Posted in Azure Data Studio, Configuration | Leave a comment

Azure Data Studio 16.1 Notebook Charts #19

Posted on March 19, 2020 by martincroft

I love this product, it keeps getting better and better and I keep finding new things out daily, the latest version came out today (and I only just noticed) I was coming to write the daily blog when I noticed, … Continue reading →

Posted in Azure Data Studio, Notebooks, Visualisation | 1 Comment

Azure Data Studio – My SQL snippets freebie #18

Posted on March 18, 2020 by martincroft

I showed how easy it is to create a snippet in a previous blog and said I would share my snippets file. These are the current SQL snippets sqlblocking – List blocked processes order by head blocking processes sqlschema – … Continue reading →

Posted in Azure Data Studio, Productivity, Snippets, TSQL, Uncategorized | Leave a comment

Azure Data Studio Snippets #17

Posted on March 17, 2020 by martincroft

I know snippets have been around for years and I have utilised lots of SSMS tools like ssmstoolspack back in the day persuading a company I worked for to buy a copy for the developers.  Of late my SSMS tool … Continue reading →

Posted in Azure Data Studio, Azure Data Studio Extensions, Management Studio, Productivity, Snippets, Uncategorized | Leave a comment

Azure Data Studio – Poor SQL Formatting extension #16

Posted on March 16, 2020 by martincroft

The stock formatting can be improved on with the Poor SQL formatting extension first it needs installing once installed open settings (Ctrl+,) type in poor, hit enter Configure as required to your specific configuration, at least change the keywords to … Continue reading →

Posted in Azure Data Studio, Azure Data Studio Extensions, Configuration | Leave a comment