Activity overview
Latest activity by JoshH
Hello,
That's a pretty old version of SQL Prompt! Do you have the ability to upgrade or is your license only for that version? I can try it out on my side, but it's going to be in version 10.16.5, so I can't guarantee I'll see the issue you are reporting.
/ comments
Official comment
Hello,
That's a pretty old version of SQL Prompt! Do you have the ability to upgrade or is your license only for that version? I can try it out on my side, but it's going to be in version 10.16.5,...
Another thing to check is if you look at your SQL Prompt options, then check under queries for History, is the "Automatically remove queries older than X days" checked?
[image]
/ comments
Another thing to check is if you look at your SQL Prompt options, then check under queries for History, is the "Automatically remove queries older than X days" checked?
Hi, can you tell me what version of Prompt you are using?
Also, if you look at the SqlHistory.db file (I use SQLite DB Browser for an easy way) how far back does the file show data?
/ comments
Hi, can you tell me what version of Prompt you are using?
Also, if you look at the SqlHistory.db file (I use SQLite DB Browser for an easy way) how far back does the file show data?
Just to add to what emmar00 said, Flyway is comprehensive DevOps software that covers generation of deployment scripts, integrates into pipelines, and also handles source control. You may want to take a look at that to see if that fits your needs as well. / comments
Just to add to what emmar00 said, Flyway is comprehensive DevOps software that covers generation of deployment scripts, integrates into pipelines, and also handles source control. You may want to t...
A few questions:
What version of SmartAssembly are you using?
How are you integrating SmartAssembly into Visual Studio?
I ask because .Net 8 support was only added in the last couple of versions, so that might have something to do with it.
/ comments
A few questions:
What version of SmartAssembly are you using?
How are you integrating SmartAssembly into Visual Studio?
I ask because .Net 8 support was only added in the last couple of versions...
What version of SQL Prompt are you using? Does SQL History show up in your men bar?
[image]
[image] / comments
What version of SQL Prompt are you using? Does SQL History show up in your men bar?
While Redgate Monitor doesn't allow searching by the QueryHash, the TopQueries_StableSamples table (begins with data.xxx and grouped by your type, ie cluster, AzureSqlServer, etc) collects the QueryHash. That might help you get what you are looking for. As for a feature request, you can enter those at our UserVoice website. Our project managers are always looking at those for ideas about new features to add. / comments
While Redgate Monitor doesn't allow searching by the QueryHash, the TopQueries_StableSamples table (begins with data.xxx and grouped by your type, ie cluster, AzureSqlServer, etc) collects the Quer...
To fix this the send from address has to match exactly what was set up. / comments
To fix this the send from address has to match exactly what was set up.
Hello,
You can configure custom comparison keys for each table to match rows based on specific columns, like using the role name rather than role id. Here's how you can set it up: 1. Open SQL Data Compare and set up your data sources for comparison. 2. In the "Tables & Views" mapping screen, locate the tables you want to compare. 3. For the table where you want to use a custom key (e.g., the "roles" table), click on the "Comparison Key" column next to the table name.
If SQL Data Compare hasn't automatically selected a comparison key, or if you want to change it, you can specify a custom comparison key.
Select the columns you want to use as the comparison key (e.g., the "role name" column).
By setting a custom comparison key, SQL Data Compare will match rows based on the specified columns, allowing you to synchronize data accurately even when using natural keys like role names instead of surrogate keys like role IDs.
/ comments
Hello,
You can configure custom comparison keys for each table to match rows based on specific columns, like using the role name rather than role id. Here's how you can set it up: 1. Open SQL Data...
What version of SQL Multiscript are you using? When the query runs against the other dbs, how long does it take? Is there anything significantly different about the last db? / comments
What version of SQL Multiscript are you using? When the query runs against the other dbs, how long does it take? Is there anything significantly different about the last db?