DotNetShoutout - Latest published stories

SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE « SQL Server Journey with SQL Authority

pinaldave — 2012-05-08T07:11:27Z

This blog post is inspired from SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 2.[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer. In the article we discussed various basics terminology of the CTE. The article further covers following important concepts of common table expression.What ...

A XAML Guy digs into ASP.NET MVC4 (Part 2 of ?)

mbcrump — 2012-05-09T01:23:41Z

Hey, you came back! Well thank you very much. I’m kind of surprised to see the amount of attention the first part received. From being featured on The Morning Brew to being featured in the ASP.NET community Spotlight, it seems that I have hit on a topic that a lot of people are interested in. Let’s not waste anymore time and jump back into the series.

Extending the Ribbon in SharePoint 2010

kalyanms1 — 2012-05-09T11:01:14Z

Presentation Layer point of view Ribbon is a big change in SharePoint 2010, which provides the consistent user experience between SharePoint and Microsoft Office products. Ribbon is defined in the form of XML and Javascript is used to provide client side functionality. The client side script is located in the following path %SharePointRootpath%\TEMPLATE\LAYOUTS\CUI.js Configuration of Ribbon is stored in XML file in %SharePointRootPath%\TEMPLATE\GLOBAL\XML\CMDUI.XML.

SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint « SQL Server Journey with SQL Authority

pinaldave — 2012-05-09T05:14:12Z

This blog post is inspired from SQL Architecture Basics Joes 2 Pros: Core Architecture concepts – SQL Exam Prep Series 70-433 – Volume 3. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to Basics of a Query Hint – A Primer. In the article we discussed various basics terminology of the query hints. The article further covers following important concepts of query hints.Expecting Seek and getting a ScanCrea...

Doing Your First Mock

KodefuGuru — 2012-05-15T04:20:51Z

Are you looking for a solution to your unit tests modifying data? Perhaps your unit tests are so slow that none of your teammates bother running them? You need mock objects.

SQL SERVER – Quiz and Video – Introduction to SQL Error Actions « SQL Server Journey with SQL Authority

pinaldave — 2012-05-10T06:16:10Z

This blog post is inspired from SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 4. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to SQL Error Actions – A Primer. In the article we discussed various basics terminology of the error handling. The article further covers following important concepts of error handling.Introduction ...

Using PowerPivot for SharePoint 2010 | TechBubbles

kalyanms1 — 2012-05-10T10:42:41Z

PowerPivot applications are created using Excel 2010 using PowerPivot add-in, You can read my post on configuring PowerPivot in SharePoint 2010 here. After creating a PowerPivot application then you need to upload it to SharePoint 2010 PowerPivot gallery so that it can share across organization. You should be able to preview the PowerPivot applications once you upload them to PowerPivot gallery and it is more user engaging. Silverlight needs to be installed to use PowerPivot gallery. You can get thre...

Ghosting and Unghosting in SharePoint 2010 | TechBubbles

kalyanms1 — 2012-05-08T10:26:12Z

Two main page types in SharePoint are Application Pages and Content Pages. Application Pages are rendered from the file system and Content Pages are usually rendered from content database. Site Pages are often loaded from content database. Master Pages or Page Templates are actually being loaded from the local file system. Pages that are loaded from the file system are known as Ghosted Pages. When pages are being customized using SharePoint 2010 designer the changed page content is stored in the content...

Post-increment Operator and Precedence

KodefuGuru — 2012-05-17T07:28:16Z

int i = 0; i = i++ + i--; Console.Write(i); What is written to the console?

Get The specific permission level from the site in SharePoint 2010 using ECMAScript

dotnetspark — 2012-05-16T06:36:08Z

In this article you will see how to get the specific permission level from the site in SharePoint 2010 using ECMAScript.

Designing a Windows 8 Metro style app starting from an existing Windows Phone app – Design Case Study Part 1

KodefuGuru — 2012-05-11T02:15:12Z

A lot of the Windows Phone developers out there are already considering porting their Windows Phone apps to Windows 8. May be you are thinking: from Metro to Metro - it has to be pretty easy and straightforward, doesn’t it? Let’s see if this is true.

Creating Type Aliases in C#

BlackWasp — 2012-05-16T10:37:26Z

The using directive of the C# programming language is often used to create namespace aliases, allowing types with matching names that appear in separate namespaces to be easily accessed. A lesser known use of the directive is to create aliases for types.

ConfirmButtonExtender With ModalPopUp In GridView Ajax

amitjain — 2012-05-14T11:54:46Z

In this example i'm explaining how to implement Ajax ConfirmButtonExtender With ModalPopUp Extender In Asp.Net GridView to show Delete Confirmation before deleting records.

Why use generics in C# dot net | Tech Samosa

ankygoyal — 2012-05-14T11:21:06Z

Recap In an earlier post Microsoft Dotnet Interview Questions 2012, question no. 10 was about benefits of generics. In this post I would answer that. Main benefits of Generics Generics typically provides a lot of performance and code safety benefits which are listed below:Generics enforce Type Safety: Type safety means that only object compatible with specified types will be used in the generic algorithm. This helps to write a code which is less prone to errors. When generics are used, compiler kn...

SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services « SQL Server Journey with SQL Authority

pinaldave — 2012-05-13T05:55:16Z

Data modeling is the most important task for any BI professional. Matter of the fact, the biggest challenge is to organizing disparate data into an analytic model that effectively and efficiently supports the reporting and analysis. SQL Server 2012 introduces BI Semantic Model (BISM), a single model that can support a broad range of reporting and analysis while blending two Analysis Services modeling experiences behind the scenes.Multidimensional modeling – enables BI professionals to create sophisticate...

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats « SQL Server Journey with SQL Authority

pinaldave — 2012-05-14T05:08:20Z

As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you have yet not caught up on that subject. After the blog post I called him and asked what should I write next on this subject. He suggested that I should write on DMV script which I have prepared related to Columnstore when I was writing our SQL Server Questions and Answers book. When we were writing this boo...

Azure Part 38 - Windows Azure WCF Hosting Methods

dotnetspark — 2012-05-12T09:13:19Z

Windows Azure WCF Hosting Methods. In this article I would like to summarize the important points of WCF service exposing in Windows Azure.

Bind DropDownList From XML File In Asp.Net

amitjain — 2012-05-12T08:39:08Z

This Example explains how to Populate Or Bind DropDownList With XML Data From File In Asp.Net Using C# And VB.

Automatically Refresh Update GridView In Asp.Net Ajax

amitjain — 2012-05-12T08:41:02Z

This Example describes how to Auto Refresh Or Update GridView Automatically At Regular Interval In Asp.Net Using Ajax And Timer.

Creating a Centralized NuGet Packages Folder

chrispoulter — 2012-05-13T02:44:53Z

I would imagine most people by now will have discovered and use the NuGet Visual Studio extension (http://www.nuget.org/). It is a great way of adding and maintaining 3rd party code libraries in your projects. One problem I find though is that every time I create a new project or solution I end up installing the same old NuGet packages. By default NuGet downloads the source code for these packages into a new "packages" folder in your project/solution root directory. This means I have the same source code downloaded multiple times, in multiple locations. This can easily be fixed as you can...

12 Most Popular jQuery Plugins of April 2012

MikeMore — 2012-05-04T11:56:15Z

Here we are again for another monthly round-up of the most popular jQuery plugins of April 2012, these 12 plugins will make you WOW!

SQL SERVER – Quiz and Video – Introduction to SQL Server Security « SQL Server Journey with SQL Authority

pinaldave — 2012-05-07T05:05:11Z

This blog post is inspired from Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners – SQL Exam Prep Series 70-433 – Volume 1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to SQL Server Security – A Primer. In the article we discussed various basics terminology of the security. The article further covers following important concepts of security.Granting PermissionsDenying PermissionsRevokin...

C#/.NET Little Wonders: The Enumerable.Repeat() Static Method

BlackRabbitCoder — 2012-05-04T12:30:54Z

The Enumerable.Repeat() method performs the simple task of creating a sequence by repeating an element a specific number of times. While this is, in of itself, a trivial need, it can also be used to drive more useful results such as repeating a generator delegate, or creating sequences out of single items.

Creating Parallel Tasks with TaskFactory

BlackWasp — 2012-05-04T10:37:11Z

The Task Parallel Library provides a number of ways in which parallel tasks can be instantiated. This article describes the use of the TaskFactory class, which uses the factory method design pattern to generate and start tasks with a single method call.

Show/hide various sections of a page using JQuery and CSS

noorani786 — 2012-05-05T03:56:33Z

In this post I’ll go over how you can utilize JQuery and CSS classes to show/hide various parts across the different sections of a page without creating a mess!