jacobsebastian

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

Last_Value function in Denali CTP 3
published 617 days, 12 hours, 16 minutes ago posted by dharadhara 618 days, 9 hours, 44 minutes ago
Tuesday, September 13, 2011 7:44:49 AM GMT Monday, September 12, 2011 10:17:02 AM GMT
LastValue Purpose: Returns the last value from the order set of values. Syntax: LastValue(expression) over( [ PartitionByclause] order by clause [rowsrangeclause]) Where, Expression => A table column or built-in function but not analytical functions... (more)
category: Data | clicked: 1 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
7
Shouts
spam Shout it Mute it

WCF # 2 - Implementation Of a Web Service (Writing/Implementing a WCF Service Entirely in Code)
published 617 days, 12 hours, 16 minutes ago posted by dharadhara 618 days, 9 hours, 43 minutes ago
Tuesday, September 13, 2011 7:44:49 AM GMT Monday, September 12, 2011 10:17:35 AM GMT
Hello Geeks, In this article we will see how to implement a simple Web Service using WCF. This section describes how to implement a simple service with WCF. By simple, we’ll assume HTTP as the wire protocol, and we’ll assume a text based representation... (more)
category: Data | clicked: 19 | 2 comments | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
6
Shouts
spam Shout it Mute it

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 621 days, 11 hours, 48 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Friday, September 09, 2011 8:12:13 AM GMT
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. (more)
category: Data | clicked: 10 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Chart Helpers in ASP.NET MVC3
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 621 days, 11 hours, 49 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Friday, September 09, 2011 8:11:24 AM GMT
I am exploring ASP.NET MVC3 and everyday I am learning something new. In today’s post I am going to explain how we can create chart with ASP.NET MVC3. Chart is one of greatest way of expressing figures. We all need that functionality in any commercial... (more)
category: Web Dev | clicked: 34 | 1 comment | | source: beyondrelational.com
tags: ASP.NET MVC, ASP .NET
6
Shouts
spam Shout it Mute it

Lag function in Denali CTP 3
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 621 days, 11 hours, 50 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Friday, September 09, 2011 8:10:38 AM GMT
Lag Function Purpose: This function returns result set starting from the previous row in the table. Syntax: Lag(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)
category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
7
Shouts
spam Shout it Mute it

What is the architecture of WPF?
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 622 days, 11 hours, 13 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:47:42 AM GMT
WPF has Presentation Framework, Presentation Core & Composition Engine (MIL). Each one sit on the top of the other in the following order 1. Composition Engine 2. Presentation Core & 3. Presentation Framework WPF uses 3D pipeline to render everything... (more)
category: Web Dev | clicked: 23 | 2 comments | | source: beyondrelational.com
tags: .NET, WPF, ASP.NET
6
Shouts
spam Shout it Mute it

Logging off disconnected users
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 622 days, 11 hours, 14 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:41 AM GMT
And now for something completely different… As it is essential for a DBA to know his/her way around in server administration, let’s think of something else for a minute. If your IT department consists of more than 2 people, you most likely... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, RDP
6
Shouts
spam Shout it Mute it

Lead function in Denali CTP 3
published 620 days, 10 hours, 30 minutes ago posted by dharadhara 622 days, 11 hours, 15 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:12 AM GMT
Lead Function Purpose: This function returns result set starting from the next row in the table. Syntax: Lead(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)
category: Data | clicked: 19 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali
8
Shouts
spam Shout it Mute it

ILSpy-Alternative of .NET Reflector
published 622 days, 12 hours, 49 minutes ago posted by dharadhara 623 days, 10 hours, 10 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:50:45 AM GMT
Sometimes we need to have decomposer tool or reflector tool for our applications to improve the performance or to know the internals of the assembly we have created. I was using Red Gate .NET Reflector earlier for same as it was free. Now Red Gate has... (more)
category: Web Dev | clicked: 49 | 2 comments | | source: beyondrelational.com
tags: .NET
6
Shouts
spam Shout it Mute it

MSBI # 26 – SSIS # 13 – Control Flow Tasks # 8 – ActiveX Script Task
published 622 days, 12 hours, 49 minutes ago posted by dharadhara 623 days, 10 hours, 9 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:17 AM GMT
Hi all , First a fall if you are rally interested in Active-X script task then only read this article ,Because it has not been use now a days !! Its has been used in 2000 its decade now still I feel like having post on same. All we use is script... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSIS
6
Shouts
spam Shout it Mute it

BCP & large BULK operations made faster – switch between FULL & BULK-LOGGED recovery models
published 622 days, 12 hours, 49 minutes ago posted by dharadhara 623 days, 10 hours, 9 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:49 AM GMT
Recently, a friend told me that they were experiencing performance issues in production when importing data from 3rd party interfaces at the end of the day. The entire import was done via BCP and at a time when no users were logged into the system. Also... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Over clause enhancement in Sql 11 Denali CTP 3
published 622 days, 12 hours, 49 minutes ago posted by kinj312kinj312 624 days, 9 hours, 37 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:23:30 AM GMT
In Denali CTP 3, the Over clause has been enhanced a lot. Let us look into them as below a.Rows and Range These keywords specifies that the function will be applied for every row a window use for calculating the function result. The Rows specifies the... (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
7
Shouts
spam Shout it Mute it

Steps to write a plugin based application with MEF
published 622 days, 12 hours, 49 minutes ago posted by kinj312kinj312 624 days, 9 hours, 38 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:22:47 AM GMT
I have already written a blog on Managed Extensibility Framework few days ago, and you must wonder why I am writing again. Well actually today I have been creating an application that could be easily plugged into a host application. In this blog lets... (more)
category: Web Dev | clicked: 30 | 1 comment | | source: beyondrelational.com
tags: .NET, C#
6
Shouts
spam Shout it Mute it

SSIS #100 – An SSIS package without Sequence Container?
published 622 days, 12 hours, 49 minutes ago posted by kinj312kinj312 624 days, 9 hours, 38 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:22:23 AM GMT
I recently needed to modify an SSIS package to add a few new columns to a table. But I turned out that I had more than just adding columns to do. I did three things prior to adding the columns: I added three Sequence Containers as part of the Control... (more)
category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
6
Shouts
spam Shout it Mute it

New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3
published 624 days, 13 hours, 35 minutes ago posted by dharadhara 625 days, 12 hours, 18 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:43:01 AM GMT
New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3 In Denali CTP 3, we have three new functions in the expression language viz. Left , Token and TokenCount so far SSIS is concern Let us analyze these functions one by one Left... (more)
category: Data | clicked: 9 | 6 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, CTP
6
Shouts
spam Shout it Mute it

SSIS #98 – IsSorted is true, but sorted on what?
published 624 days, 13 hours, 35 minutes ago posted by dharadhara 625 days, 12 hours, 18 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:36 AM GMT
In my previous post, SSIS #97 – When MERGE JOIN is your friend? , I showed you a scenario where Merge Join can be you real friend in your ETL work. I also showed you two ways to satisfy the sorting requirement by the Merge Join task. One of the... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, BI
6
Shouts
spam Shout it Mute it

Index Disabled and Index Rebuild
published 624 days, 13 hours, 35 minutes ago posted by dharadhara 625 days, 12 hours, 19 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:10 AM GMT
I received the following message from a Developer. The message was on a Test SQL Server. “NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online . The cause... (more)
category: Data | clicked: 36 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

SQL Server 2008 Service Pack 3 CTP is available for testing!
published 624 days, 13 hours, 35 minutes ago posted by kinj312kinj312 627 days, 11 hours ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:53 AM GMT
There is no doubt that Microsoft is keeping the DBAs busy with the frequent releases of Cumulative Update packages and CTP releases on existing (2008, 2008 R2 and Denali) versions! Now here is the news about SQL Server 2008 Service Pack 3 CTP release... (more)
category: Data | clicked: 8 | 3 comments | | source: beyondrelational.com
tags: SQL Server, CTP
7
Shouts
spam Shout it Mute it

SQL Server Configuration Manager - Hide your SQL Server Instance
published 624 days, 13 hours, 35 minutes ago posted by kinj312kinj312 627 days, 11 hours, 1 minute ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 8:59:50 AM GMT
Data is one of the most critical and valuable components for any industry and it’s protection is every individual’s responsibility. Data lives within Microsoft SQL Server, and therefore, it is the duty of DBAs to ensure that their SQL Server is safe from... (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Correctness and stress test
published 624 days, 13 hours, 35 minutes ago posted by kinj312kinj312 627 days, 11 hours ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:17 AM GMT
Stress test SQL Server for new hardware. Download SQLIOSim from http://download.microsoft.com and install on server. When detailing the file location, use the same as the SQL Server files. SQLIOSim will attempt to simulate the SQL Server database IO path... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
Previous 1 2 ... 12 13 14 15 16 17 18 19 20 21 ... 55 56 Next