dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 399 days, 14 hours, 56 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

Logging off disconnected users
published 624 days, 10 hours, 55 minutes ago posted by dharadhara 626 days, 11 hours, 39 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:41 AM GMT
And now for something completely different… As it is essential for a DBA to know his/her way around in server administration, let’s think of something else for a minute. If your IT department consists of more than 2 people, you most likely... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, RDP
6
Shouts
spam Shout it Mute it

Lead function in Denali CTP 3
published 624 days, 10 hours, 55 minutes ago posted by dharadhara 626 days, 11 hours, 40 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:12 AM GMT
Lead Function Purpose: This function returns result set starting from the next row in the table. Syntax: Lead(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)
category: Data | clicked: 19 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali
6
Shouts
spam Shout it Mute it

BCP & large BULK operations made faster – switch between FULL & BULK-LOGGED recovery models
published 626 days, 13 hours, 14 minutes ago posted by dharadhara 627 days, 10 hours, 34 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:49 AM GMT
Recently, a friend told me that they were experiencing performance issues in production when importing data from 3rd party interfaces at the end of the day. The entire import was done via BCP and at a time when no users were logged into the system. Also... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

MSBI # 26 – SSIS # 13 – Control Flow Tasks # 8 – ActiveX Script Task
published 626 days, 13 hours, 14 minutes ago posted by dharadhara 627 days, 10 hours, 35 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:17 AM GMT
Hi all , First a fall if you are rally interested in Active-X script task then only read this article ,Because it has not been use now a days !! Its has been used in 2000 its decade now still I feel like having post on same. All we use is script... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSIS
8
Shouts
spam Shout it Mute it

ILSpy-Alternative of .NET Reflector
published 626 days, 13 hours, 14 minutes ago posted by dharadhara 627 days, 10 hours, 35 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:50:45 AM GMT
Sometimes we need to have decomposer tool or reflector tool for our applications to improve the performance or to know the internals of the assembly we have created. I was using Red Gate .NET Reflector earlier for same as it was free. Now Red Gate has... (more)
category: Web Dev | clicked: 49 | 2 comments | | source: beyondrelational.com
tags: .NET
6
Shouts
spam Shout it Mute it

New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3
published 628 days, 14 hours ago posted by dharadhara 629 days, 12 hours, 43 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:43:01 AM GMT
New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3 In Denali CTP 3, we have three new functions in the expression language viz. Left , Token and TokenCount so far SSIS is concern Let us analyze these functions one by one Left... (more)
category: Data | clicked: 9 | 6 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, CTP
6
Shouts
spam Shout it Mute it

SSIS #98 – IsSorted is true, but sorted on what?
published 628 days, 14 hours ago posted by dharadhara 629 days, 12 hours, 43 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:36 AM GMT
In my previous post, SSIS #97 – When MERGE JOIN is your friend? , I showed you a scenario where Merge Join can be you real friend in your ETL work. I also showed you two ways to satisfy the sorting requirement by the Merge Join task. One of the... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, BI
6
Shouts
spam Shout it Mute it

Index Disabled and Index Rebuild
published 628 days, 14 hours ago posted by dharadhara 629 days, 12 hours, 44 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:10 AM GMT
I received the following message from a Developer. The message was on a Test SQL Server. “NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online . The cause... (more)
category: Data | clicked: 36 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

TSQL Challenge 63 - A TSQL Sudoku
published 631 days, 10 hours, 5 minutes ago posted by dharadhara 632 days, 8 hours, 33 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:52:32 AM GMT
This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
7
Shouts
spam Shout it Mute it

WCF # 1 – WCF Introduction (ENDPOINTs)
published 631 days, 10 hours, 5 minutes ago posted by dharadhara 632 days, 8 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:52:04 AM GMT
Hi Friends , This is the first time i m posting on Beyond Rational , and I hope my posts will be helpful for you to understand some interesting Microsoft Technologies,I would like to thank JACOB as he gave me an opportunity to start with BeyondRational... (more)
category: Web Dev | clicked: 27 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
6
Shouts
spam Shout it Mute it

Define IOPs for all database servers
published 631 days, 10 hours, 5 minutes ago posted by dharadhara 632 days, 8 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:51:30 AM GMT
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations. He’s asked me to define some configurations for optimal SQL Server performance. Rather than supply him with configurations... (more)
category: Data | clicked: 7 | 5 comments | | source: beyondrelational.com
tags: SQL Server, Database
6
Shouts
spam Shout it Mute it

Solve the FizzBuzz problem with SQL code
published 633 days, 10 hours ago posted by dharadhara 635 days, 13 hours, 22 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:03:49 AM GMT
Brent Ozar , a SQL Server MCM and MVP, posted about Top 10 SQL Server DBA Interview Questions . The question no 10 is about solving FizzBuzz problem. The FizzBuzz problem is described as Write a program that prints the numbers from 1 to 100. But for multiples... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

How to report a SQL Server performance problem
published 633 days, 10 hours ago posted by dharadhara 635 days, 13 hours, 22 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:03:23 AM GMT
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining. Many reasons could be causing this sudden slowdown. For SQL Server performance problems, gathering and analyzing data is not enough. A lot of time can be wasted... (more)
category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Query Plan Re-use: Write your T-SQL queries with the proper case for plan re-use and better query performance
published 633 days, 10 hours ago posted by dharadhara 635 days, 13 hours, 23 minutes ago
Thursday, September 01, 2011 10:25:36 AM GMT Tuesday, August 30, 2011 7:02:54 AM GMT
I had an interesting time at the office recently. We were undertaking a performance tuning exercise for the canned reports of an OLTP that were migrated from Crystal Reports to SSRS, and had to come up with some ground rules for all database developers... (more)
category: Data | clicked: 39 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

MSBI # 22 - SSIS # 9 - Control Flow Tasks # 4 - For Loop Container Task
published 634 days, 22 hours, 41 minutes ago posted by dharadhara 636 days, 14 hours, 37 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:48:56 AM GMT
Continuing from my last post on SSIS Control flow task on : MSBI # 14 – SSIS # 7 – Control Flow Tasks # 2- Details of Control Flow Task {Part – II} In this post we are going to look at every aspects of For Loop Container Task. We are covering following... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSIS, BI
9
Shouts
spam Shout it Mute it

Creating Basic RSS Reader in ASP.NET MVC 3
published 634 days, 22 hours, 41 minutes ago posted by dharadhara 636 days, 14 hours, 38 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:47:53 AM GMT
In this post I am going to explain you how we can create a basic RSS Reader with the help of Linq-To-Xml and ASP.NET MVC3 Razor. Those who are writing or reading Blogs already knows what is RSS Reader. But those who does not know What is RSS. Below... (more)
category: Web Dev | clicked: 42 | 4 comments | | source: beyondrelational.com
tags: ASP.NET MVC, .NET
7
Shouts
spam Shout it Mute it

RAID server configuration and disk amounts
published 634 days, 22 hours, 41 minutes ago posted by dharadhara 636 days, 14 hours, 38 minutes ago
Tuesday, August 30, 2011 9:45:16 PM GMT Monday, August 29, 2011 5:47:26 AM GMT
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge. Typical questions from the SAN\Storage guy to the DBA are: “How many disks in a RAID configuration?” “What is the optimal block... (more)
category: Data | clicked: 16 | 5 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Summary - SQL server to SQL Azure migration
published 636 days, 1 hour, 28 minutes ago posted by dharadhara 639 days, 10 hours, 25 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:59 AM GMT
In this blog post, I aim to summarize database migration options that I have been blogging about for past few weeks. Choosing right tool is a key decision when you decide to migrate SQL server to SQL Azure – And I hope this blog post can help you decide... (more)
category: Data | clicked: 14 | 3 comments | | source: beyondrelational.com
tags: SQL Server, SQL Azure
7
Shouts
spam Shout it Mute it

DB2 event monitor and snapshot monitor
published 636 days, 1 hour, 28 minutes ago posted by dharadhara 639 days, 10 hours, 25 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:33 AM GMT
I collect database usage information in two different ways. Snapshots and Monitoring Events. Either method collects real-time database usage information such as SQL queries, buffer pool activity and locking information. An event monitor is a statement... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

First look at ColumnStore Indexes in SQL Server DENALI
published 636 days, 1 hour, 28 minutes ago posted by dharadhara 639 days, 10 hours, 26 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Friday, August 26, 2011 10:00:01 AM GMT
By this time everyone are aware that the next version of SQL Server i.e DENALI comes with ColumnStore Indexes which is a new concept in SQL Server. If you haven’t tried this feature yet then its about time to try it out on CTP3. I am pretty sure... (more)
category: Data | clicked: 35 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali
Previous 1 2 ... 9 10 11 12 13 14 15 16 17 18 ... 42 43 Next