What Have I blogged
January 2021 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 -
Recent Posts
Archives
Cloud
Azure Data Studio Azure Data Studio Extensions Beers Bit of fun Configuration Dashboards Dataplatform DataScotland Docker extensions Management Studio Markup Notebooks Performance Tuning PowerShell Productivity Snippets SQL Notebooks SQLSaturday SQL Security Tips & Tricks TSQL Uncategorized virtualization Visualisation Waffle YorkshireCategories
- Azure Data Studio
- Azure Data Studio Extensions
- Beers
- Bit of fun
- Configuration
- Dashboards
- Dataplatform
- DataScotland
- Docker
- extensions
- Management Studio
- Markup
- Notebooks
- Performance Tuning
- PowerShell
- Productivity
- Snippets
- SQL Notebooks
- SQL Security
- SQLSaturday
- Tips & Tricks
- TSQL
- Uncategorized
- virtualization
- Visualisation
- Waffle
- Yorkshire
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
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
Comments Off on ADS Extensions (6/31)
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
DBA / Developer Tool Set
#DBA #SQLDeveloper customisable toolset that was shown in a presentation as part of #SQLPASS Manchester / Leeds in June Continue reading
All Change again
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