Comments
Sort by recent activity
hi @SkipSailors - if you have SQL Server 2016 SP1 or onwards you can use the CREATE OR ALTER PROCEDURE statement. example below: CREATE OR ALTER PROCEDURE dbo.sp_test AS SELECT 1; GO EXEC dbo.sp_test; go CREATE OR ALTER PROCEDURE dbo.sp_test AS SELECT 2 go EXEC dbo.sp_test / comments
hi @SkipSailors - if you have SQL Server 2016 SP1 or onwards you can use the CREATE OR ALTER PROCEDURE statement.example below:CREATE OR ALTER PROCEDURE dbo.sp_testASSELECT 1;GOEXEC dbo.sp_test;goC...
The licensing part of the estates tab is brilliant imo. Definitely "ingeniously simple". / comments
The licensing part of the estates tab is brilliant imo. Definitely "ingeniously simple".
Good post @RoseannaW ! i'm not a worrier but my wife has a pre-existing lung condition (not too serious) so we're all at home at the moment seeing how things play out... just trying to be on the cautious side. I'm currently juggling work with looking after my two toddlers and two high-maintenance cats which is fun [image] whilst working I listen to a lot of grime radio sets and in the evening I usually fall asleep to someone like Alan Watts (genius guy from the 1970s who talks about religion, zen, meaning of life and all that!)... i've also been a big tyson fury fan for a long time so always enjoy watching his interviews and hearing what he has to say. Hope you all keep well cheers, Ben / comments
Good post @RoseannaW !i'm not a worrier but my wife has a pre-existing lung condition (not too serious) so we're all at home at the moment seeing how things play out... just trying to be on the cau...
Hi @gmartin Welcome to the forums. We had this scenario too. As well as the options listed above, here are some other possible options. 1. Create SSIS packages that will copy the data over from prod to dev. This will be a data only refresh. (You can use BIML to make it dynamic) 2. Backup/Restore from prod every night but also schedule a job to publish/deploy your dev work from source control to the freshly restored copy on your dev server 3. Create a separate dev database and do your development work using cross database references until they are ready for production. (not great but can work) 4. Truncate/Insert Into using linked server 5. Truncate/Insert Into using a replicated copy of the production database. 6. Truncate/Insert Into using polybase 7. Use transactional replication (prod=publisher, dev=subscriber). You can still do your dev work on the replicated copy. Out of all of these, 7 would prob be the simplest. Needless to say, pros and cons to all of them. We went for option 1. We had a really smart developer come in who automated it all for us. "Also, I see things on the Red Gate site about DB Dev Ops. To be honest, I don't exactly know what that term precisely means. Any pointers toward educating me on that would also be appreciated." As for this, I have written a post to help people get started with devops: https://benbrown-sql.com/devops/ Best of luck Ben / comments
Hi @gmartin Welcome to the forums. We had this scenario too.As well as the options listed above, here are some other possible options.1. Create SSIS packages that will copy the data over from pro...
I'm starting a new job at the end of Feb - In the new role I want to focus on helping create a 'high performing team'. on the technical side, one thing I will probably do is to demo a few different products and get the team to decide upon their DevOps toolchain as a group. / comments
I'm starting a new job at the end of Feb - In the new role I want to focus on helping create a 'high performing team'. on the technical side, one thing I will probably do is to demo a few differen...
thanks a lot for this Chris, very helpful [image] / comments
thanks a lot for this Chris, very helpful
Hi Roseanna I watched the webinar and I can see that the product helps you tag or curate your data pretty quickly. I can see that masking your sensitive data in lower environments is one important use case that this tool makes easier but I was wondering what some of the other use cases could be? i.e. once you have completed the cataloging exercise, what are some of the questions that can be answered? When might you want to tag something as 'Confidential GDPR' as opposed to just 'Confidential'? Have you got a taxonomy that you have applied at Redgate that you could share? The product is probably not aimed at someone like myself as I have never been involved in the privacy or compliance side of things but its something I would like to understand a bit further in the future. cheers, Ben / comments
Hi RoseannaI watched the webinar and I can see that the product helps you tag or curate your data pretty quickly.I can see that masking your sensitive data in lower environments is one important us...
SQL Source Control just edges it over Prompt - sometimes getting database developers to use source control is like herding cats. SQL Source control makes it so easy that you see very little resistance and the devs can concentrate on delivering value. / comments
SQL Source Control just edges it over Prompt - sometimes getting database developers to use source control is like herding cats. SQL Source control makes it so easy that you see very little resist...
hi @Sergio R - I did spend some time with the command line using the include switch and made some progress but it was a struggle and wasnt "ingeniously simple"... I've created a very bad screen mock-up of what I was thinking to see if anyone else sees value in what i'm talking about. its based on the comparison pane inside SQL Source Control... its basically being able to run something like K-Diff or WinMerge from within SSMS. cheers Ben [image] / comments
hi @Sergio R - I did spend some time with the command line using the include switch and made some progress but it was a struggle and wasnt "ingeniously simple"... I've created a very bad screen moc...
thanks very much for taking the time to answer. I will definitely check out the command line and get back to you. / comments
thanks very much for taking the time to answer. I will definitely check out the command line and get back to you.