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


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

SQL Server Learning Steps

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
 
Hi, Hello all forum members, I am new to microsoft platform. I am a novice programmer learning VC#. But, While developing an application, one needs to interact with database. For that, i want to learn SQL Server. I want to learn it from Scratch (I know how to install it & and other things related to it). But, I don't know the way of learning RDBMS Like SQL Server. I have no clear picture about learning it. Means, In other words, like how do i write correct queries, how to debug large queries? Please guid eme in this issue. Thanks in advance.    


View Complete Post


More Related Resource Links

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

  
On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

skiping the steps in SQL server job

  
Below is my requirement  :  STEP 1 : Run the procedure if today is not a holiday (i have table to check whether today is holiday or not)  STEP 2 : Call the scheduler task using Type : Operating System(cmdExec) c:\windows\system32\schtasks.exe ***** if today is not a holiday.(need to check whether today is holiday or not in a table) How do I do the second step : the point is i want to skip the second step if it is holiday.. I know we can play with onsuccess and Onfailure OR creating 2 job for each steps.. but that's not am looking for is there any other way we can do this?

Clone production Sharepoint 2010 server to Developmet environment - steps? help?

  

Greetings all,

I'd really appreciate some thoughts and suggestions about how to make a clone of our Sharepoint 2010 Production environment that we can use for testing and development.

At the moment, we are likely to have two different servers (Production is a much more expensive, powerful server) for the scenarios; so if we make a direct clone, the Windows OS files would be upset.

Would it be enough to simply copy the Windows Shared files into the Dev system (taking all modifications with it) and the db into a cloned db?

If not, what are the things we'll have to consider, and/or has anyone accomplished this yet?

Thanks for your tips and suggestions!

--Dave


Best book for learning SQL Server 70-432 vs SQL Server 2008 SBS

  
I have access to both books, Training Kit 70-432 SQL Server 2008 Implementation and Maintenance and SQL Server 2008 Step by Step. Both are written by Mike Hotek.

I was wondering if one was a better starting point than the other for learning SQL Server 2008.

Thanks.

Cant see steps in SQL Server Agent Job after creating job

  
I created a job in sql server agent, which has to execute a package which is deployed on the same sql server. after creating when i double click the job. i could not see the steps of the job. what could be wrong...?

softwares required / installation steps for using SSRS 2008 along with SQL server 2005 as DataSource

  

Hi,

I want to use SSRS 2008 to develop reports, but SQL server 2005 should be used as datasource, so I assume that,

1) MS Visual Studio 2008 and SQL Server 2008 should be installed to get SSRS 2008 and BIDS

2) SQL server 2005 should be installed and in "Reporting Services Configuration Manager" the Database section should point to SQL server 2005

Please suggest whether the approach is correct or not, if not please give me the correct way to achieve it.

Thanks,

Avinash


SQL Server Agent: Job fails when all steps complete successfully

  

I have a SQL Server 2005 database with a job which contains several steps.  Each of these steps completes without issue but the overall job fails.  I believe this has to do with a NULL value generating a warning so I set SET ANSI_WARNINGS OFF; on the step I thought was generating the warning but the job still fails as a whole.

How can I either get the job as a whole to ignore warnings OR determine what is the root cause of this issue.  I don't see anything in the error logs.


A better way to reference your wizard steps using named steps

  
Note: this article uses the plain vanilla but the concepts apply equally well to its popular counterpart .

By far the most common way that I see wizard steps reference in code snippets is by their index.

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

Learning Jquery: The Basics

  
First lets go over the basics of jquery coding. All jquery starts with a "$" no matter what! In all of your jquery documents ( which is just a javascript file) you need the following code in your document, this code is to load your functions if you do not add this code your jquery will be useless.

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.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter
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