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?



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.



SSAS Tabular – Process Add memory consumption


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


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers