This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.

Loading partitions incrementally using SSIS

by Shubs

SQLServerCentral.com

partition

In this article, we discuss how to load large partition tables incrementally.

Organisations and Technical Apartheid

by David Poole

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.

Tips for Better Presentations

by Additional Articles

Brent Ozar Blog

Presentations

Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.

The Road to Better Data Handling

by Steve Jones

SQLServerCentral

Data Privacy and Protection

As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.

What’s the Difference Between PERCENT_RANK and CUME_DIST?

by Kathi Kellenberger

SQLServerCentral

Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.

How can we close the tech skills gap?

by Additional Articles

Redgate

software development

One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.

Improving Tech with Compassionate Code

by Additional Articles

SimpleTalk

Career Growth

There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.