kinj312

kinj312
Name: kinj312
Score: 2,488.52
Last Seen: 409 days, 21 hours, 21 minutes ago
Member Since: 26 October, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

Using BackgroundWorker with WPF
published 403 days, 8 hours, 52 minutes ago posted by kinj312kinj312 409 days, 21 hours, 23 minutes ago
Monday, April 16, 2012 8:26:36 PM GMT Tuesday, April 10, 2012 7:56:15 AM GMT
When one process take so much long time and UI thread needs to stay responsive while process is running, the most common method to place a long running process on a separate thread.In WPF there are mostly use technique is Backgroundworker. (more)
category: Web Dev | clicked: 63 | comment | | source: beyondrelational.com
tags:
7
Shouts
spam Shout it Mute it

Getting Started with Windows Phone 7 programming - Getting Started with Windows Phone 7 - Part 2 - Creating a Hello World Silverlight Application in Windows Phone 7
published 426 days, 2 hours, 55 minutes ago posted by kinj312kinj312 435 days, 10 hours, 49 minutes ago
Sunday, March 25, 2012 2:23:44 AM GMT Thursday, March 15, 2012 6:29:41 PM GMT
In this article, we are going to see how to create a simple 'Hello World' Silverlight Windows Phone 7 Application with the development environment, which we discussed in the first part of this series. Developing Windows Application for the developers who have exposure to Visual Studio IDE is pretty simple (more)
category: Data | clicked: 194 | 4 comments | | source: beyondrelational.com
tags: SQL Server, Windows Phone 7
2
Shouts
spam Shout it Mute it

SinghVikash Blog - SSIS: Read and Export Excel data from nth Row
published 452 days, 19 hours, 31 minutes ago posted by kinj312kinj312 462 days, 10 hours, 39 minutes ago
Monday, February 27, 2012 9:47:43 AM GMT Friday, February 17, 2012 6:40:02 PM GMT
This post shows how we can read and export data rom excel starting from nth row. In SSIS we can read excel data starting from any number of row. Considering a scenario we have a excel file like below screen and we need to read data of Row 3 to Row 14 for Top 10 companies we can do this in SSIS. (more)
category: Data | clicked: 21 | comment | | source: beyondrelational.com
tags: SQL Server, SSIS
3
Shouts
spam Shout it Mute it

#0135 - SQL Server – SSMS – Tutorial – 10 - Troubleshooting (L200)
published 452 days, 19 hours, 31 minutes ago posted by kinj312kinj312 462 days, 10 hours, 40 minutes ago
Monday, February 27, 2012 9:47:43 AM GMT Friday, February 17, 2012 6:39:02 PM GMT
All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds. The reason... (more)
category: Data | clicked: 52 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
5
Shouts
spam Shout it Mute it

#0131 - SQL Server – SSMS – Tutorial – Part 06 – Introduction to the Properties Window (L100)
published 468 days, 12 hours, 29 minutes ago posted by kinj312kinj312 470 days, 10 hours, 52 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Thursday, February 09, 2012 6:27:06 PM GMT
The SQL Server Management Studio (SSMS) continues to fascinate me with it’s immense wealth of features geared towards developer & administrator usability. What’s more amazing is that some features perform multiple useful functions depending upon the... (more)
category: Data | clicked: 12 | comment | | source: beyondrelational.com
tags: SQL Server, ssms
5
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 3: First SSIS Package - Sudeep Raj
published 468 days, 12 hours, 29 minutes ago posted by kinj312kinj312 470 days, 10 hours, 52 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Thursday, February 09, 2012 6:26:43 PM GMT
Hope that you have a basic understanding of ETL, SSIS and BIDS. So without much delay, let us start getting our package to move data from a flat file to a database table. The table does not exist and needs to be created while development. (more)
category: Data | clicked: 44 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
5
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit BOM
published 468 days, 12 hours, 29 minutes ago posted by kinj312kinj312 471 days, 9 hours, 52 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:27:15 PM GMT
The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki. The wiki, which is based on the SQL Server 2012... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL, sql server 2012
6
Shouts
spam Shout it Mute it

Add SSRS 2008 named instance tutorial
published 468 days, 12 hours, 29 minutes ago posted by kinj312kinj312 471 days, 9 hours, 52 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:26:50 PM GMT
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installation... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, SSRS
7
Shouts
spam Shout it Mute it

Data Profiling Task to Validate data before load to EDW
published 469 days, 12 hours, 19 minutes ago posted by kinj312kinj312 472 days, 11 hours, 50 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:29:03 PM GMT
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server
5
Shouts
spam Shout it Mute it

Set the Slice on your SSAS Cube Partitions now!
published 469 days, 12 hours, 19 minutes ago posted by kinj312kinj312 472 days, 11 hours, 50 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:28:32 PM GMT
I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
7
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 2: BIDS Overview - Sudeep Raj
published 470 days, 7 hours, 3 minutes ago posted by kinj312kinj312 472 days, 11 hours, 51 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Tuesday, February 07, 2012 5:28:05 PM GMT
What is BIDS? Why do I need it? Where can I find it? 3 questions are asked here. Therefore, I will provide the 3 answers to you. (more)
category: Data | clicked: 23 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
10
Shouts
spam Shout it Mute it

TSQL Script - Generating/Concatenating values into a comma separated string with a grouping
published 488 days, 5 hours, 6 minutes ago posted by kinj312kinj312 492 days, 21 hours, 29 minutes ago
Monday, January 23, 2012 12:13:07 AM GMT Wednesday, January 18, 2012 7:49:41 AM GMT
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx However, Whenever I faced a situation to concatenate... (more)
category: Data | clicked: 18 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

SQL Server – Storage requirements – CHAR v/s VARCHAR – choose the correct data-type
published 485 days, 13 hours, 44 minutes ago posted by kinj312kinj312 492 days, 21 hours, 30 minutes ago
Wednesday, January 25, 2012 3:35:01 PM GMT Wednesday, January 18, 2012 7:49:16 AM GMT
I work with academia frequently, and therefore, get a chance to interact with students and experience the issues they face first hand. I recently had a very interesting experience during one of these visits. I will try to present the experience as a story... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
10
Shouts
spam Shout it Mute it

Split a set of contiguous string into individual characters/letters using Set Based approach
published 491 days, 6 hours, 44 minutes ago posted by kinj312kinj312 492 days, 21 hours, 30 minutes ago
Thursday, January 19, 2012 10:35:12 PM GMT Wednesday, January 18, 2012 7:48:57 AM GMT
It is often a requirement to split a set of contiguous string into individual characters/letters. The below code will help us to do so Declare @str Varchar(50) = 'abcde' Select Data = Substring(@str,Number,1) From master.dbo.spt_values where Number... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Timestamp datatype - Does it store Date or Time?
published 492 days, 12 hours, 20 minutes ago posted by kinj312kinj312 494 days, 20 hours, 47 minutes ago
Wednesday, January 18, 2012 4:59:12 PM GMT Monday, January 16, 2012 8:31:39 AM GMT
Often deveopers confuse themselves between Timestamp and Datetime datatypes. But they are entirely different datatypes. Although the name has Time, the Timestamp datatype has nothing to do anything with date or time. Also you cannot explicitely add/update... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
10
Shouts
spam Shout it Mute it

SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database
published 492 days, 12 hours, 20 minutes ago posted by kinj312kinj312 494 days, 20 hours, 48 minutes ago
Wednesday, January 18, 2012 4:59:12 PM GMT Monday, January 16, 2012 8:31:09 AM GMT
The team I recently moved into had never had a data source created on their report server for an Analysis Services source. A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type. For credentials... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI, SSRS
10
Shouts
spam Shout it Mute it

SQL Server – T-SQL – Different ways to generate a comma-separated string from a table
published 488 days, 5 hours, 6 minutes ago posted by kinj312kinj312 494 days, 20 hours, 48 minutes ago
Monday, January 23, 2012 12:13:07 AM GMT Monday, January 16, 2012 8:30:35 AM GMT
Recently, someone in the team faced a fairly common requirement - to generate a comma-separated string from values stored in a table. This being the last post of the year, I thought of sharing the 2 most-commonly used methods I know of implementing this... (more)
category: Data | clicked: 13 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Redirection in URL Routing
published 497 days, 21 hours, 56 minutes ago posted by kinj312kinj312 498 days, 21 hours, 5 minutes ago
Friday, January 13, 2012 7:23:16 AM GMT Thursday, January 12, 2012 8:14:13 AM GMT
In one of the my earlier post I have written How easily we do URL rewriting in ASP.NET Web forms. In this post I am going to explain redirection in URL Routing. In web application it’s a common scenario that we are redirecting our page to the one from... (more)
category: Web Dev | clicked: 6 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
8
Shouts
spam Shout it Mute it

SQL Server – SQL 2012 (SQL11/Denali) – Query editor - Intellisense now recognizes hyperlinks!
published 497 days, 21 hours, 56 minutes ago posted by kinj312kinj312 498 days, 21 hours, 5 minutes ago
Friday, January 13, 2012 7:23:16 AM GMT Thursday, January 12, 2012 8:13:43 AM GMT
I was playing around with my SQL 2012 (SQL 11/Denali) CTP03 instance the other day, and noticed a great usability enhancement to the Intellisense available in the Query editor. I was adding a reference to a particular web-page on a query that I was working... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql 2012
7
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 6: Migrating Databases to SQL Azure
published 497 days, 21 hours, 56 minutes ago posted by kinj312kinj312 498 days, 21 hours, 6 minutes ago
Friday, January 13, 2012 7:23:16 AM GMT Thursday, January 12, 2012 8:13:01 AM GMT
In this module, we are going to see how we can migrate SQL Server 2008 R2 database to SQL Azure. We will also discuss about options available and their pros and cons. So, by the end of this article, you would be equipped with knowledge of tools that could help you migrate your SQL Server Database to SQL Azure. (more)
category: Data | clicked: 12 | comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
Previous 1 2 3 4 5 6 7 8 9 10 11 Next