SQL Server: Job – How to find jobs calling a specific stored proc?
[sql]SELECT j.name FROM msdb.dbo.sysjobs AS j WHERE EXISTS ( SELECT 1 FROM msdb.dbo.sysjobsteps AS s WHERE s.job_id = j.job_id AND s.command LIKE ‘%store_proc_name%’ ); [/sql]
Day: September 24, 2017
Visual Studio: Package Management – How to install references from NuGet?
Access to “https://www.nuget.org/” Search package Install: Tools > NuGet Package manager > Package manager Console [sql]Install-Package PdfSharp -Version 1.50.4619-beta4c[/sql] Uninstall [sql]Uninstall-Package PdfSharp -Version 1.50.4619-beta4c[/sql]
Web API: All about
NodeJS Installation Usage [js] /* users.json { “user1” : { “name” : “mahesh”, “password” : “password1”, “profession” : “teacher”, “id”: 1 }, “user2” : { […]
How to Win Friends & Influence People
What’s in it for me? Learn the simple rules for being more popular and persuasive. Since How to Win Friends & Influence People was published […]
Investing In People
What’s in it for me? Learn why effective HR is crucial to success and how you can achieve it. Are you passionate about human resources? […]
Tipping Sacred Cows
What’s in it for me? Discover common flaws in our thinking and how we can overcome them. In a famous old prank, especially in some […]
The Discomfort Zone
What’s in it for me? Learn how to create a safe conversational space to have those tough talks. We all avoid tough conversations. As a […]
The Power of Full Engagement
What’s in it for me? Live your life in accordance with your purpose. How many of us believe that we’re not operating at our full […]