jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 417 days, 15 hours, 19 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

Support for Paging Queries in SQL Server CE 4.0 - Jacob's Blog
published 1038 days, 4 hours, 30 minutes ago posted by jacobsebastianjacobsebastian 1038 days, 14 hours, 33 minutes ago
Thursday, July 22, 2010 2:57:55 PM GMT Thursday, July 22, 2010 4:55:04 AM GMT
This post explains a new TSQL enhancement added to SQL Server CE 4.0 to support queries that require server side paging. For example, this new syntax allows you to fetch rows 31 to 40 to display on page 3 of your web page. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: TSQL, sqlserver compact, sql server ce 4.0, SQLServer
6
Shouts
spam Shout it Mute it

Fun with dot - Madhivanan's TSQL Blog
published 1037 days, 5 hours, 29 minutes ago posted by jacobsebastianjacobsebastian 1039 days, 7 hours, 6 minutes ago
Friday, July 23, 2010 1:58:46 PM GMT Wednesday, July 21, 2010 12:21:48 PM GMT
SQL Server MVP Madhivanan comes up with several interesting points about the usage of the dot operator in TSQL. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL
8
Shouts
spam Shout it Mute it

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges
published 1039 days, 4 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1039 days, 16 hours, 8 minutes ago
Wednesday, July 21, 2010 3:24:21 PM GMT Wednesday, July 21, 2010 3:20:11 AM GMT
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, Puzzle, TSQL, challenge
7
Shouts
spam Shout it Mute it

Introduction to WCF Service
published 1040 days, 45 minutes ago posted by jacobsebastianjacobsebastian 1040 days, 16 hours, 20 minutes ago
Tuesday, July 20, 2010 6:43:23 PM GMT Tuesday, July 20, 2010 3:07:44 AM GMT
This post explains some basics of WCF Services to add multiple pushpins on Bing Map by fetching data from SQL Server Database. (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: WCF Service, PUSH PIN, Bing Maps, ASP.NET
7
Shouts
spam Shout it Mute it

Implementing Routing in ASP.NET 4 applications - Hima's blog
published 1041 days, 9 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1041 days, 13 hours, 34 minutes ago
Monday, July 19, 2010 10:24:02 AM GMT Monday, July 19, 2010 5:53:45 AM GMT
This article deals about on How to implement Routing in ASP.NET4 Web Applications (more)
category: Web Dev | clicked: 2 | comment | | source: beyondrelational.com
tags: SEO, URL Routing, ASP.NET
6
Shouts
spam Shout it Mute it

Understanding ASP.NET 4 URL Routing in 2 minutes - Hima's blog
published 1044 days, 6 hours, 53 minutes ago posted by jacobsebastianjacobsebastian 1044 days, 16 hours, 4 minutes ago
Friday, July 16, 2010 12:35:23 PM GMT Friday, July 16, 2010 3:23:54 AM GMT
This post explains how URL Routing helps in Search Engine Optimization and how to do URL routing with ASP.NET (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: dotnet, SEO, URL Routing, ASP.NET
4
Shouts
spam Shout it Mute it

Generating and exporting SSRS reports programatically using Report Viewer Control
published 1044 days, 6 hours, 53 minutes ago posted by jacobsebastianjacobsebastian 1045 days, 11 hours, 52 minutes ago
Friday, July 16, 2010 12:35:23 PM GMT Thursday, July 15, 2010 7:35:47 AM GMT
This post demonstrates how to generate SSRS reports programatically from an ASP.NET web page using Report Viewer control. (more)
category: Web Dev | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, Reporting, SSRS
7
Shouts
spam Shout it Mute it

Monitoring Transactional Replication - Malathi's Blog
published 1046 days, 4 hours, 8 minutes ago posted by jacobsebastianjacobsebastian 1046 days, 13 hours, 36 minutes ago
Wednesday, July 14, 2010 3:20:19 PM GMT Wednesday, July 14, 2010 5:52:00 AM GMT
This post presents a TSQL script that you can use to monitor SQL server transactional replication. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: DBA, replication, Monitoring
7
Shouts
spam Shout it Mute it

Introduction : LINQ to SQL - SQL Server Community Blogs
posted by jacobsebastianjacobsebastian 1047 days, 15 hours, 5 minutes ago
Tuesday, July 13, 2010 4:23:25 AM GMT
LINQ [Language Integrated Query], it’s a programming model for any kind of data. It’s enable you to query data irrespective of data source hence its another data abstraction layer. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: Linq To SQL, dotnet, Linq
6
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners
posted by jacobsebastianjacobsebastian 1048 days, 12 hours ago
Monday, July 12, 2010 7:28:09 AM GMT
This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: challenges, TSQL, puzzles, SQLServer, challenge
8
Shouts
spam Shout it Mute it

Export all table data to Text file - Madhivanan's TSQL Blog
published 1050 days, 5 hours, 39 minutes ago posted by jacobsebastianjacobsebastian 1050 days, 14 hours, 6 minutes ago
Saturday, July 10, 2010 1:48:36 PM GMT Saturday, July 10, 2010 5:21:44 AM GMT
One of my friends asked me if it is possible to export each table's data to each text file so that those files can be used in another system for data import? The point is he wanted to move database from SQL Server to Mysql. But there was not possible to have a connectivity between the two systems. He generated the script but exporting data was the problem. I suggested him to run this script that will take all userdefined table's data to each file where filename is the table name itself (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL, scripts, export data, SQLServer, export
4
Shouts
spam Shout it Mute it

Aggregate of an aggregate function in SSRS - Some Random Thoughts
published 1051 days, 5 hours, 43 minutes ago posted by jacobsebastianjacobsebastian 1051 days, 16 hours, 23 minutes ago
Friday, July 09, 2010 1:44:47 PM GMT Friday, July 09, 2010 3:05:26 AM GMT
I am worse than a child when it comes to colours and no wonder, spend a lot of time on the aesthetics whenever I am preparing an Excel sheet or a PowerPoint presentation. For me, this is rather a way to indulge the child within me than to make it more presentable to the audience. The joy that you get when you arrive on that perfect colour for your headers or that perfect font to suit the mood or that perfect design template for your slides is something that can’t be expressed. Recently, I was preparing t... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: Reporting, Tips and Tricks, SQLServer, SSRS
7
Shouts
spam Shout it Mute it

Using a UDF as a SARG. Make a hash of it! - Dave Ballantyne's Blog
published 1051 days, 5 hours, 43 minutes ago posted by jacobsebastianjacobsebastian 1052 days, 12 hours, 33 minutes ago
Friday, July 09, 2010 1:44:47 PM GMT Thursday, July 08, 2010 6:55:26 AM GMT
The evils and inadequacies of UDF (User Defined Functions) in SqlServer are well documented, but there is another scenario using UDF’s that will cause a lot of pain if not carefully controlled. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: UDF, TSQL, Performance, SQLServer, query plan
8
Shouts
spam Shout it Mute it

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery - Jacob's Blog
published 1052 days, 5 hours, 54 minutes ago posted by jacobsebastianjacobsebastian 1053 days, 11 hours, 6 minutes ago
Thursday, July 08, 2010 1:33:51 PM GMT Wednesday, July 07, 2010 8:22:00 AM GMT
This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: xquery, XML, TSQL, SQLServer
7
Shouts
spam Shout it Mute it

Resizing Pushpin in Bing Maps Silverlight - Dinesh's Blog
published 1053 days, 10 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1054 days, 10 hours, 9 minutes ago
Wednesday, July 07, 2010 9:14:00 AM GMT Tuesday, July 06, 2010 9:19:13 AM GMT
In my previous post I described how to add multiple locations on the Bing Map by fetching the data from a XML file. In this article I will describe how to resize the Pushpin and change the default color. (more)
category: Metro | clicked: 2 | comment | | source: beyondrelational.com
tags: Silverlight, dotnet, Bing Maps, maps
4
Shouts
spam Shout it Mute it

XQuery Lab 61 – Writing a Recursive CTE to process an XML document - Jacob's Blog
published 1057 days, 5 hours, 43 minutes ago posted by jacobsebastianjacobsebastian 1057 days, 11 hours, 29 minutes ago
Saturday, July 03, 2010 1:45:14 PM GMT Saturday, July 03, 2010 7:59:19 AM GMT
In this XQuery Lab, we will see how to write a recursive CTE to process all the elements and attributes of an XML Document. In XQuery Lab 39, we saw an example that generated the fully qualified path to all the elements and attributes of an XML document using OPENXML(). In this lab, let us look at a new version of the same code using XQuery (instead of OPENXML). (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: xquery, XML, TSQL, SQLServer, xquery labs
6
Shouts
spam Shout it Mute it

Understanding Datetime column - Part IV - Madhivanan's TSQL Blog
posted by jacobsebastianjacobsebastian 1058 days, 14 hours, 20 minutes ago
Friday, July 02, 2010 5:08:11 AM GMT
This post provides a number of best practices for working with DATETIME data types in SQL Server. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: DateTime, data types, TSQL, SQLServer
8
Shouts
spam Shout it Mute it

Bing Maps Binding XML Data Source - Dinesh's Blog
published 1060 days, 6 hours, 50 minutes ago posted by jacobsebastianjacobsebastian 1060 days, 16 hours, 3 minutes ago
Wednesday, June 30, 2010 12:37:34 PM GMT Wednesday, June 30, 2010 3:24:31 AM GMT
In my previous post I described how to create a simple Silver Light Application to show the Bing Map and add one location on the map.In this article I will step through the process to add multiple locations on the Bing Map by fetching the data from a XML file (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: Silverlight, Map Control, Bing Maps, map, SQLServer, ASP.NET, Geospatial
5
Shouts
spam Shout it Mute it

SSAS Dimension Attribute Properties : Part 2 - Some Random Thoughts
posted by jacobsebastianjacobsebastian 1061 days, 15 hours, 56 minutes ago
Tuesday, June 29, 2010 3:31:28 AM GMT
In SSAS Dimension Attribute Properties : Part 1, we reviewed the Advanced and Basic properties of dimension attributes. This article would be continuing with the Misc, Parent-Child and Source properties. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: data warehouse, SSAS, Business intelligence, SQLServer
8
Shouts
spam Shout it Mute it

XQuery Lab 60 – Executing dynamic query strings with OPENXML() - Jacob's Blog
published 1062 days, 7 hours, 20 minutes ago posted by jacobsebastianjacobsebastian 1062 days, 16 hours, 14 minutes ago
Monday, June 28, 2010 12:07:55 PM GMT Monday, June 28, 2010 3:14:03 AM GMT
This installment of XQuery Lab shows how to execute dynamic queries that contain OPENXML() calls. We will see examples that use EXEC() and sp_executesql. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: xquery, OpenXML, XML, TSQL, SQLServer
Previous 1 2 3 4 5 6 7 Next