Dean Castro

Blogs

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

Read the latest Blogs

Forums

Two beginner Availability Groups questions

By webrunner

Hello experts, I'm an accidental DBA who recently joined a new group, and I'm...

SSIS Excecute SQL Task not executing simple T-SQL correctly.

By brettwalker42

Hello, I have an SSIS package with an Execute SQL Task that runs the...

Case when index scan faster then index seek (see example)

By ebooklub

Hi, we had case today  where query   with existing non clustered index  provided  100% ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers