Screen Resolution Problem with Ubuntu 14.04.3 LTS in VirtualBox

This post for those who are facing the problem of screen resolution and unable to locate the package virtualbox-guest-x11

Follow the below step to make it solve:

1. Open the Terminal window
2. type sudo apt-get remove libcheese-gtk23
3. then type sudo apt-get install xserver-xorg-core
4. then finally type sudo apt-get install -f virtualbox-guest-x11

That's it..

Read More

Turn Off Automatic Updates in Windows 10

In windows 10, Microsoft removed the ability to turn off automatic updates. the registry setting that allowed you to disable windows update in the previous build of windows 10 no longer works. however it is still possible to deactivate automatic updates.

In this post, I will show you how you can disable automatic windows update by disabling the windows update service.

Follow the below step:

1. Type services  in the windows 10 search box and click View Local Services.

2. Find the Windows Update and double click it.

3. A new windows will be open.

4. If service status is running, then press the Stop button.

5. Select Startup Type Disabled.

6. Press Apply and OK.

And you are ready to go..:)

Read More

Git ignore File List for ASP.NET Web Form Project

# Created by https://www.gitignore.io

### VisualStudio ###
## Ignore Visual Studio temporary files, build results, and
## files generated by popular Visual Studio add-ons.

# User-specific files
*.suo
*.user
*.csproj.user
*.userosscache
*.sln.docstates

# User-specific files (MonoDevelop/Xamarin Studio)
*.userprefs

# Build results
[Dd]ebug/
[Dd]ebugPublic/
[Rr]elease/
[Rr]eleases/
x64/
x86/
build/
bld/
[Bb]in/
[Oo]bj/

# Visual Studo 2015 cache/options directory
.vs/

# MSTest test Results
[Tt]est[Rr]esult*/
[Bb]uild[Ll]og.*

# NUNIT
*.VisualState.xml
TestResult.xml

# Build Results of an ATL Project
[Dd]ebugPS/
[Rr]eleasePS/
dlldata.c

*_i.c
*_p.c
*_i.h
*.ilk
*.meta
*.obj
*.pch
*.pdb
*.pgc
*.pgd
*.rsp
*.sbr
*.tlb
*.tli
*.tlh
*.tmp
*.tmp_proj
*.log
*.vspscc
*.vssscc
.builds
*.pidb
*.svclog
*.scc

# Chutzpah Test files
_Chutzpah*

# Visual C++ cache files
ipch/
*.aps
*.ncb
*.opensdf
*.sdf
*.cachefile

# Visual Studio profiler
*.psess
*.vsp
*.vspx

# TFS 2012 Local Workspace
$tf/

# Guidance Automation Toolkit
*.gpState

# ReSharper is a .NET coding add-in
_ReSharper*/
*.[Rr]e[Ss]harper
*.DotSettings.user

# JustCode is a .NET coding addin-in
.JustCode

# TeamCity is a build add-in
_TeamCity*

# DotCover is a Code Coverage Tool
*.dotCover

# NCrunch
_NCrunch_*
.*crunch*.local.xml

# MightyMoose
*.mm.*
AutoTest.Net/

# Web workbench (sass)
.sass-cache/

# Installshield output folder
[Ee]xpress/

# DocProject is a documentation generator add-in
DocProject/buildhelp/
DocProject/Help/*.HxT
DocProject/Help/*.HxC
DocProject/Help/*.hhc
DocProject/Help/*.hhk
DocProject/Help/*.hhp
DocProject/Help/Html2
DocProject/Help/html

# Click-Once directory
publish/

# Publish Web Output
*.[Pp]ublish.xml
*.azurePubxml
# TODO: Comment the next line if you want to checkin your web deploy settings 
# but database connection strings (with potential passwords) will be unencrypted
*.pubxml
*.publishproj

# NuGet Packages
*.nupkg
# The packages folder can be ignored because of Package Restore
**/packages/*
# except build/, which is used as an MSBuild target.
!**/packages/build/
# Uncomment if necessary however generally it will be regenerated when needed
#!**/packages/repositories.config

# Windows Azure Build Output
csx/
*.build.csdef

# Windows Store app package directory
AppPackages/

# Others
*.[Cc]ache
ClientBin/
[Ss]tyle[Cc]op.*
~$*
*~
*.dbmdl
*.dbproj.schemaview
*.pfx
*.publishsettings
node_modules/
bower_components/

# RIA/Silverlight projects
Generated_Code/

# Backup & report files from converting an old project file
# to a newer Visual Studio version. Backup files are not needed,
# because we have git ;-)
_UpgradeReport_Files/
Backup*/
UpgradeLog*.XML
UpgradeLog*.htm

# SQL Server files
*.mdf
*.ldf

# Business Intelligence projects
*.rdl.data
*.bim.layout
*.bim_*.settings

# Microsoft Fakes
FakesAssemblies/

# Node.js Tools for Visual Studio
.ntvs_analysis.dat

# Visual Studio 6 build log
*.plg

# Visual Studio 6 workspace options file
*.opt

Read More

How can I find out what FOREIGN KEY constraint references a table in SQL Server?

By using the following command in sql server, you are able to find out the foreign key constraint references.

SELECT

   OBJECT_NAME(f.parent_object_id) TableName,

   COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName

FROM

   sys.foreign_keys AS f

INNER JOIN

   sys.foreign_key_columns AS fc

      ON f.OBJECT_ID = fc.constraint_object_id

INNER JOIN

   sys.tables t

      ON t.OBJECT_ID = fc.referenced_object_id

WHERE

   OBJECT_NAME (f.referenced_object_id) = 'YourTableName'

Read More