Comments
Sort by recent activity
Hi @RoseannaW Thanks for your nice message, I have five days without out of my apartment together with my wife and children, I live in the south of Spain (Costa del Sol, Malaga), we have adapted to a new routine and keeping moving :-) and combining funny activities, keeping under control the hours in front of the TV, agree with @AlexYates not 24/7 news is the best for our mental health. Take care Geo Hernandez / comments
Hi @RoseannaW Thanks for your nice message, I have five days without out of my apartment together with my wife and children, I live in the south of Spain (Costa del Sol, Malaga), we have adapted to...
Hi Roseanna Well, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of my demos how SQL Prompt can be installed and help us to improve the velocity and agility in our T-SQL code inside Visual Studio. More details about this event here: https://geohernandez.net/announcement/webinar-in-net-ni-nicaragua/ I am going to do two presentations more in March, another in Nicaragua and once for Guatemala User Group, in both cases I already include in my demos an example about how to increase productivity with RedGate tools. Best wishes, Geo Hernandez / comments
Hi RoseannaWell, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of...
Hi Roseanna Well, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of my demos how SQL Prompt can be installed and help us to improve the velocity and agility in our T-SQL code inside Visual Studio. More details about this event here: https://geohernandez.net/announcement/webinar-in-net-ni-nicaragua/ I am going to do two presentations more in March, another in Nicaragua and once for Guatemala User Group, in both cases I already include in my demos an example about how to increase productivity with RedGate tools. Best wishes, Geo Hernandez / comments
Hi RoseannaWell, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of...
Hi Roseanna Well, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of my demos how SQL Prompt can be installed and help us to improve the velocity and agility in our T-SQL code inside Visual Studio. More details about this event here : https://geohernandez.net/announcement/webinar-in-net-ni-nicaragua/ I am going to do two presentations more on March, another in Nicaragua and once for Guatemala User Group. Best wishes, Geo Hernandez / comments
Hi RoseannaWell, in my case I presented a session (in Spanish) for the community .Net in Nicaragua where I had had the opportunity of talking about SSDT in Visual Studio, I could include as part of...
Thanks @RoseannaW, I hope this year coming with interesting projects and ways of contributing RedGate people. / comments
Thanks @RoseannaW, I hope this year coming with interesting projects and ways of contributing RedGate people.
I have been involved in this program during the last four years and my experience has been amazing, I hope to continue support the community and during this year's focus on Latin America and Spanish people for pushing some topics like Unit Testing and DB Automation. Have a great 2020 !!!! / comments
I have been involved in this program during the last four years and my experience has been amazing, I hope to continue support the community and during this year's focus on Latin America and Spanis...
Hi Dave I agree with you in how the product (aka MS SQL Server) has grown, it has transformed in a complete ecosystem more than a simple product, this is simple to discover when we analyze how we can now integrate Python, R , etc inside of SQL Server. I believe that the road will be focus on subset, the specialization, is part of our challenge to recognize what of these subsets is the best for us, taking account our skills-desire-career objectives. We can not be naive and think that we will be able to cover the complete product (as MS SQL Server), and probably the same is happening with other SQL product as Oracle. / comments
Hi DaveI agree with you in how the product (aka MS SQL Server) has grown, it has transformed in a complete ecosystem more than a simple product, this is simple to discover when we analyze how we ca...
Hi @David Atkinson Thanks for asking, I have read this project of Ed Elliot, it looks very interesting, however, the approach that I presented in my session was focus into a "progressive" way of solving some problems and improving Visual Studio Unit Testing projects, in the second demo I I demonstrated how you can use tSQLt inside VS, but keeping the use of Unit Test classes from VS, how can I did that? Basically deploying tSQLt framework inside your target Unit Test DB, in my demo for instance, I used the function tSQLt.FakeTable inside my class ( I can't not past the image directly here, let me to send you by email). In my last demo, I presented a personal project which consisted in an extension of existing C# class that you can use and develop Unit Test with the advantage that you can copy/paste the results directly of SSMS and organize into your assert section, something like: [TestMethod] public void usp_CheckingDataInsertedIntoProcessMetricSegmentIsOk() { RunTest(Actions.CreateBlock(@" --Initial load with valid values for the PlayerMetricSegment which is the base value --for calculating the new range of dates EXEC tSQLt.FakeTable 'dbo.ProcessMetricSegment'; --Act EXEC [dbo].[usp_SetProcessBySegment] @range_start =1 , @range_end =3 , @initial_date ='20190101', @segmentid = 1 --Assert --DataSet 1 SELECT RangeValue,ProjectedDate FROM ProcessMetricSegment; ") .ResultsetShouldBe(1, @1 2019-01-02 2 2019-01-03 3 2019-01-04)); } This project is in Github: https://github.com/geohernandez/SQLBits2019 If you have any doubt or simply you want to talk more about it, please, you can send me an email and we can schedule a chat, I always be available for RedGate people :-) / comments
Hi @David Atkinson Thanks for asking, I have read this project of Ed Elliot, it looks very interesting, however, the approach that I presented in my session was focus into a "progressive" way of so...
Hi @David Atkinson , great, you got it :-) . I have sent you an email, anything don't hesitate in write me. Cheers, Geo / comments
Hi @David Atkinson , great, you got it :-) . I have sent you an email, anything don't hesitate in write me.Cheers,Geo
Hi @David Atkinson , I was refering into the context of the session,about the environment that C# developers (or full-stack) use to develop, in my specific experience this is Visual Studio and programming of Unit Tests classes, which includes into the constructor of their classes a generic arrange section for the Unit Tests. A common request of many of these developers is to continue working/develop their Unit Tests without have to leave VS and move to other context or UI, in fact in the session I focused in these specific kind of roles, obviously, for DB roles (DBA,DB Dev, DB Engineers, etc) our main tool is SSMS or Azure Data Studio. / comments
Hi @David Atkinson , I was refering into the context of the session,about the environment that C# developers (or full-stack) use to develop, in my specific experience this is Visual Studio and prog...