Martyn Jones

Great session by @HeiniIlmarinen and with both a surfboard and cycling jersey in the background someone I'm definitely going to follow :D Thanks again. #PASSDataCommunitySummit

@Doctor_Who You can run them manually, disabling them disables the schedule. You can even create a job that runs disabled jobs :D #sqlhelp

Can I run a disabled SQL Job manually, or do I have to enable it first? This is in a SQL 2019 instance. #sqlhelp

Sessions all planned for @redgate #PASSDataCommunitySummit this week, can't wait! Easiest way to organise yourself: Favourite sessions of interest then pick from the schedule. So many great sessions and some hard choices made. #SQLServer #data #PowerShell

SQL Server Restore Error 19 - devondba.blogspot.com/2021/10/sql-se… #sqlnewblogger

A strange issue resolved: SQL Server 2019 Log Shipping issue, could not log history/error messages. devondba.blogspot.com/2020/12/sql-se… #sqlnewblogger

@PlantBasedSQL I think Get-DbaDbCertificate may give what you need, from the #dbatools module #Get-DbaDbCertificate" target="_blank" rel="nofollow noopener">docs.dbatools.io/#Get-DbaDbCert… #sqlhelp

@sqldbawithbeard @Kendra_Little @AngelaTidwell Totally agree & it's always good to see you, in a virtual world on the velo, or in person; hopefully in person again soon but for now it's #zwift. Have fun, probably the key to forming habits and creating the new norm :)

@Kendra_Little @AngelaTidwell I have managed to create a habit of an indoor cycle first thing in the morning, now it has become the norm and that is a good thing.

My plan as we head into this next lockdown is to build a habit to log 30+ mins of purposeful activity every day (walking / light yoga on rest days). And to work on plank every day. (I hate plank but it is needed.) Grateful to have the luxury to fit this into my life.

@pdgb @Kevin3NF @BrentO @bobwardms @mike_walsh @sqlstudent144 @erinstellato @Lance_LT @AngelaTidwell @gbargsley Ha Ha go @KillaDBA! Love it.

OK, who did this... youtu.be/Rc6Gmk-R3jo #sqlhelp @Kevin3NF @BrentO @bobwardms @mike_walsh @sqlstudent144 @erinstellato @Lance_LT @AngelaTidwell @gbargsley

@gbargsley Glad you got it sorted. Something for next time perhpas, take a look at #dbatools Set-DbaTempDbConfig: #Set-DbaTempDbConfig" target="_blank" rel="nofollow noopener">docs.dbatools.io/#Set-DbaTempDb… #sqlhelp

Further info, the c# references a file in the GAC. Is there anything security wise, relating to the GAC, which could affect it please? part 2 #sqlhelp

Hey All, I'm having an issue: an SSIS package referencing a UNC path fails when called by me from the Catalog. If I exec via SQL Agent, using proxy with me as cred, it works. All path permissions seem fine. I'm waiting to get a copy of the package but any thoughts? #sqlhelp

Quick query to see if connections to sql server are encrypted: devondba.blogspot.com/2020/06/encryp… #sqlnewblogger #sqlserver #SQL

PowerShell to alert on locked out AD account devondba.blogspot.com/2020/04/find-l… #SQLNewBlogger #PoSh #powershell

War hero Tom Moore aged 99 to be knighted! #CaptainTomMoore  - Sign the Petition! chng.it/YLPxKkcd via @UKChange

Find out who is in my van! Our schedule has just been published and we think it is awesome. 42 sessions to pick from. 11 days to go! dataweekender.com/schedule

Captain Tom, at 100 years old, has now raised over £28 million for the NHS, simply inspirational, what an amazing man. justgiving.com/fundraising/to… youtube.com/watch?v=LcouA_…

PowerShell 7 was released on the 4th. If you've not installed it yet here's a couple of links that will help you understand it and crack on with your install: devondba.blogspot.com/2020/03/powers… #PowerShell7 #PowerShell #sqlnewblogger

Today's problem resolved, System.Core error using Biml to copy SSIS package devondba.blogspot.com/2020/02/biml-e… #Biml #SSIS #sqlnewblogger #SQL #SQLServer

The strange issue of when SQL Server Configuration Manager won't start/error: devondba.blogspot.com/2019/11/sql-se… #sqlnewblogger

@RoniVeredAdar For an easy test and fix you could use dbatools,io commands: Test-DbaPowerPlan to show the current settings and recommendation then Set-DbaPowerPlan to change it :) #dbatools #sqlhelp

#sqlhelp, Is there ANY reason to keep a Production DB server with a "Balanced Mode" Power Plan settings (a Win2012R2 VM with 4CPUs - SQL Server Enterprise 2014SP3) ?