The Author
The Author, S.Abhilash is a Technology Enthusiast., and is having past one decades experience in IT related technologies including RDBMS, Application tools,IDEs , Web development Platforms, Server side Scripting , GUI , Server monitoring etc..
This time he is concentrating on IIS/Apache Server side Scripting , RDBMS, along with Server platforms as MS Windows and Redhat.
and is maintaining this from his own experience channel.
Read More | Contact
MSSQL Server Archive
-
Insert auto Number in SQL Bulk insert
Posted on July 3, 2010 | No CommentsTo insert unique serial numeric values to an SQL table usually DBAs rely on procs with loops and inside loop an incrementing variable substitutes numeric values this may query time out., will consume mush significant time and may cause intermediate termination to resolve this issue in... -
MS SQL Server – Functions
Posted on March 6, 2010 | 1 CommentSQL Help Launch “SQL Query Analyzer” then Help, click “Transact-SQL Help”, click the tab “Contents”, then click on the plus sign by “Transact-SQL Reference”. Launch “SQL Query Analyzer” then Help, “Contents and Index”. When “SQL Server Books Online” loads click on “Index” and type the... -
MSSQL Server Date Manipulations (datename)
Posted on March 6, 2010 | No CommentsIn MSSQL Server its necessary for to see weekname(sunday,monday,etc..) and, weekcount and even some times its important to the day count in an year and most of DBA s directly count these , but SQL has a lot of built in Functions have a look... -
Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
Posted on February 27, 2010 | No CommentsYou must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps: Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then... -
MSSQL 2005 Express Edition Agent(Scheduler)
Posted on February 4, 2010 | No CommentsMicrosoft’s Free Edition of its SQL Server Edition MSSQL 2005 Express Edition is not shipped with SqlServer Agent, This is the Major Drawback of SQL Server  and i made a lot of googling for the same Finally i reached http://www.lazycoding.com/products.aspx     Version... -
MSSQL Server Rules Simplified
Posted on January 8, 2010 | No CommentsOne of the most exciting RDBMS Feature RULE is very simple with MSSQL Server Creates an object called a rule. When bound to a Field, data type, a rule specifies the acceptable values that can be inserted into that field. Here i am using a... -
Strange Experience in MSSQL Server with ‘substring’ and ‘len’ Functions
Posted on January 8, 2010 | No CommentsAs of all DBA a me too is a great FAN of MS SQl Server for its Flexibility, stability and versatility , though recently i experienced a strange walthrough while i was into simple string functions with length and Substring extractions my requirement is simple... -
Comparison b/w MSSQL and Mysql
Posted on December 29, 2009 | No CommentsDatabase engines are a crucial fixture for businesses today. There is no shortage of both commercial and open source database engines to choose from. Microsoft SQL Server 2005 is Microsoft’s next-generation data management solution that claims to deliver secure and scalable applications while making them... -
SQL Server Insert Row number in Query Resultset
Posted on December 12, 2009 | No CommentsSelect Like following SELECT custid, custname, ROW_NUMBER() OVER(ORDER BY custid asc) AS ‘Row Number’ from members will list row number serially -
MSSQL Client For Linux
Posted on December 1, 2009 | No CommentsAqua Data Studio is a complete Integrated Development Environment (IDE) for database administrators, software developers and business analysts. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3)...
