SQL Server 2012 will be released on March 7th

Pascal Carpels brought the news via LinkedIn about the SQL Server 2012 upcoming release date, it will be on the 7th of March!

Microsoft has said that it will launch its SQL Server 2012, the next generation of its database product, online in March 7.

However Microsoft is quietly confident about SQL Server 2012 which will arrive in three flavours. As well as a standard “nothing to see here move on please version” there will be a business intelligence version that adds features such as the Power View data-discovery tool and data quality services to the standard edition’s features.
There is the Enterprise Edition that includes advanced security, high-availability capabilities and a columnar data store.
As you might expect, to celebrate the release, Microsoft is creating a new licensing plan.
Enterprise and Standard Edition will be available on a core-based model, with licenses sold in two-core packs. Standard Edition is also available on a server plus client access license basis. BI edition is only available via server-plus-CAL licensing.

Read more: click here

2012
01/27
CATEGORY
SQL
SQL Server
SQL Server 2012
TAGS
Write comment

sp_lock2

Download the code: Code: sp_lock2

Thanks to Narayana Vyas Kondreddi

2012
01/23
CATEGORY
SQL
SQL Server 2008 R2
T-SQL
TAGS
Write comment

How to create your own Report Template

I really thought I had a blog post already about Report Templates, guess not :)

Well basically you need to create two reports, one for Portrait orientation and one for Landscape orientation.
Next is to copy/paste them into this folder:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

Once you add a New Report to your Reporting Project, you’ll notice that your Report Templates will be listed:

2012
01/23
CATEGORY
SSRS 2005
SSRS 2008
SSRS 2008 R2
TAGS
Write comment

LinkMentalist.com PingBack’s

I’ve been receiving quite a few PingBack’s from Dactylonomy of Web Resource (alias ‘Link Mentalist’):

It’s actually quite a nice and resourceful linking website, just have a look.
Each week, several interesting blog posts on BI, SSIS, SSRS and SSAS are listed here.

Pingback lets you notify the author of an article if you link to his article (article on a blog, of course).

2012
01/03
CATEGORY
Web
TAGS
1 comment

How To: Generate a script to drop all Indexes

Well…here it is!
I know some of you are thinking, why would you ever do that?
In my case, I had to upload the entire database (about 40GB) to an external FTP-server.
It saved me a few GB’s to drop the indexes first and send them a SQL-script to (re-)create them ;)

SELECT
'DROP INDEX ' + SS.name + '.' + SO.name + '.' + '[' + SI.name + ']'
FROM sys.objects as SO
INNER JOIN sys.schemas SS
ON SO.schema_id = SS.schema_id
INNER JOIN sys.indexes as SI
ON SO.Object_Id = SI.Object_Id
WHERE LEFT(si.Name,2) IN ('IX') --'IX' is the used naming prefix.
ORDER BY SO.Name , SI.name

2011
12/30
CATEGORY
T-SQL
TAGS


Write comment

New SQL Server 2012 Labs and Presentations Available

Microsoft released (and updated) the SQL Server 2012 Developer Training Kit and you can get it right now via the Web Installer Preview:

Microsoft’s Download Center

A complete list of the content can be found here.

2011
12/05
CATEGORY
SQL Server 2012
TAGS
Write comment

SSIS: ErrorDescription and ErrorColumn (ErrorColumnName)

If you’re looking for a way to add the logical error description into your dataflow, you may want to use a common Script Component with these lines of Visual C# script (overwrite the existing procedure):

public override void Input0_ProcessInputRow(Input0Buffer Row)
{
Row.ErrorDescription = this.ComponentMetaData.GetErrorDescription(Row.ErrorCode);
}

A detailed manual to accomplish this can be found here, thanks to Jamie Thomson.

But if you also want to add the specific column name on which the error occured, take a look at this customer SSIS component.

Error Output’s Description on CodePlex

Error Output’s Description

EOD in action:

EOD’s output:

It’s a little bit buggy and it will take a few tweaks to get it working on a Windows Server / SQL Server 2008R2 environment.

First bump: from 32-bit to 64 bit…The DLL needs to be copied to your Program Files (x86)-folder.

Second bump: You need GACUtil to register these assemblies (it’s not in the new .NET Framework(s) anymore, so you’ll need to copy it from an older .NET Framework version (2.0?).

Two possible locations for GACUtil:
- Windows\Microsoft.NET\assembly
- Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin

Third bump: The ‘Exception from HRESULT: 0xC0010009′ exception…it appears that it’s a little bit sensitive to changes in the metadata of the dataflow (more info on this here).

A quick work around is to delete all dataflow components down-stream of the EOD-component and possibly rebuild the package, before you edit the EOD-component.

It appears that the exception has something to do with accessing System Parameters according to Google.

Other discussions about this custom component can be found here.

But…after all…it works great once you get it running :D
You may want to use the column name to zoom in on the incorrect values which were found during processing.

A practical example of such a report can be found here.

2011
11/22
CATEGORY
SSIS
SSIS 2008
SSIS 2008 R2
TAGS


Write comment

SSIS: FINDSTRING() with backspaces

It took some time for me to figure this one out, but actually it’s pretty easy…
Apparently the SSIS coding is based on C/C#, so you’ll need to use an escape character to get the filename out of ‘Fully qualified’ path/filename.

So to get ‘FileName.txt’ out of ‘C:\Temp\FileName.txt’, you’ll need to use a combination of FINDSTRING() and REVERSE():

FINSTRING() – To find a string-part within a string
REVERSE() – Because you’re not able to select the last string-part within a string.


(DT_WSTR,50)
REVERSE(
SUBSTRING(REVERSE(@[User::FileName]),1,FINDSTRING(REVERSE(@[User::FileName]),"\\",1) - 1)
)

2011
11/14
CATEGORY
SSIS
SSIS 2008
TAGS

2 comments

SSIS: Trash Destination Adapter

I found this easy to use (and free) trash destination adapter for your SSIS packages:

Check out the website of SQLIS.com and download this custom component.

2011
11/12
CATEGORY
SSIS
SSIS 2008
SSIS 2008 R2
TAGS
Write comment

Microsoft’s Productivity Future Vision (2011)

It’s going to be a very cool future…but in what year would this be possible? :)

2011
10/29
CATEGORY
Microsoft
TAGS
Write comment
Follow

Get every new post delivered to your Inbox.