|
|
|
 |
| 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. |
|
| Essential Guides |
by Rick Obsitnik |
| Data Shepherds! Protect Your Flock! |
 |
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 |
 |
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 |
 |
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 |
|
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* |
 |
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 |
| 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 |
| The Importance of Backups |
|
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 |
|
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 |
|
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 |
| Essential Guides |
by Web Monkey |
| Ten Steps to Becoming an Eco DBA |
|
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 |
|
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 |
| Essential Guides |
by Rachel Clements |
| SQL Server Version Numbers - From 6.5 to 2008 |
 |
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
|
|
