|
|
-
|
|
Microsoft announced that SQL Server 2012 RTM has released to manufacturing and general availability is scheduled for 1 April 2012.
You can download an evaluation of the SQL Server 2012 RTM today.
Microsoft SQL Server 2012 Feature Pack is available here.
T...
|
|
-
|
|
After SQL Server 2012 RC0 installation I noticed a few changes in SQL Server services account configuration. In previous versions (SQL Server 2005 and 2008/R2) during stand-alone SQL Server installation, local Windows group is created and service account for services or service SID is added as a mem......
|
|
-
|
|
Sort warnings events will rise when sort operation is performed in a query and it doesn’t fit into memory. In this case, SQL Server needs to spill the sort operation into tempdb which can result in a very slow physical operation especially if multiple passes to tempdb is needed for sorting the......
|
|
-
|
|
Microsoft has released a Product Guide for SQL Server Denali CTP3. It contains white papers, presentations, datasheets, demos and links to online videos and references. It’s excellent source of information for everyone who want to experience and evaluate Microsoft SQL Server Denali.
......
|
|
-
|
|
I’ve tried Denali CTP3 SQLPS and noticed some great changes. Here I will describe my first experience with Denali SQLPS.
I’ve started SQLPS by right-clicking on server node in SSMS Object Explorer and selecting “Start PowerShell”. I read that sqlps is no longer a mini-shell, so I first executed Get......
|
|
-
|
|
SQL Server Denali introduced new conversion functions: PARSE() and TRY_PARSE().
PARSE() function
PARSE() function converts expression (string value) to date/time and number data types if conversion is possible. If conversion isn’t possible it raises an error.
-- Parse to datetime specifying cul......
|
|
-
|
|
SQL Server Denali introduces 7 new date and time built-in functions. One of these functions is EOMONTH(). EOMONTH() returns the date value that represents the last day of the month for given date.
Syntax: EOMONTH( start_date [, months_to_add] )
Pre- Denali, to calculate the date value that represe......
|
|
-
|
|
TRY_CONVERT is new conversion function in SQL Server Denali. Unlike the CAST and CONVERT functions, TRY_CONVERT allows us to test whether it is possible to convert a value to specific data type.
TRY_CONVERT converts passed value to the specified data type, if conversion isn’t possible null is retur......
|
|