SQL Server Club
Home Articles Essential Guides Blogs Links Twitter Facebook Join Contact About
Essential Guides
Essential Guides by Shafqat Tanzeel
How to Configure SQL Server 2005 to Allow Remote Connections
SQL Server Club Author: Shafqat Tanzeel 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.
Essential Guides by Rick Obsitnik
Data Shepherds! Protect Your Flock!
SQL Server Club Author: Rick Obsitnik As experienced DBA Rick Obsitnik knows all too well, DBAs are the guardians of enterprise data, or as he likes to call us, Data Shepherds! This no-nonsense article comes straight from the front line of the SQL Server administration world, advising you on not only how to protect your data, but also how to safeguard your job in the current economic downturn.
Essential Guides by Web Monkey
A Step by Step Guide to Installing SQL Server 2008
SQL Server Club Author: Web Monkey 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 Anil Mahadev
How to Implement Policy Based Management: A Primer in SQL Server 2008
SQL Server Club Author: Anil Mahadev 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 Anil Mahadev
How to Document SQL Server for the Novice DBA - Part 1
SQL Server Club Author: Anil Mahadev In part one of this article, SQL Server expert Anil Mahadev discusses the various forms of database documentation that are practiced by most database administrators. So if you're a novice DBA, or indeed a seasoned expert but need to do more documenting, you'll find Anil's top ten tips for happy documenting a great start!
Essential Guides by Norb Technologies
White Paper on the Business Cost of SQL Server Fragmentation *NEW VERSION*
SQL Server Club Author: Norb Technologies As a database is used during the course of a business day, information is inserted, updated and deleted. In a typical front office support system, this can mean tens of thousands of individual changes each and every hour. As this data is changed, it gets moved around within the database and eventually becomes so out-of-order that all of the records have to be searched, even if only one record is being retrieved. Read this white paper from Norb Technologies to find out more.
Essential Guides by Microsoft
Microsoft SQL Server 2000 Index Defragmentation Best Practices
SQL Server Club Author: Microsoft Although this document was written with SQL Server 2000 in mind, the practices within remain applicable to SQL Server 2005. It was last updated in 2003, but it's incredibly useful for on-going advice on your indexes. Recommended reading.
Essential Guides by Web Monkey
How to Install SQL Server 2005 Replication - A Simple Guide
SQL Server Club Author: Web Monkey 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
The Importance of Backups
SQL Server Club Author: Web Monkey As a DBA your most important duty is to protect the data in your databases. If you've ever considered skipping a backup job or maybe thinking you'd take the off-site backup home on another night, then this article will make sure you never think twice again. Norb Technologies' very own SQL Server DBA tells how he had a very lucky escape when disaster recently struck and has never been so glad to have made that backup!
Essential Guides by Web Monkey
New Year, New Server: Ten Steps to Get Your SQL Servers Fighting Fit
SQL Server Club Author: Web Monkey What better time is there than the extended Christmas and New Year holiday for putting your SQL Servers through a work-out? Use our list of top ten tips to have your servers back in peak performance for the new year. A little advance planning now can make all the difference, so grab a pen and paper and a mince pie and let's get started.
Essential Guides by Web Monkey
Farming Today with SQL Server: Guide to SQLBits SQL Server Conference
SQL Server Club Author: Web Monkey On a crisp Saturday morning in October, a group of dedicated MVPs held a free SQL Server Conference at Microsoft's Thames Valley Campus in Reading (UK). With highly qualified and experienced guest speakers, the 300 delegates were treated to a variety of sessions on SQL Server 2005 and some insights into the features coming in SQL Server 2008. Read about our trip to this SQLBits day out to see what you missed!
Essential Guides by Web Monkey
A Slight Case of Over Licensing: How to Save a Million Dollars on SQL Server
SQL Server Club Author: Web Monkey Is your company giving too much money to Microsoft? SQL Server licenses aren't exactly cheap, but you're paying for a top database engine. The question you need to ask as a DBA is whether your SQL Server licenses are costing you more than they should. This article explores the way you can save money.
Essential Guides by Web Monkey
Ten Steps to Becoming an Eco DBA
SQL Server Club Author: Web Monkey If you're conscious about the carbon footprint your office and server room are leaving on this planet and want to do more to help prevent climate change, then these ten easy steps will set you on the green road to becoming an ecological DBA.
Essential Guides by Web Monkey
Cable Guy - How to Get on with your Resident Network Engineer
SQL Server Club Author: Web Monkey When you lose your internet connection, or can't access your SQL Server, what do you do? As a database or software specialist the chances are you may not have much network knowledge. This simple five step plan gives you some basic network skills to troubleshoot the problem and help you and your network engineer work together.
Essential Guides by Web Monkey
How to get on with your Resident DBA - A Guide for the Modern Developer
SQL Server Club Author: Web Monkey Depending on the size of your organization, you may or may not be beer buddies with your in-house DBA. You may be a developer working for a company with a whole team of DBAs. This article explores what you as a developer need to know to befriend your DBA.
Essential Guides by Rachel Clements
SQL Server Version Numbers - From 6.5 to 2008
SQL Server Club Author: Rachel Clements If you run the query select @@version in Query Analyzer or Management Studio, it will bring back the version of your SQL Server as a load of digits. If you want to translate those digits into something more meaningful, use this handy look-up guide.
Essential Guides by Web Monkey
How to Install SQL Server 2005 - A Quick Guide
SQL Server Club Author: Web Monkey 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.
Essential Guides by Web Monkey
SQL Server 2005 DBCC Command Reference
SQL Server Club Author: Web Monkey 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.
Essential Guides by Web Monkey
Selecting a Web Host for Your SQL Server - Part 2 of 2
SQL Server Club Author: Web Monkey Is your web host up to the job? Use the tips in this guide to put your web host to the test to ensure you are getting the service your web site visitors demand. Is your web server fast enough, is it secure and what contingency do you have if you want to change hosts?
Essential Guides by Web Monkey
Selecting a Web Host for Your SQL Server - Part 1 of 2
SQL Server Club Author: Web Monkey Your business critical web application uses a SQL Server back-end and you've been assigned the task of finding a new web host. This detailed but easy to use step-by-step guide will take you from start to finish in choosing the right host, reducing risk and increasing up-time.
Top Of Page


Join SQL Server Club Today
SQL Server Technical Articles
Essential Guides Understanding SQL Server Collation Sequences
Essential Guides I/O Error (torn page) Detected During
Read at Offset
Essential Guides Introduction to SQL Server Shared Management Objects (SMO)
Essential Guides Database Cannot be Opened Due to Inaccessible Files
>> More SQL Server Articles...
Essential Guides to SQL Server
Essential Guides How to Configure SQL Server 2005 to Allow Remote Connections
Essential Guides Data Shepherds! Protect Your Flock!
Essential Guides A Step by Step Guide to Installing SQL Server 2008
Essential Guides How to Implement Policy Based Management in SQL Server 2008
>> More SQL Server Guides...
Bloglines
Blog Directory for Bristol, Avon
Blog Flux Directory
My Yahoo!
NewsGator
Google
FeedZilla
© Norb Technologies 2007-2010 Privacy Policy Norb Technologies Devdex Feedback Home
Feedback Form