Skip to content

Instantly share code, notes, and snippets.

View rajanand's full-sized avatar
🎯
Focusing

Rajanand Ilangovan rajanand

🎯
Focusing
61 followers · 361 following
View GitHub Profile
@rajanand
rajanand / css_resources.md
Created December 8, 2013 15:38 — forked from jookyboi/css_resources.md
CSS libraries and guides to bring some order to the chaos.

Libraries

  • 960 Grid System - An effort to streamline web development workflow by providing commonly used dimensions, based on a width of 960 pixels. There are two variants: 12 and 16 columns, which can be used separately or in tandem.
  • Compass - Open source CSS Authoring Framework.
  • Bootstrap - Sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.
  • Font Awesome - The iconic font designed for Bootstrap.
  • Zurb Foundation - Framework for writing responsive web sites.
  • SASS - CSS extension language which allows variables, mixins and rules nesting.
  • Skeleton - Boilerplate for responsive, mobile-friendly development.

Guides

@rajanand
rajanand / close database connection .sql
Last active December 30, 2015 13:49
To close all the connection of a database in SQL Server.
USE master
GO
ALTER DATABASE DatabaseName
SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE DatabaseName
SET ONLINE
GO
@rajanand
rajanand / find_week_and_quarter_from_date_sql_server.sql
Last active December 25, 2015 10:09
To find the week and quarter from date column using T-SQL. #SQLserver
--To find the week and quarter from date column using T-SQL.
DECLARE @temp_tb TABLE (CreateDate DATETIME)
INSERT INTO @temp_tb SELECT '2012-08-15 07:22:56.000'
INSERT INTO @temp_tb SELECT '2012-11-16 10:10:00.000'
INSERT INTO @temp_tb SELECT '2013-04-22 08:47:37.000'
INSERT INTO @temp_tb SELECT '2013-12-31 23:59:38.000'
INSERT INTO @temp_tb SELECT '2013-01-29 16:26:25.000'