Welcome to sql-articles
Welcome to Sql-articles.com and this site is intended to produce articles related to sql server and its a free resource .All latest developments in the world of SQL Server will be available.Feel free to post your suggestion in the suggestion tab.You can also contribute any kind of Tips relating to SQL Server in the Tips tab. The sole purpose of starting this website is to create a knowledge base and help all the Newbies in SQL
Articles
| Installing SQL Server 2008 Clustering on Windows Server 2008 |
| In this podcast we are going to install SQL Server 2008 Clustering on Windows server 2008. I’ve already made my both the nodes clustered with Windows server 2008 and the details are below. |
| Submitted by: Vidhya Sagar on 2009-05-24 |
| Installing MSDTC as Cluster Aware Service |
| This is my first podcast for sql-articles.com. In this article we are going to discuss on Installing MSDTC as cluster aware service on Windows server 2008. We need this service as cluster aware because this is the perquisite when configuring SQL Server 2008. Watch the video and post your feed back in our discussion board. |
| Submitted by: Vidhya Sagar on 2009-05-16 |
| Configuring Failover Clustering in Windows Server 2008 |
| I have planned to configure SQL Server 2008 clustering on Windows Server 2008 Clustering. To do this, first I need to configure Windows Server Clustering. Now a days DBA’s are not only working on RBMS platform, they should also have sufficient knowledge in their operating system on which their RDBMS is running. As a DBA we shouldn’t look into SQL Server cluster alone, we should also take part in windows clustering too. In this article I’m going to configure fail over clustering in Windows |
| Submitted by: Vidhya Sagar on 2009-05-16 |
| Resource Database – 5th System database |
| In this article we are going to take a look at the 5th system databases available right from SQL Server 2005. As everyone know till SQL Server 2000 there are four system database is available and they are master, model, msdb and tempdb databases. From SQL Server 2005 Microsoft has introduced a new system database to the database engine called Resource database (actual name for this database is mssqlsystemresource ) which is hidden to the users. |
| Submitted by: Vidhya Sagar on 2009-04-17 |
| Creating Linked server to MYSQL from SQL Server |
| In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to MYSQL database server from SQL Server environment and then going to query data’s from MYSQL. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. In this we need drivers for MYSQL, this is not included in windows you need to download it from MYSQL We |
| Submitted by: Vidhya Sagar on 2009-04-03 |
|
Reviews & Downloads
|
|
