Enabling SQL Server 2008 (R2) access over Network

First: enable SQL Server itself to be accessed over the network Open SQL Server Configuration Manager Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER Doubleclick TCP/IP Set Enabled to Yes Secondly: change the Windows Firewall to allow incoming connections on the TCP port of SQL Server Open Windows Firewall with Advanced Security Click […]

Small update on enabling shares in Windows 7.

Execute this line in the CMD as Administrator (start > type ‘cmd’ > hit control+shift+enter) and paste this line (rightmousebutton > paste). reg add HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\ /v LocalAccountTokenFilterPolicy /t REG_DWORD /d 1 Be sure to DISABLE your Homegroup and to enable file sharing in the Network & Sharing Center

Property setters and side effects

I ran into this little problem last week. I had a class with some properties and they were implemented like this: class Foo { private int _bar; public int Bar { get { return this._bar; } set { this._bar = value; this.DoSomeThing(); } } private void DoSomeThing() { /* blah */ } } Setting the […]