SQL Server 2014 Service Pack 1 Unattended Setup Error – "The specified value ‘Upgrade’ is invalid"

SQL Server 2014 Service Pack 1 Unattended Setup Error – “The specified value ‘Upgrade’ is invalid”   I was recently sent a question regarding a failed unattended install of SQL Server 2014 Service Pack 1.  The customer had spent some time searching online for the error message, but found surprisingly little detailed information for unattended…

4

Bulk Database Migration from On-Premise SQL Server to SQL Azure – Step 1: Bulk .bacpac Export

I recently had a task to perform a bulk migration of hundreds of databases to Windows Azure SQL Database (formerly known as SQL Azure) from an instance of SQL Server 2012.  If you need to migrate a very small number of databases, the easiest way is likely through the SSMS export Data-Tier Application wizard.  You can…

4

Creating Complex Test Databases – Generating One Table for each of the 2,397 supported Collations

As a follow up to my series on complex test databases, this article will cover one of the more interesting test databases that I recently created.    Goal:  Create a database that includes one table for each supported collation.  Each table contains a single column with the various column level collations supported by SQL Server 2012 (nearly…

0

Creating Complex Test Databases – Using Excel to convert a raw list of text into viable T-SQL syntax

As part of my series on creating databases with interesting characteristics for testing purposes, I have covered a few different engine constructs, test strategies, and scripting techniques to build interesting databases.  In this article, I am going to highlight one technique I use fairly often with leveraging Excel’s text concatenation functionality to generate T-SQL script…

4

Creating Complex Test Databases – Creating a Table with more than 1,024 Columns

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll cover a question that was asked in the SQL Server MSDN forums regarding column limits.  The question is “What is the true column limit in SQL Server?” From a testing perspective, one of the more interesting documentation articles is…

0

Creating Complex Test Databases – Request for Ideas

Over the past week, I’ve written a few entries regarding complex databases with interesting characteristics for testing purposes.  Creating Complex Test Databases – Intro  Creating Complex Test Databases – Creating a Database with 1 Billion Random Rows  Creating Complex Test Databases – Generating One Table for each of the 2,397 supported Collations  Creating Complex Test…

1

Creating Complex Test Databases – Creating a Table with all Supported SQL Server Data Types

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll leverage the internal SQL Server system tables to create a table containing columns of each nullable and non-nullable data types supported by SQL Server. Goal:  Create a table that contains one column of every nullable data type and one column for…

1

Creating Complex Test Databases – Creating a Database with 1 Billion Random Rows

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll create a database containing a large number of tables, each with a large number of rows inserted. Goal:  Create a database with ONE BILLION ROWS.  The database should contain 1,000 tables with each table containing 5 integer columns and…

0