Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
.net android asp.net asp.net mvc azure backup bigdata book business intelligence c# community continuous delivery database denali excel gotcha how to indexing java mongodb nancy nhibernate nosql performance powershell restore security silverlight sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali sqlcop ssis ssms ssrs structuremap syndicated t-sql tip unit testing vb.net visual studio 2010 windows 7
Authors
- SQLDenis (584)
- Christiaan Baes (chrissie1) (528)
- Ted Krueger (onpnt) (332)
- Jes Schultz Borland (grrlgeek) (140)
- Eli Weinstock-Herman (tarwn) (117)
- Alex Ullrich (51)
- George Mastros (gmmastros) (46)
- Koen Verbeeck (31)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (23)
- David Forck (thirster42) (22)
- Kevin Conan (18)
- chopstik (18)
- Rob Earl (14)
- thatrickguy (12)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: denali
SQL Server 2012 to be released Q1 2012
Ted Kummert, Senior VP, Business Platform Division announced at the PASS Summit 2011 Day One Keynote that the next version of SQL Server will be named SQL Server 2012 SQL Server 2012 will be released in Q1 2012 They are a variety of clients already…
Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing
According to the Microsoft SQLNCli team blog, SQL Server, codename "Denali", will be the last release to support OLE DB. Here is what they are currently saying The next release of Microsoft SQL Server, codename “Denali”, will be the last release t…
SQL Server Code Name “Denali” CTP3 Product Guide available for download
This is pretty cool and it is all in one place, the download is 456.0 MB The SQL Server Code Name “Denali” CTP3 Product Guide includes useful resources and demos that will help IT Professionals better evaluate of CTP3. This includes: - 14…
TRY_CONVERT in SQL Server Denali CTP3
TRY_CONVERT is a new function in SQL Server Denali CTP3, TRY_CONVERT enables you to test if a value can be converted to a specific data type, TRY_CONVERT returns a value cast to the specified data type if the cast succeeds; otherwise, TRY_CONVERT…
Format function in SQL Server Denali CTP3
SQL Server Denali CTP3 brings a couple of new functions, one of these is the FORMAT function The syntax of the format function looks like this FORMAT ( value, format [, culture ] ) Here is what Books On Line has to say about the arguments that…
Concat function in SQL Server Denali CTP3
SQL Server Denali CTP3 brings a couple of new functions, one of these is the CONCAT function. The CONCAT function returns a string that is the result of concatenating two or more string values. The syntax of the CONCAT function looks like this CO…
ColumnStore Index limitations in SQL Server Denali CTP3
If you have been working with Sybase IQ then you might be familiar with what a columnstore database is. SQL Server has added a new type of index which is column based instead of row based, this is the columnstore index. I will create another post thi…
DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3
Function Syntax Return value Return data type DATEFROMPARTS…
A Quick look at the new EOMONTH function in SQL Server Denali CTP3
SQL Server Denali CTP3 has a bunch of new date/time functions like DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH First let's take a look at EOMONTH. The syntax for EOMONTH is EOMONTH ( start_date [, month_to_add ] ) If you pass in getdate()…
A Quick look at the new IIF function in Denali CTP3
Denali CTP3 comes with the IIF function, if you have used VB or Excel then you already know how this function works. In essence this function is a shorter version of a CASE statement. The syntax is as follows IIF ( boolean_expression, true_value,…
:: Next >>
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.