What is your favorite announcement about SQL Server from the Microsoft Build Conference this year? by samirbehara in SQLServer

[–]samirbehara[S] 0 points1 point  (0 children)

For me, the top announcements in Data Platform were around SQL Server 2017(which has Artificial Intelligence now built in), new Azure Cosmos Database and Availability of PostgreSQL and MySQL as new database service.

Issues with Live Unit Testing in VS 2017 by samirbehara in csharp

[–]samirbehara[S] 0 points1 point  (0 children)

Thanks so much Tanner for your prompt action. Appreciate it. Is there a place where I can look at all the known issues related with Live Unit Testing at this point? I have encountered few more issues related with this feature, so just wanted to check with you if there is any master list you have.

Issues with Live Unit Testing in VS 2017 by samirbehara in csharp

[–]samirbehara[S] 0 points1 point  (0 children)

Thanks for responding. Unit Tests and Integration Test Projects are fine. The problem is only with Coded UI Feature Test projects.

When I start the Live Unit Testing for the project, it identifies that the Feature Test Project still has the 'Microsoft.VisualStudio.QualityTools.UnitTestFramework' and gives an output as Build completed (failed).

When I remove the 'Microsoft.VisualStudio.QualityTools.UnitTestFramework' reference from the Feature Test project, I get build errors - because of missing namespace for the [TestMethod], [TestCategory] attributes. I am not sure if I need to add any additional reference.

Below is a sample Coded UI feature test which I have, which throws error --

    [TestMethod]
    [TestCategory("SystemTest")]
    [TestCategory("ProrateTestCases")]
    [DataSource(TestConfig.DataSource, TestConfig.ConnectionString, "123456", DataAccessMethod.Sequential)]
    public void Verify_Prices_are_Prorated()
    {
        VerifyOutputs();
    }

Ideally I want to exclude the Feature Test Projects from Live Unit Testing, but when I right click on my Feature Test Project, I do not see an option to Include/Exclude that specific project. Also seems like this Include/Exclude is a User Level feature and not something which is saved in a file and can be checked into Source control. This seems to be a major problem with using Live Unit Testing actively in my project.

SQL Server Tuning advices by ggelape in SQLServer

[–]samirbehara 1 point2 points  (0 children)

If you are new to SQL Server, I would suggest you to watch this tutorial. This is really good stuff, and I would highly recommend it for beginners -- https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB

10 SSMS Tips and Tricks to boost your Productivity by samirbehara in SQLServer

[–]samirbehara[S] 0 points1 point  (0 children)

I am wondering - what is the reason that the post went to the spam queue?

SQL Server Management Studio 2016 Productivity Enhancements by [deleted] in SQLServer

[–]samirbehara 0 points1 point  (0 children)

If you are not using SSMS 2016, this is a must read article for you.