Tag: Denali

SQL Server Denali – New Logical Functions

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, SQL-Tips and Tricks, Varinder Sandhu

There are two new Logical functions are introduced in Denali. Let‘s have a look IFF CHOOSE IFF It Returns one of two values, depending on whether the Boolean expression evaluates to true or false. IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. That is, the true_value is returned if the Boolean expression

» Read more
, , ,

SQL Server – PARSE() and TRY_PARSE() conversion functions

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, SQL-Tips and Tricks, Varinder Sandhu

PARSE() and TRY_PARSE() are new conversion function introduced in SQL Server Denali. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns error. Also, we can also specify the CULTURE, during this conversion.  CULTURE, means a language which will used by SQL Server to interpret data. If

» Read more
, , ,

SQL Server code name ‘Denali’ – Community Technology Preview 3 (CTP 3)

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, Varinder Sandhu

Microsoft SQL Server code name ‘Denali’ enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence. SQL Server code name ‘Denali’ enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for

» Read more
, , ,

SQL Server – Inside of Next Generation SQL Server – Denali

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, SQL-Tips and Tricks, Varinder Sandhu

Today I have attended the webcast topic “Inside of Next Generation SQL Server – Denali” at Zeollar.com. This session presented by Pinal Dave (http://blog.sqlauthority.com) It was really a nice presentation about features of SQL Server 2011 – Denali.  You can get the details of this session at here You can watch or download the video at http://zeollar.cloudapp.net/Session/234

» Read more
, , ,

Welcome SQL Server 2011-Denali – CTP1

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

Dear friends, A new release of SQL Server is available, and if you follow blogs or tweets or check Microsoft’s SQL Server website. You might have seen mention of the new version, code-named “Denali” SQL Server 2011 – CTP1 Released. CTP stands for Community Technology Preview It’s available in both 32-bit and 64-bit version. May you are getting excited about the new version. So that‘s why I am sharing with you all… What‘s New SQL 2011 Microsoft SQL Server 2011

» Read more
, ,

SQL Server 2011-Denali

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

SQL Server code-named “Denali” Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named “Denali” customers will benefit from the following added

» Read more
, ,