Activity overview
Latest activity by emmar00
NickP I still run into this from time to time. I don't think it's really a problem with SQL Prompt; it's the SSMS intellisense that thinks your new object is invalid. You can also flush this to get it to stop complaining by going to Edit > IntelliSense > Refresh Local Cache, or Ctrl+Shift+R for short. I personally have gotten in the habit of doing both the Ctrl+Shift+R and Ctrl+Shift+D to reload suggestions when I see complaints about an object that I have just created. / comments
NickP I still run into this from time to time. I don't think it's really a problem with SQL Prompt; it's the SSMS intellisense that thinks your new object is invalid.You can also flush this to get ...
You may want to post this on the UserVoice site then: https://sqlmonitor.uservoice.com/forums/91743-suggestions . That would probably be the best way for others to see and indicate if it is valuable to them, since it's kind of dead around here. Personally I could see this being kind of neat to have. / comments
You may want to post this on the UserVoice site then: https://sqlmonitor.uservoice.com/forums/91743-suggestions . That would probably be the best way for others to see and indicate if it is valuabl...
Have you tried logging in to the Redgate Portal in the browser to see if you have a license? That might refresh or set your access token as well. / comments
Have you tried logging in to the Redgate Portal in the browser to see if you have a license? That might refresh or set your access token as well.
You might want to post this on the UserVoice site then: https://redgate.uservoice.com/forums/94413-sql-prompt . This is probably the best way for others to weigh in on how important it is to them. / comments
You might want to post this on the UserVoice site then: https://redgate.uservoice.com/forums/94413-sql-prompt . This is probably the best way for others to weigh in on how important it is to them.
This was seemingly released in version 10.15.0 (November 2024), with a few fixes and enhancements since: Added the ability to show the aggregate values of a selection of cells in the results grid. When I select a range of cells, I can right-click and do Show Aggregate Results, which shows things like COUNT and DISTINCT for string values and COUNT, DISTINCT, SUM, AVERAGE, MIN, and MAX for numerics. / comments
This was seemingly released in version 10.15.0 (November 2024), with a few fixes and enhancements since:Added the ability to show the aggregate values of a selection of cells in the results grid.Wh...
I'm not sure if this is the cause of your problems but did see in the release notes for 14.28.0: Fixed an issue where SQL Server backups were not shown on the Estate > Backups page, and backup overdue alerts were raised incorrectly, when the database name recorded in the backup history differed in case from the actual database name. Many of my backup overdue alerts appeared to be due to this. The database would be named something like “HR_PROD” but msdb would contain backup records for “hr_prod”, and thus Monitor would complain about not finding backups for HR_PROD even though it was regularly receiving all its backups. / comments
I'm not sure if this is the cause of your problems but did see in the release notes for 14.28.0: Fixed an issue where SQL Server backups were not shown on the Estate > Backups page, and backup over...
What is the outputProgress parameter and how do I use it?
The release notes for v12.9.0 of the Flyway CLI mention “check drift, changes and dryrun commands now report phase-level progress when outputProgress is enabled” (emphasis mine). This seems like a ...
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors. When it comes to actually deploying the changes, that might be more a question of your CI/CD rules. One team I work with has the standard that each deployment target has a branch (so a beta branch, a main/production branch) and any new migrations are first merged into those branches before deployment occurs. / comments
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors.When it comes to actually deploying the ...
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move anyone's changes to any environment. So for example, Team 1 will start their migrations at number 10000, Team 2 will start with 20000, and Team 3 will start with 30000. That gives you 10,000 migrations per team until you run out. At that point you should probably be doing a rebaseline anyway. / comments
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move a...
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351) [image] One downside is that you cannot use “Match whole words only” to insist that each term is a whole word. (For example, to exclude matches of “Donec” for “nec”.) That will make it search for both words together as a phrase ("nec ipsum"). I do agree, it would be preferable to have support for more “standard” search operators like quotes and maybe some AND/OR logic. / comments
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351)One downside is that you cannot use “Mat...