Reconnect Azure DevOps Server to SQL after server name change 20 August 2020 Donovan Work (0) In this post I show you how to update the connection string of Azure DevOps to connect to SQL after server name change. [More]
Fun with SQL Server Containers 07 October 2018 Donovan Work (1) In this post I show how to get started with SQL Server containers running on Windows. [More]
2015 Ignite New Zealand demo prep: Step 6 24 October 2015 Donovan-Brown Work (0) In this post we will setup the back end. [More]
How to setup a SonarQube server in Azure 17 June 2015 Donovan-Brown Work (8) SonarQube allows youto track and manage your technical debt. At the center of a SonarQubeinstallat [More]
I can’t use SqlPackage to deploy my dacpac to Azure Sql Database 08 February 2015 Donovan-Brown Work (0) Problem: Each time I try to use a dacpac to deploy to my Azure Sql Database it times out with the following error: Publishing to database ''mydatabase_dev' on server 'mydatabase.database.windows.net'. Initializing deployment (Start) Initializing deployment (Failed) SqlPackage.exe : *** An error... [More]
How to connect SQL Server Data Tools 2012 to TFS 2013 12 October 2014 Donovan-Brown Work (0) Problem: I installed SQL Server 2012 Standard Edition with SP1 with SQL Server Data Tools and I need to version my projects in TFS 2013. Solution: The IDE for SQL Server Data Tools is Visual Studio 2010 Shell. By installing Microsoft Visual Studio Team Explorer 2010, Microsoft Visual Stud... [More]
How to install SQL Server Compact 4.0 Prerequisites for my setup project 13 January 2014 Donovan-Brown Work (0) Problem: I am missing SQL Server Compact 4.0 Prerequisites for my setup project. Solution: Use the Microsoft Web Platform Installer to install Visual Studio SP1 Tools for SQL Server Compact 4.0.
How do I grant permissions to ApplicationPoolIdentity in SQL Server 26 December 2013 Donovan-Brown Work (0) Problem: My IIS Application Pool is using ApplicationPoolIdentity and does not have permissions to my SQL Server database. Solution: Open Sql Server Management Studio (SSMS) and create a new login for "IIS AppPool\{YourAppPoolNam}". On the User Mapping page give the user access to the datab... [More]
How do I validate data in my database during a web test 25 August 2011 Donovan-Brown Work (0) Problem: The only way I can verify the success of my web test is to read a value from a database. Solution: Create a custom validation rule that can validate the value in the database. Code: using System; using System.ComponentModel; using System.Data.SqlClient; using Mic... [More]
I can't run my scripts created by DBPro in SSMS 26 July 2011 Donovan-Brown Work (0) Problem When I try and run my deploy scripts from DBPro in SSMS I get syntax errors where variables are used. Solution Switch on SQL CMD Mode before you execute the SQL file. To enable the SQL CMD Mode select SQL CMD Mode from the Query menu in SSMS.