jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 413 days, 21 hours, 54 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
9
Shouts
spam Shout it Mute it

TSQL InitCap function - Madhivanan's TSQL Blog
published 1028 days, 12 hours, 57 minutes ago posted by jacobsebastianjacobsebastian 1028 days, 19 hours, 6 minutes ago
Wednesday, July 28, 2010 1:05:43 PM GMT Wednesday, July 28, 2010 6:56:53 AM GMT
This post presents a TSQL function that can be used to convert a string to Proper Case. (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: proper case, initcap, TSQL, functions
6
Shouts
spam Shout it Mute it

How to get multiple result set of procedure using LINQ to SQL - Imran's Blog
posted by jacobsebastianjacobsebastian 1029 days, 20 hours, 56 minutes ago
Tuesday, July 27, 2010 5:07:11 AM GMT
There always be case where one procedure returns more then one result set. Getting those data in DataSet is lazy way of coding, best way to do that is using DataReader . DataReader having method call NextResult which allows us to read next result set (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: dotnet, MULTIPLE RESULT SETS, Linq, ASP.NET
5
Shouts
spam Shout it Mute it

All about Client ID Mode in ASP.NET 4 - Hima's blog
published 1039 days, 11 hours, 16 minutes ago posted by himanethimanet 1040 days, 10 hours, 8 minutes ago
Saturday, July 17, 2010 2:46:38 PM GMT Friday, July 16, 2010 3:55:22 PM GMT
This posts explains all about ClientIDMode in ASP.NET (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: ASP.NET4, Clientidmode
9
Shouts
spam Shout it Mute it

How to add method in Sealed class - Imran's Blog
posted by jacobsebastianjacobsebastian 1030 days, 18 hours, 43 minutes ago
Monday, July 26, 2010 7:19:55 AM GMT
This post explains how to add a method to a Sealed Class using Extension Methods (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: Extension Methods, dotnet, Sealed Class, C#, C#.NET, C# 3.0
7
Shouts
spam Shout it Mute it

Bing Map Binding With SQL Server Database - Dinesh's Blog
published 1033 days, 12 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1033 days, 19 hours, 37 minutes ago
Friday, July 23, 2010 1:58:46 PM GMT Friday, July 23, 2010 6:25:35 AM GMT
This post explains how to create applications that wants to display information stored in a SQL Server database on Bing Maps. (more)
category: Metro | clicked: 9 | comment | | source: beyondrelational.com
tags: Silverlight, WCF Service, Bing Maps, Bing, SQLServer
7
Shouts
spam Shout it Mute it

Support for Paging Queries in SQL Server CE 4.0 - Jacob's Blog
published 1034 days, 11 hours, 5 minutes ago posted by jacobsebastianjacobsebastian 1034 days, 21 hours, 8 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 1033 days, 12 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1035 days, 13 hours, 41 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 1035 days, 10 hours, 39 minutes ago posted by jacobsebastianjacobsebastian 1035 days, 22 hours, 43 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 1036 days, 7 hours, 20 minutes ago posted by jacobsebastianjacobsebastian 1036 days, 22 hours, 55 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 1037 days, 15 hours, 39 minutes ago posted by jacobsebastianjacobsebastian 1037 days, 20 hours, 9 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 1040 days, 13 hours, 28 minutes ago posted by jacobsebastianjacobsebastian 1040 days, 22 hours, 39 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 1040 days, 13 hours, 28 minutes ago posted by jacobsebastianjacobsebastian 1041 days, 18 hours, 27 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 1042 days, 10 hours, 43 minutes ago posted by jacobsebastianjacobsebastian 1042 days, 20 hours, 11 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 1043 days, 21 hours, 40 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 1044 days, 18 hours, 35 minutes 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
7
Shouts
spam Shout it Mute it

The Self Join – Inner Join and Outer Join - An Example
published 1046 days, 12 hours, 14 minutes ago posted by pinaldavepinaldave 1046 days, 19 hours ago
Saturday, July 10, 2010 1:48:36 PM GMT Saturday, July 10, 2010 7:03:07 AM GMT
Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
8
Shouts
spam Shout it Mute it

Export all table data to Text file - Madhivanan's TSQL Blog
published 1046 days, 12 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1046 days, 20 hours, 41 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 1047 days, 12 hours, 18 minutes ago posted by jacobsebastianjacobsebastian 1047 days, 22 hours, 58 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 1047 days, 12 hours, 18 minutes ago posted by jacobsebastianjacobsebastian 1048 days, 19 hours, 8 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 1048 days, 12 hours, 29 minutes ago posted by jacobsebastianjacobsebastian 1049 days, 17 hours, 41 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
Previous 1 2 ... 46 47 48 49 50 51 52 53 54 55 56 Next