SQL Server Club
Home Articles Essential Guides Blogs Links Twitter Facebook Join Contact About
Articles
Articles by Richard Doering
Understanding SQL Server Collation Sequences
SQL Server Club Author: Richard Doering Most of the time the collation sequence of your SQL Server is not something you give much thought to. Rich explores collation and uses code to help you discover more about it and how to fix a common error.
Articles by Rachel Clements
Msg 842, I/O error (torn page) Detected During Read at Offset
SQL Server Club Editor: Rachel Clements A torn page sounds like a pretty nasty error to have in your database. Find out what a torn page is, how SQL Server detects one and what you can do to prevent them - and also fix it when it happens to you.
Articles by Anil Mahadev
Introduction to SQL Server Shared Management Objects (SMO)
SQL Server Club Author: Anil Mahadev If you're not already using SMO, then you've probably heard of it but not yet found a reason to use it. Anil's easy to follow instructions will get you up and running in no time. A perfect start for anyone new to SMO.
Articles by Rachel Clements
Msg 945, Level 14, State 2, Line 1 Database Cannot be Opened Due to ...
SQL Server Club Editor: Rachel Clements If SQL Server has a problem trying to open a database or transaction log file, the database status will change and you'll get this message. Follow these steps to get your database back online and accessible again.
Articles by Microsoft MVP Andrew Couch
Relinking Tables and Views Between Access and SQL Server
SQL Server Club Author: MVP Andrew Couch Most of the time re-linking tables is easy enough, but re-linking views is more of a problem in respect of maintaining updateable views. Andy tackles the problems with lots of code samples and screen shots.
Articles by Anil Mahadev
SQL Server Tips and Tricks Part 1
SQL Server Club Author: Anil Mahadev When a problem suddenly surfaces you usually need a fast answer to solve it. In his new series of quick tips and tricks, Anil will show us how to solve commonly occurring problems with SQL Server.
Articles by UK MSDN
UK MSDN Flash eBook Best Technical Articles #1
MSDN UK Flash eBook Best Technical Articles #1 Eric Nelson, former Technical Editor at UK MSDN, kindly allowed me to add this fabulous PDF to SQL Server Club! The UK MSDN Flash developer newsletter contains great short technical articles written by UK developers both inside Microsoft and in the broader developer community. This eBook pulls these great articles together in one place. This first edition contains 13 articles covering dynamic languages, testing, game development, cloud computing and more. Download your copy now!
Articles by Microsoft MVP Andrew Couch
Solving Complex Query Calculations Using Nested Queries in SQL Server
SQL Server Club Author: MVP Andrew Couch Unlike Access, SQL Server won't allow you to easily construct calculated fields based on other calculated fields. Andrew solves this problem with a simple, elegant solution and really easy to understand code samples.
Articles by Shafqat Tanzeel
How to Connect SQL Server 2005 Express Edition with Microsoft Access 2003
SQL Server Club Author: Shafqat Tanzeel If you need to ever need to connect SQL Server to an Access database then this article is for you. With lots of screen shots, it walks you through every step needed to query Access from Management Studio.
Articles by Anil Mahadev
How to Document SQL Server Using BI Documenter from Pragmatic Works
SQL Server Club Author: Anil Mahadev Anil Mahadev takes a look at Pragmatic Works' BI Documenter tool to see how it handles documenting SQL Server. Using AdventureWorks he leads you step by step using the trial edition. Documentation at the click on a button? Surely this is Anil's easiest assignment yet!
Articles by Rick Obsitnik
Control Who Connects to SQL Server and Who Does Not
SQL Server Club Author: Rick Obsitnik This handy code from Rick will help you in your cross-server work. Use these scripts to end all user connections based on an instance, a database, a particular login or a login start and/or end time frame.
Articles by Rick Obsitnik
How to Compare the Columns of Two SQL Server Tables
SQL Server Club Author: Rick Obsitnik Being able to compare two tables is a common requirement in SQL Server environments, especially where development and production servers exist. Rick explores a functional way to do this task in an enterprise environment using linked servers. The SSMS file for this article is also included.
Articles by Rick Obsitnik
Minimarts: Organizational Segmentation in Datawarehousing
SQL Server Club Author: Rick Obsitnik If you don't know much about datawarehousing, then who better to learn from than a real life expert? Rick Obsitnik works with datawarehouses in his day to day role as a SQL Server DBA, so this introduction on how you can utilize datawarehousing to make your job indispensable is essential reading. Get to know how datawarehousing, datamarts and minimarts can fit in to your organization and your job!
Articles by Anil Mahadev
How to Recover from a Corrupted Database in SQL Server 2000
SQL Server Club Author: Anil Mahadev This is one useful article that you'll want to keep to hand! Anil takes you through the steps needed to bring a SQL Server 2000 database back online. It's easy to panic when crisis strikes, so save the PDF version of this document and keep it so you can find it when you really need it!
Articles by Web Monkey
How to Deal with Negative SPIDs in SQL Server
SQL Server Club Author: Web Monkey 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.
Articles by Web Monkey
21 Hot Tips for Improving Your SQL Server Security
SQL Server Club Author: Web Monkey Make your SQL Server as water tight as you can with this concise list of hot tips to tighten those leaks! These tips cover the areas of physical security, account security, DBA and developer tips, SQL Server configuration and permissions. Included are tips to keep data safe when it needs to be taken off site, and how to make sure you don't give users more access than is necessary.
Articles by Web Monkey
Linked Server Queries Stop Working After Applying Windows Server 2003 SP2
SQL Server Club Author: Web Monkey If you upgrade to Windows Server 2003 Service Pack 2 on a linked SQL Server, it can stop the Distributed Transaction Controller (DTC) from working. Why is this? Well, it's Microsoft's way of tightening up security, but it can leave you with a connection that no longer works. Follow this easy article and re-establish your connection in just a matter of minutes.
Articles by Web Monkey
SQL Server Service Packs - When Should You Apply One?
SQL Server Club Author: Web Monkey Knowing when to apply a service pack to SQL Server isn't as straight forward as you might first think. Do you apply it as soon as Microsoft releases it, or wait a while and see what problems arise? What if you don't apply it? We put these questions and more to our expert DBA and asked, "Just when is the best time to apply a new service pack?"
Articles by Web Monkey
How to Upgrade SQL Server Instances Quickly and Quietly in Ten Simple Steps
SQL Server Club Author: Web Monkey When you have more than one instance of SQL Server on a single box and you want to apply a service pack to each instance, you have to repeat the process for each installation. Here's a much quicker way to upgrade all instances on a single box in just ten easy steps to save you heaps of time.
Articles by Web Monkey
SQL Server Service Packs: Applying them to Development and Production Servers
SQL Server Club Author: Web Monkey Applying a service pack to SQL Server in production and development environments can have different impacts because the set-up of each environment is somewhat different. What's the best way to go about this and can you apply the same principles to both systems? Use this article to plan how you're going to roll out your service pack upgrades.
Articles by Web Monkey
Going Virtual, Going Green
SQL Server Club Author: Web Monkey Virtual machines are gaining ground in both reliability and cost-effectiveness in a production environment. As VMs become a normal part of every day server room installs, they are helping in a seemingly invisible way to help reduce climate change. Possibly not the first advantage that may have come to mind when you installed yours...
Articles by Web Monkey
Job Details Vanish in SQL Server Management Studio
SQL Server Club Author: Web Monkey Strange things can happen in the world of development and even stranger things seem to happen when SQL Server service packs are involved. In this case it's a matter of disappearing job properties in Management Studio before the service pack had even been applied. If weird things are occurring inside your client tools, then read this article.
Articles by Web Monkey
How to Set Up Database Mail on SQL Server 2005
SQL Server Club Author: Web Monkey 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 or mobile, as long as you have an internet connection, you can get SQL Server to keep you updated.
Articles by Web Monkey
Ten Things a DBA Should Never Do
SQL Server Club Author: Web Monkey So you're the top dog for data in your company. The DBA. Responsible, stable and reliable. That's you. But are you doing anything which could jeopardize your company's data or even your career? This light-hearted look at the things a DBA should never do covers some serious points and is essential for existing DBAs and anyone thinking of a career change...
Articles by Web Monkey
How to Schedule a SQL Server Database Creation Script
SQL Server Club Author: Web Monkey SQL Server Management Studio makes it easy to right click and generate a script to create databases. That's all well and good but what happens when you need to schedule such a task? Did you even know it was possible? This article looks at how you can use a little utility called SCPTXFR.EXE to schedule the creation of databases.
Articles by Web Monkey
Fixing the Error Message - Server: Message 1807, Level 16, State 2 Line 1
SQL Server Club Author: Web Monkey This interesting error is generated when SQL Server tries to take an exclusive lock on the Model database. Use this article to solve this error message and also make sure you don't face it again in the future.
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