Microsoft Development Help

What settings to override on fresh install of SQL Server 2016?

I am installing this BEFORE I install Visual Studio Professional 2017 so that the Visual Studio installer will not try and install SQL Server for me. But I want to be sure I install SQL Server exactly correctly.

What questions will the installer ask me which might require me to change the default settings?

I would like to be armed with all the answers before I start the installation. My worry is that I may need to make an error and then need to uninstall SQL Server, which is not a good place to be.

Thanks

2 Comments

Introduction to R

LVL 13

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

I need to install Visual Studio Professional 2017 but want to be sure I get the settings correct. I have had bac luck in the past letting Visual Studio install my instance of SQL Server, and found it better to FIRST install SQL Server, THEN install Visual Studio.

So, my questions are where can I get the URL's for

Visual Studio Professional 2017
SQL Server 2016

I plan to install them and use them for free until I get license keys in the next few weeks.

Thanks

6 Comments

SQL Server: What are DDL, DML and DCL?

Thanks

4 Comments

Change mouse cursor color from white to black on Windows 10

I spend too much time looking for my mouse, and realized it's white.

Can I change it and/or change it's size on Windows 10?

Thanks

2 Comments

Need a sample SQL Server database I can use to play around with

I have SQL Server 2014 installed and hope to goof around with a sample database which has lots of different object types already installed. In fact, I hope that

sys.objects table is filled with every possible permutation. I want this database for the sole purpose of raising questions in me about what things I may have not seen before.

Do you have a link so such a free database for me to download?

Thanks.

4 Comments

Please provide a list of SQL Database Objects

I am curious about whether "SQL Database Objects" makes you think of scripts, stored procedures, functions, views and triggers. Or, if there is a set of objects I may have not worked with yet.

Please confirm that those which I listed are in fact "SQL Database Objects" or list any that come to mind.

Thanks.

6 Comments

Does MVC.Razor have a future?

How do Angular and React co-exist with Razor? Or is it a binary choice?

Either, MVC.Razor OR Angular OR React?

Curious.

Thanks.

4 Comments

Any advantage of EF6.CodeFirst on a static database?

I have used Code First on a new project, and it rocked. Once the migration scripts are created, the database gets updated whenever it's out of sync. Awesome!

I have also use Entity Framework on a database that was not allowed to change, in any way. For this, I did NOT use Code First.

But, I recently watched a video on Udemy which said even in my second case, the Code First can still save time.

Is this true?

Id so, please explain why this is the case.

Thanks

2 Comments

Pros and more Cons of using SASS on a new MVC website?

I have not used SASS but hear it produces perfect CSS files. One downside is that everyone who needs to create classes must learn the SASS scripting language. Another may be that debugging time is much higher.

Are there, instead, good coding practices that all developers can follow, so they can avoid the negatives of using SASS and get some of the benefits of using standardized CSS?

(I am not sure if the MVC site will use the Razor View Engine, but does this change your opinion of using SASS?)

Thanks

7 Comments

What version of Visual Studio Community Edition?

I have 2015 but need to upgrade. I want to start testing some newer features of the .NET Framework, and perhaps play around with .NET Core as well as to use the .NET Standard 2.0.

What is the right version for me to install?

Can I leave Visual Studio Community Edition 2015 installed?

What about SQL Server? I have found if SQL Server is already installed, the Visual Studio installer will not try and install it. And I found that the Visual Studio installer does not do a great job of installing SQL Server.

I see I have SQL Server 2008 and 2014 installed.

Shall I install an updated version of SQL Server, then install the Visual Studio Community Edition?

If so, what versions of each do I install?

Thanks

6 Comments

Rowby Goren Makes an Impact on Screen and Online

LVL 13

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Need to take a small screen capture in Windows 10

Without installing any new programs, can I take a small photo of part of the screen?

Thanks

5 Comments

How does ASP.NET – "SameSite Cookie" block XSS attacks?

Please give me a quick view under the covers how this .NET Framework Version 4.7.2 feature helps stop XSS attacks.

And how is it that an MVC site did not have this exposure with earlier versions of .NET Framework?

Thanks

2 Comments

Dividing line between .NET Framework and ASP.NET?

When in comes to differentiating between .NET Framework and ASP.NET, I am a bit confused. Here are the list of enhancements to .NET Framework 4.7.1

For example, do the features below, which explicitly mention ASP.NET, only apply to "code behind" kinds of Web Forms?

The .NET Framework 4.7.1 includes improvements in several areas:

Accessibility improvements in narration, high contrast and focus control areas
.NET Framework support for .NET Standard 2.0 and compiler features
More secure SHA-2 support in ASP.NET and System.Messaging
Configuration builders
ASP.NET Execution step feature
ASP.NET HttpCookie parsing
Performance and reliability improvements

Thanks

3 Comments

What are the recent enhancements to the .NET Framework since 4.5?

What is the current latest released version? Are there any reasons to NOT use this latest version on a new .NET Framework MVC project?

So, what are the big updates since 4.5? And when was 4.5 released?

Thanks

4 Comments

What top .NET Technologies for .NET Technical Lead Role?

I am brushing up on various .NET Technologies to fill a .NET Technical Lead Role which will involve not only various technology choices, but mainly the communication with a global team of developers who need to implement these technologies.

So, please provide me a list of .NET Technologies which I should prioritize as I spend the next few weeks ramping up.

I may also be looked at to assemble a list of coding standards (coding do's and don't's), then to use code reviews, pull requests, etc. to help communicate those coding standards to a team, some of which may be an offshore and on a different timezone.

So, can you start with a short list of .NET technologies that can prime the pump and get my juices flowing again with these topics, most (or all) I have worked with previously in some capacity.

Thanks.

2 Comments

Need a quick start in SiteCore

I have a new job as a .NET Software Engineer and expect to need to integrate .NET Framework code and ASP.NET code with SiteCore. So, I want to be a quick study with SiteCore, since I have not yet worked with that CRM.

Can you provide me URL's to some key videos and/or documents where I can start the process of getting acclimated?

Thanks

3 Comments

Compare a List with an Array (in .NET)

Please list the pros and cons of each.

Thanks

5 Comments

What performance consideration (for sorting) are there in .NET regarding various List Types? Arrays? Other?

What options are there when choosing a list type to use to hold large amounts of data? And what are the advantages of one of the other in a quick sort-time is required?

And, besides sorting, where would performance be a consideration?

Thanks

4 Comments

The big terms of BigO Notation

I want to drill down into BigO, but hope to do so from a usefulness perspective. So, regarding making low-level algorithms more performant, for example. Or, from a memory management view...

Suggested topics to read up on? And a site where I can read this?

Thanks

3 Comments

JavaScript Best Practices

LVL 13

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Hi there,

In SSIS I need to be able to change some values as the data is imported into the target. I have a series of number codes that I need to change during this process. For example, if the source value is 150, it needs to be changed to 137 on entry into the target. I have quite a few of these to do so I thought it may be quicker to do a transform rather than run a script. Any assistance would be appreciated.

Thanks

1 Comment

Need a video intro to Azure

I have the 30-day free trial and need to get started quickly. Can you suggest a video (or three) I can watch in order to get a basis for what part of Azure I will focus on first?

Thanks

5 Comments

Need to read up on Windows Architecture & Operating system / Win32 APIs

What can you suggest?

3 Comments

Dynamics 365 Online, SQL 2012

We have SQL stored procedure code that needs to be converted to CRM out-of-the-box functions or code compatible with D365 Online 9.0. The code is below:

CREATE TABLE #tmpData
		(OppID nvarchar(100)
		  ,Quote nvarchar(100)
		  ,QuoteId uniqueidentifier
		  ,OrderID nvarchar(100)
		  ,Account nvarchar(175)
		  ,OppModel nvarchar(100)
		  ,Model nvarchar(100)
		  ,RiskOwner nvarchar(100)
		  ,Risk nvarchar(100)
		  ,RiskComments nvarchar(4000)
		  ,SSOA nvarchar(100)
		  ,LCReceived nvarchar(100)
		  ,EUCReceived nvarchar (100)
		  ,PrepayReceived nvarchar(100)
		  ,SiteReadinessDate datetime
		  ,SiteReady nvarchar(100)
)

Open in new window

	   As ExpRevDate
	  ,(select top 1 value from #stringmap where attributename = 'fei_fin_moment_rev_rec' and langId = '1033' and attributevalue =   ff.fei_fin_moment_rev_rec) As MomentOfRevenue
	  ,FQ.fei_inco_terms As IncoTerms
	  ,iif(foa.fei_oa_pod_received = 1,'Yes','No')  As PODReceived
          ,dbo.fn_UTCToTzSpecificLocalTime(FOA.fei_oa_date_of_delivery, 
	  us.TimeZoneBias,
				us.TimeZoneDaylightBias,
				us.TimeZoneDaylightYear,
				us.TimeZoneDaylightMonth,
				us.TimeZoneDaylightDay,
				us.TimeZoneDaylightHour,
				us.TimeZoneDaylightMinute,
				us.TimeZoneDaylightSecond,
				0,
				us.TimeZoneDaylightDayOfWeek,
				us.TimeZoneStandardBias,
				us.TimeZoneStandardYear,
				us.TimeZoneStandardMonth,
				us.TimeZoneStandardDay,
				us.TimeZoneStandardHour,
				us.TimeZoneStandardMinute,
				us.TimeZoneStandardSecond,
				0,
				us.TimeZoneStandardDayOfWeek)
		    As DateOfDelivery

Open in new window

8 Comments

I want to disable a dropdown in my cshtml code

<dropdown dropdown-menu-items="results" option-label="Not Reviewed" class="jq-checker-inspection-dropdown" data-poi-index="@inspectionItem.PointOfInspection"></dropdown>

I tried disabled = "true" and that does not work.

I also have a boolean variable
isenable = false

and i tried something like this

<dropdown dropdown-menu-items="results" option-label="Not Reviewed" class="jq-checker-inspection-dropdown" data-poi-index="@inspectionItem.PointOfInspection" @(isEnabled ? "disabled" : "")></dropdown>

None of them work. can you please suggest on how i can diable the dropdown box.

6 Comments

Example of Web Tokens

I am sure I have worked with these, but please give an overview.

Also, it would great if you could also include a .NET perspective

Thanks.

2 Comments

Microsoft Development

Related Topics

Dynamics 365 Online, SQL 2012

We have SQL stored procedure code that needs to be converted to CRM out-of-the-box functions or code compatible with D365 Online 9.0. The code is below:

Microsoft Development

Related Topics

Microsoft Development

Related Topics

Dynamics 365 Online, SQL 2012 We have SQL stored procedure code that needs to be converted to CRM out-of-the-box functions or code compatible with D365 Online 9.0. The code is below:

Microsoft Development

Related Topics

Dynamics 365 Online, SQL 2012

We have SQL stored procedure code that needs to be converted to CRM out-of-the-box functions or code compatible with D365 Online 9.0. The code is below: