Additional Articles

SQL Server Best Practices for Data Quality

Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?

2020-01-03

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.

2019-12-27

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Grant a user access to job history

By toyabre

Hello. I would like to give a user the right to see the history...

Concat XML field values ?

By jbalbo

Hi I have the XML field  below I need to concatenate the "Purpose of...

convert string + add '.'

By samirca007

Hello Please help me (how to modify a character string in sql server 2017)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers