dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 396 days, 17 hours, 57 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

@@TRANCOUNT is always incremented in a trigger
published 478 days, 12 hours, 12 minutes ago posted by dharadhara 482 days, 4 hours, 48 minutes ago
Tuesday, January 31, 2012 11:14:37 AM GMT Friday, January 27, 2012 6:39:12 PM GMT
The system variable @@TRANCOUNT is used to get the number of transactions that are active. Consider the following code begin transaction select 3 select @@TRANCOUNT commit transaction The result of @@TRANCOUNT is 1. Consider the following code. begin... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

SSIS - Delete files from specified folder using Script Task in SQL Server
published 490 days, 52 minutes ago posted by dharadhara 492 days, 13 hours, 3 minutes ago
Thursday, January 19, 2012 10:35:12 PM GMT Tuesday, January 17, 2012 10:23:33 AM GMT
Earlier we have seen for the files deletion using File System Task in SSIS. We have used it with Foreach Loop Container. Used a variable to hold file names which are passed from earlier stage one by one and then finally used with File System Task to delete... (more)
category: Data | clicked: 21 | comment | | source: beyondrelational.com
tags: SQL Server, SSIS
9
Shouts
spam Shout it Mute it

Using SSAS formatting in SSRS
published 490 days, 52 minutes ago posted by dharadhara 492 days, 13 hours, 4 minutes ago
Thursday, January 19, 2012 10:35:12 PM GMT Tuesday, January 17, 2012 10:23:01 AM GMT
Christmas time is one of my most favourite times of the year – the time when you can just lay back, relax, enjoy some quality time with your family and catch up with your old friends. While this Christmas time has been a little hectic for me considering... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI, SSRS
9
Shouts
spam Shout it Mute it

Getting Started with SQL Azure - Getting started with SQL Azure - Part 7: SQL Azure administration - I - Paras Doshi
published 490 days, 52 minutes ago posted by dharadhara 492 days, 13 hours, 4 minutes ago
Thursday, January 19, 2012 10:35:12 PM GMT Tuesday, January 17, 2012 10:22:30 AM GMT
First up is how to Improve SQL Azure performance? Now, though SQL Azure is a cloud-based service and few details are abstracted from the service administrator – we still need to perform tasks from our side to get the best performance out of SQL Azure. (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Azure, Azure
8
Shouts
spam Shout it Mute it

SSIS - Delete files from specified folder using File System Task in SQL Server
published 494 days, 11 hours, 32 minutes ago posted by dharadhara 496 days, 16 hours, 7 minutes ago
Sunday, January 15, 2012 11:54:38 AM GMT Friday, January 13, 2012 7:19:57 AM GMT
We know all the various methods to delete the particular or all files from the specified folder using some of the methods like xpdeletefile , Ole Automation Procedures and with xp_cmdshell command line utility which we used for the old files archive... (more)
category: Data | clicked: 21 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS, BI
10
Shouts
spam Shout it Mute it

Async file upload with jquery and ASP.NET
published 488 days, 6 hours, 40 minutes ago posted by dharadhara 496 days, 16 hours, 7 minutes ago
Saturday, January 21, 2012 4:46:53 PM GMT Friday, January 13, 2012 7:19:31 AM GMT
Recently before some I was in search of good asynchronous file upload control which can upload file without post back and I have don’t have to write much custom logic about this. So after searching it on internet I have found lots of options but... (more)
category: Web Dev | clicked: 104 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
8
Shouts
spam Shout it Mute it

SSIS – Loop through rows in a SQL table (with multiple columns)
published 494 days, 11 hours, 32 minutes ago posted by dharadhara 496 days, 16 hours, 8 minutes ago
Sunday, January 15, 2012 11:54:38 AM GMT Friday, January 13, 2012 7:19:08 AM GMT
I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop through rows record by record. In SSIS package design, however, I have used the Foreach Loop Container very often. I would not say that I have broken my vows though for... (more)
category: Data | clicked: 47 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS, BI
8
Shouts
spam Shout it Mute it

Session Timeout in IIS 7 - Worker Process of ApplicationPool
published 494 days, 11 hours, 32 minutes ago posted by dharadhara 498 days, 16 hours, 23 minutes ago
Sunday, January 15, 2012 11:54:38 AM GMT Wednesday, January 11, 2012 7:03:44 AM GMT
Problem Recently while testing my application, I was facing problem of Session time out. By Default Session time is 20 mins and I wanted to extend it Attempts if we want to extend it we can set in web.config within System.web tag (more)
category: Web Dev | clicked: 39 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET, Session
7
Shouts
spam Shout it Mute it

SSIS #104 – When Row Count Transformation is invaluable
published 496 days, 16 hours, 4 minutes ago posted by dharadhara 498 days, 16 hours, 24 minutes ago
Friday, January 13, 2012 7:23:16 AM GMT Wednesday, January 11, 2012 7:03:10 AM GMT
The Row Count transformation is a pretty straightforward transformation. It does the following two things: 1. It counts rows as data passes through a data flow, and 2. it stores the final count in a variable . (Note that the variable is only populated... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, SSIS, BI
7
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 10 B: Conclusion
published 496 days, 16 hours, 4 minutes ago posted by dharadhara 498 days, 16 hours, 24 minutes ago
Friday, January 13, 2012 7:23:16 AM GMT Wednesday, January 11, 2012 7:02:30 AM GMT
Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure. First summary... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
7
Shouts
spam Shout it Mute it

MSBI # 59 - SSIS # 23 – Data Flow Task # 9 - Audit Transformation Task- Detailed information & Explanation with example, Use & Properties
published 499 days, 3 hours ago posted by dharadhara 500 days, 15 hours, 21 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:05:17 AM GMT
Hi friends I have started explaining each Data flow task, i.e continuing from my last as well as link MSBI # 55 – SSIS # 21 – Data Flow Task # 7 – All Transformation in Data Flow task MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, BI
7
Shouts
spam Shout it Mute it

Implement Role based security using Windows Groups in WCF
published 499 days, 3 hours ago posted by dharadhara 500 days, 15 hours, 22 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:04:47 AM GMT
This is third blog on security concept in WCF. You can read previous posts: Something about Security in WCF- I Implement windows authentication and security in WCF Service Today I’ll describe how we can implement role based authorization using Windows... (more)
category: Web Dev | clicked: 43 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
7
Shouts
spam Shout it Mute it

SSAS #26 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers
published 499 days, 3 hours ago posted by dharadhara 500 days, 15 hours, 22 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:04:19 AM GMT
A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube . If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
8
Shouts
spam Shout it Mute it

The Dark Side of Covariance
published 501 days, 9 hours, 43 minutes ago posted by dharadhara 503 days, 15 hours, 55 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:31:31 AM GMT
What’s wrong with the following code? var names = new HashSet (more)
category: Web Dev | clicked: 37 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP .NET
8
Shouts
spam Shout it Mute it

SQL Server – SQL Agent – Jobs – Automatically delete SQL Server Agent jobs
published 501 days, 9 hours, 43 minutes ago posted by dharadhara 503 days, 15 hours, 56 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:30:43 AM GMT
I would start today’s post with a question – Have you ever faced a requirement to delete a job once it successfully completes? Once I had to achieve just that – a SQL Server job had to be created, and the requirement was to delete the job after it’s execution... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Implement windows authentication and security in WCF Service
published 501 days, 9 hours, 43 minutes ago posted by dharadhara 503 days, 15 hours, 57 minutes ago
Sunday, January 08, 2012 1:43:59 PM GMT Friday, January 06, 2012 7:30:16 AM GMT
This is continuation with previous post on “Security in WCF -I”. Here I’ll explain how we can implement windows authentication with transport level security in intranet environment. Windows authentication In intranet environment, client and service are... (more)
category: Web Dev | clicked: 32 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
6
Shouts
spam Shout it Mute it

Nic Teaming
published 505 days, 5 hours, 42 minutes ago posted by dharadhara 505 days, 14 hours, 1 minute ago
Wednesday, January 04, 2012 5:44:44 PM GMT Wednesday, January 04, 2012 9:25:49 AM GMT
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes are 1) increasing throughput beyond a single connection and 2) redundancy. The three main teaming configurations... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

MSSQL transaction log
published 503 days, 7 hours, 36 minutes ago posted by dharadhara 505 days, 14 hours, 1 minute ago
Friday, January 06, 2012 3:51:12 PM GMT Wednesday, January 04, 2012 9:25:23 AM GMT
It is good if you backed up the LOG file also when we take the full backup of the database. If you are not backed up the .LDF file or LOG then it will become huge and occupy the large number of space, if you need to clean up the transaction log. Follow... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

MSBI # 55 - SSIS # 21 - Data Flow Task # 7 - All Transformation in Data Flow task (Introduction and Usage) {Part - VI}
published 505 days, 5 hours, 42 minutes ago posted by dharadhara 505 days, 14 hours, 2 minutes ago
Wednesday, January 04, 2012 5:44:44 PM GMT Wednesday, January 04, 2012 9:25:03 AM GMT
Hi friends , As I am getting more time today I want to utilized same for blogging only !! Today only I have completed 2 post which is in series of All Transformation in Data Flow task So here is complete sequence form my last continuing post MSBI # 36... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, SSIS
7
Shouts
spam Shout it Mute it

SSIS #103 – Learn SSIS NOW
published 507 days, 12 hours, 53 minutes ago posted by dharadhara 511 days, 12 hours, 56 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Thursday, December 29, 2011 10:30:55 AM GMT
When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package , it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works... (more)
category: Data | clicked: 12 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS, BI
Previous 1 2 3 4 5 6 7 8 9 10 ... 42 43 Next