jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 418 days, 8 hours, 40 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

Download Free ebook - Introducing Microsoft SQL Server 2008 R2
published 1132 days, 3 minutes ago posted by ashishgilhotraashishgilhotra 1133 days, 6 hours, 25 minutes ago
Tuesday, April 20, 2010 12:46:00 PM GMT Monday, April 19, 2010 6:24:28 AM GMT
Introducing Microsoft SQL Server 2008 R2 is a 10 chapter, 216 page book writtenby Ross Mistry and Stacia Misner. Microsoft has made it available as a free ebook (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Dashboards in SSRS 2008
published 1132 days, 3 minutes ago posted by ashishgilhotraashishgilhotra 1133 days, 6 hours, 24 minutes ago
Tuesday, April 20, 2010 12:46:00 PM GMT Monday, April 19, 2010 6:25:38 AM GMT
SSRS 2008 version has changed so much for the better when you compare to the 2005 version, be it on terms of aesthetics or developer friendliness. This post shows a trick that demonstrates how to create a heatmap control on a report. (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
5
Shouts
spam Shout it Mute it

Managing SQL Server Jobs in a Mirroring Environment
published 1132 days, 3 minutes ago posted by ashishgilhotraashishgilhotra 1133 days, 6 hours, 22 minutes ago
Tuesday, April 20, 2010 12:46:00 PM GMT Monday, April 19, 2010 6:26:45 AM GMT
This article demonstrates an efficient way to manage SQL Server jobs between the Principal and Mirror databases. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
4
Shouts
spam Shout it Mute it

XQuery Lab 55 – Extracting values from XML elements that matches a string pattern
posted by ashishgilhotraashishgilhotra 1143 days, 2 hours, 53 minutes ago
Friday, April 09, 2010 9:56:20 AM GMT
Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
6
Shouts
spam Shout it Mute it

SSIS - Delete files in a folder older than a specified number of days
posted by ashishgilhotraashishgilhotra 1143 days, 2 hours, 56 minutes ago
Friday, April 09, 2010 9:53:14 AM GMT
This post explains how to delete files created a number of days before current date using SSIS. (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

Cannot resolve collation conflict for column 1 in SELECT statement
posted by ashishgilhotraashishgilhotra 1143 days, 3 hours, 1 minute ago
Friday, April 09, 2010 9:47:47 AM GMT
This post explains how to fix the SQL Server error message "Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "ArabicCIAS" and "SQLLatin1GeneralCP1CI_AI" in the equal to operation". (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
3
Shouts
spam Shout it Mute it

Incrementing a column value in SSIS
posted by ashishgilhotraashishgilhotra 1143 days, 3 hours, 4 minutes ago
Friday, April 09, 2010 9:45:09 AM GMT
Many times it is required to insert an incremental value inside a column and we tend to use Identity column to achieve it. But what if we already have an identity column in the same table? To achieve this we write some custom logic to fetch the maximum value and increment the value by one. (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: sql 2005, BI
Previous 1 2 ... 47 48 49 50 51 52 53 54 55 56 Next