SQL Server Professionals

This is an community of professional developers and database administrators in the SQL Server area, who enjoy learning about SQL Server and its related technologies. We provide Corportae trainings for SQL Server Administrations in Mumbai,Bangalore,Delhi,Chennai,Hyderabad & Pune. Professionals for SQL Server is the one of the independent, user-run,group dedicated to the SQL Server community. Our goal is to provide you with the definitive resource to network with your peers, exchange tips and tricks, and gain access to the latest in SQL Server and BI education, information and news.

Tags:	SQL Server DBA
Category:	Business Area
Industries:	Technology Consulting
Functional Areas:	New Technologies
Moderation:	All Members
Visibility:	Everyone
Members:	693
Jobs:	7
Articles:	108
Questions:	13
Debates:	18
Idea Contests:	3

more >>

Join community

Rate :

more actions >>

Report abuse

Topic of the week : SQL Server Programming Go to Topic

Discussion on SQL Server Programming

Difference between LINQ to SQL and the Entity Framework

** Taken From http://dotnethitman.spaces.live.com/blog/cns!E149A8B1E1C25B14!195.entry I was browsing through the usual newsgroups I visit and came up with this post about LINQ to SQL vs EDM and thought I should share it here. LINQ to SQL and the Entity Framework have a lot in common, but each have features targeting different scenarios. LINQ to SQL has features targeting "Rapid Development" against a Microsoft SQL Server database. Think of LINQ to SQL as allowing you to have a strongly-typed vi

How to call a stored procedure using SQL Server 2000 and C#.NET?

Top Rated Answer :

Create an ASP.NET Project and Add Controls In this section, you create an ASP.NET project and build the basic user interface. Note that these steps use Microsoft Visual C# .NET code. To create the project, follow these steps: Click Start , point...

Community Board

Debates in "SQL Server Professionals"

Argue

Is free songs downloading should be ban

13 referals, 3 arguments, 0 views

	Argument added by Sharad Gupta, Software Developer, Tripura Technologies, Hyderabad \| Topic: free online resources \| 1 year ago
	this is not the debate topic, you must post good topic with some base, this is baseless topic..

Argue

SQL SERVER 2008 OR ORACLE...Which is better?

3 referals, 8 arguments, 16 views

	Argument added by devaraj, project associate, mindlogicx \| Topic: SQL Server 2005/2008 Profiler \| 1 year ago
	I accept arunkumar argument i felt my experience sql server is best

view all debates

Idea Contests in "SQL Server Professionals"

Participate

How Do You Know When It's Time for You to Go?

829 referals, 10 ideas, 166 views

	Referred by Divyang Patel, PROGRAMMER CUM DEVELOPER , INTERFACE SOFTWARE INC. \| 1 year ago
	Are you feeling increasingly unhappy about your job? Do you find yourself day dreaming about other things you could do with the time you spend at work? Do you dread the thought of Monday mornings? Then, it may be time for you to quit your job. Or,...

Participate

What Are the Benefits of Incremental Backups?

0 referals, 5 ideas, 117 views

	Idea added by Thanigachalam T, Database Developer, Zeomega \| Topic: SQL Server Backup \| 1 year ago
	Incremental Backups is the best method to use in large scale databae(TB) and 24/7 DB, which will take more more resources of the system. This will make more performance issue for end users. To overcome this we can use Incremental backups/Differential...

view all idea contests

Trends and Insights in "SQL Server Professionals"

Comment

May-10: The Job Index is 29% above the May-09 levels

0 referals, 0 comments, 0 views

	Referred by Dines Arora, Web Analytic, Hindustan Times \| 1 year ago
	The Naukri Job Speak index for all cities, industries and functional areas show an upward moving index in May-10 over May-09 Key Highlights Hiring activity in the IT- Software, Banking and Auto sectors are all back to the pre down turn levels with the...

Comment

Database Shrinking in SQL Server

3 referals, 2 comments, 491 views

	Commented by RAJEEV KUMAR, Software Developer, NETPROPHETS CYBERWORKS PVT. LTD. \| Topic: SQL Server 2005/2008 Profiler \| 1 year ago
	Why database shrinking is not done implicitly? It is better idea to save space automatically. Or some performance concerns are hidden.

view all trends & insights

Q & A in "SQL Server Professionals"

Answer

How is the requirement on MS-BI Technology? Can I choose my career as a MS-BI?

0 referals, 0 answers, 0 views

	Referred by Maheshguptha, Software Developer, GWS \| 7 months ago
	MS-BI is Microsoft Business Intelligence tool, I want to know the information about this MS-BI.

Answer

what to do when i want to perform a join operation on the resultset of a stored proc in some other stored proc

0 referals, 0 answers, 0 views

	Answered by Pinky Yadav, Freelancer, IT Services \| 10 months ago

view all Q & A

Topics in SQL Server Professionals

Clustering in SQL Server Go to Topic

SQL Cluster Tips

SQL Server Top Tips for SQL Server Clustering At a Glance: Running SQL Server on a cluster Hardware and software requirements Clustering one node Cost-effective options A server cluster allows you to connect a number of physical servers—or nodes—that act as failover partners for each other. The redundancy a cluster provides spells more uptime for your critical operations. I've implemented lots of clusters in my 13 years working with SQL Server™, and each had its own set of issues. That expe

SQL Server vs Oracle

SQL Server

Oracle

Automating Database Deployment Go to Topic

Trends in database administration

Trend in the database industry is rapid DBMS versioning. It seems like we just start to get a handle on the latest and greatest version of our favorite DBMS and then -- wham! -- the vendor releases a new version. I mean, people are still digesting Oracle9i and then Oracle unleashes 10g on the world. And how about IBM? On the mainframe side of the world most folks are still using DB2 V7, even though V8 has been available since March 2004. Who wants to be the first to encounter all those bugs tha

Ways to manage database

A database administrator is required to maintain the production and test environments of an application development project. The tools used to manage the production environment are used to sort issues related with database performance, administration and database recovery . The DBA can tune and improve the performance of a database by using such tools. The performance-monitoring tool helps a DBA gauge the efficiency and responsiveness of SQL queries, system parameters and database structures. S

Advanced SQLCLR: Security Best Practices and Design for Reuse Go to Topic

SQL Query Analyzer Tips and Tricks

If you've worked with Microsoft SQL Server at all, you've run across SQL Query Analyzer. Of course, this tool is essential for running ad hoc queries and executing SQL statements. But have you ever taken the time to really investigate its capabilities? The SQL Server developers built a lot of functionality into Query Analyzer, not all of which is obvious to the casual user. In this article, I'll offer you ten bits of Query Analyzer that you might not have looked at already. 1. Getting Database

Database management best practices: Expert tips for improving DBMS infrastructures

A good mix of people, process and product is essential for building and managing a good database. Hence obviously we need to care about these three elements. Considering these three elements and managing them will definitely be best practice for database management. OPTIMIZE PEOPLE An appropriate levels of staffing, well alligned with duties, points directly at maximizing the use of talent base. Regular training should be practiced to leverage new technology and reinforces the best management

SQL Server 2008 - Unstructured Data Storage Solutions Go to Topic

Top 10 Storage Predictions for 2008

Making the best possible use of resources is critical in today's resource-constrained environment. For better performancce you need to have ready avaliability of all vital resources. But formore thing to remember is the application of methods and tools to to store and manage your resources. May it be IT, Construction, Retailing etc, every business process needs effecient storage system. Here we will be talking about the data storage in IT and Infrastructure, in which Data storage is becoming a

What storage solution are you using for High Performance Compute Grid Environments ?

Latest Answer :

If high availability and performance is critical I prefer to go with iSCSI (if distance and the logistics between servers and the arrays are an issue and security over the lan is not a concern) otherwise I would select a Fibre Channel solution....

SQL Server Backup Go to Topic

How to: Restore a Database Backup (SQL Server Management Studio)

Latest Answer :

Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select respective database. Right-click the database, point to Tasks, and then click Restore, then select from databse /from device...

What Are the Benefits of Incremental Backups?


	0 Its very fast because SQL Server Database Engine tracks the changes
	0 Backup Method Advantages and Disadvantages
	0 Reduced risks for backup media failure