Articles

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.

2019-05-20 (first published: )

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.

2019-05-20

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.

2019-05-17

Overview of Azure Cosmos DB

Cosmos DB is Microsoft’s highly scalable, NoSQL database platform running in Azure. It supports four API models, including Key-Value pair and Documents. Pushpa Sekhara provides an overview of Cosmos DB, including some best practices to improve performance.

2019-05-16

Blogs

Learning Containers

By

I find that I’m using containers more and more to get things done with...

Bad Idea Cowboy Hat: Using a foreign key to prevent updates

By

When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series...

Inspector V1.4 now available

By

The SQL Installation script can be found here The Inspector sample report has been...

Read the latest Blogs

Forums

Lock Request Timeout period Exceeded Error 1222

By homebrew01

A long running job is doing a SELECT INTO a table, so the table...

Primary Keys

By cbrammer1219

What is a good way to determine which combinations of fields should make up...

Net Earned in Triangles without a Triangular Join?

By Thom A

Something I've been trying to figure today is can I achieve a figure for...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers