The Voice of the DBA

Blog Post

Finding Failed Job Steps

Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them...

2021-08-18

383 reads

Blogs

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

By

Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...

Optimizing Redshift Performance by Configuring WLM Queues

By

Efficient query performance in Amazon Redshift often comes down to how well you manage...

PowerShell Strikes Back: Return of the Loop

By

Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...

Read the latest Blogs

Forums

BCA KCP Kebon Sirih No.Telpon 087781685647

By ricardooliveira

Whatsapp 087781685647 Jl. Kebon Sirih No.6A Lantai 1 B, RT.14/RW.2, Gambir, Kecamatan Gambir, Kota...

BCA KCP Undaan Telpon/WA:083179431313

By Nha cai Thienhabet

WhatsApp:083179431313Plaza Ciputat Mas Jl. Ir H. Juanda No.5A Blok AD 5, Rempoa, Kec. Ciputat...

Bank Central Asia. PT Tbk Call Center/Telpon 083179431323

By wesan

Call Center/Telpon 083179431323 HMMF+G8F, Jl. Diponegoro Dalam, Madras Hulu, Kec. Medan Polonia, Kota Medan,...

Visit the forum

Question of the Day

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

See possible answers