neerajmathur

Stories submitted by neerajmathur

SQL University : An Introduction to BI – Part I(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 6 months ago

Welcome to Class Guys , Well , we will be starting our week of by taking a sneak peek into SQL BI gearing up to the more elaborative and deep understanding about BI and its applications . Before , just diving in , I would like to mention here , the useful resources , which are being referred here up in this article. read more...

add a comment |category: |Views: 13

tags: another

Understanding ASP.Net : A Complete Overview(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 6 months ago

Understanding ASP.Net : A Complete Overview with presentations on all topics... Introduction to Visual Studio Application and Page Frameworks GUI Controls Validation Server Controls Working with Master Pages Themes & Skins Collections & Lists Data Binding Data Management with ADO.Net Working with XML Site Navigation Security State Management Caching Debugging & Error Handling File I/O & Streams Configurations read more...

add a comment |category: |Views: 7

tags: another

How to search specific word or text in Database object ?(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 7 months ago

Today i am posting very basic but very important topic and that is “How to search specific word or text in Database object ?”. Everyone who is using MS-SQL at least once they have already faced or will face a situation where they need to find out that How many times and where in the Database objects a particular text or word has been used? For example I use a WHERE clause like “where Product.amount >= 1000″ in my store procedures and this kind of WHERE clause is using into 40 store procedures in my database and in my database i have more than 500 store procedures .One day i get situation that i need to update this WHERE clause and that will be like “Where (Product.amount + Product.XYZ) >= 1000″, Now what would i like to do to change this Where clause in all my 40 store procedures. read more...

add a comment |category: |Views: 4

tags: another

IIS Database Manager(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 7 months ago

IIS Database Manager allows IT Administrators to manage backup and restore operations of Microsoft SQL Server databases within IIS Manager. Since IIS Database Manager can handle Windows Authentication and SQL Authentication credentials, IT Administrators can also delegate this administrative procedure to other IIS users. read more...

add a comment |category: |Views: 5

tags: another

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 7 months ago

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008. read more...

add a comment |category: |Views: 23

tags: another

Lambda Expressions in .Net 3.0(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 7 months ago

In this post we are discussing the new feature Lambda Expressions being introduced in .NET 3.0 . C# 3.0 introduces a new feature called lambda expressions. While this is not a revolutionary thing, it opens up a plethora of new possibilities for .Net programming. This post aims to introducing the Lambda Expressions by providing a background, the syntax for using it , and a suitable example. read more...

add a comment |category: |Views: 8

tags: another

BEGIN TRANSACTION and COMMIT TRANSACTION(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

I know everyone will be thinking why am i posting about BEGIN TRANSACTION and COMMIT TRANSACTION which are the very basic and common thing that every one is known about it and why and where we we need to use this statement in sql statements/queries or in our code. But sometimes, we make such kind of small mistake with this BEGIN and COMMIT statement that make a cause of deadlock in our application and when it happens no one thinks that this could be the reason of the dead lock. The same problem i faced sometimes back. read more...

add a comment |category: |Views: 14

tags: another

Service Broker in Sql Server 2008(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

I am back with new topic in SQL Server from last few days i tried lots of stuff in Sql Server 2008 in which once thing is Service Broker but i am not able to do that… but with the grace of god while googling i found lots of article on this who tells this topic in detail…. so i did all this things and able to do that successfully… i m mentioning all the steps which i did…. In this topic we will see how to configure, send and receive messages using Service broker in SQL Server read more...

add a comment |category: |Views: 8

tags: another

Insert value using Table Value Functions (TVF)(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

In my last article we discuss about Table Value function…. a real gem in Sql Server 2008… mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now… In previous if we have to insert some data in table it requires lots of step like creating a table, Store procedure , Insert Data etc.. with TVF it can be done with lots of ease… i am mentioning a small example of TVF which may be helpful in coming days we will discuss more in detail regarding TVF and what kind of Stored procedure we can use in TVF… one more thing i am looking these days is to measure the performance issue of TVF or we can say which one is better TVF or SP read more...

add a comment |category: |Views: 11

tags: another

HttpWebRequest, HttpWebResponse and send POST request(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

Some times we do have a requirement to call external web pages through our application. The System.Net.HttpWebRequest Class allow us to make a call to any web page programmatically. In the below code you will see how we can make a call to any webpage and get there response on our page. read more...

add a comment |category: |Views: 28

tags: another

Whats New in SQL Server 2008 R2 CTP(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

Hi , this post is all about discussing the latest new features being embedded , released up with SQL SERVER 2008 R2 CTP . We are attaching the complete powerpoint presentation , that we had made to describe all the new features of this 2008 R2 CTP Release . If you do have any kind of querries regarding the same , feel free to ping us back and we will be more than happy to solve your querries . read more...

add a comment |category: |Views: 17

tags: another

FILESTREAM feature is disabled in SQL Server 2008(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

Today when i am working with SQL Server 2008 and doing some RnD … find a new feature FILESTREAM … found really interesting and want to do some testing work…when i tried to enable the FILESTREAM in my SQL Server 2008 ( as bydefault it is not enabled) by running this T-SQL Command ... read more...

add a comment |category: |Views: 15

tags: another

Role Based Access Control (RBAC) Application.(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

In this post we are going to discuss about creating RBAC applications . Before that , we will have a brief overview of RBAC. What does R B A C mean . R-Role B-Based A-Access C- Control So summing up , its all about implementing role based access control system in application . Now , we will see how to implement this system and make us of it in our application . As , we all are familiar with Membership , Role , Profile Providers being available in .Net 2.0 . Those role providers does provide the same functionality , but there are requirements some time to get more of them so we will achieve those targets by using RBAC . Say for Example , we are having roles being implemented in our application , like (admin , Hr , Senior HR , Trainee HR etc) , now in our application , we do want to implement such a functionality , where a role defined can perform certain access like Senior HR can edit , update or delete the records while Junior HR can only ADD records and view records . Even going more deep , lets assume a scenario where on a certain form /view we want that a user with specific permission (access rights ) can only view a specific part of form while others cannot , that is a form is being displayed in a different-different way depending on the access rights of the user . So how to attain this . read more...

add a comment |category: |Views: 357

tags: another

cannot rename the table because it is published for replication(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

Yesterday i faced a problem in SQL. I was not able to modify my column datatype, i was getting error “cannot rename the table because it is published for replication” i searched it and found the solution, i needed to drop subscription and then drop the related article database and then readd the subscription and article. read more...

add a comment |category: |Views: 27

tags: another

Recompiling Stored Procedures in Sql Server | SolidDotNet.com(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

1. How stored procedures are compiled 2. What happens when a stored procedure is called 3. What is execution plan , and what is the need to recompile a stored procedure. read more...

add a comment |category: |Views: 5

tags: another

CodePlex Foundation “The Next Step Towards Open Source Community”(soliddotnet.com)

submitted by neerajmathurneerajmathur(130) 2 years, 8 months ago

September 10, 2009 Microsoft announced the creation of CodePlex Foundatin After the success and a great brand in open source project hosting codeplex.com. Microsoft is now come up with a new idea more precisely it is a extension of CodePlex i.e. CodePlex Foundation (codeplex.org). read more...

add a comment |category: |Views: 4

tags: another