DotNetShoutout

denali

7
Shouts

Shout it

SQL Server 2012 – new conversion functions

published 525 days, 13 hours, 31 minutes ago posted by

kinj312 525 days, 22 hours, 46 minutes ago

With SQL Server 2012 comes a new set of conversion functions , that will certainly help doing type casts and conversions in t-sql. These functions are: TRYPARSE TRYCONVERT PARSE TRYPARSE() Syntax from BOL: TRYPARSE ( stringvalue AS datatype [ USING... (more)

category: Data | clicked: 16 | comment | | source: beyondrelational.com

tags: SQL Server, denali, sql server 2012

8
Shouts

Shout it

SQL Server 2012 (“Denali”) Licensing

published 546 days, 14 hours, 24 minutes ago posted by

kinj312 547 days, 22 hours, 56 minutes ago

Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing options – one that is based on computing power (“core based”), and one that is based on users or devices (“Server... (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

tags: SQL Server, denali

7
Shouts

Shout it

CONCAT() – SQL Server 2012

published 546 days, 14 hours, 24 minutes ago posted by

kinj312 553 days, 39 minutes ago

With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of the concatenation of two or more strings – if the input is another type than string a conversion will be done implicit. The CONCAT() function takes... (more)

category: Data | clicked: 11 | 1 comment | | source: beyondrelational.com

tags: SQL Server, denali, sql server 2012

8
Shouts

Shout it

Rule “SQL Server "Denali" CTP3 Feature Upgrade” Failed

published 585 days, 6 hours, 34 minutes ago posted by

dhara 589 days, 8 minutes ago

UPDATE: Hindsight is a wonderful thing. If I had remembered that you can’t upgrade ANY current edition of SQL Server to an evaluation edition , I wouldn’t have wasted time building a SQL Server 2008 R2 VM and then trying to upgrade it to SQL Server 2012... (more)

category: Data | clicked: 5 | 4 comments | | source: beyondrelational.com

tags: SQL Server, denali, CTP

2
Shouts

Shout it

SQL-Articles » IIF function – SQL Server Denali

published 597 days, 13 hours, 15 minutes ago posted by

sqlarticles 599 days, 20 hours, 18 minutes ago

IIF function is new to SQL Server Denali however if you worked with MS Access then you are familiar with this function. So if you are upgrading a database from Access to SQL Server Denali you don’t need to worry about rewriting the IIF function queries. IIF function will evaluate the expression and it will return one value out of two input values. Read more: http://sql-articles.com/articles/general/iif-function-sql-server-denali/#ixzz1c5Ej6pGn (more)

category: Data | clicked: 9 | comment | | source: sql-articles.com

tags: Development, TSQL, denali, sqlarticles, IIF, SQL Server 2011

6
Shouts

Shout it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips – Editing, exporting & importing

published 607 days, 4 hours, 4 minutes ago posted by

dhara 614 days, 2 hours, 45 minutes ago

The debugger in the SQL Server Management Studio (SSMS) for the upcoming SQL 11 (“Denali”) is packed with exciting features.The new SSMS is a derivative of the VS2010 shell and therefore extends the same debugging experience (with the obvious differences... (more)

category: Data | clicked: 4 | comment | | source: beyondrelational.com

tags: SQL Server, denali

6
Shouts

Shout it

SQL Server Denali: New warnings in Actual Execution Plan

published 607 days, 4 hours, 4 minutes ago posted by

dhara 614 days, 2 hours, 46 minutes ago

I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sortwarning and hashwarnig. In SQL Server 2008R2, we can create SQL Trace to capture... (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, denali

6
Shouts

Shout it

THROW - New Addition for Error Handler in SQL Server Denali

published 614 days, 13 hours, 27 minutes ago posted by

dhara 615 days, 22 minutes ago

Now we have so many options and ways to handle errors in SQL Server. And It is very easy today because of addition or enhancement of error handling in SQL Server. You can read all features of SQL Server Denali. (more)

category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, denali

6
Shouts

Shout it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips

published 614 days, 13 hours, 27 minutes ago posted by

dhara 616 days, 2 hours, 45 minutes ago

The debugger of any IDE is a very powerful tool because it gives developers the insight on how their program or script is functioning. I have throughout been a SQL person, and have always felt that at some stage, Microsoft SQL Server did not deliver at... (more)

category: Data | clicked: 9 | 6 comments | | source: beyondrelational.com

tags: SQL Server, TSQL, denali

6
Shouts

Shout it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Breakpoints - “When Hit” do something

published 614 days, 13 hours, 27 minutes ago posted by

dhara 618 days, 2 hours, 51 minutes ago

During Tech-Ed (read my 3 part series here – Part 01 , Part 02 , Part 03 ), I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL 11 (Code Named: “Denali”). I am currently summarizing... (more)

category: Data | clicked: 4 | 5 comments | | source: beyondrelational.com

tags: SQL Server, denali

5
Shouts

Shout it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Export/Import Breakpoints

published 621 days, 12 hours, 16 minutes ago posted by

dhara 622 days, 23 hours, 19 minutes ago

category: Data | clicked: 7 | 4 comments | | source: beyondrelational.com

tags: SQL Server, denali

6
Shouts

Shout it

SQL Server “Denali”: Installing on a Virtual Machine

published 626 days, 15 hours, 3 minutes ago posted by

dhara 628 days, 1 hour, 43 minutes ago

With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as the new tools, such as Crescent and Juneau . The steps below are what I took to create a virtual machine to install all the products needed... (more)

category: Data | clicked: 58 | 4 comments | | source: beyondrelational.com

tags: SQL Server, denali

5
Shouts

Shout it

XEVENT Provider in Denali

posted by

dhara 637 days, 5 minutes ago

XEVENT provider is new sqlps provider in Denali CTP3. To admit, I was surprised when I saw it. In SQL Server 2008R2 we don’t have any GUI for XEVENT (Extended Events) written by SQL Team and now, in Denali CTP3, we have nice GUI through SSMS and... (more)

category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, denali

7
Shouts

Shout it

New LOGICAL functions in SQL Server Denali

published 630 days, 18 hours, 20 minutes ago posted by

dhara 638 days, 22 hours, 47 minutes ago

IFF Function If you are an old Access or Excel “developer” you know this one. This is not a function I have been missing before I read about it today. If you, like me, is so tired of writing CASE statements with only 2 possible outcoms... (more)

category: Data | clicked: 14 | 15 comments | | source: beyondrelational.com

tags: SQL Server, denali

8
Shouts

Shout it

Percentile_Disc Function in Denali CTP3

published 634 days, 18 hours, 35 minutes ago posted by

dhara 642 days, 1 hour, 47 minutes ago

Percentile_Disc Function Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an element from the set.It accepts any numeric datatype or any nonnumeric datatype that can be implicitly converted... (more)

category: Data | clicked: 5 | 13 comments | | source: beyondrelational.com

tags: SQL Server, denali, CTP

7
Shouts

Shout it

Percentile_Cont Function in Denali CTP3

published 643 days, 15 hours, 44 minutes ago posted by

dhara 644 days, 3 hours, 6 minutes ago

Percentile_Cont Function Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an interpolated value that would fall into that percentile value with respect to the sort specification.It accepts any... (more)

category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com

tags: SQL Server, denali, CTP

9
Shouts

Shout it

SQL Server Denali – FORMAT() string function

published 638 days, 15 hours, 23 minutes ago posted by

dhara 644 days, 22 hours, 56 minutes ago

SQL Server Denali brings us new string function, FORMAT function. It will make formatting of date/time and number values easier. Syntax: FORMAT (value, format [,culture]) Formatting Date/Time Let’s see how it works: DECLARE @a datetime = getdate... (more)

category: Data | clicked: 11 | 15 comments | | source: beyondrelational.com

tags: SQL Server, denali

8
Shouts

Shout it

Percent_Rank function in Denali CTP 3

published 643 days, 15 hours, 44 minutes ago posted by

dhara 644 days, 22 hours, 57 minutes ago

PercentRank Function Purpose: Within a group of rows, it calculates the relative rank of a row. Syntax: PercentRank () Over ( [partitionbyclause] orderbyclause) Formula: Percent_Rank = (R -1)/(N-1) Where, R => The row whose rank needs to be found... (more)

category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com

tags: SQL Server, denali, CTP

7
Shouts

Shout it

Last_Value function in Denali CTP 3

published 645 days, 2 hours, 12 minutes ago posted by

dhara 645 days, 23 hours, 40 minutes ago

LastValue Purpose: Returns the last value from the order set of values. Syntax: LastValue(expression) over( [ PartitionByclause] order by clause [rowsrangeclause]) Where, Expression => A table column or built-in function but not analytical functions... (more)

category: Data | clicked: 1 | 1 comment | | source: beyondrelational.com

tags: SQL Server, denali, CTP

6
Shouts

Shout it

Lag function in Denali CTP 3

published 648 days, 27 minutes ago posted by

dhara 649 days, 1 hour, 46 minutes ago

Lag Function Purpose: This function returns result set starting from the previous row in the table. Syntax: Lag(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)

category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com

tags: SQL Server, denali, CTP

Welcome!

denali

SQL Server 2012 – new conversion functions

SQL Server 2012 (“Denali”) Licensing

CONCAT() – SQL Server 2012

Rule “SQL Server "Denali" CTP3 Feature Upgrade” Failed

SQL-Articles » IIF function – SQL Server Denali

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips – Editing, exporting & importing

SQL Server Denali: New warnings in Actual Execution Plan

THROW - New Addition for Error Handler in SQL Server Denali

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Breakpoints - “When Hit” do something

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Export/Import Breakpoints

SQL Server “Denali”: Installing on a Virtual Machine

XEVENT Provider in Denali

New LOGICAL functions in SQL Server Denali

Percentile_Disc Function in Denali CTP3

Percentile_Cont Function in Denali CTP3

SQL Server Denali – FORMAT() string function

Percent_Rank function in Denali CTP 3

Last_Value function in Denali CTP 3

Lag function in Denali CTP 3

Open ID Login

Standard Login

Forgot Password?

Sign up