Category Archives: Tips & Tricks

Azure Data Studio -The gift that keeps on giving (day 12/31)

I thought I had come up with a clever way of searching in Azure Data Studio to search for the filename of a SQL or PowerShell file using a PowerShell script that read the file in reversed the file, and … Continue reading

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

Azure Data Studio – wow more time saving

I worried I would not have content for 31 blog posts, however, I keep finding more new stuff daily. I am working in an environment with a few hundred SQL servers and managing the servers list is a pain.  I … Continue reading

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

Azure Data Studio Notebooks Markup (9/31)

Notebooks are great ways to add code and documentation to SQL scripts and PowerShell scripts to add clarity and increase productivity (if you add the syntax you don’t need to google it each time you need to change it slightly!. … Continue reading

Posted in Azure Data Studio, Markup, Tips & Tricks | Tagged , | Leave a comment

Azure Data Studio – Database Status Dashboard (5/31)

One of the things I was finding I was missing was when restoring databases and adding into availability groups. It was quite easy to see in SSMS when databases, were synchronized or syncronizing or had just plain, fell over when … Continue reading

Posted in Azure Data Studio, Dashboards, SQLSaturday, Tips & Tricks, TSQL | Tagged , , , | Leave a comment

ADS Keyboard Shortcuts -part 2 and a name drop or two (Day 3)

Day 3 of posts around ADS and time for a name drop.  I mentioned I managed to be selected to speak at SQL Saturday Iceland ( as since drafted also Belgium and SQL Denmark) a fellow speaker mentioned some of … Continue reading

Posted in Azure Data Studio, SQLSaturday, Tips & Tricks | Tagged , , | 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

ADS – Azure Data Studio SQL Saturday’s

I have used ADS (Azure Data Studio) from time to time since it was originally released, I tend to move back however to using SSMS as its not the finished article. It does, however, evolve with monthly releases. Well, that’s … Continue reading

Posted in Azure Data Studio, SQL Notebooks, SQLSaturday, Tips & Tricks | Tagged , , , | 1 Comment