RSSRecent Articles

May

1

Change the Default Database for a User in SQL Server

Posted by • Leave a Comment

Here are three easy ways to change the default database for a user in SQL Server.

Option 1: Execute the system stored procedure sp_defaultdb

EXEC sp_defaultdb @loginame='UserName', @defdb='NewDefaultDB'

Continue Reading

Apr

24

Poll: What is the most you have ever paid for a PC?

Posted by • 1 Comment

What is the most you have ever paid for a PC?

View Results

Loading ... Loading ...

Apr

16

Control Computer from Your Android/iPhone/iPad Mobile Device

Posted by • Leave a Comment

If you need access to your Windows, Mac, or Linux computer from an Android, iPhone, or iPad mobile device you can use the free program TeamViewer. TeamViewer lets you access any of your computers which have the host application installed, from any computer or device running the client app. They also have a flash-based option you can use by logging in to their website.

Continue Reading

Apr

9

Post to Multiple Social Networks using HootSuite

Posted by • Leave a Comment

If you are looking for a way to post to multiple social networks at the same time, you can use a free service called HootSuite. HootSuite supports all of the major networks such as Twitter, Facebook, Google+, and many more. It handles multiple accounts and can even post to your WordPress blog.

They also have mobile apps for Android, iPhone and iPad which currently supports Twitter and Facebook.

Continue Reading

Apr

5

LINQ – SQL Wildcard Equivalents

Posted by • Leave a Comment

LINQ has several ways to mimic SQL wildcards in both query and method syntax. Below are a few examples of each:

Continue Reading

Apr

3

LINQ Single vs SingleOrDefault vs First vs FirstOrDefault

Posted by • 1 Comment

Many people get confused about the difference between Single, SingleOrDefault, First, and FirstOrDefault methods in Linq. Below is a chart explaining the difference between them and examples of each scenario.

Continue Reading

Apr

3

What is svchost.exe?

Posted by • Leave a Comment

From Microsoft’s description of svchost.exe:

“Svchost.exe is a process on your computer that hosts, or contains, other individual services that Windows uses to perform various functions.”

To expand on that, most Windows services these days are stored in .dll (Dynamic-Link Library) files instead of .exe (executable) files. Since you can’t launch a .dll file directly in Windows, it uses svchost.exe to host these services.

Continue Reading

Next Page »