jacobsebastian

jacobsebastian
Name: jacobsebastian
Score: 4,772.5
Last Seen: 415 days, 1 hour, 37 minutes ago
Member Since: 6 April, 2010
DotNetShoutout
atom rss
9
Shouts
spam Shout it Mute it

How to load a huge file into a FILESTREAM column quickly - Jacob's Blog
published 1015 days, 15 hours, 27 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 2 hours, 7 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 1016 days, 19 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 19 hours, 58 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 1018 days, 2 hours, 53 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
11
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters - TSQL Challenges for Beginners
published 1017 days, 15 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1019 days, 2 hours ago
Monday, August 09, 2010 2:32:49 PM GMT Sunday, August 08, 2010 3:46:26 AM GMT
The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E" (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: Puzzle, TSQL, SQLServer, challenge
12
Shouts
spam Shout it Mute it

What is Silverlight - Dinesh's Blog
published 1019 days, 15 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1019 days, 22 hours, 51 minutes ago
Saturday, August 07, 2010 2:32:10 PM GMT Saturday, August 07, 2010 6:55:03 AM GMT
This article explains what Silverlight is and how it fits into the web spectrum and in Building Business Applications. It demonstrates the programming model for Silverlight and will be very helpful for the beginners as well as people who already has started working with silverlight. (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: Silverlight
12
Shouts
spam Shout it Mute it

LINQ to SQL Query Operators Part II - Imran's Blog
published 1019 days, 15 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1020 days, 17 hours, 32 minutes ago
Saturday, August 07, 2010 2:32:10 PM GMT Friday, August 06, 2010 12:14:13 PM GMT
This installment of the LINQ tutorial series explains how to perform grouping on data and perform set operations and joins in a LINQ query (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: dotnet, C#, joins, Linq, grouping
14
Shouts
spam Shout it Mute it

LINQ to SQL Query Operators Part I - Imran's Blog
published 1018 days, 10 hours, 10 minutes ago posted by jacobsebastianjacobsebastian 1021 days, 3 hours, 10 minutes ago
Sunday, August 08, 2010 7:36:48 PM GMT Friday, August 06, 2010 2:36:21 AM GMT
LINQ stands for Language Integrated Query which was introduced in .Net Framework 3.5. This post helps you to explore the basics of LINQ and help you to get started with LINQ programming. (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: language integrated query, C#, Linq
10
Shouts
spam Shout it Mute it

How to replace Machine Name with Domain name in WCF Service wsdl link?
published 1020 days, 17 hours, 54 minutes ago posted by jacobsebastianjacobsebastian 1021 days, 18 hours, 53 minutes ago
Friday, August 06, 2010 11:52:23 AM GMT Thursday, August 05, 2010 10:53:18 AM GMT
This post explains how to replace Machine Name with Domain name in WCF Service wsdl link, which is a very common problem that most people face when getting started with WCF services (more)
category: Web Dev | clicked: 8 | comment | | source: beyondrelational.com
tags: dotnet, Web Services, wcf services, WCF
11
Shouts
spam Shout it Mute it

SQL Server - How to move database transaction log files in a Log Shipping environment? - David's Blog
published 1020 days, 17 hours, 54 minutes ago posted by jacobsebastianjacobsebastian 1022 days, 2 hours, 37 minutes ago
Friday, August 06, 2010 11:52:23 AM GMT Thursday, August 05, 2010 3:09:10 AM GMT
Sometimes, it is necessary for a database administrator to move database transaction log files. Moving files on a normal environment is pretty straightforward but with log-shipping the operation can be slighty more complicated (more)
category: Data | clicked: 0 | 1 comment | | source: beyondrelational.com
tags: DBA, log shipping, TSQL, SQLServer
9
Shouts
spam Shout it Mute it

SQL Server App_name() function - find out which application has modified your data - Madhivanan's TSQL Blog
posted by jacobsebastianjacobsebastian 1022 days, 18 hours, 9 minutes ago
Wednesday, August 04, 2010 11:37:29 AM GMT
This post explains how to use the App_name() function to identify the client application that makes modifications to your data (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: app_name(), TSQL, SQLServer
9
Shouts
spam Shout it Mute it

Backup of a FILESTREAM database may include garbage files as well - Jacob's Blog
published 1022 days, 18 hours, 7 minutes ago posted by jacobsebastianjacobsebastian 1023 days, 3 hours, 8 minutes ago
Wednesday, August 04, 2010 11:39:56 AM GMT Wednesday, August 04, 2010 2:38:11 AM GMT
This post is based on the observation that the backup of a FILESTREAM database includes garbage files as well. The repro example given in this post demonstrates that (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: backup, SQLServer, FILESTREAM
11
Shouts
spam Shout it Mute it

Adding Pushpin on Bing Map in Silverlight
published 1021 days, 20 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 1023 days, 18 hours, 28 minutes ago
Thursday, August 05, 2010 9:37:51 AM GMT Tuesday, August 03, 2010 11:18:38 AM GMT
This article shows how to add multiple pushpins on the Bing Map in Silverlight in c-sharp. (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: Silverlight, Bing Maps, Bing, ASP.NET
8
Shouts
spam Shout it Mute it

SQL Server - Count(*) or Count(1) ? - Which is better? - Dave Ballantyne's Blog
published 1023 days, 17 hours, 27 minutes ago posted by jacobsebastianjacobsebastian 1024 days, 2 hours, 35 minutes ago
Tuesday, August 03, 2010 12:19:31 PM GMT Tuesday, August 03, 2010 3:11:54 AM GMT
This post explains the differences between COUNT(*) and COUNT(1) and helps you to decide which one is better (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL, SQL, Performance, SQLServer, Database
7
Shouts
spam Shout it Mute it

TSQL Challenge 35 - Find the total number of 'Full Attendees' in each 24 HOP Session
posted by jacobsebastianjacobsebastian 1024 days, 17 hours, 47 minutes ago
Monday, August 02, 2010 11:59:17 AM GMT
The recent 24-hours-of-pass or more widely known as #24HOP on twitter and other social media was one of the most exciting SQL Server events that happened recently. For this challenge, we created some (fake) attendance data for this event. Your task is to count the number of attendees who watched the complete presentation of each speaker. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: tsql challenges, TSQL, puzzles, SQLServer
8
Shouts
spam Shout it Mute it

Time Zone Awareness For Global Organization
published 1024 days, 18 hours ago posted by jacobsebastianjacobsebastian 1024 days, 23 hours, 39 minutes ago
Monday, August 02, 2010 11:46:52 AM GMT Monday, August 02, 2010 6:07:23 AM GMT
This article explains the importance of time zone calculations for global organizations and introduces the time-zone aware data types and functions in SQL Server (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: timezone, SQLServer
10
Shouts
spam Shout it Mute it

SQL Server - Difference between TSQL Functions CAST() and CONVERT() - Madhivanan's TSQL Blog
published 1024 days, 18 hours ago posted by jacobsebastianjacobsebastian 1025 days, 23 hours, 52 minutes ago
Monday, August 02, 2010 11:46:52 AM GMT Sunday, August 01, 2010 5:54:56 AM GMT
This post explains the differences between TSQL functions CAST() and CONVERT(). Though they seem identical, there are several differences between these functions. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: Convert, TSQL, Cast, SQLServer
8
Shouts
spam Shout it Mute it

SQL Server - Server-side paging with Row_number() function - Jacob's Blog
published 1025 days, 15 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 1027 days, 1 hour, 58 minutes ago
Sunday, August 01, 2010 2:32:30 PM GMT Saturday, July 31, 2010 3:48:16 AM GMT
If you are a programmer working with SQL Server, you must have found it little embarrassing to display information which spans across multiple pages (web pages). SQL Server 2000 did not allow you to retrieve a specific range of records, say, records 51 to 100 ordered by a certain column. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL, SQLServer, server side paging
7
Shouts
spam Shout it Mute it

An Examination of ClientIDMode in ASP.NET4 - Hima's blog
published 1035 days, 14 hours, 49 minutes ago posted by himanethimanet 1036 days, 16 hours, 50 minutes ago
Thursday, July 22, 2010 2:57:55 PM GMT Wednesday, July 21, 2010 12:56:37 PM GMT
ClientIdMode implementation in ASP.NET4 (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: ASP.NET4, Clientidmode
9
Shouts
spam Shout it Mute it

How to access a newly installed SQL Server 2008 R2 instance if you do not know the login and password
published 1026 days, 17 hours, 30 minutes ago posted by jacobsebastianjacobsebastian 1027 days, 23 hours, 57 minutes ago
Saturday, July 31, 2010 12:16:00 PM GMT Friday, July 30, 2010 5:49:32 AM GMT
This post shows a work around to access a newly installed SQL Server 2008 R2 instance in case you forgot/lost the login name and password (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: Security, DBA, SQLServer, workaround
9
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 12 - Find the available registration dates
published 1028 days, 15 hours, 38 minutes ago posted by jacobsebastianjacobsebastian 1028 days, 21 hours, 22 minutes ago
Thursday, July 29, 2010 2:08:31 PM GMT Thursday, July 29, 2010 8:24:27 AM GMT
This challenge involves finding available registration dates based on event schedules and registration data. Students can register for an event only for a specific period defined in "tblRegistration" table. Another table callled "tblEvent" stores the registration details which indicates the dates where a registration is made. Your job is to find the available dates where no event is registered. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: challenges, Puzzle, TSQL, SQLServer
Previous 1 2 ... 45 46 47 48 49 50 51 52 53 54 55 56 Next