ASP.NET Write to Windows Event Logs 16. April 2014 sellout Logs (0) I like applications to write to the Windows Event Logs unless they are going to be verbose. Windows Event Logs can be collected and forwarded with a variety of tools for continuous monitoring. Sometimes logging errors is going to be way to noisy and an alternative is needed. But it is a go... [More]
Advice from a Sell Out: Don’t Let Your Job Determine Your Career 9. April 2014 sellout Tech Culture (0) Learn things you think will help your career by creating useful projects for yourself or friends using technology you want to explore. Learning by doing is best but doing without your job's business requirements lets you actually explore. If your job requires licenses to do it, if you can’t o... [More]
I Am Admin But I Can't Get Up 1. April 2014 sellout SQL (0) addselftosqlsysadmin.cmd (5.25 kb) Crap, why can't I connect to SQL Server, I am a local Admin what's the problem?
Learn Ham 5. March 2014 sellout SpamAssassin (0) I am starting a post on my struggles convincing spamassassin's Bayes classification system to learn ham. When I su into the user account I can run this command: sa-learn --dump magic and it tells me how many ham and spam it thinks it has seen. when I train spam it goes up, but not when I train ham... [More]
Turning Off IPv6 On Rackspace Cloud Server Blows 2. March 2014 sellout IIS, Network (0) I was trying to diagnose some issues with ASP.NET Web Forms post backs so I turned off IPv6 even though none of my websites were bound to IPv6 addresses. I unchecked it on the adapter property page. I had no logical reason for doing this. Then Windows Update stopped working. This was ... [More]
whats my preferred IP anyway 26. December 2013 sellout Network (0) What is my preferred IP anyway? Not this: Set-NetIPAddress -IPAddress xxx.xxx.xxx.xxx -SkipAsSource 1 You can do that in Power Shell on all the IP addresses you don't want to be chosen as your preferred IP address for your windows 2012 machine. This will tell you what is set: Netsh int ipv4 sho... [More]
.NET 4.5.1, IE 11, IIS 8 - oh my 4. December 2013 sellout IIS (0) This is not going well... The page size of asp.net had increased when comparing to 2008 R2 IIS 7.5 ASP.NET 4.0 C:\Windows\System32\Inetsrv\Appcmd.exe set config -section:httpCompression -[name='gzip'].staticCompressionLevel:9 -[name='gzip'].dynamicCompressionLevel:4 All of a sudden... [More]
Moving MSSQL Databases to Different Partition 1. December 2013 sellout SQL (0) I just moved from one Rackspace cloud server to another. The main purpose was to get IIS 8 so I could do TLS/SNI. I got a skimpy partition for the system and the preinstalled SQL Server Web Edition databases were taking up precious space so I moved them with help from this article: http://technet.m... [More]
Tally Ho 7. November 2013 sellout SQL (0) CREATE FUNCTION [dbo].[ufn_TallyHo] (@quantity int) RETURNS TABLE AS RETURN( with cte(tally)as(select 1 union all select tally + 1 from cte where tally < @quantity)SELECT tally FROM cte ) I found a table at work called Tally that was a list of numbers. I thought it was sad until I needed ... [More]
Did You Need an Excel Data Connection with Parameters - One with Multi-Values? 4. September 2013 sellout Excel (0) Const ValueSheetName As String = "MyParamSheet" Const ServerName As String = "ServerName" Public Sub GetData() ThisWorkbook.Names("Results").RefersToRange.Value = "Getting..." Dim oWorksheet As Worksheet On Error Resume Next Set oWorksheet = ThisWorkbook.Worksheets(ValueSheetName) On E... [More]