Friday, January 15, 2016

How to CACHE using .NET

›
Add <?xml .... >  script below to the directory you want to CACHE for 365 days - if it is static than why have the client retrieve it,...
Wednesday, December 02, 2015

Check your SQL STATISTICS TIME

›
SET STATISTICS TIME ON RUN T-SQL SET STATISTICS TIME OFF
Friday, November 27, 2015

Windows Run --- msinfo32.exe

›
Find out all you need to know about your system with msinfo32.exe
Tuesday, November 17, 2015

Check LIVE TEMP Tables

›
SELECT TABLE_NAME FROM tempdb.information_schema.tables

SQL Server Queries are spilling out to tempdb

›
-- How to rid yourself of tempDB spilage if SORT causing issues Create a Temp Table with a CLUSTERED INDEX IF OBJECT_ID('tempdb..#temp...
Thursday, November 12, 2015

Definition of Done in Computer Programming

›
Thank you Plural Sight.
Tuesday, November 03, 2015

Quiz Question of the day - HOW TO GEEK

›
Is 0445567892 a INTEGER?
Friday, October 30, 2015

IIS ApplicationPoolIdentity - Credit - http://stackoverflow.com/users/419/kev

›
The  ApplicationPoolIdentity  is assigned membership of the  Users  group as well as the  IIS_IUSRS  group. On first glance this may look s...
Wednesday, October 07, 2015

FTP Certificate TLS Encryption fix

›
Windows 2008 R2 - IIS 7.5 using FTP FileZilla (Protocol=FTP; Encryption=Require explicit FTP over TLS; Logon Type:=Normal; UserName=***...
Thursday, October 01, 2015

Reads of the week

›
Finding the Causes of Poor Performance in SQL Server, Part 1 & 2 https://www.simple-talk.com/sql/performance/finding-the-causes-of-...
Friday, September 25, 2015

Locking your network password

›
NEVER EVER have Scheduled TASKs, SERVICES or be logged into another machine when changing your password.  NEVER!!!!! In other words, alway...
Thursday, September 24, 2015

KNOW YOUR DATA, KNOW YOUR WORKLOAD AND KNOW YOUR DB ENGINE

›
MARCH 30, 2007  BY  PINAL DAVE SQL SERVER – Index Seek Vs. Index Scan (Table Scan) Index Scan retrieves all the rows from the table. ...
Friday, September 18, 2015

Chrome developer tools - DOM Bread Crumb

›
Today, I was really stumped with some CSS and setting display:none; and display: block; on the correct DOM element. depending on @media quer...
Thursday, September 10, 2015

When should I use jQuery's document.ready function?

›
Credit stackoverflow - http://stackoverflow.com/questions/13062246/when-should-i-use-jquerys-document-ready-function In simple words, ...
Wednesday, September 02, 2015

Quiz Day - What does this do?

›
var nyc = {     fullName: "New York City",     mayor: "Bill de Blasio",     population: 8000000,     boroughs: 5 };...
Monday, August 31, 2015

New Nick Name - "CoDEcAT --- Taking on PHP...

›
<!DOCTYPE html> <html>     <head>  <title> Challenge Time! </title>       <link type='text/css...
Wednesday, August 19, 2015

IIS Blowout Corruption

›
Had IIS on TEST go corrupted yesterday and had to remove and re-install.  I do not know why, but the following firewall setting got cut off ...
Tuesday, August 18, 2015

IIS_IUSRS be sure if you have relocated you IIS folders these permissions are added. Will save a lot of time and headache.

›
Friday, August 14, 2015

Awesome Disclaimer

›
Disclaimer ###### Inc., provides this publication as is without warranty of any kind , either expressed or implied. This publication could ...
Thursday, August 13, 2015

ThreadAbortException with ASP.NET redirect

›
Response.Redirect("/newpage.aspx", False) HttpContext.Current.ApplicationInstance.CompleteRequest()