ashishgilhotra

ashishgilhotra
Name: ashishgilhotra
Score: 1,695.33
Last Seen: 617 days, 8 hours, 58 minutes ago
Member Since: 7 April, 2010
DotNetShoutout
atom rss
14
Shouts
spam Shout it Mute it

SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds
published 615 days, 4 hours, 55 minutes ago posted by pinaldavepinaldave 617 days, 9 hours, 26 minutes ago
Wednesday, September 14, 2011 6:12:58 PM GMT Monday, September 12, 2011 1:42:12 PM GMT
My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create this video which is about how one can install SQL Server Denali CTP3. There is no audio in this video as the video is very simple and one can understand it quite easily. Click here to watch the Denali CTP3 Installation Video o... (more)
category: Data | clicked: 12 | 4 comments | | source: blog.sqlauthority.com
5
Shouts
spam Shout it Mute it

Exploring SSMS - Filtering object names
published 652 days, 3 hours, 9 minutes ago posted by dharadhara 652 days, 12 hours, 10 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 10:58:32 AM GMT
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to filter the objects in the object... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
5
Shouts
spam Shout it Mute it

What is Dependency Object? How did you create Dependency Property
published 652 days, 3 hours, 9 minutes ago posted by dharadhara 652 days, 12 hours, 11 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 10:57:43 AM GMT
Most of the WPF classes derive from Dependency Object . All UI Elements are derived from Dependency Object. The Dependency Object class gives all the functionality of the WPF dependency property system. Dependency Object defines WPF Property System. System... (more)
category: Web Dev | clicked: 32 | 1 comment | | source: beyondrelational.com
tags: WPF, ASP.NET
5
Shouts
spam Shout it Mute it

Parse Function Function in Denali , CTP 3
published 652 days, 3 hours, 9 minutes ago posted by dharadhara 652 days, 12 hours, 11 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 10:57:09 AM GMT
Well dot net developers don't need any new introduction to it but for those who are encountering this function for the first time the answer is that it accepts a string datatype and converts to the requested datatype. Purpose: It accepts a string... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, denali, CTP
12
Shouts
spam Shout it Mute it

Many to Many Relationship Made Simpler
published 648 days, 1 hour, 48 minutes ago posted by pinaldavepinaldave 652 days, 13 hours, 15 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Monday, August 08, 2011 9:53:27 AM GMT
We need a new process to map this complex relationship. Sometimes tables exist for the sole purpose of allowing indirect relationships between tables. What do you call tables the handle relationships for other tables? Common terms for these type of tables are mapping tables, bridge tables, or junction tables. Learn about Many to many relationship and Win Free Book (more)
category: Data | clicked: 62 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

Compare Collections in C#
posted by kinj312kinj312 655 days, 16 hours, 28 minutes ago
Friday, August 05, 2011 6:40:44 AM GMT
Often we need to check if the items in the collections are same or not. It comes into action very often during unit testing. Here we will see three ways of doing so Entity Class (Player Entity) namespace ConsoleApplication1 { public class Players { public... (more)
category: Web Dev | clicked: 7 | comment | | source: beyondrelational.com
tags: .NET, C#, ASP.NET
7
Shouts
spam Shout it Mute it

Dynamics CRM 2011 – Customize Prefix for new Entities
posted by kinj312kinj312 655 days, 16 hours, 28 minutes ago
Friday, August 05, 2011 6:39:59 AM GMT
At the times when we need to customize the system, we need to place our own custom prefix string at the time of creation of new entities / option sets etc. To do this, follow the following steps: Open Dynamics CRM 2011 URL and navigate to Settings ->... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, CRM
8
Shouts
spam Shout it Mute it

Should Foreign Key constraints be used in a Data Warehouse?
posted by kinj312kinj312 655 days, 16 hours, 29 minutes ago
Friday, August 05, 2011 6:39:34 AM GMT
My question in the recent Beyond Relational BI Quiz (see http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/132/use-of-foreign-key-constraints.aspx) sparked a bit of debate about Foreign Keys, and whether they should be used in a Data Warehouse... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, foreign key, TSQL
6
Shouts
spam Shout it Mute it

Intresting Conversion functions arrived in SQL Server Denali CTP3
published 655 days, 3 hours, 11 minutes ago posted by dharadhara 656 days, 16 hours, 14 minutes ago
Friday, August 05, 2011 7:57:13 PM GMT Thursday, August 04, 2011 6:54:36 AM GMT
Last time, i have posted for the new Anaytical functions of Denali CTP3.You can see WHAT IS NEW in SQL Server Denali CTP3. This time i am going to write for new conversion functions which are summarized below, 1. TRY_CONVERT() - Returns a value to be... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

LINQ To Entity and Convert class Methods Problems
published 654 days, 2 hours, 48 minutes ago posted by dharadhara 656 days, 16 hours, 15 minutes ago
Saturday, August 06, 2011 8:20:16 PM GMT Thursday, August 04, 2011 6:53:46 AM GMT
While I was working today on one of my projects, as per habits, I used Conversion functions from Convert class and I noticed a peculiarity. Just sharing this with the readers to keep this in mind: Ideally, Convert.ToInt32("12") is same as integer... (more)
category: Web Dev | clicked: 22 | comment | | source: beyondrelational.com
tags: .NET, Linq, ASP.NET
6
Shouts
spam Shout it Mute it

Try_Convert Function in Denali , CTP 3
published 654 days, 2 hours, 48 minutes ago posted by dharadhara 656 days, 16 hours, 15 minutes ago
Saturday, August 06, 2011 8:20:16 PM GMT Thursday, August 04, 2011 6:53:13 AM GMT
In earlier version of Sql Server till Sql 11 (code name: Denali) CTP 2, there was no option to check if a conversion from one data type to another was possible or not.Consider the below example where we are trying to convert a varchar to int Select CONVERT... (more)
category: Data | clicked: 20 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
11
Shouts
spam Shout it Mute it

Learning SQL Server - Efficient Query Writing Strategy - Gift Book
published 648 days, 1 hour, 48 minutes ago posted by pinaldavepinaldave 656 days, 5 hours, 22 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Thursday, August 04, 2011 5:45:47 PM GMT
Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. (more)
category: Data | clicked: 56 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
6
Shouts
spam Shout it Mute it

Format function in Denali , CTP 3
published 657 days, 3 hours, 15 minutes ago posted by kinj312kinj312 658 days, 15 hours, 51 minutes ago
Wednesday, August 03, 2011 7:53:16 PM GMT Tuesday, August 02, 2011 7:17:04 AM GMT
This function is there in dot net for a long time and now has been added in Sql Server. It formats the value as indicated. Syntax: Format (expression, format [, culture]) Where, Expression = > the expression to format Format => A valid dot net framework... (more)
category: Data | clicked: 19 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, denali, CTP
7
Shouts
spam Shout it Mute it

Dynamics CRM 2011 – Reporting through BIDS
published 658 days, 1 hour, 15 minutes ago posted by kinj312kinj312 658 days, 15 hours, 52 minutes ago
Tuesday, August 02, 2011 9:53:42 PM GMT Tuesday, August 02, 2011 7:16:27 AM GMT
Today while learning Dynamics CRM 2011, I had to create a report that will show only User Names and their Mobile Numbers. Digging in process of creating reports, Dynamics CRM 2011 offers two modes: (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, BIDS, TSQL
6
Shouts
spam Shout it Mute it

MSBI #2– BI # 2- Lets play with Business Intelligence Development Studio (BIDS)
published 657 days, 3 hours, 15 minutes ago posted by dharadhara 659 days, 15 hours, 50 minutes ago
Wednesday, August 03, 2011 7:53:16 PM GMT Monday, August 01, 2011 7:18:09 AM GMT
Before kick start next tutorial I want you to just have a look at our new link resource website hope you will definitely like it Link Resource # 5 July 24 « Dactylonomy of Web Resource BIDS is Stands for Business Intelligence Development Studio... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI
6
Shouts
spam Shout it Mute it

SSMS - Script changes to SQL Server configuration
published 657 days, 3 hours, 15 minutes ago posted by dharadhara 659 days, 15 hours, 51 minutes ago
Wednesday, August 03, 2011 7:53:16 PM GMT Monday, August 01, 2011 7:16:52 AM GMT
Rarely, one needs to change the SQL Server configuration. However, when such a change is required, it needs to be planned and scheduled for execution during an outage. There too, the team implementing the change may or may not be the same as those recommending... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
6
Shouts
spam Shout it Mute it

TSQL Challenge 61 - Generate an HTML calendar in TSQL
published 657 days, 3 hours, 15 minutes ago posted by dharadhara 659 days, 15 hours, 52 minutes ago
Wednesday, August 03, 2011 7:53:16 PM GMT Monday, August 01, 2011 7:16:27 AM GMT
This challenge is to generate an HTML calendar based on the data stored in a table. The concept is very similar to the calendar we generate for the Quiz Series... (more)
category: Data | clicked: 49 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
10
Shouts
spam Shout it Mute it

Visual Studio 2010 styles
published 657 days, 3 hours, 15 minutes ago posted by kinj312kinj312 661 days, 17 hours, 14 minutes ago
Wednesday, August 03, 2011 7:53:16 PM GMT Saturday, July 30, 2011 5:54:11 AM GMT
I have been working with visual studio 2010 yesterday and I was searching some thing and same time I have found one great site for Visual Studio styles. http://studiostyl.es/ This site is cool and you can find lots of visual studio 2010 styles of your... (more)
category: Web Dev | clicked: 56 | 2 comments | | source: beyondrelational.com
tags: .NET, Visual Studio 2010, ASP.NET
8
Shouts
spam Shout it Mute it

A script for index maintenance based on fragmentation
published 658 days, 1 hour, 15 minutes ago posted by kinj312kinj312 661 days, 17 hours, 14 minutes ago
Tuesday, August 02, 2011 9:53:42 PM GMT Saturday, July 30, 2011 5:54:34 AM GMT
In my previous post regarding indexes I presented a method of inspecting all indexes in a database using sys.dmdbindexphysicalstats. Let us develop it a little bit more. Suppose you want to loop through all indexes and rebuild those which fragmentation... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Enhanced Log Function in Denali , CTP 3
published 658 days, 1 hour, 15 minutes ago posted by kinj312kinj312 661 days, 17 hours, 13 minutes ago
Tuesday, August 02, 2011 9:53:42 PM GMT Saturday, July 30, 2011 5:55:11 AM GMT
Well we have this function for a long time. But the log function has been overloaded this time with an additional base argument. Syntax : Log (Float Expression [, base]) Example ;With CTE AS ( Select Base = 2 Union All Select Base+1 from CTE Where Base... (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
Previous 1 2 3 4 5 6 7 8 9 10 ... 25 26 Next