Martyn Jones

1.1K posts

Martyn Jones

Martyn Jones

@MartynJones76

Work in Bath, UK. Love SQL, PowerShell, automation, learning & occasionally blogging. Enjoy swimming, cycling, running (Triathlons), Tae Kwon Do, BBQs, Camping.

Bath Katılım Ağustos 2012
178 Takip Edilen182 Takipçiler
Martyn Jones
Martyn Jones@MartynJones76·
@Doctor_Who You can run them manually, disabling them disables the schedule. You can even create a job that runs disabled jobs :D #sqlhelp
English
0
0
1
0
Rod Falanga
Rod Falanga@Doctor_Who·
Can I run a disabled SQL Job manually, or do I have to enable it first? This is in a SQL 2019 instance. #sqlhelp
English
1
0
0
0
Martyn Jones
Martyn Jones@MartynJones76·
@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 :)
English
0
0
1
0
Kendra Little
Kendra Little@Kendra_Little·
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.
English
1
0
23
0
Martyn Jones
Martyn Jones@MartynJones76·
@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
English
1
0
1
0
Martyn Jones
Martyn Jones@MartynJones76·
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
English
0
0
0
0
Martyn Jones
Martyn Jones@MartynJones76·
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
English
1
0
0
0
Martyn Jones retweetledi
#DataWeekender
#DataWeekender@DataWeekender·
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
English
3
19
29
0
Martyn Jones
Martyn Jones@MartynJones76·
@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
English
1
0
0
0
Roni Vered Adar
Roni Vered Adar@RoniVeredAdar·
#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) ?
English
4
0
0
0