.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Test your skill in SQL Server

Posted By: Avinash Kr Singh     Posted Date: April 08, 2010    Points: 2   Category :Sql Server
 
You will be given a series of 10 SQL Server related questions that are randomly selected. Since the questions are randomly selected, you will receive a different set of questions each time you start a test. At the end of the last question, you will be given your score. You can then start a new test session if you like.


View Complete Post


More Related Resource Links

Test Run: Configuration Testing With Virtual Server, Part 2

  

Because Virtual Server is built upon a set of COM modules, you can automate the creation and testing of virtual machines. Here we use Windows PowerShell to run the tests.

Dr. James McCaffrey and Paul Despe

MSDN Magazine December 2008


Test Run: Configuration Testing With Virtual Server, Part 1

  

This time James McCaffrey sets up a virtual environment to use for configuration testing to introduce you to software configuration testing with Microsoft Virtual Server

Dr. James McCaffrey

MSDN Magazine September 2008


Publish and test a WebMatrix web site using a Local Windows Server 2008

  

I am new to ASP.NET as well as to WebMatrix Beta Razor language.

I am trying to publish and test a Web Site from WebMatrix Beta IDE to a local Virtual Windows Server 2008 IIS Server.

I did install SQL Server Express 2008 R2 at my local Virtual Windows Server 2008 (using Web Matrix Microsoft Web Platform).

Everything works fine till I add a database table to my WebMatrix site.

When I add a database table and Publish to local Virtual Windows Server 2008 IIS Server my WebMatrix IDE

closes unexpectedlly without any error message.

Running my Web Site using WebMatrix IISExpress works fine.

Any help will be very appreciated... 




How to test reports generated using web intelligence and sql server?

  

Hi all,

How to test reports generated using web intelligence and sql server?

One way of validating the data is to write sql query based on the report requirement and match the resultset with the data of the report. Then for testing the front end, based on the report requirement,validate the filters or prompts, formatting , printing and exporting feature of the report.

what else can be tested? is it necessary to test the Universe as well? like integrity checking, closed loops, joins etc..?or just run the sql query against the database from which the universe is created and match with the data in the report??

Could anyone Please advice me asap.

Thank You


Eveta

how to test reports generated using web intelligence and sql server

  

Hi all,

How to test reports generated using web intelligence and sql server?

One way of validating the data is to write sql query based on the report requirement and match the resultset with the data of the report. Then for testing the front end, based on the report requirement,validate the filters or prompts, formatting , printing and exporting feature of the report.

what else can be tested? is it necessary to test the Universe as well? like integrity checking, closed loops, joins etc..?or just run the sql query against the database from which the universe is created and match with the data in the report??

Please advice me asap.

Thank You


ssrs 2008 reports Datasource error in Test server..

  

Hi ,

 i Have upgraded my Reports from Report server  VS 2005 to  VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

 When i deployed to Test server i am trying to access my reports i am getting below errors,

 An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server,  it  doesn't works in srs 2008 test server.

 

Why? Can anyone give me some idea...?

 


ssrs moved rdl files from dev server to test server but its not working

  

Hi All,

I have developed 5 reports in dev box.After testing those i have saved the rdl files in a shared loacation.I told the Test team guys to copy the rdl files from that shared loacation and perform testing those reports on test box.But they are not able to do it.The reports are not running.they are throwing errors.I have one shared datasource for all those 5 reports.The reportserver for dev box is sqldev05 and test box is sqltest05.

What are all the steps needed to be implemented by test team so that reports will run succesfully in test box.

Thanks in Advance!!

 


Linked server issue on test box, post upgrade 2005 to 2008 R2

  

In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box.  2005 instance, copied as many things as I could think of from various other instances.  Made a basic linked server to our main cluster, had a repeating job to email me results of a query across that link every few hours.

 

Everything was working fine until the upgrade finished.  It completed at ~7pm.  The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through.  Checked various things (DB mail was still working, tested fine).  It couldn't access the data across the linked server.  I tried deleting that link and remaking it.  Errors out.  Tried running the same scripts we use to create our standard linked servers, error out.  The only ones that I can set up and function are links to other instances on the same box.

I've looked around at other fixes for this error message and none seem to make any difference.  Log in with Domain cred's, log in with the sa account, no difference.  I can connect from other instances & servers back to this one, just not outbound from this one.  And it worked prior to the upgrade I applied to it.  All other instances on the box are 2005 as well.

Here is the message I ge

I transferred a site template from test server to staging and it is not available when creating a ne

  

Hi

I transferred a site template from test server to staging and it is not available when creating a new site.

Means i have taken copy of .stp file and uploaded into the diffrent site of another server

while creating the sub site i cannot able to see the uploaded site template

Please let me know, if any one knows the answer

Regards

Pankaj

 


I need to simulate a proxy server to test mobile device c# application.

  

I need to simulate a proxy server to test mobile device c# application.

Is there a way to do this? how should I do this. 


php script using LDAP Test server

  

Can someone tell me if there is a place where I can have access to a .asp server for testing purposes only for logging in to testing LDAP??


Is this possible to test a script for logging on to a ASP server?  I would like to test username / Password for logging on to a ASP server.


I am crossing my fingers that such a server is available for testing a php script.

Thank you in advance for any help on this

rober4t


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
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.

Below is the complete step by step guide of this process.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend