External Article

Cloud Services for the DBA

A critical part of any DBA's role is implementing the systems that will improve in the long term their organization's guardianship, use and understanding of its data. Too often, however, this gets lost in the fog of immediate and urgent tasks. Gareth Marlow explains why he believes Cloud services will play an increasingly prominent role in helping DBAs achieve their strategic goals.

External Article

SQL Server Database RESTORE WITH MOVE or not WITH MOVE

Mike Eastland frequently restores production databases to various development servers. The drive layouts between the servers are almost never the same. He is constantly shuffling files on his development servers due to space constraints, which in turn breaks the automated restore scripts because the MOVE clauses are invalidated. Does he have to use the MOVE clause every time he does a restore?

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 KCU SCBD No. telp:087757645171

By midani222

Whatsapp:087757645171 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...

BCA KCU A. YANITelepon 083179431638

By Nha cai Thienhabet

WhatsApp083179431638Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282

BCA KCP Wahid Hasyim No.Telpon 087781685647

By ricardooliveira

Whatsapp 087781685647 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota Jakarta...

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