Category Archives: Database

Generate insert statements

Posted on June 15, 2012 by mytechlifedays

The scripts section of SQLCentral has real wonderful scripts ! 😉 One of them is indeed so useful for our MS SQL Server … You could find many variants of the same if you google it … but this one … Continue reading →

Posted in Database | Tagged | Leave a comment

Filetable – SQL Server 2012

Posted on June 13, 2012 by mytechlifedays

With the new SQL server 2012 , Microsoft has packed a whole new bunch of features ! One among them is the ‘FileTable’ . The name it self suggest it all ! As per MSDN : SQL Server provides a … Continue reading →

Posted in Database | Tagged , | Leave a comment

Understanding Sequences and their use – SQL Server 2012

Posted on April 13, 2012 by mytechlifedays

As per MSDN , A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending … Continue reading →

Posted in Database | Tagged , | Leave a comment

Sequences in SQL Server 2012

Posted on April 13, 2012 by mytechlifedays

Sequences where for Oracle until now 😉 Now, SQL Server 2012 comes with a nice and simple to use Sequence Feature like Oracle. An example sequence ‘countToten’ which would have sequence from 1 to 10 could be created like this … Continue reading →

Posted in Database | Tagged , | 1 Comment

SQL Server 2012 – The Virtual Launch Event

Posted on March 7, 2012 by mytechlifedays

Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server. As per MS : Why You Should Attend? You will have access to over 30+ … Continue reading →

Posted in Database | Tagged | Leave a comment