External Article

Jodie Beay and the Production Database Drift

You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you're worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of guilt. What would the Devs say? Somehow databases take on lives of their own, populated by the lost souls of users, Developers and DBAs. Has the Redgate DLM Team's practice Forex database somehow come alive?

External Article

Declarative SQL: Using UNIQUE Constraints

In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. In this introduction to Declarative SQL, Joe Celko demonstrates how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.

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 MUARA KARANG No.Telpon 087781685647

By ricardooliveira

Whatsapp 087781685647 Jl. Muara Karang Timur, Blok B VIII No.116-117, RT.6/RW.12, Pluit, Kecamatan Penjaringan,...

BCA KCU MENARA BIDAKARA No.Telpon 087781685647

By ricardooliveira

Whatsapp 087781685647 Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1, RT.1/RW.1, Menteng Dalam,...

BCA KCU PLUIT No.Telpon 087781685647

By ricardooliveira

Whatsapp 087781685647 Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North...

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