Comments
Sort by recent activity
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...
Hi everyone Well, probably the most excited things was my first presentation on SQLBits (https://sqlbits.com/Sessions/Event18/Lets_go_deep_in_SQL_Server_Unit_Testing_with_Visual_Studio), I had the opportunity of sharing with many people from SQL community. In March, I am working on improve the design and some cosmetic changes in my personal blog and well I have in the Todo list to write 1 article dedicated to SQLData generator of RedGate, I will put in contact with @RoseannaW when I would completed. Cheers, Geo / comments
Hi everyoneWell, probably the most excited things was my first presentation on SQLBits (https://sqlbits.com/Sessions/Event18/Lets_go_deep_in_SQL_Server_Unit_Testing_with_Visual_Studio), I had the o...
I agree this is a great benefit Roseanna, I have completed two amazing courses of Paul Randall and thinking to continue with one of Erin Stellato. / comments
I agree this is a great benefit Roseanna, I have completed two amazing courses of Paul Randall and thinking to continue with one of Erin Stellato.
I would like to be involved in this initiative. What can I have access to it? Regards. / comments
I would like to be involved in this initiative. What can I have access to it? Regards.
Excellent news Roseanna It is a great honor to be part of this amazing program. / comments
Excellent news RoseannaIt is a great honor to be part of this amazing program.
Amazing news, I would like to say: Welcome Kendra !!!! I have enjoyed many interesting articles from Kendra, in especial about indexes ;-) / comments
Amazing news, I would like to say: Welcome Kendra !!!! I have enjoyed many interesting articles from Kendra, in especial about indexes ;-)
Done ! / comments
Done !
I would like to nominate Alex Yates, I have followed his activity in RG forums and I consider that his contributions are valuable, especially, because his vision about the world of Devops from DB perspective represents a very interesting source of learning. / comments
I would like to nominate Alex Yates, I have followed his activity in RG forums and I consider that his contributions are valuable, especially, because his vision about the world of Devops from DB p...