Activity overview
Latest activity by ScottSauber
I like highlighting a row in the SSMS results and saying "Script as Insert" to automatically create an insert script for me. Super handy when I need to move that data over somewhere else (i.e. from my local Docker database into a migration script in Flyway). / comments
I like highlighting a row in the SSMS results and saying "Script as Insert" to automatically create an insert script for me. Super handy when I need to move that data over somewhere else (i.e. from...
I’ll be there! I have a few clients on Flyway (with both Postgres and MSSQL but Postgres being the new default for new apps) and one on SCA (MSSQL) right now. Some questions I have about Deploy are: - When do I pick this over Flyway or SCA? Or re-phrased, what are the tradeoffs? - If a client is on either Flyway or SCA, what’s the sales pitch for getting them to consider Deploy? Should they be? - Is there one product Redgate is investing in more heavily and possibly reducing investment in another? - Is there a table or comparison chart that gives a rundown of features and what is available in which product? Thanks! Looking forward to learning more. / comments
I’ll be there! I have a few clients on Flyway (with both Postgres and MSSQL but Postgres being the new default for new apps) and one on SCA (MSSQL) right now.Some questions I have about Deploy are:...
I'm in! / comments
I'm in!
Another handy one from SQL Prompt is the "Copy as IN clause" feature. When you get the results back from running a query, you can highlight the entire column (or just the values you care about), then right-click and choose "Copy as IN clause." This will save those values to your clip board as an IN statement. So if you highlight values 1,2,3 it will put "IN (1,2,3)" onto your clipboard. This is handy during data exploration and feeding values from one query into another, such as grabbing the ID's from one query and dropping them onto the where clause of another query. / comments
Another handy one from SQL Prompt is the "Copy as IN clause" feature. When you get the results back from running a query, you can highlight the entire column (or just the values you care about), t...
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about), then right-click and choose "Script as Insert." This will scaffold out the insert statement for you inside of SSMS. This is handy for scenarios such as generating a script to be used for re-seeding data for an integration test without having to write that insert by hand. / comments
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about...
I'll be there! / comments
I'll be there!
Thank you for everything Roseanna! Best wishes in your new role! Looking forward to working with you, Eleanor! / comments
Thank you for everything Roseanna! Best wishes in your new role!Looking forward to working with you, Eleanor!
I hope to join. My house was hit by the Derecho (land hurricane, 80+ mph winds) that hit the Midwest US yesterday. I’m running off a generator, because I still have no power (last 21 hours) and running internet off my hotspot that has been a little flaky. If my internet can’t keep up, I’ll be sure to watch the recording and give any feedback I have! / comments
I hope to join. My house was hit by the Derecho (land hurricane, 80+ mph winds) that hit the Midwest US yesterday. I’m running off a generator, because I still have no power (last 21 hours) and run...
I'll be there. / comments
I'll be there.
I'll be there! / comments
I'll be there!