jacobsebastian

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

SqlCeCmd tutorial part three – query options
published 991 days, 9 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 993 days, 18 hours, 20 minutes ago
Monday, September 06, 2010 2:06:01 PM GMT Saturday, September 04, 2010 4:54:48 AM GMT
This is the third part of a 3 part series with some examples of sqlcecmd usage. The first part is here and the second here. This third part deals with querying database objects and formatting query output. (In other words, running SELECT statements) (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: sqlserver compact, SQLServer, sqlserverce
7
Shouts
spam Shout it Mute it

Performing a Right Outer Join with a Left Outer Join clause - Some Random Thoughts
published 994 days, 1 hour, 43 minutes ago posted by jacobsebastianjacobsebastian 995 days, 10 hours, 47 minutes ago
Friday, September 03, 2010 9:31:22 PM GMT Thursday, September 02, 2010 12:27:41 PM GMT
Most of the interviewers I have seen tend to prefer people with better problem solving skills rather than better knowledge on a particular technology. No wonder considering the fact that technologies change with each fleeting moment, while a good problem solving mentality stays forever. With this prelude, I put forward this question that I came to hear from one of friends recently – How do you perform a right outer join with a left outer join clause? (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL
9
Shouts
spam Shout it Mute it

Using Let Keyword in Linq - DotNetJaps-SQL
published 994 days, 1 hour, 43 minutes ago posted by jacobsebastianjacobsebastian 995 days, 10 hours, 50 minutes ago
Friday, September 03, 2010 9:31:22 PM GMT Thursday, September 02, 2010 12:24:26 PM GMT
I am using Linq-To-Object in my current project to remove some extra loops and I have found one of the great keyword in Linq called ‘Let’. Let keyword provides facility to declare a temporary variable inside the Linq Query.We can assign the result of manipulation to temporary variable inside query and we can use that temporary variable to another manipulation. (more)
category: Data | clicked: 1 | 1 comment | | source: beyondrelational.com
tags: dotnet, Linq
8
Shouts
spam Shout it Mute it

Event Handling in Silverlight - Dinesh's Blog
published 995 days, 11 hours, 12 minutes ago posted by jacobsebastianjacobsebastian 995 days, 17 hours, 10 minutes ago
Thursday, September 02, 2010 12:02:39 PM GMT Thursday, September 02, 2010 6:05:00 AM GMT
In the previous article I described what are the different Layout Management Panels in Silverlight and how and when they are used. In this article I will try to describe how to add/manage events in Silverlight. (more)
category: Metro | clicked: 1 | 1 comment | | source: beyondrelational.com
tags: Silverlight, dotnet, error handling, ASP.NET
7
Shouts
spam Shout it Mute it

Select and SelectMany: LINQ projection operator - Debug Mode
published 995 days, 11 hours, 12 minutes ago posted by jacobsebastianjacobsebastian 995 days, 18 hours, 35 minutes ago
Thursday, September 02, 2010 12:02:39 PM GMT Thursday, September 02, 2010 4:39:40 AM GMT
Projection helps us developer to retrieve desired result from the collection . LINQ provides two projection operator. Select and SelectMany. Select works with one collection whereas SelectMany works with more than one collection. (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: dotnet, projection, Linq
10
Shouts
spam Shout it Mute it

Basic of C#: Call Stack, Call Site and Stack unwinding - Debug Mode
published 1003 days, 10 hours, 27 minutes ago posted by jacobsebastianjacobsebastian 1004 days, 8 hours, 53 minutes ago
Wednesday, August 25, 2010 12:47:59 PM GMT Tuesday, August 24, 2010 2:21:49 PM GMT
When we call a method in c# in a nested manner , there are three terms come into action. They are Call stack , Call Site and Stack unwinding This article is going to explain about that. (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: dotnet, C#, CSharp
8
Shouts
spam Shout it Mute it

SQL Server - Identifying identity columns using TSQL - Madhivanan's TSQL Blog
published 1003 days, 10 hours, 27 minutes ago posted by jacobsebastianjacobsebastian 1004 days, 18 hours, 34 minutes ago
Wednesday, August 25, 2010 12:47:59 PM GMT Tuesday, August 24, 2010 4:40:17 AM GMT
One of my friends asked me if it is possible to identify the tables with identiy columns as he wanted to run dbcc checkident command to all the tables of the database.There are actually many ways to identify identity columns from a table.The following three methods will list out the table names and the identity column name (if available) (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: TSQL, database design, SQLServer
7
Shouts
spam Shout it Mute it

SQL Server Performance Monitoring and Alerts using Quest SpotLight - SQL Server Tools In My Environment
published 1010 days, 8 hours, 42 minutes ago posted by jacobsebastianjacobsebastian 1010 days, 14 hours, 5 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Wednesday, August 18, 2010 9:09:13 AM GMT
Keeping a watch on the SQL Server instances, databases and ensuring their health is one of the fundamental responsibility of a DBA. In this post, Malathi Mahadeven explains how Quest SpotLight is used in her environment for SQL Server monitoring and alerting. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: Performance, SQLServer, Tools, Quest Software
13
Shouts
spam Shout it Mute it

Access a local SQL Compact database from Silverlight 4 - Blogs from the Experts
published 1009 days, 8 hours, 20 minutes ago posted by jacobsebastianjacobsebastian 1010 days, 21 hours, 30 minutes ago
Thursday, August 19, 2010 2:54:21 PM GMT Wednesday, August 18, 2010 1:44:42 AM GMT
In Silverlight 4, it is now possible for an elevated OOB application to access a local SQL Server Compact database. This post presents a walk-through that shows how to do this. (more)
category: Metro | clicked: 4 | comment | | source: beyondrelational.com
tags: Silverlight, SQL, sqlserver compact, Silverlight 4, ASP.NET
12
Shouts
spam Shout it Mute it

VS2010 Parallel Tasks - Debugging enhancement in VS2010 - Hima's blog
published 1011 days, 6 hours, 53 minutes ago posted by jacobsebastianjacobsebastian 1013 days, 16 hours, 24 minutes ago
Tuesday, August 17, 2010 4:21:41 PM GMT Sunday, August 15, 2010 6:50:43 AM GMT
VS2010 has new concept for Parallel Programming that is added as part of .NET Framework 4.0. This makes the ability to work in multi-core processor Environment. Digging through the code and debugging in parallel programming would definitely help. (more)
category: Web Dev | clicked: 0 | 2 comments | | source: beyondrelational.com
tags: VS, Debugging, Visual Studio 2010, paralle programming, Visual Studio
10
Shouts
spam Shout it Mute it

Getting started with ASP.NET Razor based app in WebMatrix - Blogs from the Experts
posted by jacobsebastianjacobsebastian 1015 days, 17 hours, 3 minutes ago
Friday, August 13, 2010 6:11:10 AM GMT
This post provides an introduction to ASP.NET Razor and Web Matrix and provides a walk through that helps you to build your first ASP.NET Razor based application using Web Matrix (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: dotnet, Web matrix, ASP.NET Razor, ASP.NET
13
Shouts
spam Shout it Mute it

Tips and Tricks for Error Handling in ASP.NET Web Applications - Jacob's Blog
published 1014 days, 9 hours, 27 minutes ago posted by jacobsebastianjacobsebastian 1016 days, 14 hours ago
Saturday, August 14, 2010 1:48:04 PM GMT Thursday, August 12, 2010 9:14:56 AM GMT
This post highlights some of the most common Error Handling techniques in ASP.NET Web Applications.. (more)
category: Web Dev | clicked: 22 | comment | | source: beyondrelational.com
tags: .NET, internet, error handling, ASP.NET
10
Shouts
spam Shout it Mute it

SQL Server FILESTREAM feature and Differential Backups - Jacob's Blog
published 1016 days, 11 hours, 10 minutes ago posted by jacobsebastianjacobsebastian 1016 days, 19 hours, 45 minutes ago
Thursday, August 12, 2010 12:04:44 PM GMT Thursday, August 12, 2010 3:29:22 AM GMT
This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore them correctly when a differential backup is restored. (more)
category: Data | clicked: 9 | 2 comments | | source: beyondrelational.com
tags: Databases, internet, DBA, TSQL, Microsoft, SQLServer, Technology, FILESTREAM
10
Shouts
spam Shout it Mute it

SQL Server - Quick and Easy auditing using host_name() and user_name() functions - Madhivanan's TSQL Blog
published 1016 days, 11 hours, 10 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 11 hours, 4 minutes ago
Thursday, August 12, 2010 12:04:44 PM GMT Wednesday, August 11, 2010 12:11:04 PM GMT
This post demonstrates a few quick and easy methods to audit the data modifications on your SQL Server Database using the hostname() and username() system functions. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, Databases, internet, DBA, user_name, host_name, TSQL, Microsoft
7
Shouts
spam Shout it Mute it

Getting started with PIVOT Queries in SQL Server 2005/2008 - Jacob's Blog
published 1017 days, 8 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 20 hours, 52 minutes ago
Wednesday, August 11, 2010 2:19:45 PM GMT Wednesday, August 11, 2010 2:22:18 AM GMT
This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the pas (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Databases, internet, TSQL, pivot, Microsoft, Cross Tab
6
Shouts
spam Shout it Mute it

Manage Kerberos Authentication Issues in a Reporting Services Environment - SQL Server White Papers
published 1017 days, 8 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 21 hours ago
Wednesday, August 11, 2010 2:19:45 PM GMT Wednesday, August 11, 2010 2:14:30 AM GMT
This article describes how to configure and troubleshoot a Reporting Services service environment to use Kerberos authentication with full delegation. (more)
category: Data | clicked: 0 | 1 comment | | source: beyondrelational.com
tags: Best Practices, Whitepaper, SQLServer, analysis services
10
Shouts
spam Shout it Mute it

Binding A Custom Entity Class to stored procedure using Linq-To-SQL - DotNetJaps-SQL
published 1017 days, 8 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 1018 days, 13 hours, 34 minutes ago
Wednesday, August 11, 2010 2:19:45 PM GMT Tuesday, August 10, 2010 9:40:12 AM GMT
The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: Linq To SQL, dotnet, Linq
9
Shouts
spam Shout it Mute it

How to load a huge file into a FILESTREAM column quickly - Jacob's Blog
published 1017 days, 8 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 1018 days, 19 hours, 35 minutes ago
Wednesday, August 11, 2010 2:19:45 PM GMT Tuesday, August 10, 2010 3:39:57 AM GMT
This post shows a quick and dirty way of loading a huge file into the FILESTREAM column of a SQL Server 2008 database instance. (more)
category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com
tags: DBA, TSQL, SQLServer, FILESTREAM
10
Shouts
spam Shout it Mute it

Interesting enhancements to the VALUES Clause in SQL Server 2008 - Madhivanan's TSQL Blog
published 1018 days, 12 hours, 42 minutes ago posted by jacobsebastianjacobsebastian 1019 days, 13 hours, 27 minutes ago
Tuesday, August 10, 2010 10:32:44 AM GMT Monday, August 09, 2010 9:48:00 AM GMT
With SQL Server 2008, you can do many more interesting things using VALUES clause than the previous versions.The following examples will explain it's various usages in detail (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL, SqlServer 2008, SQLServer
9
Shouts
spam Shout it Mute it

SQL Server Performance Monitoring with Quest Performance Analysis
posted by jacobsebastianjacobsebastian 1019 days, 20 hours, 21 minutes ago
Monday, August 09, 2010 2:53:22 AM GMT
We often have to provide back dated reports on performance or troubleshoot performance issues that happened sometime ago when they come to light by developers or other concerned people. We also have to give comparative performance reports on server performance... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: sqlserver performance, SQLServer Tools, Performance, SQLServer, performance monitoring
Previous 1 2 3 4 5 6 7 Next