So by this time all of you should know that SQL Server “Denali” CTP 3 is out and about. For all of you(like me) who rushed to download and install it, there is a little secret. There are a few feature packs as well available to accompany your new installation and Visual Studio 2010(with SP 1). All the feature packs can be found here, including the alluding Books On Line which doesn’t force you to connect to the internet version.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Yesterday, I attended a training class at Microsoft’s facility in Malvern, Pennsylvania. This training class was led by Sebastian Meine (sqlity.net) and Dennis Lloyd (curiouslycorrect.com). The class was from 9:00 am to 5:00 pm with a short break for lunch. During the class, Dennis and Sebastian explained how to use tSQLt (http://tSQLt.org) to write unit tests for your database code. tSQLt is a frame work that can be freely downloaded and applied to your database, allowing you to quickly and easily write unit tests.
Apparently Project Kotlin is a new JVM based language ala Scala developed by Jetbrains. We all know jetbrains from the excellent products they make. Like Resharper and IntelliJ. With Kotlin, we’re building upon the many years of experience creating development tools for different languages, and hoping to provide a language which is productive enough for today’s environment and at the same time simple enough for the ordinary programmer to learn.
As a software developer you need to stay on top of things by reading articles, watching screencasts, following the right people on twitter,… Of course you have to find the good stuff else you are going to waste most of your time. For this there are already several sites out there. Sites like DZone and DotNetkicks will help you find the good stuff by having a voting system. But voting is flawed concept however you look at it.
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 returns null. Here is what Books On Line has to say about TRY_CONVERT _TRY_CONVERT takes the value passed to it and tries to convert it to the specified data_type.
Working as a Software Developer* in a range of small companies and organizations, I’ve had the opportunity to work on quite a number of different projects. That experience has given me a healthy appreciation for how not to execute projects, as well as a healthy respect for process. Recently I pulled together a basic process to help manage the development tasks I am working on, track completion against my estimates, and a number of other things.
The SQL Server Database Engine has published a SQL Server Columnstore Index FAQ wiki The SQL Server columnstore index feature, code-named Apollo, speeds up data warehouse query processing in SQL Server code-named “Denali”, in many cases by a factor of 10 to 100. We’ll be posting answers to frequently asked questions here. For more information about columnstore indexes, please see Columnstore Indexes on MSDN. There are 6 sections Overview Creating a Columnstore Index
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 you can pass in _value Expression of a supported data type to format. format nvarchar format pattern. The format argument must contain a valid .
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 CONCAT ( string_value1, string_value2 [, string_valueN ] ) You can concatenate between 2 and 254 values, if you use for example only one value, you will get an error
Ok, I hope I got your attention with this title 🙂 I want to share my solution of an interesting problem I saw today at tek-tips forum SQL 2005: Find longest sequence of events within a table Given the following table: Team Table Team Date WiLose A 2010-01-01 00:00:00.000 Win A 2010-01-07 00:00:00.000 Lose A 2010-01-13 00:00:00.