Category Archives: Uncategorized

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 – 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

ADS Error switching Kernel in PowerShell Notebook (8/31)

Posted on March 8, 2020 by martincroft

When switching or attempting to switch Kernel, you get a prompt to install Python on clicking yes, it errors with the following message Could not start session: Installing Notebook dependencies failed with error: Process exited with with error code: 1. … Continue reading →

Posted in Uncategorized | Leave a comment

ADS Extensions (6/31)

Posted on March 6, 2020 by martincroft

Day 6 and I’ve arrived in Belgium for SQL Saturday tomorrow. I’m wondering the stupidly now of saying or doing 31 blog posts on ADS, a talk at SQL Saturday Belgium and SQL Saturday Iceland in March and the Organising … Continue reading →

Posted in Azure Data Studio, Uncategorized | Comments Off on ADS Extensions (6/31)

Email Security SQL Server

Posted on September 17, 2016 by martincroft

One security vulnerability that people don’t often realise , is that SQL server can email information out through the likes of  sp_send_dbmail. It goes without saying that you should take steps to stop emails externally and then if its a … Continue reading →

Posted in Uncategorized | Leave a comment

Kerberos -The annoyance that is

Posted on August 1, 2016 by martincroft

This is more about how to find something than finding something if that makes sense or doesn’t. Anyway a bit of back story is probably worthwhile at this point In the beginning  There was once a server that wasn’t working … Continue reading →

Posted in PowerShell, Tips & Tricks, Uncategorized | Leave a comment

DBA / Developer Tool Set

Posted on July 11, 2016 by martincroft

#DBA #SQLDeveloper customisable toolset that was shown in a presentation as part of #SQLPASS Manchester / Leeds in June Continue reading →

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

All Change again

Posted on February 11, 2016 by martincroft

I’ve been playing with SilvrBack for writing some blogs for a consultancy that I am involved with, which you can see these here posts blog.solutionsctrl.com however I always intended to blog on my own website as well.  I decided I was a … Continue reading →

Posted in Uncategorized | Leave a comment