|
|
|
|
 |
 |
@SQLServerClub Tops 1,400 Twitter Followers We're now one of the most popular SQL Server profiles on Twitter, so thanks to everyone who supports us! If you have an account you can follow
us from twitter.com/SQLServerClub, or if you aren't a member yet, it's free to sign up. |
 |
 |
| Essential Guides |
by Web Monkey |
| How to Install SQL Server 2005 - A Quick Guide |
 |
So many of us develop on it, query against it and administer it, yet it's not often we actually get to install it. This guide will take you from start to finish of how to install SQL Server 2005, which options to choose, which to ignore and the best time to take a coffee break. |
|
| Articles |
by Rick Obsitnik |
| How to Compare the Columns of Two SQL Server Tables |
 |
Being able to compare two tables is a common requirement in SQL Server environments, especially where development and production servers exist. Rick Obsitnik explores a functional way to do this task in an enterprise environment using linked servers. |
|
| How to Set Up Database Mail on SQL Server 2005 |
 |
Database mail is a great way of getting SQL Server to tell you when it's done something. Or, when it's not done something and a job has failed. You can use it to keep you informed of actions by sending an email to you, whether you're at your desk or on the road with your laptop. |
|
| Essential Guides |
by Web Monkey |
| A Step by Step Guide to Installing SQL Server 2008 |
 |
Installing SQL Server has always required some thought about such things as service accounts and collation sequences. However with SQL Server 2008, Microsoft has added in more options during the installation. Follow this step by step guide for a stress-free install. |
|
| Essential Guides |
by Shafqat Tanzeel |
| How to Configure SQL Server 2005 to Allow Remote Connections |
 |
After installing SQL Server you'll need to do some extra work to allow remote connections. Shafqat explains with clarity how to configure SQL Server to allow remote connections. Follow this step by step process with plenty of screen shots to get your SQL Server configured. |
|
| How to Deal with Negative SPIDs in SQL Server |
 |
If you've ever run sp_who or sp_who2 and encountered a SPID with a negative number, that is SPID = -2, then you may have found yourself in a position where you couldn't kill it off the conventional way. Take a look at this article to find out how to kill it off. |
|
| Essential Guides |
by Anil Mahadev |
| How to Implement Policy Based Management: A Primer in SQL Server 2008 |
 |
Policy Based Management (PBM) is growing in popularity in response to the greater need for organizational compliance. In this article SQL Server expert Anil Mahadev explains the main components of PBM and then he guides you through the steps of implementing it with a sample database. |
|
| Essential Guides |
by Web Monkey |
| How to Install SQL Server 2005 Replication - A Simple Guide |
 |
This easy to follow guide to setting up replication on SQL Server 2005 will have you up and running in no time at all. Whether you need to install it from scratch or fix the Microsoft SQL Server error 21028, then this guide is for you. Just grab your installation CD and get started. |
|
| Essential Guides |
by Web Monkey |
| SQL Server 2005 DBCC Command Reference |
 |
Make sure you are up to date with this essential guide to new, undocumented and retired DBCC commands in SQL Server 2005. Microsoft has removed some commands, so use this reference to check your applications don't depend on them before upgrading to 2005. |
|
 |
 |
|
 |
| Publish your technical article, a blog or maybe a top ten list of some of your favorite development things. Submit your article now! |
|
 |
|
|
|
|
|