CA2214 : Do not call overridable methods in constructors Workaround

When you seriously take .net code analysis you may either try to suppress them or try to fix it. There is one such code analysis review if have override or virtual method call in constructor.

 
http://stackoverflow.com/questions/17018569/accessing-an-implemented-abstract-property-in-the-constructor-causes-ca2214-do

http://blogs.msdn.com/b/ericlippert/archive/2008/02/18/why-do-initializers-run-in-the-opposite-order-as-constructors-part-two.aspx

http://blog.duncanworthy.me/swdev/csdotnet/constructor-gotchas-part1/

http://stackoverflow.com/questions/119506/virtual-member-call-in-a-constructor


When an object written in C# is constructed, what happens is that the initializers run in order from the most derived class to the base class, and then constructors run in order from the base class to the most derived class
Problem - Constructor has call to override method.

 

 Workaround :- Add Sealed

 

Powershell Scripting: Automated scripting of database DDL

Make use of Sql server Management Object using Microsoft.sqlserver. This can be added as reference in powershell script as given below. If you are DBA and want to read schema for that matter any automation. You can check the commands within SMO object.

References:

https://www.simple-talk.com/sql/database-administration/automated-script-generation-with-powershell-and-smo/

http://www.sqlservercentral.com/Forums/Topic1167710-1550-1.aspx#bm1168100

http://www.sqlhammer.com/blog/t-sql-command-line-options-part-5-sqlps/

http://stackoverflow.com/questions/483568/how-can-i-automate-the-generate-scripts-task-in-sql-server-management-studio-2

http://www.sqlhammer.com/blog/t-sql-command-line-options-part-4-sqlpsx/

Tips # OneNote Copy Text From Image

How to extract text from image-Use One Note

1. Copy Image to onenote
2. Right click on image select Copy text from Image
3. Paste it.

 

Tips #-.Net Reflection to fetch value of Object Property.

Runtime Activity- I want to pass a class and property in the string and resolve the value of the property.

 With Generics

Generics

Get website details such as physical path using Powershell

Import-Module "WebAdministration" -ErrorAction Stop

foreach($site in (dir iis:\sites\*WebSiteNameXyz*))



{

write-host $site.Name

write-host $site.Bindings

write-host $site.State

write-host $site.physicalpath



}

Power of Powershell remoting WSMan

If you want to execute powershell script from your local box onto remote server this is the best solution to do.

Before you take deep dive in below powershell script . Ensure few things in local source and destination remote server settings.
* Ensure WinRs windows remote services . Type services.msc and this service should be enabled and auto mode.
* Ensure WSMan is enabled

Use gpedit.msc and look at the following policy:

 

Computer Configuration ->
Administrative Templates ->

System ->

Credentials Delegation -> Allow Delegating Fresh Credentials. 

 

Verify that it is enabled and configured with an SPN appropriate for the target computer.C lick on add server list mention WSMAN/myserver.domain.com

 

set-item wsman:localhost\client\trustedhosts -value *

#Enable credssp authentication
Enable-WSManCredSSP -Role Client –DelegateComputer *

# This will establish server connection
Connect-WSMan myserver

invoke-command -computername myserver-authentication credssp -credential domain\username -filepath c:\dbtest.ps1

  
This will prompt for password and you are good to go.
Now this dbtest.ps1 can be your powershell script which will deploy code base to different environment.

 
Useful References


Write to event log
http://blogs.technet.com/b/heyscriptingguy/archive/2013/06/20/how-to-use-powershell-to-write-to-event-logs.aspx

Monitor Scheduled Job
http://blogs.technet.com/b/heyscriptingguy/archive/2014/04/29/powertip-use-powershell-to-show-state-of-scheduled-tasks.aspx

http://www.howtogeek.com/117192/how-to-run-powershell-commands-on-remote-computers/

http://technet.microsoft.com/en-us/library/hh849719.aspx

http://technet.microsoft.com/en-us/library/dd819505.aspx

http://msdn.microsoft.com/en-us/library/ee309365(VS.85).aspx

 

Database administration

http://sqlmag.com/powershell/use-powershell-remoting-manage-sql-servers-efficiently?NL=News_SQL_JH_SQLServerProUpdate_issue050114%20-%20Batch&E_ID=16079033&NLL=4333