All Articles - SQL Authority with Pinal Dave

SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction

September 10, 2011

In SQL Server Denali, there are two new logical functions being introduced, namely: IIF() CHOOSE() Today, we will have a look at the IIF() function. This function does not need any introduction as developers have used this function in various languages from ages. This function is shorthand way for writing…

SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()

September 9, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

In SQL Server Denali, three new conversion functions have been introduced, namely,

PARSE()
TRY_PARSE()
TRY_CONVERT()

SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction

September 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly take a look at the TRY_CONVERT() function. The TRY_CONVERT() function is very similar to CONVERT function which is avail in SQL Server already. Only difference is that it will attempt…

SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction

September 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly take a look at the TRY_PARSE() function. The TRY_PARSE() function can convert any string value to Numeric or Date/Time format. If the passed string value cannot be converted to Numeric…

SQL SERVER – A Guide to Integrating SQL Server with XML, C#, and PowerShell – Book Available for SQL Server Certification

September 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQL Scripts

We recently gave away 7 physical books of Joes 2 Pros Book Volume 5. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…

SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction

September 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly look at PARSE() function. PARSE() function can convert any string value to Numeric or Date/Time format. If passed string value cannot be converted to Numeric or Date/Time format, it will…

SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide

September 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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. Download Denali CTP3. Additionally you can read what…

SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide

September 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

I was recently looking for best practices for Hyper-V and SQL Server and I ended up whitepaper which was published in July earlier this year. I really wish I had come across this whitepaper earlier but any way still it is better to be late then never. Download Running SQL…

SQL SERVER – Programming and Development – Book Available for SQL Server Certification

September 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQL Scripts

We recently gave away 7 physical books of Joes 2 Pros Book Volume 4. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35

September 4, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQL Scripts

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. OpenXML Options The last posts introduced us to the OpenXML function. We learned…