Malcolm Smith

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Malcolm Smith supported this idea  · 
    An error occurred while saving the comment
    Malcolm Smith commented  · 

    Can SSDT code be updated from check of variables from Windows Registry to Server Properties
    DefaultDataPath = SERVERPROPERTY('InstanceDefaultDataPath')
    DefaultLogPath = SERVERPROPERTY('InstanceDefaultLogPath')
    This could be switch for DB versions SQL2017 or later only

    Additional issue for PreDeployment, as PreDeployment runs AFTER CREATE DATABASE statements and not PRE deployment Code, so unable to use own dynamic SQLCMD created in the PreDeployment Script

  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Malcolm Smith commented  · 

    Had issue fro upgrade to 18.2 and now for move to 18.3

  3. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Additional Services  ·  Flag idea as inappropriate…  ·  Admin →
    Malcolm Smith supported this idea  · 
  4. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Malcolm Smith commented  · 

    There is alos a use case for tSQLt CI deployments.
    Having a test DB project referncing the DB under test and tSQLt command needs to create the Test Class aka Schema that the Test Cases aka Procedure are created in.
    I tried to add the creation of the Schema into the Pre-Deploy script but the docker build publish still tries to CREATE SCHEMA [mySchema] create in the Pre-Deploy script.

    Malcolm Smith supported this idea  · 

Feedback and Knowledge Base