Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, February 13, 2018

Realistic, simulated data for testing, development and prototypes

SQLServerCentral.com Articles
Realistic, simulated data for testing, development and prototypes

This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it to various formats, then distribute it out to the different data technologies and platforms that require a copy of the data. The tool becomes a mechanism to support ‘polyglot persistence’.

sqlmonitor How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

No comments: