SQL Server Knowledge Sharing Network (SqlServer-qa.net)

Browse by Tags

• 2005
• authentication
• blogs
• business intelligence
• certifications
• cluster
• clustering
• experience
• faq
• forums
• gotchas
• indexes
• installation
• instances
• integration services
• links
• management
• mcdba
• mcit
• mcts
• microsoft
• monitoring
• msdtc
• multiple
• network services
• newsgroups
• performance
• reference
• search
• security
• ssis
• tasks
• uninstallation
• upgarde
• upgrade
• usage

• SQL Injection attacks - don't forget to visit guidance information from Microsoft

  One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding... Posted Jun 01 2008, 12:23 AM by satya with | with no comments Filed under: security, best practice, sql server, microsoft, authentication

• Best practices/Gotcha's when migrating 2k DB's to 2K5 box? (also 2K->2K)

  Here is another interest forum post that will talk through the best practices, gotchas and FAQ when you are performing a database upgarde from SQL Server 2000 to 2005 version. Post link . Posted May 25 2008, 04:56 AM by satya with | with no comments Filed under: best practice, sql server, blogs, faq, gotchas, links, upgarde

• SQL Server multiple instances and resource utilization - best practices

  A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System... Posted Mar 14 2008, 02:28 PM by satya with | with 2 comment(s) Filed under: best practice, sql server, indexes, performance, management, multiple, clustering, instances, monitoring

• Integration Services Package performance tuning - 5 tables betwenn 5000 and 15 million rows

  Wanted to stroll interested (best suggestions) posts on the forums here and recently this 25701 topic has very good tips & tricks in managing performance your Integration Services packages that will need to deal huge number of rows (such as in millions... Posted Mar 03 2008, 02:35 PM by satya with | with no comments Filed under: integration services, best practice, sql server, forums, ssis, blogs

• SQL Server 2005 - Uninstalling cluster and nightmare of tasks you need to observe!

  One of the SSP member gujsa01 has posted his realtime experience about uninstalling cluster on SQL Server 2005, its worth going through this post that will guide you through such issues! Upon installing new 64bit iSCSI SQL Server 2005 EE Cluster, vendor... Posted Feb 03 2008, 02:36 PM by satya with | with no comments Filed under: best practice, sql server, 2005, cluster, tasks, uninstallation, installation

• All about SQL Server with 32bit to 64bit cluster migration - steps to take care

  Recently there has been few 'interesting' posts that will help most of the SQL Server users in this cyber world. Here is the basic question posted by the user: I have been tasked with migrating our SQL Server 05 Active/Passive cluster from 32bit... Posted Jan 14 2008, 10:41 PM by satya with | with 3 comment(s) Filed under: best practice, sql server, forums, reference, upgrade, cluster

• Newbie questions - getting knowledge in SQL Server with certifications?

  Now a days lot of newbie users are posting questions on the SQL Server, which is a good sign that more people wanted to know the SQL Server. But most of them do need a better understanding on SQL Server, so how best you can achieve such knowledge. Certifications... Posted Oct 31 2007, 04:44 PM by satya with | with no comments Filed under: best practice, sql server, mcdba, mcit, newsgroups, microsoft, certifications, mcts, search, business intelligence, forums, experience, usage

• Run Network Service on SQL Server when used specifically with IIS?

  When it comes to databases using a web-farm then using Network Service account is compulsory within the ASP.NET and other resources. So when you have installed Windows server with IIS6 that defaults to using the account “NT Authority/ Network Service... Posted Oct 17 2007, 01:39 PM by satya with | with no comments Filed under: security, best practice, sql server, msdtc, network services