Category Archives: Productivity

Azure Data studio – PowerShell Command Explorer – Day #24

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

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 – My SQL snippets freebie #18

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

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

Getting the git repository- AzureDataStudio. And an offer that I might regret this one! Maybe not (14/31)

I have stored the GitHub Presentation in the following location https://github.com/martincroft/SQLPresentations.git I quite like presenting the same talk at multiple locations (turns out they have been cancelled since I drafted this), but we need to look after each other so … Continue reading

Posted in Azure Data Studio, Productivity | Leave a comment

ADS Keyboard Shortcuts -part 1

The 2nd post in a series, suppose starting at configuring ADS is a good place to start and the power and productivity in ADS come from learning several short cut keys.  At this stage, it’s worth mentioning a few time-saving … Continue reading

Posted in Azure Data Studio, Productivity, SQLSaturday, Tips & Tricks | Leave a comment

Data Scotland Presentation

It’s now (well) over a week since I presented at Data Scotland in Glasgow and had an amazing time, definitely one to add to the calendar for next year and Glasgow is such a vibrant city I presented a talk called … Continue reading

Posted in PowerShell, Productivity, SQL Notebooks, Tips & Tricks | Leave a comment

5 things in 5 minutes presentation- Data & Gravy

It was 2nd year attending the great data event hosted in Leeds (for those who don’t know its near Manchester and not far from Lancashire), last year I did a full hour presentation. This year I wasn’t as organised submitting … Continue reading

Posted in PowerShell, Productivity, SQL Notebooks, Tips & Tricks, TSQL | Tagged , , , , , , , , , , | 2 Comments

SQL Solutions – Part 2 bookmarks

Bookmarks combined with SQL solutions can start to give some serious power to a script library. In the previous blog post I covered creating a script library, he’s a copy of one that i created / use daily. SO i … Continue reading

Posted in Configuration, Management Studio, Productivity, Tips & Tricks | Leave a comment

Horizontal Whitespace & Vertical Select

Another demo from the June SQL Pass / SSUG presentation. Some of the lesser known features of management studio is the ability to vertically select data (see below) and also delete white space the following is an example of using these. … Continue reading

Posted in Management Studio, Productivity, Tips & Tricks | Leave a comment