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

How to connect SQL server and C++

Latest Answer :

#define DBNTWIN32 #include stdio.h #include windows.h #include sqlfront.h #include sqldb.h // Forward declarations of the error handler and message handler. int err_handler(PDBPROCESS, INT, INT, INT, LPCSTR, LPCSTR); int msg_handler(PDBPROCESS,...

How I create my function in sql server 2008?

Community Board

Prev12 3 Next LastShowing 1 - 10 of 23

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 \| 10 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 \| 1 year ago

Answer

Can i load data from excel sheet to MySql Server without making columns

0 referals, 1 answers, 22 views

	Answered by Sharad, Software Developer, Tripura Technologies \| 1 year ago
	yes, you can load data from excel to mysql or sql server. firstly import data from excel to ms-access and then export from ms-access to Sql server or mysql using odbc.

Answer

Why Job Portals?

0 referals, 0 answers, 0 views

	Referred by Dines Arora, Web Analytic, Hindustan Times \| 1 year ago
	Why we need job portal for job searching? Is the tradition method is of no use

Answer

What should we do to stop this large Donation asked by School

0 referals, 0 answers, 0 views

	Referred by Dines Arora, Web Analytic, Hindustan Times \| 1 year ago

Answer

Which is the good BOOK for learning RUBY ?????????????

0 answers

	Referred by Anshul, B.Tech/B.E. student, Baba Banda Singh Bahadur Engineering College \| Topic: open source tools \| 2 years ago

Answer

Is Sql A part of Oracle.Or they both are same

130 referals, 3 answers, 42 views

	Answered by RAJEEV KUMAR, Software Developer, NETPROPHETS CYBERWORKS PVT. LTD. \| Topic: SQL Server Programming \| 2 years ago
	SQL is a "structured Query Language" which is used for querying the different databases. SQL Server is a relational database. Oracle is a object oriented database.

Answer

How I create my function in sql server 2008?

0 referals, 0 answers, 0 views

	Referred by Himmat Singh, Software Developer, Banana Outsourcing Pvt. Ltd. \| Topic: SQL Server Programming \| 2 years ago
	I want to create my function that can retrieve data from Table in sql server 2008 on the basis of several parameters which I pass to that function as argument? And I also want to make that function in such a way that if parameters contains a value...

Answer

How can I start my career in Data warehousing?

1 referals, 0 answers, 0 views

	Referred by Shubhankar Bhadra, MCA student, CMR Institute of Management Studies \| 2 years ago
	Hi Senthil, First of all thanks to add me. Hey!! I am doing MCA(last sem) from CMRIMS, Bangalore and I want to go in the field of Data warehousing but I am not getting the appropriate information. I am little bit confused. I am searching for the...

Answer

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

0 referals, 4 answers, 59 views

	Answered by Thanigachalam T, Database Developer, Zeomega \| Topic: SQL Server Backup \| 2 years ago
	please Refer http://msdn.microsoft.com/en-us/library/ms187510.aspx http://msdn.microsoft.com/en-us/library/ms177429.aspx

Prev12 3 Next LastShowing 1 - 10 of 23

Topics in SQL Server Professionals

Clustering in SQL Server Go to Topic

SQL Server vs Oracle

SQL Server

Oracle

production level real time sql server clusteing

Automating Database Deployment Go to Topic

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

is Automation is good for worker'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

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....

Five Step Storage Strategy

Storage is a complex business these days. Businesses face an almost overwhelming choice of differing technologies and vendors, and it can be very difficult to separate marketing hype from fact and decide which systems are the best fit for your organisation’s requirements. The situation is exacerbated by the increasingly complex raft of corporate governance legislation and industry regulation that businesses must comply with, since much of this involves a large degree of data retention which req

SQL Server Backup Go to Topic

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