Home  >  Jacob Saylor

Author: Jacob Saylor

Software developer in Kentucky
November 28, 2012

Use AutoHotKey To Google Inside Any Application

So I started getting back into autohotkey to increase productivity with some office tasks, and I thought of a useful script to keep Google a second away in any application. I had seen a few scripts out there to bring up Google, but I wanted to take a step further and allow you to highlight a word, then Google that...

Categories Development/General Tips Comments: 2
November 18, 2012

CodeSearch

Being an avid user of Chrome, always looking up either documentation and programming help, and a great suggestion from a friend, I created the Chrome Extension, CodeSearch. CodeSearch will create a search string from your keywords and use a selection of some of the biggest programming sites to get you accurate programming help instead of being misdirected by ads and...

Categories Uncategorized Comments: 0
November 14, 2012

SqlDataAdapter Will Not Always Return a Result, SSMS Will

The Issue I ran into a strange issue with an ASP.NET site (MVC2 – 4.0 Framework) where when executing a stored proc, SqlDataAdapter.Fill(DataTable) will not return any rows some of the time, but SQL Server Management Studio will almost immediately return results. The full method calling the stored procedure is below : (Auto-generated from LLBL Pro V2.6) This issue occurs...

Categories C#/Development/SQL Comments: 0
November 7, 2012

SqlCommand.Parameters.Add() vs SqlCommand.CreateParameter()

When doing some quick research on SQL Parameters with SqlCommand, I noticed two methods which seemed to perform the same task, SqlCommand.Parameters.Add() and SqlCommand.CreateParameter().  After looking into each method on MSDN, I noticed that CreateParameter() will simply create the parameter, while Parameters.Add() will create the parameter and add it to the parameter collection. SqlCommand.Parameters.Add() The following example will create a SQL command object, create...

Categories C# Comments: 0
November 1, 2012

How to Setup and Reset Outlook’s New Mail Icon [Outlook 2007]

This is a simple trick I found for those using Outlook 2007, who use Outlook’s new mail notification, and view their mail from other locations than just their desktop. This spawned from me checking my mail on my phone while at a meeting, at home, etc.. , then when I’m back at my desktop at work, I have the new...

Categories General Tips Comments: 0
October 23, 2012

View The Last 50 Queries Ran on SQL Server

I ran into an issue where I needed to see the last few queries ran on SQL Server (Currently using SQL Server 2005). There were quite a few suggestions out there, but one I found on Stack Overflow seemed to be formated the best and didn’t require me messing with the query. (See Query Below) This however wasn’t working for...

Categories SQL Comments: 0
October 15, 2012

Watch Star Wars Episode IV From The Command Prompt

Who needs a bluray version of Star Wars when you can watch it in ASCII form! Thanks to the huge effort to Simon Jansen, you can watch most of the movie in ASCII right from your desktop (command prompt). A lot of you might have already seen this since it has been around for awhile (circa. 2000), but just stumbled across it...

Categories General Tips Comments: 0
August 25, 2012

HTTP could not register URL [url]. Your process does not have access rights to this namespace

I was trying to build a project that I inherited (ASP C# ~.Net4) and I got the following error Please try changing the HTTP port to 8732 or running as Administrator. System.ServiceModel.AddressAccessDeniedException: HTTP could not register [url]. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). —> System.Net.HttpListenerException: Access is denied … System.Net.HttpListenerException (0x80004005): Access...

Categories WCF Comments: 0
August 25, 2012

A connection cannot be made to redirector

I started learning about SQL Server Analysis Services interacting with and using SQL Server Integration Services, and I ran into an issue getting connected to my local server’s Analysis Service. The full error message : A Connection Cannot be made to redirector.Ensure that ‘SQL BROWSER’ Service is running. No connection could be made because the target machine actively refused it. First things first...

Categories SSAS/SSIS Comments: 0
August 25, 2012

Cannot find either column “[ColumnName]” or the user-defined function or aggregate “[ColumnName]”, or the name is ambiguous

I had the following, really simple, issue when adding no locks to my join statements. (I’m relatively new to nolocks since my other applications didn’t require almost immediate concurrent access) Note: Tables names were changed obviously And it was throwing Msg 4121, Level 16, State 1, Line 3 Cannot find either column “b” or the user-defined function or aggregate “b.index”, or the...

Categories SQL Comments: 0
%d bloggers like this: