all things Sitecore related

SQL Server

Step 3: Create the outgoing link report

Step 3: Create the outgoing link report

This article is part 3 of Sitecore How To: Track Exteral links with DMS series. Before starting with this step you need to be finished with Step 2. Otherwise you don’t have any report data. Show the outgoing links in a report The easiest way to generate a report is find a report that matches your needs, […]

Continue Reading »

Converting .mrt reports from OMS to DMS

By on November 15, 2011 in Analytics, DMS, Sitecore, SQL Server, TSQL, Tutorials with 0 Comments
Converting .mrt reports from OMS to DMS

In this article I’m going to explain how to convert .mrt reports from the Sitecore Online Marketing Suite (Sitecore 6.4) to the Sitecore Digital Marketing System (Sitecore 6.5). Report related changes between OMS and DMS Both the OMS and the DMS use .mrt reports for Analitics reporting. There are two mayor changes between the OMS […]

Continue Reading »

Linq to Sql: Retrieve properties from related data (LoadWith)

By on January 15, 2009 in ASP.Net, linq, SQL Server with 0 Comments

You have to specify which related-data you want to retrieve from a object so you can access them outside the Linq data-context. You can achieve this by using the LoadWith method of the DataLoadOptions Class. The LoadWith method accepts an lambda expression that specifies which object you want to retrieve. In the following example I […]

Continue Reading »

MSSQL: Database diagram support objects cannot be installed because this database does not gave a valid owner.

By on December 13, 2008 in SQL Server with 2 Comments

For a customer I needed to do a review there database (MSSQL 2000 database). For this I wanted to create some database diagrams. When I tried to create a diagram with Sql Sever Management Studio I got the following message: "Database diagram support objects cannot be installed because this database does not gave a valid owner." To […]

Continue Reading »

Microsoft SQL Server Database Publishing Wizard 1.1

By on September 2, 2008 in SQL Server with 0 Comments

When I was trying to publish a database to my shared hosting provider I encountered some problems with backup and restoring my database. To restore a database on my provider I needed a full Sql script (schema and data). After a few attempts with SQL comparer and Management studio I found a link to ‘Microsoft […]

Continue Reading »

Linq to Sql: Change connectionstring to load from Web.config

By on September 2, 2008 in ASP.Net, linq, SQL Server with 2 Comments
Linq to Sql: Change connectionstring to load from Web.config

Update 20 may 2009: New easy sollution Set the Connection -> Application Settings property True. This will generate a connection string in your app.config.   Copy this connection string to your web.config and your all set!   =================================================================  Old post:  If you want to use your connectionstring from the web.config with Linq to Sql (dbml) […]

Continue Reading »

MsSql: How to enable clr (to run c# / vb code in SQL)

By on June 26, 2008 in SQL Server with 0 Comments

Execute the next query to enable CLR.   [code:c#] // Turn advanced options on EXEC sp_configure 'show advanced options' , '1'; go reconfigure; go EXEC sp_configure 'clr enabled' , '1' go reconfigure; // Turn advanced options back off EXEC sp_configure 'show advanced options' , '0'; go [/code] More info about CLR on Microsoft MSDN.

Continue Reading »

Dynamic load whereparameters for linqDatasource

By on April 1, 2008 in ASP.Net, SQL Server with 1 Comment

When using an Linq Datasource (linq to sql) for a datagrid (Gridview, ListView, etc) you don't always want all rows from a table. To exclute data you can use the WhereParameters to add an where statement to your DataSource. You can do limited where statements with the Visual Studio Wizards. When you need more than a […]

Continue Reading »

Top