SQL Server Testing Tips
Attach and Detach
Automation
- Automate SQL Server Testing with Profiler, SQLCMD and SSIS
- Test Driven SQL Server Development with LegiTest
Checklist
Configuration
Data
- Generating SQL Server Test Data with Visual Studio 2010
- Populating a SQL Server Test Database with Random Data
- SQL Server Stored Procedure to get every Nth row of a Query Result Set
Date Range
- How to test what a SQL Server application would do in the past or in the future with date and time differences
- SQL Server video to test what an application would do in the past or in the future
Deployment
Development
Performance
- Clearing Cache for SQL Server Performance Testing
- Getting real time SQL Server lab exposure to test new features
- Populate Large Tables with Random Data for SQL Server Performance Testing
Planning
- Avoiding SQL Server Query Disaster through Refactoring for Resilience
- Testing Options with SQL Server 2000 and 2005
- Using Microsoft Hands-On labs to get hands-on cloud experience for free
Random Data
- Generate Random Strings with High Performance with a SQL CLR function
- SQL Server T-SQL Code to Generate A Normal Distribution
Restore
Template
Tools
- Create delays in SQL Server processes to mimic user input
- Free Database Unit-Testing for SQL Server Data Tools
- Free Database Unit-Testing Framework for SQL Server
- Getting real time lab exposure to test latest SQL Server features
- How to Setup Boot from VHD for a SQL Server test or development environment
- SQL Query Stress Tool
- SQL Server Unit Testing with Visual Studio 2010
- Test Driven Development with Modern Database Tools using tSQLt
