DBA

Join our Affiliate Program

Can we send you a check every month? Earn ongoing monthly income by joining the free affiliate program We payout 35% commissions with a 90-day cookie for selling our courses. You could earn hundreds off a single email. email: training@cloudwer.co.uk and ask to join our affiliate program  

Microsoft Ending SQL Server 2019 Certifications

From June 30 2020, you will not be able to take a certification in SQL Server 2019 according to the Microsoft blog post This because the following courses are ending Microsoft Certified Solutions Associate (MCSA) Microsoft Certified Solutions Developer (MCSD) Microsoft Certified Solutions Expert (MCSE) There will be no further exams in SQL Server 2019. …

Microsoft Ending SQL Server 2019 Certifications Read More »

SQL Server Agent Jobs

Find out which SQL Agent Jobs that are currently running

Find out which SQL Agent Jobs that are currently running If you ever want to find out which SQL Server Agent jobs that are currently running on your server without using Management Studio, just run the code below. SELECT ja.job_id, j.name AS job_name, ja.start_execution_date, ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id, Js.step_name FROM msdb.dbo.sysjobactivity ja LEFT JOIN msdb.dbo.sysjobhistory jh …

Find out which SQL Agent Jobs that are currently running Read More »

Database

What is a database?

What is a database? I thought I would write this article for people who have no experience in SQL Server or know what a database is. A database is a method of storing information where that information can be accessed to answer or to solve questions. There are many types of databases that you can …

What is a database? Read More »