Certifications

SQLServerCentral Article

From DBA to DWA

  • Article

Everyone wants to know what a DBA does and it is becoming a hard question to answer as the responsibilities and capabilities of database platforms increase. Longtime author Vincent Rainardi brings us the proposition of a new type fo DBA, one that focuses more on data warehousing.

4 (3)

You rated this post out of 5. Change rating

2007-09-17

8,483 reads

Blogs

A Conversation That Refused to End: What We Learned from Our First Event in Zurich

By

On May 8, 2025, we hosted our first official event in Switzerland at Prime...

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

Read the latest Blogs

Forums

CAST(VARCHAR(n)) resolved performance issue?

By mikael_ljunghorn

Hi, I would love to hear if anyone can tell me why a CAST...

isnull, coalesce overhead

By stan

hi, one of our sister division's erp extract view is going thru at least...

is there an elegant way for agent notification to show failure if any step fails

By stan

hi our corp dw load sqlagent job goes to the next step on the...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers