csherts csherts

Herts Chen is a data architect for the City of Portland, Oregon’s Corporate GIS group. He is responsible for integrating and modeling city and regional data, and he has a PhD.

Articles by csherts csherts
Cube-Partitioning Tests
Herts Chen describes the testing he did to prove his hypotheses about cube partitioning and improving Analysis Services performance.
Improving Analysis Services Query Performance 2
Analysis Services is a valuable business intelligence (BI) tool, but when queries become complex, Analysis Services can bog down. Get your queries running efficiently by using these techniques for proper cube partitioning.
Automatic Pilot
Manually customizing replication agent job steps speeds up snapshot replication, but it's impractical for a large-scale environment. Learn how to automate this customization in the last article of a three-part series.
Manual Transmission 3
Trying to copy large databases from one server to multiple remote servers can throw your snapshot replication into low gear. But you can rev up the process by manually customizing the replication's steps.
Stop, Drop, and Save
Here’s how the drop and save works when you add the customized drop step to a snapshot replication’s Distribution Agent job.
Bottleneck Blues
Are performance-sapping bottlenecks weighing down your snapshot replication environment? Here's how to optimize snapshot replication for large databases.
Why Not Transactional Replication?
When you want to copy large data sets to multiple target servers, snapshot replication beats transactional replication hands down.
Custom Scripting in SQL Server 2000
If your scripts are simple, static, and stable, you can use SQL Server 2000's custom scripting feature to perform custom tasks for snapshot replication.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×