Archives for Language features, Development Methodologies - Page 12
Enabling ports in Windows Firewall (for SQL Server Access)
If you are having trouble connecting to a newly created default instance on SqlServer , try this msdn article (it DOES seem to contain every possible thing that could be…
Hide gridlines in Excel
Select multiple sheets , On the View tab, in the Show/Hide group, check/uncheck the Gridlines check box.
Default instance SQL Server
Each SQL server can contain many INSTANCES ( a set of SQL Server Services). An instance is either the default, unnamed instance, or it is a named instance. When SQL…
.NET Framework 2.0 and 3.5 feature install fails on Windows 8.1
I tried to enable this feature on Windows ( as part of a SQL Server 2014 installation) - it failed. I tried downloading the redist executables separately - and installing.…
WCF and AJAX
In VS2010 – you are provided with a template for AJAX enabled WCF Service. Basically, all you need to do is Add an AJAX-enabled endpoint to a WCF service 1.…
Windows Server–Adding Roles and Features Hangs
This seems to be a common occurrence. The workaround I have found invovles Powershell . Simply Export the Configuration Settings – into say c:\ Run the following command in a…
PC cleanup
Iolo System Mechanic – Comprehensive, License fee required – $39 SlimWare Utilities SlimCleaner Run Geekbench Score to check if performance truly improved after running these tools.
Using Git with Visual Studio 2013
All I wanted to do was look at some sample source code within a GIT ; For this, the repository exposes a Git URL . This URL is all that…
Multiple FROM statements in a LINQ expression
Multiple "from" statements are like nested foreach statements. MSDN example: var scoreQuery = from student in students from score in ; where score > 90 select new {…
SQL Server Passing parameters in VIEW
The short answer is that a VIEW is just a static representation of tabular data – and cannot accept a parameter. However, one can accomplish the same thing by doing…