Posts
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        Handle out of order changes to static data
                        
                        
                        
                        
                      
                      
                      
                  
                    We have a table that we use to store the current version of an application.  A simplified version of it can be thought of as a primary key (auto-incrementing) and a string with the application vers...
                      
                    
                      
                        Can flyway refuse to execute code with missing where clause?
                        
                        
                        
                        
                      
                      
                      
                  
                    SQL Prompt has the "Show execution warnings: Show warnings for statements with an INNER JOIN" that will warn a user in SSMS if execution may affect an undue number of records due to incorrect JOIN ...
                      
                    
                      
                        DataFileSet element in RedGateDatabaseInfo.xml changes
                        
                        
                        
                        
                      
                      
                      
                  
                  
                This part of the file seems to change without reason:  <DataFileSet>    <Count>3</Count>    <DataFile>MOM.Enums_Data.sql</DataFile>    <DataFile>MOM.Errors_Data.sql</DataFile>    <DataFile>MOM.Prin...
                      
                    