jacobsebastian

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

Heat Map Control in WPF
published 604 days, 16 hours, 21 minutes ago posted by dharadhara 607 days, 23 hours, 43 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Tuesday, September 20, 2011 8:00:00 AM GMT
In this short article we will look into how to make a Heat Map control in WPF What is Heat Map? A heat map is a graphical representation of data where the values taken by a variable in a two-dimensional table are represented as colors(Adopted from Wikipedia... (more)
category: Web Dev | clicked: 100 | 2 comments | | source: beyondrelational.com
tags: .NET, WPF, ASP.NET
7
Shouts
spam Shout it Mute it

Thinking about taking a contract position? Questions to ask
published 604 days, 16 hours, 21 minutes ago posted by dharadhara 607 days, 23 hours, 44 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Tuesday, September 20, 2011 7:59:23 AM GMT
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position (W2 or 1099) that I am looking at taking. Many of these questions will also apply if you are thinking about working as a salaried employee... (more)
category: Data | clicked: 16 | 2 comments | | source: beyondrelational.com
tags: SQL Server
11
Shouts
spam Shout it Mute it

SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction « Journey to SQLAuthority
published 600 days, 16 hours, 7 minutes ago posted by pinaldavepinaldave 608 days, 40 minutes ago
Tuesday, September 27, 2011 3:36:42 PM GMT Tuesday, September 20, 2011 7:02:43 AM GMT
In SQL Server Denali, seven new datetime functions have been introduced, namely,DATEFROMPARTS (year, month, day)DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision)DATETIMEFROMPARTS (year, month, day, hour, minute, seconds, milliseconds)DATETIMEOFFSETFROMPARTS (year, month, day, hour, minute, seconds, fractions, houroffset, minuteoffset, precision)SMALLDATETIMEFROMPARTS (year, month, day, hour, minute)TIMEFROMPARTS (hour, minute, seconds, fractions, precision)EOMONTH (star... (more)
category: Data | clicked: 48 | 10 comments | | source: blog.sqlauthority.com
6
Shouts
spam Shout it Mute it

Post a message in Twitter using TwitSharp
published 600 days, 16 hours, 7 minutes ago posted by dharadhara 608 days, 20 hours, 33 minutes ago
Tuesday, September 27, 2011 3:36:42 PM GMT Monday, September 19, 2011 11:10:39 AM GMT
In this short article we will look into how can we post a message/twit in Twitter application Before going to do any programming, first we need to create an application in Twitter. We will follow the below steps for doing so. Steps to create an application... (more)
category: Web Dev | clicked: 30 | 15 comments | | source: beyondrelational.com
tags: .NET, ASP.NET
7
Shouts
spam Shout it Mute it

How to Use Microsoft Access to Create Logins in a SQL Azure Database
published 600 days, 16 hours, 7 minutes ago posted by dharadhara 608 days, 20 hours, 33 minutes ago
Tuesday, September 27, 2011 3:36:42 PM GMT Monday, September 19, 2011 11:09:57 AM GMT
In this article we will demonstrate how you can use a Pass-through query in Access with VBA code to create SQL Azure Logins. Microsoft Access can then use the Login and Password to gain access to SQL Azure Tables, Views, and Stored Procedures. We will... (more)
category: Data | clicked: 11 | 18 comments | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Database
7
Shouts
spam Shout it Mute it

New LOGICAL functions in SQL Server Denali
published 600 days, 16 hours, 7 minutes ago posted by dharadhara 608 days, 20 hours, 34 minutes ago
Tuesday, September 27, 2011 3:36:42 PM GMT Monday, September 19, 2011 11:09:29 AM GMT
IFF Function If you are an old Access or Excel “developer” you know this one. This is not a function I have been missing before I read about it today. If you, like me, is so tired of writing CASE statements with only 2 possible outcoms... (more)
category: Data | clicked: 14 | 15 comments | | source: beyondrelational.com
tags: SQL Server, denali
8
Shouts
spam Shout it Mute it

System Center and Visual Studio Team Foundation Server 2010
published 604 days, 16 hours, 21 minutes ago posted by dharadhara 611 days, 23 hours, 33 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Friday, September 16, 2011 8:10:22 AM GMT
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new connector between System Center and Visual Studio Team Foundation Server (TFS) 2010 that helps the coordination between... (more)
category: Web Dev | clicked: 41 | 16 comments | | source: beyondrelational.com
tags: Visual Studio
9
Shouts
spam Shout it Mute it

Conversation between Databases in SQL Server - Service Broker
published 604 days, 16 hours, 21 minutes ago posted by dharadhara 611 days, 23 hours, 33 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Friday, September 16, 2011 8:09:47 AM GMT
Recently I have posted for Service Broker for single database in which i have explained it with table history example and it was invoked within trigger. It was a for single database, here i will explain service broker for between databases. In earlier... (more)
category: Data | clicked: 27 | 15 comments | | source: beyondrelational.com
tags: SQL Server
8
Shouts
spam Shout it Mute it

Percentile_Disc Function in Denali CTP3
published 604 days, 16 hours, 21 minutes ago posted by dharadhara 611 days, 23 hours, 34 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Friday, September 16, 2011 8:09:28 AM GMT
Percentile_Disc Function Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an element from the set.It accepts any numeric datatype or any nonnumeric datatype that can be implicitly converted... (more)
category: Data | clicked: 5 | 13 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
8
Shouts
spam Shout it Mute it

Prefixing procedure names with sp_ is bad practice. Is this true?
published 604 days, 16 hours, 21 minutes ago posted by kinj312kinj312 613 days, 50 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:53:36 AM GMT
Yes but partly. Let us explore this with examples We have a system procedure spwho that returns the informations about the current connections, users, sessions etc. Let us create a new database named test and create spwho inside it. Case 1 Create database... (more)
category: Data | clicked: 29 | 15 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

TSQL Challenge 64 - A Payroll calculation Challenge
published 604 days, 16 hours, 21 minutes ago posted by kinj312kinj312 613 days, 50 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:52:43 AM GMT
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays. (more)
category: Data | clicked: 16 | 13 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
8
Shouts
spam Shout it Mute it

SQL Server Myth - Table Name cannot be same as Database Name
published 604 days, 16 hours, 21 minutes ago posted by kinj312kinj312 613 days, 50 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:53:04 AM GMT
Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such myth... (more)
category: Data | clicked: 7 | 13 comments | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

MSBI # 29 – SSIS # 14 – Mentalist Link Book # 1–SSIS link book–Set of 101 useful link for SSIS - Vishal Pawar's Blog
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 614 days, 51 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Wednesday, September 14, 2011 6:52:20 AM GMT
Hi folks, As Beyond Relational and Jocob has given me lot of opportunity to express my views its my time to give them at lest something. Today I just collect my various links which I have been locally storing from last few months. This links I have been... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, SSIS, BI
7
Shouts
spam Shout it Mute it

DB2 process model
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 614 days, 52 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Wednesday, September 14, 2011 6:51:19 AM GMT
There’s a good article on http://www.ibm.com/developerworks/data/library/techarticle/dm-0807kharche/ outlining the DB2 9.5 process model. Key Points New memory model Increased automatic configurations. According to the article, less is required... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

Percentile_Cont Function in Denali CTP3
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 614 days, 52 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Wednesday, September 14, 2011 6:50:59 AM GMT
Percentile_Cont Function Purpose: An inverse distribution function which takes a percentile value and a sort specification and returns an interpolated value that would fall into that percentile value with respect to the sort specification.It accepts any... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
9
Shouts
spam Shout it Mute it

SQL Server Denali – FORMAT() string function
published 608 days, 13 hours, 9 minutes ago posted by dharadhara 614 days, 20 hours, 43 minutes ago
Monday, September 19, 2011 6:34:23 PM GMT Tuesday, September 13, 2011 11:00:33 AM GMT
SQL Server Denali brings us new string function, FORMAT function. It will make formatting of date/time and number values easier. Syntax: FORMAT (value, format [,culture]) Formatting Date/Time Let’s see how it works: DECLARE @a datetime = getdate... (more)
category: Data | clicked: 11 | 15 comments | | source: beyondrelational.com
tags: SQL Server, denali
8
Shouts
spam Shout it Mute it

Percent_Rank function in Denali CTP 3
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 614 days, 20 hours, 43 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Tuesday, September 13, 2011 11:00:12 AM GMT
PercentRank Function Purpose: Within a group of rows, it calculates the relative rank of a row. Syntax: PercentRank () Over ( [partitionbyclause] orderbyclause) Formula: Percent_Rank = (R -1)/(N-1) Where, R => The row whose rank needs to be found... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
8
Shouts
spam Shout it Mute it

Preventing projects from deploying when debugging a SSIS package
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 614 days, 20 hours, 43 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Tuesday, September 13, 2011 10:59:50 AM GMT
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am writing a blog about it, will be able to solve it in no time (a big benefit of blogging is to never have to try to remember a solution to a problem you have had... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
14
Shouts
spam Shout it Mute it

SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds
published 613 days, 13 hours, 30 minutes ago posted by pinaldavepinaldave 615 days, 18 hours, 1 minute ago
Wednesday, September 14, 2011 6:12:58 PM GMT Monday, September 12, 2011 1:42:12 PM GMT
My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create this video which is about how one can install SQL Server Denali CTP3. There is no audio in this video as the video is very simple and one can understand it quite easily. Click here to watch the Denali CTP3 Installation Video o... (more)
category: Data | clicked: 12 | 4 comments | | source: blog.sqlauthority.com
10
Shouts
spam Shout it Mute it

Performance Best practice - Transaction log must on a different drive. But WHY?
published 613 days, 13 hours, 30 minutes ago posted by dharadhara 615 days, 21 hours, 27 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Monday, September 12, 2011 10:16:36 AM GMT
It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high... (more)
category: Data | clicked: 27 | 3 comments | | source: beyondrelational.com
tags: SQL Server
Previous 1 2 ... 11 12 13 14 15 16 17 18 19 20 ... 55 56 Next