SQL in the City Summits – US & Down Under

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

Testing Databases: What’s Required?

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

The Silent Bug I Find in Most Triggers

I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a minimum (say, 2-3), and don’t try to do something really slow like fire up a cursor, triggers can be an efficient way to solve hard problems quickly. However, most triggers I run across have a really, really dangerous bug.

Blogs

SQLDay 2019 – day 3 (last)

By

SQLDay 2019 has come to an end. Three days with workshops, technical sessions, networking...

Back with a new focus

By

First let me say wow can’t believe that it has been almost 3 years...

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...

Read the latest Blogs

Forums

Preventing Access

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preventing Access

Creating Aliases for Docker Commands in Linux

By carlos10robles

Comments posted to this topic are about the item Creating Aliases for Docker Commands...

error Output File cleanup does not delete files script d'olla

By abdalah.mehdoini

Hello everyone, I use olla scripts in my backup and maintenance operations there is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers