DotNetShoutout

dhara

Name:	dhara
Score:	12,446.92
Last Seen:	393 days, 1 hour, 35 minutes ago
Member Since:	12 August, 2010

8
Shouts

Shout it

SqlCeCmd tutorial part one – Managing database files

published 992 days, 14 hours, 56 minutes ago posted by

dhara 993 days, 2 hours, 2 minutes ago

This tutorial will show various samples of using SqlCeCmd, which is available at http://sqlcecmd.codeplex.com – sqlcecmd is the “equivalent” of sqlcmd for the full SQL Server product. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL ServerCE, SQLCE

11
Shouts

Shout it

SILVERLIGHT Tutorial - What is XAML?

published 992 days, 14 hours, 56 minutes ago posted by

dhara 993 days, 19 hours, 46 minutes ago

In the previous article I attempted to explain What is XAP file in Silverlight. In this article I will try to explain what is XAML and how it is used in Silverlight. Extensible Application Markup Language (XAML, pronounced zammel) is a declarative XML-based language created by Microsoft which is used as a user interface markup language to define UI elements, data binding, event handlers, and other features. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, Silverlight, XAML, ASP.NET

10
Shouts

Shout it

SQL Server - Understanding the behavior of @@TRANCOUNT when querying from a client application

published 992 days, 14 hours, 56 minutes ago posted by

dhara 994 days, 1 hour, 13 minutes ago

As you know, @@TRANCOUNT is used to inform you about the number of live transactions active at point. If you want to retrieve it's value using an application, you should be careful about the behaviour of the returned value. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, .NET, TSQL

7
Shouts

Shout it

Raising Custom Messages through RAISERROR

posted by

dhara 995 days, 21 hours, 47 minutes ago

When we design a database application, whenever we come across errors in our stored procedures, we can throw custom error messages using RAISERROR . It is very sophisticated way of handling error in TSQL Code. Here we are going to discuss how can we use RAISERROR to throw custom error messages in our code. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: TRANCOUNT, TSQL

11
Shouts

Shout it

SILVERLIGHT Tutorial - What is XAP File?

published 994 days, 16 hours, 5 minutes ago posted by

dhara 996 days, 1 hour, 46 minutes ago

In the previous article I attempted to explain What Silverlight is and how it is being used more and more to develop business applications. When web page with a Silverlight application runs on the browser it requests for XAP file. In this article I will try to explain what XAP file is and what it contains. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: Silverlight, Xap, ASP.NET

9
Shouts

Shout it

Basics of C#: Checked and Unchecked Conversions

published 996 days, 15 hours, 6 minutes ago posted by

dhara 996 days, 21 hours, 16 minutes ago

When we do conversion in c# , sometime conversions are not checked. C# compiler may not check the conversion and truncate the result. So Checked keyword helps us in doing that. (more)

category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com

tags: .NET, C#, ASP .NET

10
Shouts

Shout it

SQL SERVER – Adding Column is Expensive – Limitation of the Views Part 2 « Journey to SQL Authority with Pinal Dave

published 996 days, 14 hours, 45 minutes ago posted by

pinaldave 997 days, 1 hour, 11 minutes ago

Let’s see another reason why I do not like Views. Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away. If we want to do the same with Views, we will have to modify them first. This means any query that does not need this column will start having the column’s data additionally. This will lead to added network traffic as well as it will reduce the performance of the part where the View is used. This further leads to a concl... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

10
Shouts

Shout it

SSIS - Managing Control Flow based on the input file name

published 996 days, 14 hours, 45 minutes ago posted by

dhara 997 days, 2 hours, 3 minutes ago

Many times during ETL we have a requirement where based on the file name we have to perform certain operations. Normally within a For Each Loop with File enumerator in Control Flow Task there is no direct way of doing this. If the file mask matches, well and good but nothing beyond that (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, SSIS, BI

8
Shouts

Shout it

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

published 996 days, 14 hours, 45 minutes ago posted by

dhara 997 days, 21 hours, 33 minutes ago

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, ASP .NET, Linq

10
Shouts

Shout it

LINQ to SQL Query operators Part III

published 997 days, 19 hours, 25 minutes ago posted by

dhara 998 days, 1 hour, 46 minutes ago

In this instalment of LINQ tutorial we will see a few more operators like "Set" and "Aggregate" (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, ASP .NET, Linq

11
Shouts

Shout it

How to save and retrieve Images using LINQ to SQL with SQL Compact

published 996 days, 14 hours, 45 minutes ago posted by

dhara 998 days, 21 hours, 44 minutes ago

The code below demonstrates several features of working with System.Drawing.Image object together with LINQ to SQL, which maps a byte[] to the System.Data.Linq.Binary type. (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Linq

7
Shouts

Shout it

Silverlight Architecture

published 998 days, 18 hours, 17 minutes ago posted by

dhara 999 days, 1 hour, 17 minutes ago

This article explains the Architecture of Silverlight in simpler manner. We can think silver light plug-in as a combination of some technologies from core .NET framework, vector animations, media and JavaScript. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, ASP .NET, WCF

8
Shouts

Shout it

SQL Server - Identifying identity columns using TSQL - Madhivanan's TSQL Blog

published 998 days, 18 hours, 17 minutes ago posted by

jacobsebastian 1000 days, 2 hours, 25 minutes ago

One of my friends asked me if it is possible to identify the tables with identiy columns as he wanted to run dbcc checkident command to all the tables of the database.There are actually many ways to identify identity columns from a table.The following three methods will list out the table names and the identity column name (if available) (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: TSQL, database design, SQLServer

10
Shouts

Shout it

Basic of C#: Call Stack, Call Site and Stack unwinding - Debug Mode

published 998 days, 18 hours, 17 minutes ago posted by

jacobsebastian 999 days, 16 hours, 43 minutes ago

When we call a method in c# in a nested manner , there are three terms come into action. They are Call stack , Call Site and Stack unwinding This article is going to explain about that. (more)

category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com

tags: dotnet, C#, CSharp

12
Shouts

Shout it

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 « Journey to SQL Authority with Pinal Dave

published 998 days, 18 hours, 17 minutes ago posted by

pinaldave 1000 days, 5 hours, 46 minutes ago

Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let us start with the first well-known limitation. Order By clause does not work in View. I agree with all of you who say that there is no need of using ORDER BY in the View. ORDER BY should be used outside the View and not in the View. This example is another reason why one should not use ORDER BY in Views. Here is the quick example for the same. I have used sample datab... (more)

category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

MS PowerPivot - A view point

published 999 days, 18 hours, 2 minutes ago posted by

dhara 1000 days, 21 hours, 29 minutes ago

Looking at the cost aspect associated with Power Pivot, I can see many business users using Power Pivot for excel 2010 to do some data analysis and reporting .They will least care about publishing it on Share Point which needs SP 2010 and SQL Server 2008 R2. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: POWERPIVOT, MSBI, SSAS, BI

9
Shouts

Shout it

Lookup in SSRS 2008 R2

published 1000 days, 18 hours, 6 minutes ago posted by

dhara 1001 days, 2 hours, 2 minutes ago

Many times we want to associate a tablix with more than one dataset in reports but we are not able to do so in SSRS 2008 and previous versions. This limitation has been taken care of by some RDL expression language enhancements in SSRS 2008 R2 (more)

category: Web Dev | clicked: 1 | 2 comments | | source: beyondrelational.com

13
Shouts

Shout it

SQL SERVER – Computed Columns – Index and Performance « Journey to SQL Authority with Pinal Dave

published 1000 days, 18 hours, 6 minutes ago posted by

pinaldave 1002 days, 3 hours, 45 minutes ago

This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER – Computed Column – PERSISTED and Performance This article talks about how PERSISTED columns give better performance than non-persisted columns. SQL SERVER – Computed Column – PERSISTED and Performance – Part 2 This art... (more)

category: Data | clicked: 2 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

Less known/used property: ExecValueVariable

published 1001 days, 19 hours, 19 minutes ago posted by

dhara 1003 days, 1 hour, 4 minutes ago

At times I have seen in SSIS forums people ask about the way they can know the number of records updated by a query or deleted by a query in an Execute SQL Task in control flow. Even I replied at times that its not possible(in a direct manner), until... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL, SSIS

11
Shouts

Shout it

SQL Server White Paper: Database Encryption in SQL Server 2008 Enterprise Edition

published 1001 days, 19 hours, 19 minutes ago posted by

dhara 1003 days, 1 hour, 55 minutes ago

With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by... (more)

category: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: White Paper, SQL Server

Welcome!

dhara

SqlCeCmd tutorial part one – Managing database files

SILVERLIGHT Tutorial - What is XAML?

SQL Server - Understanding the behavior of @@TRANCOUNT when querying from a client application

Raising Custom Messages through RAISERROR

SILVERLIGHT Tutorial - What is XAP File?

Basics of C#: Checked and Unchecked Conversions

SQL SERVER – Adding Column is Expensive – Limitation of the Views Part 2 « Journey to SQL Authority with Pinal Dave

SSIS - Managing Control Flow based on the input file name

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

LINQ to SQL Query operators Part III

How to save and retrieve Images using LINQ to SQL with SQL Compact

Silverlight Architecture

SQL Server - Identifying identity columns using TSQL - Madhivanan's TSQL Blog

Basic of C#: Call Stack, Call Site and Stack unwinding - Debug Mode

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 « Journey to SQL Authority with Pinal Dave

MS PowerPivot - A view point

Lookup in SSRS 2008 R2

SQL SERVER – Computed Columns – Index and Performance « Journey to SQL Authority with Pinal Dave

Less known/used property: ExecValueVariable

SQL Server White Paper: Database Encryption in SQL Server 2008 Enterprise Edition

Open ID Login

Standard Login

Forgot Password?

Sign up