Skip to content
Latest:
  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

Script(s)

technology as-is

  • Home
  • About
  • Archives by Month/Year
  • Contact Me

Tips and Tricks

Softwares Tips and Tricks Windows 

The system administrator has set policies to prevent this installation

April 25, 2018June 25, 2018 gchandra 0 Comments installation, policy, systemadmin, Windows

This is a common problem when you try to install  .msi files on Windows Server. There is a simple way

Read more
Linux Tips and Tricks 

Linux Tip : Convert date time to Unix Time (Epoch)

August 17, 2015August 17, 2015 gchandra 0 Comments Bash, Epoch, Linux, UTC

Simple script to covert  regular  date time to unix epoch time format  (UTC) $dat=’01/02/2015′ #If date is passed without time

Read more
Linux Tips and Tricks 

Linux Tip : Split Date into Day, Month, Year

August 17, 2015August 17, 2015 gchandra 0 Comments Bash, Date Split

Easy way to split date into  Day, Month, Year  in Linux.  This code was tested using Bash shell. $dat=’13/2/2015′ sday=$(date -d

Read more
featured SQL Server Tips and Tricks 

SQLServer : Get Last Businessday of previous month

September 4, 2014February 11, 2018 gchandra 0 Comments featured

DECLARE @LastmonLastBusinessDay date, @inputdate date SET @inputdate = ’05/25/2014′ SELECT @LastmonLastBusinessDay = DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0)) – CASE DATENAME(dw,DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0))) WHEN ‘SUNDAY’ THEN 2

Read more
featured Tips and Tricks Windows Windows 7 

How to kill or terminate a frozen windows task manager

March 17, 2014December 3, 2017 gchandra 0 Comments featured

Here is a simple command line statement to kill frozen windows task manager. START – RUN – CMD (make sure

Read more
featured SQL Server Tips and Tricks 

SQLServer Delete Duplicate Rows

August 12, 2013December 3, 2017 gchandra 0 Comments CTE, Delete, Duplicate Rows, featured, SQLServer

Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order

Read more
Tips and Tricks Visual Studio 

Visual Studio Debug Problem with IE8

May 4, 2011May 4, 2011 gchandra 1 Comment Asp.Net, IE8, Regedit, Registry, Visual Studio, VS2005, VS2008

Thanks to  : Abdulla AbdelHaq Source : http://weblogs.asp.net/abdullaabdelhaq/archive/2009/06/01/VS-Debug-Problem-with-IE8.aspx   How VS debugger could be crashed with IE8? If you opened

Read more
Outlook Tips and Tricks 

Outlook Cached Exchange Mode

August 5, 2010August 5, 2010 gchandra 0 Comments Cached Mode, Email, Enterprise, Exchange, Outlook 2007

When a new email address or Distribution list is created, the email address or distribution list may not be visible

Read more
Tips and Tricks Windows 

Manage Terminal Services Session

May 27, 2009May 27, 2009 gchandra 2 Comments Remote Desktop, Terminal Services

To Manage Terminal Services Session first Query the Server 192.168.2.5 c:\>qwinsta /server:192.168.2.5 SESSIONNAME USERNAME ID STATE TYPE DEVICE console  

Read more
Error Messages SQL Server Tips and Tricks 

Unable to instantiate XML DOM document : SSIS 2005

April 27, 2009December 3, 2017 gchandra 2 Comments Error Message, SQLServer 2005, SSIS, XML

SSIS 2005 Business Intelligence Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered.

Read more
Tips and Tricks Windows 

Get Server Name using IP

March 30, 2009March 31, 2009 gchandra 2 Comments nbstat, Server, Server Name, Win 2003

To find out Windows Server Name using IP Goto Command Prompt (Start > Run > cmd> C:> nbtstat –A  <<ip address>>

Read more
  • ← Previous

Subscribe to new Script(s)

Enter your email address to subscribe to this site and receive notifications of new posts by email.

Bragging

  • Classes I teach
  • Professional Connections
  • Rate My Professor
  • Rowan – TAP
  • Volunteer Spotlight – TechGirlz

Links

  • Oviam Hosting

Recent Scripts

  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

RSS Script(s)

  • Machine Learning made simple for beginners

Script Categories

  • Database (35)
    • Access (1)
    • MYSQL (7)
    • neo4j (1)
    • SQL Server (14)
      • Active Directory (1)
    • SQLite (2)
    • SSIS (3)
  • Error Messages (6)
  • Exception (2)
  • featured (7)
  • Hadoop (12)
    • Hive (7)
    • Spark (2)
    • Sqoop (2)
  • Interview Qn (1)
  • Machine Learning (1)
  • Misc (4)
    • Audio Conversion (2)
    • Audio Ripping (2)
    • Mp3 (2)
  • OS (26)
    • Docker (3)
    • Linux (11)
    • Mac (1)
    • Windows (12)
      • Vista (3)
      • Windows 7 (1)
  • Scripting (13)
    • Enterprise Library (1)
    • JSON (1)
    • LDAP (1)
    • Ports (1)
    • Python (4)
    • R (1)
    • skmmenu (4)
    • SMTP (1)
  • Software Development (1)
  • Softwares (31)
    • Freebies (4)
    • Open Source (4)
    • Outlook (1)
    • Team Foundation Server (2)
    • Third Party Tools (6)
      • Atalasoft DotImage 4.0 (2)
      • controls (4)
    • Tools (10)
    • Visual Studio (10)
  • Tips and Tricks (36)
  • Tutorial (1)
  • Web (74)
    • AJAX (2)
    • Asp.Net (29)
    • Browser (2)
    • Browsers (4)
    • IIS (2)
    • Javascript (2)
    • Web Coding (42)
    • WebService (1)
    • Wordpress (6)

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?

Tech GirlZ (SQL)

Tech Girlz

Tech Women (BigData)

Feedburner Stats

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?
Copyright © 2022 Script(s). All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.