External Article

Formatting SQL Code - Part the Second

When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is possible, in a way that errors stand out. The extra time it takes to write code in an accessible way is far less than the time saved by the poor soul in the future, possibly yourself, when maintaining or enhancing the code. There isn't a single 'best practice, but the general principles, such as being consistent, are well-established. Joe Celko gives his take on a controversial topic.

External Article

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

By

If you are considering any of the ISACA AI certs like the Advanced Artificial...

A Fabric solution can be very cost effective

By

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Track SQL Server Configuration Changes Using the Error Log

By

Track SQL Server Configuration Changes Using the Error Log If you...

Read the latest Blogs

Forums

Alamat kontak resmi BCA KCP Blok M Tlp/Wa:0817-866-887

By layanan 24jam BCA

WhatsApp:0817866887 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...

Alamat kontak resmi BCA KCP Benhil Telp:0817866887

By CSO BCA

Tlp/Wa_Cs:0817-866-887  Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...

Alamat kontak resmi BCA KCU SCBD Telp:0817866887

By CS BCA

Tlp/Wa_Cs:0817-866-887  Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...

Visit the forum

Question of the Day

Detecting Deadlocks Quickly

In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?

See possible answers