DotNetShoutout

dhara

Name:	dhara
Score:	12,446.92
Last Seen:	396 days, 20 hours, 55 minutes ago
Member Since:	12 August, 2010

5
Shouts

Shout it

TSQL Challenge 65 - Solving the Running Total Problem

published 595 days, 4 hours, 43 minutes ago posted by

dhara 596 days, 15 hours, 48 minutes ago

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial transactions. This is not a very complicated challenge and there are different ways to solve this. The key here is to see some... (more)

category: Data | clicked: 17 | 2 comments | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

5
Shouts

Shout it

Building a Visual Studio project from an existing SSAS database

published 595 days, 4 hours, 43 minutes ago posted by

dhara 596 days, 15 hours, 48 minutes ago

Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You are asked to add an enhancement to one of the cubes, so you poke around in source control for the Visual Studio analysis services... (more)

category: Data | clicked: 10 | 4 comments | | source: beyondrelational.com

tags: SQL Server, SSAS, TSQL, BI

11
Shouts

Shout it

SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special « Journey to SQLAuthority

published 588 days, 5 hours, 54 minutes ago posted by

pinaldave 596 days, 17 hours, 41 minutes ago

Get SQL Wait Stats – Kindle Edition Last month I released my SQL Wait Stats book. This book is the beginning of my journey in wait stats. It has been extremely popular and so far in India it has sold all the print copies twice on Flipkart. This book is available in the United States on Amazon and it has gotten a tremendous response as well. What is special about this book is that it gives you the opportunity to start on performance tuning instantly after receiving the book. The scripts are very simple ... (more)

category: Data | clicked: 87 | 9 comments | | source: blog.sqlauthority.com

5
Shouts

Shout it

Day 3: InitCap function in Oracle

published 595 days, 4 hours, 43 minutes ago posted by

dhara 597 days, 15 hours, 43 minutes ago

Let Us Learn Oracle - Part 3 of N [ InitCap function in Oracle ] Source table: tblPlayers Purpose: Capitalizes the first letter of the string Syntax : InitCap(Column Value) SQL> Select Initcap(Upper(BelongsTo)) InitCapExample From tblPlayers; INITCAPEXAMPLE... (more)

category: Data | clicked: 4 | 4 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

5
Shouts

Shout it

What are WPF Commands and Events

published 595 days, 4 hours, 43 minutes ago posted by

dhara 597 days, 15 hours, 44 minutes ago

In order the application to respond to user input WPF offers 2 concepts . Lot of people get confused with events and commands. When do you use what? When to choose which? Handling input in WPF is done by 1. Event Handling 2. Command... (more)

category: Web Dev | clicked: 22 | 5 comments | | source: beyondrelational.com

tags: .NET, WPF, ASP.NET

5
Shouts

Shout it

SQL Server - Stored Procedure Internal Activation in Service Broker

published 595 days, 4 hours, 43 minutes ago posted by

dhara 597 days, 15 hours, 45 minutes ago

As we have seen earlier posts for Service Broker for single database and Service Broker between databases , we have implemented it with examples. Hope you liked those posts. Remember, in service broker example for single database, we have created stored... (more)

category: Data | clicked: 12 | 4 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Day 2: Length function in Oracle - niladri.biswas

published 595 days, 4 hours, 43 minutes ago posted by

dhara 598 days, 16 hours, 44 minutes ago

Let Us Learn Oracle - Part 2 of N [ Length function in Oracle ] Source table: tblPlayers This function will return the length of the string SQL> Select PlayerFirstName... (more)

category: Data | clicked: 16 | 5 comments | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

DBA personality Traits

published 595 days, 4 hours, 43 minutes ago posted by

dhara 598 days, 16 hours, 45 minutes ago

I’m just about to interview 2 candidates for a Senior DBA vacancy. As part of the interview process. Technical Test Interview (Technical, Experience & Personality) The purpose of the Technical Tests is not to determine their memory of commands... (more)

category: Data | clicked: 10 | 5 comments | | source: beyondrelational.com

tags: SQL Server, Database

8
Shouts

Shout it

What are Types of events in WPF or What is Event Routing or a Routed Event?

published 595 days, 4 hours, 43 minutes ago posted by

dhara 598 days, 16 hours, 45 minutes ago

Event Routing or A Routed Event is a type of event that is has the ability to invoke handlers not only on on the object that raised the event but also on multiple listeners in an element tree. There are 2 types of events in WPF 1. Bubbling 2. Tunneling... (more)

category: Web Dev | clicked: 28 | 4 comments | | source: beyondrelational.com

tags: .NET, WPF, ASP.NET

6
Shouts

Shout it

WCF # 4 – Metadata Exchange Points (Creating/Exposing Metadata Exchange Point using code and configuration files)

published 595 days, 4 hours, 43 minutes ago posted by

dhara 600 days, 16 hours, 23 minutes ago

Hi Friends, We have learnt how to write the web service using WCF,In this article we will see how Metadata in WCF refers to the information that describes precisely how to communicate with a service. * Clients can request metadata from a running... (more)

category: Web Dev | clicked: 23 | 4 comments | | source: beyondrelational.com

tags: .NET, WCF, ASP.NET

5
Shouts

Shout it

Sql Server Scripts

published 595 days, 4 hours, 43 minutes ago posted by

dhara 600 days, 16 hours, 23 minutes ago

The tables that will participate in the demonstration tblPlayers tblStudents tblDept tblEmployee Script for tblPlayers ... (more)

category: Data | clicked: 17 | 4 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Setting, Labeling, Using & Searching Conditional Breakpoints

published 595 days, 4 hours, 43 minutes ago posted by

dhara 600 days, 16 hours, 23 minutes ago

Way back in March 2011, I attended Tech-Ed India 2011 (read my 3 part series here – Part 01 , Part 02 , Part 03 ). During Tech-Ed, I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL... (more)

category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Question of the month September 2011 - Find out problamatic query

published 600 days, 7 hours, 31 minutes ago posted by

dhara 601 days, 18 hours, 4 minutes ago

Out of these four queries, only one query will throw an error. Without running these queries find out the query and error message that it would generate. Queries Query 1 : select top 1 1 from sysobjects,syscolumns where 1=1 Query 2 : select top 1 1 from... (more)

category: Data | clicked: 15 | 3 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

SQL Server “Denali”: Installing on a Virtual Machine

published 600 days, 7 hours, 31 minutes ago posted by

dhara 601 days, 18 hours, 10 minutes ago

With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as the new tools, such as Crescent and Juneau . The steps below are what I took to create a virtual machine to install all the products needed... (more)

category: Data | clicked: 58 | 4 comments | | source: beyondrelational.com

tags: SQL Server, denali

6
Shouts

Shout it

Day 1: String Concatenation in Oracle

published 600 days, 7 hours, 31 minutes ago posted by

dhara 601 days, 18 hours, 11 minutes ago

Let Us Learn Oracle - Part 1 of N [ String Concatenation in Oracle ] Source table: tblPlayers In Oracle concatenation can be done in the following ways Option 1: Using Concatenation Operator ( || ) SQL> Select PlayerFirstName || ' ' || PlayerLastName... (more)

category: Data | clicked: 14 | 4 comments | | source: beyondrelational.com

tags: SQL Server, TSQL, Oracle

7
Shouts

Shout it

MSBI # 37 – SSIS # 16 - Data Flow Task # 2 - Introduction to Data Flow Task {Part - I}

published 600 days, 7 hours, 31 minutes ago posted by

dhara 602 days, 18 hours, 29 minutes ago

Hi friends , As I have already started some basic explanation of Data Flow Task on my last post: MSBI # 36 – SSIS # 15 – Control Flow Tasks # 8 – Data Flow Task # 1 « (B)usiness (I)ntelligence Mentalist In this post we will look further in base of Data... (more)

category: Data | clicked: 5 | 4 comments | | source: beyondrelational.com

tags: SQL Server, MSBI, TSQL

7
Shouts

Shout it

SQL SERVER: Load Reports without SQL SERVER Reporting Service with Asp.Net

published 600 days, 7 hours, 31 minutes ago posted by

dhara 602 days, 18 hours, 30 minutes ago

Recently, we have weekly meetings with my team and one of developer is come up with question that, "Can we use Reports without having SQL SERVER Report Services?". That is very good question that came up by him, as he says client does not want... (more)

category: Data | clicked: 13 | 4 comments | | source: beyondrelational.com

tags: SQL Server, SSRS

7
Shouts

Shout it

SQL Server 2008 - Monitor SQL Server's Activity with Activity Monitor

published 600 days, 7 hours, 31 minutes ago posted by

dhara 602 days, 18 hours, 30 minutes ago

With SQL server 2008 and the feature provided by it, This is very best feature for DBA people to get easily information for the SQL server details and process running inside it. You can read all features provided by SQL Server 2008 This feature is "Activity... (more)

category: Data | clicked: 10 | 4 comments | | source: beyondrelational.com

tags: SQL Server

8
Shouts

Shout it

What is an index – a theory (part 1/4 – dense and sparse indexes)

published 600 days, 7 hours, 31 minutes ago posted by

dhara 603 days, 18 hours, 2 minutes ago

Since I had written a few posts about indexes before, I thought it would be good to shed some light on theory behind indexes in SQL Server. It would be divided into four parts: Dense and sparse indexes (this post). B-trees – searching for a value and... (more)

category: Data | clicked: 16 | 3 comments | | source: beyondrelational.com

tags: SQL Server, index

7
Shouts

Shout it

T-SQL Function: EOMONTH

published 600 days, 7 hours, 31 minutes ago posted by

dhara 603 days, 18 hours, 2 minutes ago

We have all been in a situation where we had to get the last day of the month with T-SQL. The world would just be so much easier with 30 days in every month, which is not the case. To calculate if the last day is 31, 30, 28 or maybe even 29 is not that... (more)

category: Data | clicked: 13 | 3 comments | | source: beyondrelational.com

tags: SQL Server, TSQL

Welcome!

dhara

TSQL Challenge 65 - Solving the Running Total Problem

Building a Visual Studio project from an existing SSAS database

SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special « Journey to SQLAuthority

Day 3: InitCap function in Oracle

What are WPF Commands and Events

SQL Server - Stored Procedure Internal Activation in Service Broker

Day 2: Length function in Oracle - niladri.biswas

DBA personality Traits

What are Types of events in WPF or What is Event Routing or a Routed Event?

WCF # 4 – Metadata Exchange Points (Creating/Exposing Metadata Exchange Point using code and configuration files)

Sql Server Scripts

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Setting, Labeling, Using & Searching Conditional Breakpoints

Question of the month September 2011 - Find out problamatic query

SQL Server “Denali”: Installing on a Virtual Machine

Day 1: String Concatenation in Oracle

MSBI # 37 – SSIS # 16 - Data Flow Task # 2 - Introduction to Data Flow Task {Part - I}

SQL SERVER: Load Reports without SQL SERVER Reporting Service with Asp.Net

SQL Server 2008 - Monitor SQL Server's Activity with Activity Monitor

What is an index – a theory (part 1/4 – dense and sparse indexes)

T-SQL Function: EOMONTH

Open ID Login

Standard Login

Forgot Password?

Sign up