ConnectionStrings - a tribute

By Rajib Bahar at September 29, 2009 07:25
Filed Under: SQL

I use the ConnectionStrings.com site many times. Whehter it's MS SQL server or Oracle or MySql, they have the useful snippet of code for the connection string. It usually saves me time from looking up the manual. I thought I would dedicate this entry just for them.

 

If you don't know what connection string is then you are lucky to be reading this entry. In short, connection string is what defines how we connect to data sources and destinations. It enables application to talk to the database so that information is persisted in the RDBMS or target data structure. 

 

A sample connection string may look like this... (Yes... I borrowed the connection string below from their site :) )

 

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Obama Health Care Speech At Target Center In Minnesota Part 1

By Rajib Bahar at September 12, 2009 18:00
Filed Under:


Obama Health Care Speech At Target Center In Minnesota Part 1

http://www.youtube.com/rajib2k5

TSQL Cheatsheet - Need more to build on this list

By Rajib Bahar at September 01, 2009 07:31
Filed Under: SQL

I use these cheatsheets related  to TSQL and/or SQL server from time to time.

 

I can not count on my memory, but, it would be nice to have a photographic one.

 

Enough of my rambling, here is the list:

TSQL Cheatsheet found at Scribd - http://www.scribd.com/doc/399147/TSQL-Cheat-Sheet

SQL Server Cheatsheet found at Scribd - http://www.scribd.com/doc/15235350/SQL-Server-TSQL-Cheatsheet

Dave Pinal or SQL Authority's Cheatsheet - http://www.pinaldave.com/sql-download/SQLServerCheatSheet.pdf 

 

Did I miss any good ones? I'll update this 

Tag cloud

Month List