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...

Read the latest Blogs

Forums

Restor DB

By ramyours2003

what is the procedure to restore a database of size 2 TB with a ...

Encyrption and change field as same time

By barry.nielson

Hello all. I am doing this to modify a field and encrypt data in...

Duplicate title

By barry.nielson

Duplicated post. plz ignore

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers