Category Archives: Tips & Tricks

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

Posted on March 12, 2020 by martincroft

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

Posted on March 10, 2020 by martincroft

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)

Posted on March 9, 2020 by martincroft

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)

Posted on March 5, 2020 by martincroft

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)

Posted on March 3, 2020 by martincroft

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

Posted on March 2, 2020 by martincroft

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

Posted on March 1, 2020 by martincroft

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

Creating test data using TSQL- 4 weeks of CPU stats

Posted on October 21, 2019 by martincroft

To Spoof the creation of SQL creating the CPU stats for the last 4 weeks I used some useful SQL routines, the full code is linked here but the relevant sections are explained in the blog post. These are a … Continue reading →

Posted in DataScotland, Tips & Tricks, TSQL | Leave a comment

Data Scotland Presentation

Posted on September 25, 2019 by martincroft

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

Posted on April 29, 2019 by martincroft

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