Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

The SQL Server team is unleashing the first widespread test builds of the next version of Microsoft's database, a k a SQL Server 2008 R2 (codenamed "Kilimanjaro").

tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected ...

SQL Test is the user interface for tSQLt, the open source unit testing framework for SQL Server. From the SQL Test window, users can create test classes, view existing unit tests, execute them ...

Who needs extra stress in their lives? Well, here’s a tool to add stress to your SQL Server. It’s called SQLIOSim. It’s from Microsoft and it’s free. SQL Server Magazine highlighted this ...

The Katmai TAP tests commence in June 2007. All testing will be done in secret, according to the original TechNet post. When is SQL Server Katmai due to ship?

Anyone have any ideas about how to simulate real-world scenarios in a dev environment? Specifically regarding SQL Server. To get a good picture of real-world performance behaviors (locking ...

A comparison of SQL Server's throughput performance on Microsoft Azure and Amazon Web Services (AWS) gives the edge to Microsoft's cloud.

The SQL Developer unit testing framework involves a set of sequential steps for each test case. The steps are as follows, including the user input for before the step is run and the framework ...

Recently I wanted to test out SAN access with SQL Server while I was on the road. I wasn’t able to get access to our Data Center which runs with an IBM DS4300 SAN via Fiber Channel using a ...