Category Archives: Uncategorized

Azure Data Studio – The run book #21

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

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

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

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)

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

Email Security SQL Server

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

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