Technical Article

SQLServerCentral Webinar Series #11: A Sandbox Development Process

Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.

External Article

Arrays in SQL that Avoid Repeated Groups

It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.

Blogs

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

T-SQL Tuesday #200: When I Look at a Query …

By

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...

Reflections on the Life of a DBA

By

The DBA life is fraught with pain. Those battles that we endure are mostly...

Read the latest Blogs

Forums

ALAMAT KONTAK BCA KCU CILACAP Telp:08218154393

By layanan 24jam BCA

WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...

ALAMAT BCA KCP Telepon Kota Telp:08218154393

By layanan 24jam BCA

WA:08218154393 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...

A Quick Second Opinion

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Second Opinion

Visit the forum

Question of the Day

Checking the Error Log I

On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?

See possible answers