Skip to content

Instantly share code, notes, and snippets.

@idevacc
idevacc / Git-server-Windows-Filesystem
Last active August 29, 2015 14:02
Git server on Windows File system
Reference Links
[Network Shared Git Repo](http://elegantcode.com/2011/06/18/git-on-windows-creating-a-network-shared-central-repository/)
[Gitguide](http://nathanj.github.io/gitguide/tour.html)
[Github docs](https://help.github.com/articles/set-up-git)
[Git remote repo - Windows](http://stackoverflow.com/questions/9308952/how-to-setup-and-clone-a-remote-git-repo-on-windows)
[Git initial remote setuo](http://thelucid.com/2008/12/02/git-setting-up-a-remote-repository-and-doing-an-initial-push/)
[Git SCM book](http://git-scm.com/book/en/Git-Basics-Working-with-Remotes)
[Git SCM book](http://git-scm.com/book/en/Git-on-the-Server-Setting-Up-the-Server)
@idevacc
idevacc / gist:4527149
Created January 14, 2013 01:24
Creates the Pubs database for use with SQL Server 2012
/* */
/* InstPubs.SQL - Creates the Pubs database */
/* */
/*
** Copyright Microsoft, Inc. 1994 - 2000
** All Rights Reserved.
*/
SET NOCOUNT ON
GO
@idevacc
idevacc / gist:4527115
Last active December 11, 2015 01:59
Northwind database for SQL Server 2012 substitutes sp_dboption for ALTER DATABASE -- exec sp_dboption 'Northwind','trunc. log on chkpt.','true' -- exec sp_dboption 'Northwind','select into/bulkcopy','true' -- see http://msdn.microsoft.com/en-us/library/ms187310(v=sql.105).aspx ALTER DATABASE Northwind SET RECOVERY SIMPLE ALTER DATABASE Northwind…
/*
** Copyright Microsoft, Inc. 1994 - 2000
** All Rights Reserved.
*/
SET NOCOUNT ON
GO
USE master
GO
@idevacc
idevacc / gist:4381851
Created December 26, 2012 17:59
Query to list all the fields from a table in mySql
select * from information_schema.columns
where table_schema = 'db_name' and table_name='tablename'
@idevacc
idevacc / gist:4381824
Last active December 10, 2015 04:38
Mysql get all columns from all tables in a database -- 'dbname'
select * from information_schema.columns
where table_schema = 'db_name'
order by table_name,ordinal_position